4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Los Cortijillos
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
PRIMERA ANDALUZA GRUPO 34
Equipo PJ GF GC Puntos
1 Los Cortijillos Cortijillos 4 10 4 9
2 Algeciras CF B Algeciras 4 8 6 8
3 UD Algaida UD Algaida 6 13 10 9
4 Chipiona CF Chipiona CF 6 8 15 6
5 Grupo Empresa Bazán CF Grupo 4 7 11 3
TEMPORADA 2019/2020
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Guadiaro Guadiaro 25 79 17 69
2 Los Cortijillos Cortijillos 25 53 20 55
3 UD Algaida UD Algaida 25 56 24 48
4 Xerez Deportivo B Xerez 25 65 34 47
5 CD Jédula CD Jédula 25 45 33 41
6 San Fernando CD B Fernando 25 42 34 41
7 CD Rivera CD Rivera 25 36 30 40
8 RC Portuense Portuense 25 42 32 39
9 Divina Pastora Sanluqueña Divina 25 28 41 31
10 Amigos Cruz Roja Jerez Amigos Cruz 25 39 45 28
11 J. Sanluqueña Sanluqueña 25 39 46 28
12 Medina Balompié Medina 25 36 41 27
13 Estrella Portuense FC Estrella 25 23 39 25
14 Rayo Sanluqueño Rayo 25 21 40 25
15 Alcalá del Valle Alcalá 25 27 53 24
16 Espera C.F. Espera C.F. 25 22 54 23
17 Cañorrera Cañorrera 25 18 65 21
18 San Jose Obrero UD Jose Obrero 25 30 53 20
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 2013/2014
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 CD UD Villamartín Villamartín 30 60 36 58
2 Los Cortijillos Cortijillos 30 46 32 58
3 Algeciras CF B Algeciras 30 58 26 54
4 CD Rivera CD Rivera 30 46 31 54
5 CD Balona Balompié CF Balona 30 55 43 51
6 Pueblo Nuevo La Granja Pueblo Nuevo 30 46 46 49
7 Estella Cd Estella Cd 30 52 35 47
8 Recreativo Portuense Recreativo 30 50 38 46
9 Barbate Barbate 30 40 44 39
10 Rayo Sanluqueño Rayo 30 44 46 39
11 CD Jédula CD Jédula 30 40 48 39
12 Atletico El Gastor Atletico 30 43 54 35
13 Tarifa UD Tarifa UD 30 43 59 34
14 Athletic Nueva Jarilla Athletic 30 38 46 34
15 Cdg Don Benito Benito 30 42 86 24
16 Federico Mayo C.F. Federico 30 24 57 16
TEMPORADA 2009/2010
3ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 CD Rivera CD Rivera 27 71 34 61
2 Tiempo Libre Tiempo Libre 28 48 23 59
3 Puerto Serrano Bpié. Puerto 27 84 56 55
4 Estella Cd Estella Cd 27 60 35 51
5 Los Cortijillos Cortijillos 28 60 37 50
6 Puerto Real CF B Puerto Real 28 63 39 48
7 Cádiz Provincial Cádiz 27 71 48 46
8 Alcalá Atlético Alcalá 28 46 45 40
9 CD El Torno 2009 Torno 2009 27 44 40 36
10 Olvera Olvera 27 45 44 36
11 Athletic Club Jimena Athletic 28 38 55 28
12 Sindicales Sindicales 28 41 73 24
13 Juventud Torrecera Juventud 27 34 82 20
14 Arcos CF Arcos CF 28 28 88 12
15 Pastores Pastores 21 31 65 11
TEMPORADA 2008/2009
3ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 El Colorado El Colorado 16 31 15 30
2 Conil B Conil B 16 30 21 29
3 Español de Vejer Español 16 29 21 27
4 Sidonia Bpie Sidonia Bpie 16 28 21 25
5 Alcalá Atlético Alcalá 16 22 20 24
6 Los Cortijillos Cortijillos 16 22 28 19
7 Jimena Jimena 16 23 31 17
8 Cádiz Provincial Cádiz 16 15 24 17
9 Sindicales Sindicales 16 15 34 12
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
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 AD Cartaya AD Cartaya 30 64 21 69
2 San Roque de Lepe Roque Lepe 30 60 17 64
3 Punta Umbria Punta Umbria 30 57 33 63
4 Tesorillo Tesorillo 30 64 38 52
5 Atlético Onubense Atlético 30 63 41 52
6 La Palma La Palma 30 43 37 46
7 Roteña Roteña 30 36 28 36
8 Barbate Barbate 30 45 41 36
9 Los Cortijillos Cortijillos 30 39 42 36
10 Conil Conil 30 33 38 36
11 Chiclana Industrial Chiclana 30 24 45 35
12 Algeciras CF B Algeciras 30 37 55 34
13 At. Cortegana Cortegana 30 39 59 33
14 Bollullos CF Bollullos 30 29 46 29
15 Ubrique Ind. Ubrique Ind. 30 25 51 26
16 Hinojos Hinojos 30 25 91 9
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

  USO DE MEMORIA  
6,033,976 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1535
Total Execution Time  0.1547
  CADENA URL  
/historico/Cortijillos
  GET DATOS  
$_GET['/historico/Cortijillos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (51)  
0.0027  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 = 'Cortijillos' 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.0033  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 = 'Cortijillos' 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=1591 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=1591 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  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=1591 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=1591 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=1591 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=1591 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=1591 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=1591 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=1591 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=1591 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=1591 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=1591 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=1591 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  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=1591 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=1591 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027  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 = 67384
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1591 AND type_rel = 2
0.0032  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1591 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0019  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (381069) ORDER BY n.cover_points DESC, update_date DESC
0.0028  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 = '1591' ORDER BY l.year DESC,cat.coefficient DESC
0.0031  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 = '1591' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '1591' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = '1591' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 67384 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  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=1591 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (67384) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 67384 AND teamId = 1591
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 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 = 64022 AND t.round = 18 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '1591' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1591' and rp.type = 4
0.0021  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 = '1591' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 events2022 e ON e.player_id = p.id AND e.league_id = 64022 WHERE rp.league_id = 64022 AND rp.teamId = 1591 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.0021  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 events2022 e ON e.player_id = p.id AND e.league_id = 64022 WHERE rp.league_id = 64022 AND rp.teamId = 1591 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 events2022 e ON e.player_id = p.id AND e.league_id = 64022 WHERE rp.league_id = 64022 AND rp.teamId = 1591 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 1591 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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 = 58973 AND t.round = 22 ORDER BY team.conference ASC,t.position 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 `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 = 62159 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 51363 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.0032  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.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 `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.0029  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 = 2586 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 `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 = 2992 AND t.round = 30 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 `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 = 2991 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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.0021  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 = 115 AND t.round = 30 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 `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.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 `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.0020  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 = 64022 ORDER BY nameShow LIMIT 100