4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SD Ceuta
TEMPORADA 1957/1958
SEGUNDA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Real Betis Real Betis 34 66 42 42
2 Tenerife Tenerife 34 61 40 38
3 Real Murcia Real Murcia 34 54 42 38
4 Levante Levante 34 65 48 37
5 Hércules Hércules 34 57 54 36
6 CD San Fernando Fernando 34 51 45 36
7 AD Plus Ultra Plus Ultra 34 55 53 36
8 Eldense Eldense 34 57 68 35
9 CF Extremadura Extremadura 34 51 63 35
10 Cádiz Cádiz 34 46 61 35
11 Córdoba CF Córdoba CF 34 57 60 35
12 CD Badajoz CD Badajoz 34 57 52 35
13 SD Ceuta SD Ceuta 34 43 48 33
14 CD Málaga CD Málaga 34 58 54 32
15 Recreativo Recreativo 34 49 53 32
16 Xerez CD Xerez CD 34 50 46 32
17 Alicante Alicante 34 42 64 23
18 Alcoyano Alcoyano 34 54 80 22
TEMPORADA 1956/1957
SEGUNDA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Granada Granada 38 79 45 47
2 Hércules Hércules 38 66 52 45
3 Real Murcia Real Murcia 38 68 50 43
4 Córdoba CF Córdoba CF 38 96 66 43
5 CD Málaga CD Málaga 38 67 45 42
6 Real Betis Real Betis 38 80 51 41
7 CD Badajoz CD Badajoz 38 67 64 41
8 SD Ceuta SD Ceuta 38 53 58 39
9 CF Extremadura Extremadura 38 61 71 39
10 Xerez CD Xerez CD 38 64 56 39
11 Levante Levante 38 65 68 38
12 Cádiz Cádiz 38 58 72 38
13 Tenerife Tenerife 38 71 60 37
14 CD San Fernando Fernando 38 63 79 37
15 Alicante Alicante 38 63 77 37
16 Eldense Eldense 38 67 78 35
17 Valencia Mestalla Valencia 38 61 75 34
18 Algeciras CF Algeciras 38 60 83 31
19 Puente Genil Puente Genil 38 44 81 27
20 CD Castellón Castellón 38 42 64 27
TEMPORADA 1955/1956
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 SD Ceuta SD Ceuta 18 56 16 30
2 UD Melilla UD Melilla 18 53 19 27
3 Español de Tetuán Español 18 44 31 23
4 Larache Larache 18 36 34 21
5 Ceuti At. Ceuti At. 18 35 35 17
6 Unión Tangerina Unión 18 31 31 16
7 Villa Nador Villa Nador 17 29 32 12
8 CD Pescadores Pescadores 17 24 50 12
9 Gimnástico de Alcázar Gimnástico 16 15 40 8
10 CD Alcazaba CD Alcazaba 18 18 53 6
TEMPORADA 1954/1955
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 SD Ceuta SD Ceuta 16 53 14 28
2 UD Melilla UD Melilla 16 36 16 23
3 Villa Nador Villa Nador 16 24 25 17
4 Larache Larache 16 29 24 17
5 Gimnástico de Alcázar Gimnástico 16 23 31 15
6 UA. Ceutí UA. Ceutí 16 24 24 13
7 Español de Tetuán Español 16 19 38 13
8 Unión Tangerina Unión 16 15 28 11
9 Pescadores A Pescadores 16 18 41 7
10 Juventud Sevillana Juventud 0 0 0 0
TEMPORADA 1953/1954
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Real Betis Real Betis 36 77 33 52
2 CD San Alvaro Alvaro 36 85 57 46
3 CD San Fernando Fernando 36 114 57 45
4 Cádiz Cádiz 35 90 52 43
5 SD Ceuta SD Ceuta 36 65 43 42
6 Recreativo Granada Recreativo 36 62 59 38
7 Algeciras CF Algeciras 36 72 53 38
8 CA Almeria CA Almeria 34 65 43 36
9 Martos CD Martos CD 36 75 67 36
10 Recreativo Recreativo 36 49 61 34
11 Iliturgi CF Iliturgi CF 36 63 80 32
12 Utrera Utrera 36 54 87 32
13 Español de Tetuán Español 36 66 76 31
14 Larache Larache 36 64 88 31
15 At. Malagueño Malagueño 36 58 83 30
16 RCD Córdoba Córdoba 36 51 50 29
17 Valdepeñas Valdepeñas 36 45 88 29
18 CD Úbeda Viva Úbeda Viva 36 45 83 27
19 Juventud Sevillana Juventud 35 53 93 27
TEMPORADA 1952/1953
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Xerez CD Xerez CD 30 88 42 43
2 UD España UD España 30 94 43 42
3 Cádiz Cádiz 30 75 48 37
4 Algeciras CF Algeciras 30 102 45 36
5 Recreativo Granada Recreativo 30 58 55 35
6 Real Betis Real Betis 29 72 56 34
7 SD Ceuta SD Ceuta 30 55 47 33
8 Recreativo Recreativo 30 83 66 32
9 Iliturgi CF Iliturgi CF 30 75 75 31
10 CA Almeria CA Almeria 30 53 51 30
11 CD San Fernando Fernando 30 52 77 27
12 Español de Tetuán Español 30 48 74 27
13 Juventud Sevillana Juventud 30 58 86 26
14 CD Úbeda Viva Úbeda Viva 30 52 79 23
15 Utrera Utrera 30 38 91 14
16 At. Malagueño Malagueño 29 32 100 5
TEMPORADA 1951/1952
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Real Jaén Real Jaén 26 84 40 37
2 CA Almeria CA Almeria 26 70 37 35
3 Real Betis Real Betis 26 63 47 32
4 Cádiz Cádiz 26 66 39 31
5 SD Ceuta SD Ceuta 26 59 44 31
6 Recreativo Recreativo 26 54 45 31
7 UD España UD España 26 56 44 30
8 Algeciras CF Algeciras 26 47 48 26
9 CD San Fernando Fernando 26 54 53 23
10 Xerez CD Xerez CD 26 52 71 23
11 Recreativo Granada Recreativo 26 36 54 20
12 Español de Tetuán Español 26 43 70 17
13 Utrera Utrera 26 30 62 16
14 At. Malagueño Malagueño 26 24 84 11
15 Larache Larache 0 0 0 0
16 Maghreb-Al-Aksa Maghreb-Al-A 0 0 0 0
TEMPORADA 1950/1951
SEGUNDA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Tetuán Tetuán 28 69 35 35
2 UD Salamanca Salamanca 28 60 47 32
3 Las Palmas Las Palmas 28 53 47 31
4 Hércules Hércules 28 66 51 30
5 RCD Córdoba Córdoba 28 65 53 30
6 Granada Granada 28 52 52 30
7 AD Plus Ultra Plus Ultra 28 46 46 29
8 Valencia Mestalla Valencia 28 51 51 29
9 RB Linense RB Linense 28 53 54 28
10 UD Melilla UD Melilla 28 63 65 28
11 Cartagena CF Cartagena 28 59 68 27
12 Mallorca Mallorca 28 61 61 26
13 Levante Levante 28 45 55 26
14 SD Ceuta SD Ceuta 28 43 67 24
15 Albacete Albacete 28 46 80 15
TEMPORADA 1949/1950
TERCERA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 SD Ceuta SD Ceuta 34 115 43 50
2 UD Melilla UD Melilla 34 99 45 49
3 Real Betis Real Betis 34 90 51 44
4 Recreativo Recreativo 34 86 63 43
5 Iliturgi CF Iliturgi CF 34 76 49 40
6 CD San Fernando Fernando 34 89 61 40
7 Xerez CD Xerez CD 34 72 63 37
8 Cádiz Cádiz 34 70 68 37
9 Maghreb-Al-Aksa Maghreb-Al-A 34 73 71 35
10 Algeciras CF Algeciras 34 72 84 35
11 Real Jaén Real Jaén 34 57 65 31
12 CA Almeria CA Almeria 34 77 80 30
13 CD Badajoz CD Badajoz 34 63 79 30
14 CP Cacereño Cacereño 34 55 80 28
15 UD España UD España 34 54 71 27
16 Mérida CP Mérida CP 34 54 122 21
17 Larache Larache 34 43 102 19
18 CD Electromecánica Electromecá 34 38 86 16
TEMPORADA 1948/1949
TERCERA DIVISIÓN GRUPO 6
Equipo PJ GF GC Puntos
1 Tetuán Tetuán 26 52 26 34
2 RCD Córdoba Córdoba 26 62 30 34
3 RB Linense RB Linense 26 72 38 34
4 Recreativo Recreativo 26 55 42 32
5 Cádiz Cádiz 26 56 41 30
6 SD Ceuta SD Ceuta 26 47 50 28
7 Real Betis Real Betis 26 60 42 25
8 Algeciras CF Algeciras 26 57 62 25
9 UD España UD España 26 46 63 23
10 Real Jaén Real Jaén 26 50 59 22
11 Iliturgi CF Iliturgi CF 26 57 75 22
12 UD Melilla UD Melilla 26 50 52 21
13 CD Electromecánica Electromecá 26 34 66 19
14 Larache Larache 26 39 91 15
TEMPORADA 1947/1948
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 UD Melilla UD Melilla 26 58 29 40
2 Recreativo Recreativo 26 84 36 35
3 RB Linense RB Linense 26 70 38 35
4 SD Ceuta SD Ceuta 26 64 55 29
5 Cádiz Cádiz 26 48 47 28
6 Iliturgi CF Iliturgi CF 26 68 56 26
7 Larache Larache 26 51 55 26
8 Tetuán Tetuán 26 60 58 25
9 Algeciras CF Algeciras 26 75 64 24
10 CD Electromecánica Electromecá 26 55 73 24
11 CD San Fernando Fernando 26 48 66 23
12 Coria CF Coria CF 26 36 56 19
13 Antequera CF Antequera 26 38 59 19
14 Calavera Calavera 26 30 93 11
TEMPORADA 1946/1947
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 UD Melilla UD Melilla 18 42 26 25
2 Cádiz Cádiz 18 36 31 24
3 SD Ceuta SD Ceuta 18 35 18 23
4 Tetuán Tetuán 18 47 37 22
5 CD San Fernando Fernando 18 43 42 17
6 Algeciras CF Algeciras 18 34 38 16
7 Antequera CF Antequera 18 30 41 14
8 RB Linense RB Linense 18 21 34 14
9 Larache Larache 18 32 42 13
10 CA Almeria CA Almeria 18 23 34 12
TEMPORADA 1945/1946
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 CE Sabadell CE Sabadell 26 50 29 35
2 RC Deportivo Deportivo 26 38 28 33
3 Gimnàstic Tarragona Gimnàstic 26 50 46 29
4 Granada Granada 26 49 35 29
5 RCD Córdoba Córdoba 26 36 34 29
6 Real Sociedad Real 26 46 33 27
7 Racing Ferrol Racing 26 39 52 25
8 Mallorca Mallorca 26 37 39 25
9 Racing Racing 26 56 51 24
10 Real Zaragoza Real 26 44 53 24
11 Real Betis Real Betis 26 41 40 24
12 Jerez FC Jerez FC 26 43 59 22
13 UD Salamanca Salamanca 26 41 48 20
14 SD Ceuta SD Ceuta 26 35 58 18
TEMPORADA 1944/1945
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Alcoyano Alcoyano 26 57 35 34
2 Hércules Hércules 26 55 39 33
3 Celta Celta 26 65 40 32
4 Real Sociedad Real 26 56 34 31
5 Jerez FC Jerez FC 26 52 50 29
6 Racing Racing 26 69 57 26
7 Real Betis Real Betis 26 45 47 26
8 Real Zaragoza Real 26 50 53 26
9 SD Ceuta SD Ceuta 26 40 49 24
10 Racing Ferrol Racing 26 44 68 24
11 Mallorca Mallorca 26 44 55 22
12 Constància Constància 26 42 53 22
13 Cultural Leonesa Cultural 26 41 49 22
14 Barakaldo Barakaldo 26 31 62 13
TEMPORADA 1943/1944
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Sporting Real 26 50 19 37
2 Real Murcia Real Murcia 26 62 40 32
3 Constància Constància 26 49 37 31
4 Alcoyano Alcoyano 26 44 34 30
5 Jerez FC Jerez FC 26 50 41 30
6 Real Zaragoza Real 26 56 40 29
7 Real Betis Real Betis 26 50 44 29
8 SD Ceuta SD Ceuta 26 47 45 25
9 Cultural Leonesa Cultural 26 42 45 25
10 Hércules Hércules 26 38 45 22
11 Barakaldo Barakaldo 26 34 61 19
12 Arenas de Getxo Arenas Getxo 26 39 60 19
13 Osasuna Osasuna 26 34 60 18
14 Real Valladolid Real 26 29 53 18
TEMPORADA 1942/1943
SEGUNDA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 SD Ceuta SD Ceuta 14 27 17 20
2 Jerez FC Jerez FC 14 23 22 17
3 Real Murcia Real Murcia 14 26 19 15
4 Hércules Hércules 14 20 18 15
5 CD Málaga CD Málaga 14 26 23 14
6 Elche Elche 14 16 26 12
7 Cádiz Cádiz 14 19 25 11
8 Alcoyano Alcoyano 14 21 28 8
TEMPORADA 1941/1942
SEGUNDA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Real Betis Real Betis 14 39 22 20
2 Real Murcia Real Murcia 14 37 28 17
3 Cádiz Cádiz 14 30 19 16
4 CD Málaga CD Málaga 14 19 21 14
5 SD Ceuta SD Ceuta 14 27 19 14
6 Elche Elche 14 23 35 11
7 Jerez FC Jerez FC 14 25 36 10
8 Cartagena CF Cartagena 14 19 39 10
TEMPORADA 1940/1941
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Constància Constància 4 9 6 5
2 SD Ceuta SD Ceuta 4 7 11 4
3 Elche Elche 4 9 8 3
TEMPORADA 1939/1940
SEGUNDA DIVISIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Cádiz Cádiz 14 40 15 23
2 Granada Granada 14 36 16 22
3 CD Málaga CD Málaga 14 36 19 20
4 RCD Córdoba Córdoba 14 33 35 14
5 Jerez FC Jerez FC 14 21 23 14
6 Recreativo Recreativo 14 29 43 9
7 SD Ceuta SD Ceuta 14 19 33 9
8 EHAT EHAT 14 15 45 1

  USO DE MEMORIA  
6,756,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  1.2355
Total Execution Time  1.2367
  CADENA URL  
/historico/Sd-Ceuta
  GET DATOS  
$_GET['/historico/Sd-Ceuta']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (74)  
0.0150  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Sd-Ceuta' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0321  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Sd-Ceuta' ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62415 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62415 AND type_rel = 2
0.0151  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '62415' ORDER BY l.year DESC,cat.coefficient DESC
0.0148  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '62415' AND l.year = 1958 ORDER BY l.year DESC,cat.coefficient DESC
0.0148  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '62415' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '62415' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 21446 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=62415 AND l.year in (1957,1958,1959) ORDER BY l.id DESC, l.year DESC ;
0.0145  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (21446) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 21446 AND teamId = 62415
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1958` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21446 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '62415' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '62415' and rp.type = 4
0.0146  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '62415' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0152  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1958 e ON e.player_id = p.id AND e.league_id = 21446 WHERE rp.league_id = 21446 AND rp.teamId = 62415 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1958 e ON e.player_id = p.id AND e.league_id = 21446 WHERE rp.league_id = 21446 AND rp.teamId = 62415 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1958 e ON e.player_id = p.id AND e.league_id = 21446 WHERE rp.league_id = 21446 AND rp.teamId = 62415 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 62415 AND l.year <= 1958 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0165  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1957` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21445 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1956` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21472 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1955` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21429 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1954` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21415 AND t.round = 40 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1953` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21401 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1952` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21395 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1951` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21384 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1950` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21383 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1949` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21374 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1948` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21367 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1947` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21356 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1946` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 10381 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1945` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 10380 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1944` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 10392 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1943` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21319 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1942` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21317 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1941` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21269 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1941` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21271 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1940` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21264 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 21446 ORDER BY nameShow LIMIT 100