4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Rota
TEMPORADA 2016/2017
DIVISIÓN HONOR SENIOR GRUPO 1
Equipo PJ GF GC Puntos
1 Cádiz CF Mirandilla Cádiz 38 83 28 82
2 Salerm Puente Genil Salerm 38 72 36 73
3 Xerez CD Xerez CD 38 74 37 72
4 Ciudad de Lucena Ciudad 38 60 39 71
5 Estrella San Agustín Estrella 38 59 46 68
6 Xerez Deportivo Xerez 38 65 43 63
7 Conil Conil 38 65 47 60
8 CD Pozoblanco Pozoblanco 38 39 36 58
9 La Palma CF La Palma CF 38 73 58 57
10 Viso UP Viso UP 38 47 38 54
11 AD Cartaya AD Cartaya 38 49 48 54
12 AD San José José 38 57 45 53
13 Ol. Valverdeña Valverdeña 38 55 74 45
14 CD Rota CD Rota 38 58 85 44
15 Chiclana CF Chiclana CF 38 46 62 42
16 Roteña Roteña 38 48 66 41
17 Lora CF Lora CF 38 48 71 39
18 San Juan San Juan 38 58 78 38
19 Pinzón CD Pinzón CD 38 45 71 28
20 Almodóvar del Río Almodóvar 38 25 118 13
TEMPORADA 2015/2016
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Onubense Atlético 34 68 30 76
2 Cádiz CF Mirandilla Cádiz 34 90 32 71
3 CD Rota CD Rota 34 71 47 68
4 AD Cartaya AD Cartaya 34 64 32 64
5 La Palma CF La Palma CF 34 55 48 55
6 Xerez CD Xerez CD 34 49 41 54
7 Chiclana CF Chiclana CF 34 49 40 53
8 Ol. Valverdeña Valverdeña 34 51 45 50
9 Chipiona CF Chipiona CF 34 45 55 48
10 Isla Cristina Isla 34 38 47 48
11 Jerez Industrial CF Jerez 34 39 41 47
12 Recreativo Portuense Recreativo 34 52 48 43
13 Grupo Empresa Bazán CF Grupo 34 44 55 35
14 Algeciras CF B Algeciras 34 27 42 33
15 San Roque de Lepe B Roque Lepe 34 36 57 31
16 At. Sanluqueño B Sanluqueño 34 25 54 31
17 CD UD Villamartín Villamartín 34 25 64 23
18 AD Los Cortijillos Cortijillos 34 27 77 13
TEMPORADA 2014/2015
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 Roteña Roteña 32 58 29 63
2 Jerez Industrial CF Jerez 32 41 27 54
3 CD Rota CD Rota 32 50 41 54
4 Chiclana CF Chiclana CF 32 51 37 52
5 Ol. Valverdeña Valverdeña 32 47 30 50
6 At. Sanluqueño B Sanluqueño 32 57 56 50
7 Grupo Empresa Bazán CF Grupo 32 52 40 49
8 Balón de Cádiz CF Balón 32 50 39 49
9 Algaida UD Algaida UD 32 51 52 45
10 Xerez CD Xerez CD 32 40 41 43
11 San Roque de Lepe B Roque Lepe 32 42 42 39
12 AD Los Cortijillos Cortijillos 32 35 43 39
13 Chipiona CF Chipiona CF 32 38 47 39
14 CD UD Villamartín Villamartín 32 45 59 38
15 Mazagon CF Mazagon CF 32 49 64 38
16 Chiclana Industrial Chiclana 32 31 57 25
17 CD Balona Balompié CF Balona 32 37 70 25
TEMPORADA 2013/2014
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Guadalcacín Guadalcacín 32 51 28 69
2 Los Barrios Los Barrios 32 57 24 65
3 CD Rota CD Rota 32 55 45 51
4 Ol. Valverdeña Valverdeña 32 55 47 51
5 Grupo Empresa Bazán CF Grupo 32 43 39 50
6 Chiclana CF Chiclana CF 32 49 35 48
7 Roteña Roteña 32 53 58 47
8 Chiclana Industrial Chiclana 32 36 38 46
9 Jerez Industrial CF Jerez 32 44 38 43
10 At. Sanluqueño B Sanluqueño 32 43 43 41
11 Balón de Cádiz CF Balón 32 43 45 39
12 Chipiona CF Chipiona CF 32 27 32 39
13 UD Algaida UD Algaida 32 43 49 38
14 Mazagon CF Mazagon CF 32 41 39 38
15 Puerto Real CF Puerto Real 32 49 58 33
16 Tesorillo Tesorillo 32 38 71 31
17 Aljaraque CD Aljaraque 32 36 74 24
TEMPORADA 2011/2012
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 Los Barrios Los Barrios 34 68 25 74
2 Puerto Real CF B Puerto Real 34 70 39 69
3 Xerez B Xerez B 34 87 42 68
4 Isla Cristina Isla 34 57 35 66
5 Balón de Cádiz CF Balón 34 59 47 62
6 Chiclana CF Chiclana CF 34 60 39 61
7 Grupo Empresa Bazán CF Grupo 34 53 50 47
8 Ol. Valverdeña Valverdeña 34 56 57 46
9 CD Guadalcacín Guadalcacín 34 56 56 45
10 Tarifa UD Tarifa UD 34 42 51 44
11 Chiclana Industrial Chiclana 34 55 53 43
12 La Palma La Palma 34 40 40 42
13 CD Rota CD Rota 34 45 47 42
14 Almonte Balompié Almonte 34 49 79 41
15 San Roque de Lepe B Roque Lepe 34 34 55 34
16 Roteña Roteña 34 48 79 29
17 Chipiona CF Chipiona CF 34 30 71 27
18 Pinzón CD Pinzón CD 34 36 80 23
TEMPORADA 2010/2011
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 CD San Roque Roque 34 65 25 76
2 Arcos CF Arcos CF 34 69 31 75
3 Xerez B Xerez B 34 52 16 73
4 Chiclana Industrial Chiclana 34 66 29 71
5 Atlético Tharsis Atlético 34 66 60 50
6 CD Rota CD Rota 34 44 48 49
7 Barbate Barbate 34 46 50 48
8 Ol. Valverdeña Valverdeña 34 43 40 47
9 La Palma La Palma 34 53 48 46
10 Isla Cristina Isla 34 45 45 44
11 Balón de Cádiz CF Balón 34 46 49 44
12 Pinzón CD Pinzón CD 34 44 53 43
13 Roteña Roteña 34 50 61 41
14 San Roque de Lepe B Roque Lepe 34 33 49 35
15 Gibraleón Gibraleón 34 39 59 35
16 CD Guadalcacín Guadalcacín 34 53 67 34
17 Ac Nueva Jarilla Nueva 34 44 65 28
18 CD San Juan CD San Juan 34 21 84 18
TEMPORADA 2009/2010
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 Conil Conil 34 55 38 70
2 San Fernando CD Fernando 34 74 33 66
3 Arcos CF Arcos CF 34 57 20 65
4 Xerez B Xerez B 34 68 34 63
5 Ol. Valverdeña Valverdeña 34 61 39 56
6 Pastores Pastores 34 51 37 55
7 Chiclana CF Chiclana CF 34 63 46 53
8 Balón de Cádiz CF Balón 34 55 47 52
9 La Palma La Palma 34 55 45 47
10 Isla Cristina Isla 34 52 51 47
11 CD Rota CD Rota 34 42 47 44
12 Roteña Roteña 34 50 57 42
13 CD San Roque Sub 19 Roque 34 40 78 38
14 Atlético Zabal Atlético 34 44 67 36
15 Gibraleón Gibraleón 34 31 58 36
16 Atl. Cortegana Atl. 34 47 57 35
17 Punta Umbria Punta Umbria 34 29 60 25
18 Almonte Almonte 34 33 93 17
TEMPORADA 2008/2009
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 Algeciras CF Algeciras 34 64 30 69
2 Conil Conil 34 64 39 69
3 Arcos CF Arcos CF 34 70 32 67
4 CD Rota CD Rota 34 55 48 54
5 Punta Umbria Punta Umbria 34 40 42 53
6 Roteña Roteña 34 59 48 50
7 La Palma La Palma 34 49 44 49
8 Xerez B Xerez B 34 47 45 47
9 Atl. Cortegana Atl. 34 46 48 42
10 San Roque de Lepe B Roque Lepe 34 31 42 41
11 Balón de Cádiz CF Balón 34 36 41 40
12 Isla Cristina Isla 34 34 41 39
13 Ol. Valverdeña Valverdeña 34 37 55 39
14 San Fernando CD Fernando 34 41 49 38
15 Atlético Tharsis Atlético 34 36 50 38
16 Ud Bornense Ud Bornense 34 45 60 32
17 Tesorillo Tesorillo 34 39 56 31
18 Chiclana Industrial Chiclana 34 24 47 31
TEMPORADA 2007/2008
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Onubense Atlético 34 75 19 75
2 Chiclana CF Chiclana CF 34 57 28 68
3 Tesorillo Tesorillo 34 67 38 66
4 Conil Conil 34 65 43 66
5 Punta Umbria Punta Umbria 34 52 32 64
6 La Palma La Palma 34 45 38 56
7 Ol. Valverdeña Valverdeña 34 37 31 53
8 CD Rota CD Rota 34 39 44 43
9 At. Cortegana Cortegana 34 40 48 43
10 Atlético Tharsis Atlético 34 40 48 42
11 San Fernando CD Fernando 34 63 54 40
12 Los Cortijillos Cortijillos 34 37 55 38
13 Roteña Roteña 34 43 61 37
14 Chiclana Industrial Chiclana 34 45 66 37
15 Atlético Cruceño Atlético 34 36 51 36
16 Barbate Barbate 34 36 65 31
17 Pastores Pastores 34 40 73 28
18 Chipiona CF Chipiona CF 34 31 54 26
TEMPORADA 2006/2007
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 San Fernando C. Fernando 30 59 29 66
2 CD Rota CD Rota 30 58 27 55
3 Chipiona CF Chipiona CF 30 47 27 54
4 Rayo Sanluqueño Rayo 30 42 33 49
5 Balón de Cádiz CF Balón 30 53 43 47
6 Algeciras CF B Algeciras 30 40 36 47
7 Tarifa UD Tarifa UD 30 47 40 45
8 CD Guadalcacín Guadalcacín 30 38 38 42
9 Atlético Zabal Atlético 30 28 30 37
10 Pastores Pastores 30 36 41 37
11 Deportes Romero Deportes 30 34 56 36
12 Trebujena CF Trebujena 30 35 43 33
13 Chiclana Ind. Chiclana 30 25 38 33
14 Vejer Bpie Vejer Bpie 30 36 47 31
15 Florida Dst. 5 Florida Dst. 30 31 43 28
16 Grupo Empresa Bazán CF Grupo 30 19 57 13
TEMPORADA 2005/2006
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Chiclana Ind. Chiclana 30 52 25 58
2 Conil Conil 30 56 30 55
3 Balón de Cádiz CF Balón 30 47 38 54
4 CD Rota CD Rota 30 54 30 52
5 Chipiona CF Chipiona CF 30 34 21 51
6 Rayo Sanluqueño Rayo 30 50 40 44
7 Florida Dst. 5 Florida Dst. 30 49 44 44
8 CD Guadalcacín Guadalcacín 30 39 33 43
9 Chiclana B Chiclana B 30 40 43 37
10 Grupo Empresa Bazán CF Grupo 30 35 44 37
11 Vejer Bpie Vejer Bpie 30 36 49 37
12 Tarifa UD Tarifa UD 30 29 43 36
13 Ud Bornense Ud Bornense 30 35 59 34
14 S.Isidro Guadalete S.Isidro 30 35 53 30
15 Palmones Palmones 30 33 57 27
16 CD UD Villamartín Villamartín 30 36 51 23
TEMPORADA 2003/2004
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Puerto Real CF Puerto Real 30 54 24 60
2 Cádiz CF Mirandilla Cádiz 30 85 34 58
3 Arcos CF Arcos CF 30 51 27 57
4 Roteña Roteña 30 42 37 49
5 Los Cortijillos Cortijillos 30 42 28 48
6 Tarifa UD Tarifa UD 30 43 30 48
7 Algeciras CF B Algeciras 30 35 28 47
8 Barbate Barbate 30 41 38 45
9 Xerez B Xerez B 30 36 38 39
10 Atletico San Roque Atletico 30 39 60 38
11 Chiclana Ind. Chiclana 30 49 52 36
12 Chipiona CF Chipiona CF 30 36 42 35
13 CD Guadalcacín Guadalcacín 30 39 48 35
14 CD Rota CD Rota 30 34 44 34
15 Palmones Palmones 30 36 58 33
16 Ubrique Ind. Ubrique Ind. 30 26 41 32
17 CD UD Villamartín Villamartín 30 31 56 27
18 Rayo Sanluqueño Rayo 30 24 58 22
TEMPORADA 2002/2003
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Chiclana Ind. Chiclana 30 57 24 63
2 R. Portuense Portuense 30 54 26 62
3 Cádiz CF Mirandilla Cádiz 30 68 33 61
4 Los Cortijillos Cortijillos 30 46 29 58
5 Xerez B Xerez B 30 55 27 56
6 Chiclana CF Chiclana CF 30 47 38 50
7 CD Rota CD Rota 30 71 38 49
8 Chipiona CF Chipiona CF 30 44 45 44
9 Atletico San Roque Atletico 30 44 38 41
10 CD UD Villamartín Villamartín 30 31 37 38
11 Ac Nueva Jarilla Nueva 30 30 41 38
12 Roteña Roteña 30 49 47 37
13 Ubrique Ind. Ubrique Ind. 30 35 49 35
14 Rayo Sanluqueño Rayo 30 44 55 34
15 Barbate Barbate 30 33 50 34
16 Grupo Empresa Bazán CF Grupo 30 41 56 33
17 Carolinense Carolinense 30 27 56 29
18 San Fernando C. Fernando 30 42 54 28
19 Guadiaro Guadiaro 30 43 71 23
20 San Bernardo Bernardo 30 34 81 16
TEMPORADA 1999/2000
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Algeciras CF Algeciras 38 64 32 73
2 CD San Fernando Fernando 38 58 31 68
3 Puerto Real CF Puerto Real 38 62 40 66
4 RC Portuense Portuense 38 44 41 65
5 UD Los Palacios Palacios 38 54 43 64
6 At. Sanluqueño Sanluqueño 38 61 47 63
7 CD Pozoblanco Pozoblanco 38 62 43 61
8 Lucena Lucena 38 45 37 55
9 Atlético Onubense Atlético 38 45 38 55
10 UD Tomares UD Tomares 38 55 52 55
11 CD Villanueva Villanueva 38 43 49 51
12 Córdoba CF B Córdoba 38 53 54 48
13 AD Cartaya AD Cartaya 38 49 54 47
14 La Palma La Palma 37 37 45 43
15 Ayamonte Ayamonte 38 35 53 41
16 Los Barrios Los Barrios 38 36 49 40
17 Chiclana CF Chiclana CF 38 42 58 39
18 Montilla Montilla 38 38 59 38
19 AD Ceuta FC B Ceuta 38 43 67 28
20 CD Rota CD Rota 37 32 66 26
TEMPORADA 1998/1999
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 RB Linense RB Linense 38 56 19 81
2 Dos Hermanas CF Hermanas 38 67 28 80
3 Coria CF Coria CF 38 61 18 73
4 CD San Fernando Fernando 38 64 35 71
5 Lucena Lucena 38 52 21 64
6 RC Portuense Portuense 38 41 34 57
7 Chiclana CF Chiclana CF 38 44 36 56
8 At. Sanluqueño Sanluqueño 38 45 42 54
9 Montilla Montilla 38 35 35 53
10 UD Tomares UD Tomares 38 43 44 50
11 UD Los Palacios Palacios 38 52 46 47
12 CD Pozoblanco Pozoblanco 38 37 44 46
13 CD Rota CD Rota 38 42 55 46
14 Puerto Real CF Puerto Real 38 40 45 46
15 Ayamonte Ayamonte 38 36 51 43
16 Los Barrios Los Barrios 38 38 55 42
17 La Palma La Palma 38 40 50 38
18 Utrera Utrera 38 36 62 37
19 San Roque de Lepe Roque Lepe 38 34 68 29
20 Serrallo CF Serrallo CF 38 18 93 16
TEMPORADA 1997/1998
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 AgD Ceuta AgD Ceuta 38 81 27 82
2 CD San Fernando Fernando 38 91 31 78
3 San Roque de Lepe Roque Lepe 38 50 30 64
4 Algeciras CF Algeciras 38 54 46 64
5 Lucena Lucena 38 34 21 63
6 Coria CF Coria CF 38 57 36 63
7 Chiclana CF Chiclana CF 38 54 43 58
8 Utrera Utrera 38 48 48 53
9 La Palma La Palma 38 45 60 52
10 CD Rota CD Rota 38 53 65 50
11 RB Linense RB Linense 38 39 60 46
12 Ayamonte Ayamonte 38 46 48 46
13 Puerto Real CF Puerto Real 38 49 61 45
14 Montilla Montilla 38 35 47 45
15 At. Sanluqueño Sanluqueño 38 49 49 44
16 CD Pozoblanco Pozoblanco 38 43 48 44
17 UD Los Palacios Palacios 38 40 53 42
18 Cádiz CF Mirandilla Cádiz 38 35 47 40
19 La Rambla CF Rambla 38 38 74 34
20 Rayo Sanluqueño Rayo 38 36 83 24
TEMPORADA 1996/1997
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 UA. Ceutí UA. Ceutí 42 69 41 79
2 CD Isla Cristina Isla 42 76 40 76
3 Algeciras CF Algeciras 42 61 39 72
4 Ayamonte Ayamonte 42 64 38 71
5 Montilla Montilla 42 62 51 70
6 UD Los Palacios Palacios 42 60 44 66
7 CD San Fernando Fernando 42 67 57 66
8 At. Sanluqueño Sanluqueño 42 59 53 64
9 CD Pozoblanco Pozoblanco 42 55 49 61
10 CD Rota CD Rota 42 57 58 59
11 San Roque de Lepe Roque Lepe 42 57 56 57
12 RB Linense RB Linense 42 57 52 55
13 Cádiz CF Mirandilla Cádiz 42 51 55 54
14 La Palma La Palma 42 51 54 54
15 Utrera Utrera 42 71 49 54
16 Lucena Lucena 42 53 69 50
17 Chiclana CF Chiclana CF 42 45 59 50
18 Dos Hermanas CF Hermanas 42 53 60 50
19 Mairena Mairena 42 36 62 37
20 Conil Conil 42 30 77 33
21 Roteña Roteña 42 23 90 23
TEMPORADA 1995/1996
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 CD San Fernando Fernando 38 73 34 70
2 At. Sanluqueño Sanluqueño 38 60 27 67
3 CD Isla Cristina Isla 38 61 39 65
4 Chiclana CF Chiclana CF 38 53 34 64
5 San Roque de Lepe Roque Lepe 38 54 43 63
6 Montilla Montilla 38 49 31 62
7 La Palma La Palma 38 65 47 59
8 CD Pozoblanco Pozoblanco 38 52 41 58
9 Coria CF Coria CF 38 47 39 58
10 RB Linense RB Linense 38 48 36 55
11 CD Rota CD Rota 38 48 44 55
12 UD Los Palacios Palacios 38 43 53 50
13 Dos Hermanas CF Hermanas 38 62 68 48
14 Algeciras CF Algeciras 38 43 41 46
15 Mairena Mairena 38 41 56 44
16 Cádiz CF Mirandilla Cádiz 38 55 61 43
17 Conil Conil 38 36 67 39
18 Jerez Industrial CF Jerez 38 37 60 38
19 San Juan San Juan 38 29 54 37
20 O Donnell O Donnell 38 25 106 12
TEMPORADA 1992/1993
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 At. Cortegana Cortegana 38 56 23 52
2 Mairena Mairena 38 48 29 50
3 CD San Fernando Fernando 38 57 30 49
4 San Juan San Juan 38 42 34 45
5 At. Sanluqueño Sanluqueño 38 43 29 44
6 UD Los Palacios Palacios 38 46 29 44
7 Coria CF Coria CF 38 61 50 42
8 Cádiz CF Mirandilla Cádiz 38 56 45 40
9 Lucena Lucena 38 45 42 38
10 CD Pozoblanco Pozoblanco 38 49 39 37
11 Puente Genil Puente Genil 38 30 34 37
12 Roteña Roteña 38 35 41 36
13 Jerez Industrial CF Jerez 38 41 43 36
14 Montilla Montilla 38 40 49 35
15 Lebrija Lebrija 38 50 48 35
16 La Palma La Palma 38 35 48 33
17 Algeciras CF Algeciras 38 53 65 32
18 Arcos CF Arcos CF 38 30 58 29
19 CD Rota CD Rota 38 28 60 28
20 Chiclana CF Chiclana CF 38 27 76 18
TEMPORADA 1989/1990
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Betis Deportivo Betis 38 64 26 56
2 RC Portuense Portuense 38 65 32 53
3 San Roque de Lepe Roque Lepe 38 49 35 48
4 Algeciras CF Algeciras 38 51 31 45
5 CD Pozoblanco Pozoblanco 38 53 33 45
6 CD San Fernando Fernando 38 58 39 44
7 Lebrija Lebrija 38 47 35 40
8 Écija Balompié Écija 38 48 40 40
9 Santaella 2010 Santaella 38 54 56 39
10 Palma del Rio Atletico CF Palma 38 39 40 39
11 Coria CF Coria CF 38 43 44 39
12 Chiclana CF Chiclana CF 38 44 52 38
13 Ayamonte Ayamonte 38 45 49 38
14 Cádiz CF Mirandilla Cádiz 38 47 52 36
15 La Palma La Palma 38 43 52 35
16 Montilla Montilla 38 30 41 31
17 Puerto Real CF Puerto Real 38 27 40 30
18 Dos Hermanas CF Hermanas 38 43 52 29
19 CD Rota CD Rota 38 34 63 24
20 Club Atlético De Ceuta Club 38 22 94 11

  USO DE MEMORIA  
7,804,064 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1527
Total Execution Time  0.1541
  CADENA URL  
/historico/Rota/2017
  GET DATOS  
$_GET['/historico/Rota/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0030  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 = 'Rota' AND l.year = 2017 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.0018  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=2185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=2185 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 34070
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2185 AND type_rel = 2
0.0027  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 = '2185' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '2185' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '2185' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 34070 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=2185 AND l.year in (2016,2017,2018) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (39236,16712) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 16712 AND teamId = 2185
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 39236 AND teamId = 2185
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2017` 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 = 34070 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '2185' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2185' and rp.type = 4
0.0020  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 = '2185' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 events2017 e ON e.player_id = p.id AND e.league_id = 34070 WHERE rp.league_id = 34070 AND rp.teamId = 2185 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.0019  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 events2017 e ON e.player_id = p.id AND e.league_id = 34070 WHERE rp.league_id = 34070 AND rp.teamId = 2185 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 events2017 e ON e.player_id = p.id AND e.league_id = 34070 WHERE rp.league_id = 34070 AND rp.teamId = 2185 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 2185 AND l.year <= 2017 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0024  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 `tables2017` 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 = 34070 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2016` 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 = 16712 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2015` 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 = 4056 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2014` 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 = 2569 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2012` 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 = 1468 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2011` 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 = 1189 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2010` 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 = 856 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2009` 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 = 323 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2008` 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 = 114 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2007` 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 = 2919 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2006` 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 = 2918 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2004` 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 = 2916 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2003` 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 = 2915 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables2000` 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 = 22023 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables1999` 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 = 22007 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables1998` 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 = 21991 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 `tables1997` 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 = 21973 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables1996` 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 = 21952 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables1993` 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 = 21889 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables1990` 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 = 21824 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 34070 ORDER BY nameShow LIMIT 100