4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 Cádiz C Cádiz C 28 45 18 57
2 Algeciras CF B Algeciras 28 43 34 54
3 Jerez Industrial CF Jerez 28 54 31 52
4 Guadiaro Guadiaro 28 44 32 45
5 Puerto Real CF Puerto Real 28 45 31 45
6 CD Guadalcacín Guadalcacín 28 43 37 43
7 RC Portuense Portuense 29 39 40 42
8 Roteña Roteña 29 44 46 35
9 Arcos CF Arcos CF 28 35 38 34
10 Ciudad De Cadiz PCD Ciudad Cadiz 28 33 40 33
11 Trebujena CF Trebujena 28 31 41 32
12 Rayo Sanluqueño Rayo 28 42 43 31
13 Xerez Deportivo B Xerez 28 36 48 31
14 Grupo Empresa Bazán CF Grupo 28 37 54 30
15 San Bernardo Bernardo 28 22 45 28
16 CD San Roque Roque 28 27 42 25
TEMPORADA 2022/2023
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 San Fernando CD B Fernando 30 68 35 56
2 Trebujena CF Trebujena 30 46 32 54
3 Roteña Roteña 30 55 41 54
4 Puerto Real CF Puerto Real 30 63 29 53
5 Guadiaro Guadiaro 30 54 39 53
6 RC Portuense Portuense 30 55 34 51
7 Balón de Cádiz CF Balón 30 39 38 47
8 Algeciras CF B Algeciras 30 63 54 42
9 Jerez Industrial CF Jerez 30 44 35 41
10 Grupo Empresa Bazán CF Grupo 30 49 53 41
11 Xerez Deportivo B Xerez 30 57 51 40
12 CD Guadalcacín Guadalcacín 30 53 46 39
13 CD Jédula CD Jédula 30 43 51 39
14 Barbate Barbate 30 55 53 35
15 Recreativo Portuense Recreativo 30 27 74 17
16 CD UD Villamartín Villamartín 30 20 126 7
TEMPORADA 2021/2022
PRIMERA ANDALUZA GRUPO 16
Equipo PJ GF GC Puntos
1 Algeciras CF B Algeciras 28 56 47 41
2 Guadiaro Guadiaro 28 44 31 39
3 Puerto Real CF Puerto Real 28 29 45 36
4 Los Cortijillos Cortijillos 28 53 54 36
5 CD San Roque Roque 28 48 43 36
6 San Bernardo Bernardo 28 38 42 32
7 Chiclana Industrial Chiclana 28 35 52 26
8 Tesorillo Tesorillo 28 32 53 24
9 Rayo Sanluqueño Rayo 28 44 81 23
10 Ubrique UD Ubrique UD 28 39 68 21
TEMPORADA 2020/2021
DIVISIÓN HONOR SENIOR GRUPO 6
Equipo PJ GF GC Puntos
1 Bollullos CF Bollullos 30 52 30 48
2 Atlético Onubense Atlético 30 48 39 44
3 Atlético Algabeño Atlético 30 41 34 42
4 Torreblanca CF Torreblanca 30 37 40 42
5 CD Alcalá CD Alcalá 30 42 36 40
6 Isla Cristina Isla 30 41 42 39
7 AD San José José 30 42 46 39
8 Puerto Real CF Puerto Real 30 36 41 36
9 Ciudad Jardin CD Ciudad 30 30 45 33
10 CD San Roque Roque 30 27 44 32
11 Aroche CF Aroche CF 30 29 51 25
12 Écija Balompié Écija 30 29 63 17
TEMPORADA 2019/2020
PRIMERA ANDALUZA GRUPO 2
Equipo PJ GF GC Puntos
1 Puerto Real CF Puerto Real 25 53 23 57
2 Jerez Industrial CF Jerez 25 48 21 54
3 Balón de Cádiz CF Balón 25 48 27 46
4 Ubrique UD Ubrique UD 25 39 29 44
5 Roteña Roteña 25 36 29 42
6 CD El Torno 2009 Torno 2009 25 42 30 39
7 Trebujena CF Trebujena 25 41 31 39
8 Tarifa UD Tarifa UD 25 35 33 36
9 CD UD Villamartín Villamartín 25 32 31 35
10 Chipiona CF Chipiona CF 25 49 40 34
11 San Bernardo Bernardo 25 35 35 32
12 Tesorillo Tesorillo 25 33 45 32
13 Chiclana Industrial Chiclana 25 31 45 31
14 Recreativo Portuense Recreativo 25 29 36 29
15 Barbate Barbate 25 19 37 21
16 Algeciras CF B Algeciras 25 29 64 21
17 Grupo Empresa Bazán CF Grupo 25 23 46 15
18 CD Vejer Balompié Vejer 25 26 46 14
TEMPORADA 2018/2019
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 San Bernardo Bernardo 34 73 41 76
2 Puerto Real CF Puerto Real 34 75 36 74
3 Chipiona CF Chipiona CF 34 67 33 72
4 Barbate Barbate 33 75 46 69
5 Los Cortijillos Cortijillos 34 62 34 63
6 Espera C.F. Espera C.F. 34 62 37 56
7 CD Jédula CD Jédula 34 68 44 56
8 At. Sanluqueño B Sanluqueño 34 57 40 51
9 Medina Balompié Medina 33 59 48 50
10 San Jose Obrero UD Jose Obrero 34 51 63 40
11 Rayo Sanluqueño Rayo 34 55 76 39
12 C.D. La Salle C.D. Salle 34 36 57 38
13 Estrella Portuense FC Estrella 34 34 60 34
14 Juventud Jerez Industrial Juventud 34 47 68 33
15 Divina Pastora Sanluqueña Divina 34 52 76 31
16 San Jose Atletico Jose 34 44 70 30
17 Facinas Facinas 34 37 86 26
18 Prado del Rey Prado 34 40 79 19
TEMPORADA 2017/2018
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Alcalá del Valle Alcalá 33 69 31 72
2 Tarifa UD Tarifa UD 34 87 44 68
3 Ubrique UD Ubrique UD 32 67 23 67
4 C.D. La Salle C.D. Salle 33 75 33 66
5 Algeciras CF B Algeciras 32 69 34 65
6 San Bernardo Bernardo 31 63 46 59
7 Puerto Real CF Puerto Real 33 64 49 55
8 Medina Balompié Medina 32 58 59 43
9 Los Cortijillos Cortijillos 32 44 45 43
10 Prado del Rey Prado 32 45 62 41
11 Barbate Barbate 30 42 44 37
12 Divina Pastora Sanluqueña Divina 33 40 61 32
13 Espera C.F. Espera C.F. 32 30 46 31
14 CD Rivera CD Rivera 33 41 76 31
15 Facinas Facinas 33 44 65 29
16 At. Sanluqueño B Sanluqueño 31 53 78 27
17 Alma de África Alma África 32 42 78 20
18 Federico Mayo C.F. Federico 26 33 92 10
TEMPORADA 2016/2017
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 San Fernando CD B Fernando 31 83 40 64
2 Rayo Sanluqueño Rayo 32 72 33 62
3 J. Sanluqueña Sanluqueña 32 60 37 60
4 Puerto Real CF Puerto Real 31 63 34 59
5 CD Vejer Balompié Vejer 32 43 23 59
6 Ubrique UD Ubrique UD 32 72 47 57
7 C.D. La Salle C.D. Salle 31 55 37 53
8 San Bernardo Bernardo 32 63 50 47
9 C.D. Union Polidep. El Puer C.D. Union. 31 55 49 47
10 Barbate Barbate 32 47 60 46
11 Prado del Rey Prado 31 38 48 44
12 Tarifa UD Tarifa UD 32 63 74 40
13 Federico Mayo C.F. Federico 31 52 70 36
14 Conil B Conil B 32 31 61 23
15 Espera C.F. Espera C.F. 30 40 63 22
16 Unión Deportiva Torrecera Unión 31 41 89 21
17 Cañorrera Cañorrera 31 26 89 11
TEMPORADA 2015/2016
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Xerez Deportivo Xerez 31 89 12 85
2 Trebujena CF Trebujena 32 64 41 62
3 CD Jédula CD Jédula 32 62 46 56
4 Guadiaro Guadiaro 31 53 39 51
5 CD Rivera CD Rivera 32 55 40 48
6 Estella Cd Estella Cd 32 61 60 48
7 CD El Torno 2009 Torno 2009 31 46 42 48
8 San Jose Obrero UD Jose Obrero 31 59 45 47
9 Balón de Cádiz CF Balón 31 66 61 45
10 Barbate Barbate 32 43 62 43
11 Tesorillo Tesorillo 30 64 47 42
12 Chiclana Industrial Chiclana 31 46 41 42
13 Novo Chiclana Novo 32 42 70 32
14 Puerto Real CF Puerto Real 31 33 61 32
15 San Bernardo Bernardo 31 39 73 30
16 Florida Florida 29 49 97 19
17 CD Balona Balompié CF Balona 23 24 58 12
TEMPORADA 2014/2015
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Recreativo Portuense Recreativo 28 51 21 58
2 Algeciras CF B Algeciras 28 59 26 54
3 CD Jédula CD Jédula 28 61 37 54
4 San Bernardo Bernardo 28 48 42 42
5 San Jose Obrero UD Jose Obrero 28 45 39 42
6 Tesorillo Tesorillo 28 45 41 41
7 Novo Chiclana Novo 28 41 36 38
8 Barbate Barbate 28 44 40 37
9 Estella Cd Estella Cd 28 39 47 35
10 CD Rivera CD Rivera 28 34 43 34
11 Puerto Real CF Puerto Real 28 43 56 34
12 Trebujena CF Trebujena 28 45 67 32
13 Pueblo Nuevo Granja Pueblo Nuevo 28 33 53 29
14 Xerez Cd B Xerez Cd B 28 43 61 24
15 Rayo Sanluqueño Rayo 28 29 51 22
16 CD Portorrealeña Portorreale 0 0 0 0
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 2012/2013
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 La Palma Cf La Palma Cf 32 57 25 70
2 Cf Olímpica Valverdeña Olímpica 32 60 32 70
3 Xerez B Xerez B 32 67 25 67
4 At. Sanluqueño B Sanluqueño 32 50 39 50
5 Isla Cristina Fc Isla 32 53 44 50
6 Cd Rota Cd Rota 32 45 37 47
7 Puerto Real CF Puerto Real 32 60 64 47
8 Jerez Industrial Cf Jerez 32 50 52 42
9 Balón de Cádiz CF Balón 32 58 60 40
10 Chiclana Industrial Chiclana 32 41 43 40
11 Cd Guadalcacín Guadalcacín 32 43 49 40
12 UD Algaida UD Algaida 32 47 64 40
13 Chiclana CF Chiclana CF 32 37 38 39
14 Grupo Empresa Bazán CF Grupo 32 45 59 39
15 Ud Tarifa Ud Tarifa 32 47 59 37
16 CD Canela CD Canela 32 40 67 26
17 Ad Almonte Balompié Almonte 32 40 83 20
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 At. Sanluqueño Sanluqueño 38 81 32 89
2 San Fernando CD Fernando 38 88 51 74
3 Mairena Mairena 38 64 32 71
4 Coria CF Coria CF 38 72 46 68
5 Sevilla C Sevilla C 38 67 46 66
6 Algeciras CF Algeciras 38 57 50 59
7 CD Alcalá CD Alcalá 38 57 52 57
8 Atlético Onubense Atlético 38 59 55 54
9 Cádiz CF Mirandilla Cádiz 38 53 53 50
10 Córdoba CF B Córdoba 38 35 37 45
11 Conil Conil 38 47 68 45
12 CD Pozoblanco Pozoblanco 38 47 49 45
13 Atlético Antoniano Atlético 38 31 45 43
14 CD San Roque Roque 38 53 67 42
15 Puerto Real CF Puerto Real 38 45 63 40
16 RC Portuense Portuense 38 41 53 39
17 Ayamonte Ayamonte 38 46 72 38
18 Jerez Industrial CF Jerez 38 34 51 38
19 UD Marinaleda Marinaleda 38 39 59 38
20 PD Rociera PD Rociera 38 40 75 35
TEMPORADA 2010/2011
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 RB Linense RB Linense 38 65 32 76
2 San Fernando CD Fernando 38 61 33 72
3 CD Pozoblanco Pozoblanco 38 56 33 71
4 Mairena Mairena 38 41 29 63
5 Algeciras CF Algeciras 38 44 33 62
6 RC Portuense Portuense 38 44 38 61
7 Puerto Real CF Puerto Real 38 42 32 59
8 At. Sanluqueño Sanluqueño 38 47 42 56
9 Sevilla C Sevilla C 38 42 40 51
10 Córdoba CF B Córdoba 38 41 38 49
11 UD Los Palacios Palacios 38 40 44 49
12 Coria CF Coria CF 38 57 60 46
13 Jerez Industrial CF Jerez 38 36 58 45
14 Atlético Onubense Atlético 38 40 47 44
15 Conil Conil 38 44 47 43
16 Cádiz CF Mirandilla Cádiz 38 52 50 43
17 UD Marinaleda Marinaleda 38 36 53 42
18 Ayamonte Ayamonte 38 53 62 42
19 Peñarroya Pueblonuevo Peñarroya 38 35 60 34
20 Los Barrios Los Barrios 38 23 68 20
TEMPORADA 2009/2010
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 CD Alcalá CD Alcalá 38 68 21 80
2 Mairena Mairena 38 54 30 70
3 Ayamonte Ayamonte 38 63 33 69
4 UD Marinaleda Marinaleda 38 52 34 66
5 RB Linense RB Linense 38 50 32 63
6 CD Pozoblanco Pozoblanco 38 44 33 62
7 Los Barrios Los Barrios 38 42 41 57
8 Atlético Onubense Atlético 38 61 47 56
9 Córdoba CF B Córdoba 38 38 37 55
10 Cádiz CF Mirandilla Cádiz 38 42 41 54
11 UD Los Palacios Palacios 38 40 45 53
12 Coria CF Coria CF 38 56 47 50
13 Puerto Real CF Puerto Real 38 33 39 49
14 Sevilla C Sevilla C 38 42 39 49
15 Algeciras CF Algeciras 38 48 53 46
16 At. Sanluqueño Sanluqueño 38 36 41 44
17 RC Portuense Portuense 38 39 56 43
18 Murallas de Ceuta Murallas 38 28 42 39
19 Dos Hermanas CF Hermanas 38 24 92 19
20 AD Cartaya AD Cartaya 38 25 82 18
TEMPORADA 2008/2009
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 San Roque de Lepe Roque Lepe 37 64 38 74
2 Jerez Industrial CF Jerez 37 61 37 73
3 Los Barrios Los Barrios 37 58 39 67
4 CD Alcalá CD Alcalá 37 47 30 66
5 Sevilla C Sevilla C 37 68 48 65
6 Coria CF Coria CF 37 56 51 64
7 Puerto Real CF Puerto Real 37 56 35 62
8 Mairena Mairena 37 49 40 54
9 Ayamonte Ayamonte 37 51 54 51
10 CD Pozoblanco Pozoblanco 37 47 46 46
11 Atlético Onubense Atlético 37 41 39 45
12 AD Cartaya AD Cartaya 37 44 55 44
13 Cádiz CF Mirandilla Cádiz 37 38 49 44
14 UD Los Palacios Palacios 37 48 61 43
15 Dos Hermanas CF Hermanas 37 32 46 43
16 At. Sanluqueño Sanluqueño 37 29 49 38
17 Córdoba CF B Córdoba 37 45 69 30
18 Chiclana CF Chiclana CF 37 47 69 28
19 CD Villanueva Villanueva 19 26 20 26
20 Atlético Antoniano Atlético 37 29 61 25
TEMPORADA 2007/2008
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 CD San Fernando Fernando 38 64 36 78
2 Puerto Real CF Puerto Real 38 64 42 70
3 RB Linense RB Linense 38 63 32 69
4 CD Villanueva Villanueva 38 47 32 67
5 CD Pozoblanco Pozoblanco 38 52 38 66
6 At. Sanluqueño Sanluqueño 38 57 43 62
7 UD Los Palacios Palacios 38 54 34 61
8 Sevilla C Sevilla C 38 53 42 60
9 Los Barrios Los Barrios 38 45 39 54
10 Mairena Mairena 38 47 39 50
11 Cádiz CF Mirandilla Cádiz 38 54 56 49
12 San Roque de Lepe Roque Lepe 38 40 50 46
13 Córdoba CF B Córdoba 38 44 63 44
14 Jerez Industrial CF Jerez 38 35 49 41
15 Dos Hermanas CF Hermanas 38 34 49 40
16 Ayamonte Ayamonte 38 36 58 40
17 AD Cartaya AD Cartaya 38 39 61 39
18 A. Cerro Águila Cerro 38 35 53 38
19 Arcos CF Arcos CF 38 34 55 34
20 Xerez B Xerez B 38 30 56 28
TEMPORADA 2006/2007
TERCERA DIVISIÓN GRUPO 10
Equipo PJ GF GC Puntos
1 Algeciras CF Algeciras 38 63 29 79
2 Betis Deportivo Betis 38 59 33 76
3 Lucena Lucena 38 51 30 68
4 CD San Fernando Fernando 38 61 35 68
5 RB Linense RB Linense 38 55 32 67
6 UD Los Palacios Palacios 38 45 37 64
7 Los Barrios Los Barrios 38 62 44 61
8 Arcos CF Arcos CF 38 67 60 59
9 Cádiz CF Mirandilla Cádiz 38 46 43 55
10 Mairena Mairena 38 44 44 53
11 Puerto Real CF Puerto Real 38 53 48 52
12 CD Pozoblanco Pozoblanco 38 40 50 50
13 Córdoba CF B Córdoba 38 37 47 45
14 Ayamonte Ayamonte 38 31 42 41
15 Jerez Industrial CF Jerez 38 35 56 38
16 Xerez B Xerez B 38 41 58 37
17 At. Sanluqueño Sanluqueño 38 36 53 36
18 Club Atlético De Ceuta Club 38 32 54 31
19 Cabecense Cabecense 38 32 66 29
20 Chiclana CF Chiclana CF 38 37 66 28

  USO DE MEMORIA  
7,426,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1449
Total Execution Time  0.1464
  CADENA URL  
/historico/Puerto-Real
  GET DATOS  
$_GET['/historico/Puerto-Real']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0046  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 = 'Puerto-Real' 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.0019  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=2032 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=2032 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0048  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 = 73624
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2032 AND type_rel = 2
0.0042  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 = '2032' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0032  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 = '2032' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 73624 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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=2032 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (73624) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 73624 AND teamId = 2032
0.0042  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 events2024 e ON e.player_id = p.id AND e.league_id = 73624 WHERE rp.league_id = 73624 AND rp.teamId = 2032 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.0038  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 events2024 e ON e.player_id = p.id AND e.league_id = 73624 WHERE rp.league_id = 73624 AND rp.teamId = 2032 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 events2024 e ON e.player_id = p.id AND e.league_id = 73624 WHERE rp.league_id = 73624 AND rp.teamId = 2032 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 2032 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024` 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 = 73624 AND t.round = 29 ORDER BY team.conference ASC,t.position 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 `tables2023` 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 = 68699 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `tables2022` 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 = 64021 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `tables2022` 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 = 67384 AND t.round = 10 ORDER BY team.conference ASC,t.position 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 `tables2021` 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 = 58970 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `tables2021` 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 = 61679 AND t.round = 12 ORDER BY team.conference ASC,t.position 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 `tables2020` 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 = 51255 AND t.round = 25 ORDER BY team.conference ASC,t.position 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 `tables2019` 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 = 45002 AND t.round = 34 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 `tables2018` 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 = 39686 AND t.round = 34 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 `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 = 34423 AND t.round = 34 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 `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 = 16808 AND t.round = 34 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 `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 = 4105 AND t.round = 30 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 `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.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 `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 = 1406 AND t.round = 38 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 `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 = 1136 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 `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 = 844 AND t.round = 38 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 `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 = 140 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 `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 = 17 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 `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 = 95 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC