4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Conil
TEMPORADA 2022/2023
2ª ANDALUZA CÁDIZ CADETE
Equipo PJ GF GC Puntos
1 Atlético Sanluqueño Sub 16 Atlético 28 83 31 62
2 Balón De Cádiz CF B Balón 28 57 28 60
3 Algeciras B CF Algeciras 28 57 31 54
4 San Fernando Isleño Fernando 28 46 26 52
5 Arcos Club de Fútbol Academ Arcos Club. 27 59 39 51
6 Conil Conil 29 47 31 44
7 Atlético Zabal Atlético 28 36 40 39
8 Sporting Chiclana CD Sporting 27 37 33 36
9 Xerez Deportivo A Xerez 28 35 43 35
10 Estrella Portuense Estrella 28 37 33 32
11 Monitores Algeciras A Monitores 28 42 59 30
12 Tiempo Libre Tiempo Libre 27 26 44 29
13 Sancti-Petri APA AD Sancti-Petri 28 27 45 27
14 RC Portuense Portuense 28 27 58 25
15 Guadalcacin Guadalcacin 27 18 90 6
16 CD Comarca de Jerez Comarca 1 1 4 0
TEMPORADA 2021/2022
2ª ANDALUZA CÁDIZ CADETE
Equipo PJ GF GC Puntos
1 CD San Roque Roque 32 113 62 70
2 Atlético Sanluqueño Sub 16 Atlético 32 98 49 68
3 CD Comarca de Jerez Comarca 32 97 43 64
4 Sporting Chiclana CD Sporting 32 85 35 61
5 Atlético Zabal Atlético 32 86 45 61
6 Wea Sierra de Cadiz Sierra Cadiz 32 68 49 55
7 Algeciras B CF Algeciras 32 70 45 53
8 Conil Conil 32 79 76 49
9 Xerez Deportivo A Xerez 32 64 58 46
10 Tiempo Libre Tiempo Libre 32 61 58 44
11 Sancti Petri A Sancti Petri 32 63 75 41
12 Estrella Portuense Estrella 32 54 71 37
13 Pueblo Nuevo La Granja Pueblo Nuevo 32 49 61 35
14 Loluba A Loluba A 32 46 81 26
15 Ciudad de Algeciras Ciudad 32 40 108 22
16 CD San Fernando Atlético Fernando 32 40 89 18
17 La Salle A La Salle A 32 34 142 9
TEMPORADA 2020/2021
4ª ANDALUZA CÁDIZ CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Chipiona CF A Chipiona 11 49 8 30
2 CD Magallanes Magallanes 11 45 10 26
3 Ciudad de Cadiz PCD Ciudad Cadiz 11 32 14 19
4 Trasmallo Trasmallo 10 23 15 17
5 Rvo Portuense Club Futbol B Portuense 11 13 34 13
6 RC Portuense Portuense 11 14 21 10
7 CD Rota CD Rota 10 14 34 10
8 Conil Conil 11 9 30 4
9 Pueblo Nuevo La Granja A Pueblo Nuevo 11 14 62 4
TEMPORADA 2019/2020
4ª ANDALUZA CÁDIZ JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 CD Benalup CD Benalup 23 68 17 59
2 La Salle La Salle 22 70 25 52
3 Bazán Grupo Empresa CF Bazán Grupo 22 65 30 48
4 Tiempo Libre A Tiempo Libre 22 72 26 46
5 CD Cadistas La Isla Cadistas 21 52 33 42
6 CD Cañorrera Cañorrera 22 50 30 40
7 Conil Conil 22 49 45 31
8 CD Sp. Chiclana Chiclana 22 50 34 29
9 CD Escuela Bahia San Fernan Escuela 22 45 50 26
10 CD Medina Balompié Medina 22 61 47 24
11 CD Fair Play Futbol Fair Play F. 22 35 49 24
12 CD La Salle Jerez B Salle Jerez 21 29 58 19
13 CD Olimpico CD Olimpico 21 25 44 15
14 CD Pastora 1966 Pastora 1966 22 34 103 15
15 UD Río San Pedro B Río Pedro 10 13 47 7
16 CD Novo Chiclana Novo 22 17 97 1
TEMPORADA 2018/2019
3ª ANDALUZA CÁDIZ CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Sporting Chiclana CD Sporting 26 111 31 66
2 Barbate Barbate 26 98 27 64
3 APA Sancti Petri Sancti Petri 26 86 37 57
4 Novo Chiclana CD Novo 26 75 36 49
5 Futbol Vejer Futbol Vejer 26 66 45 49
6 Fair Play Futbol CD Fair Play F. 26 67 52 43
7 CD Benalup CD Benalup 26 57 45 41
8 Cañorrera Cañorrera 26 69 68 39
9 Sanix La Isla Sanix Isla 26 52 57 35
10 Conil Conil 26 44 66 20
11 Tiempo Libre Tiempo Libre 26 44 70 20
12 Chiclana Ind. CF Chiclana 26 32 63 20
13 Medina Balompié Medina 26 27 79 19
14 Nueva Vida Nueva Vida 26 16 168 3
15 Futbol Sanix Chiclana Futbol Sanix 0 0 0 0
16 Grupo Empresa Bazan Grupo 0 0 0 0
TEMPORADA 2017/2018
2ª ANDALUZA CÁDIZ CADETE
Equipo PJ GF GC Puntos
1 Algeciras CF Sub 16 Algeciras 30 153 34 76
2 Sancti Petri A Sancti Petri 30 82 53 67
3 Xerez Deportivo A Xerez 30 84 39 60
4 Balón De Cádiz CF B Balón 30 90 33 58
5 Conil Conil 30 54 42 57
6 San Jose Obrero UD Sub 16 Jose Obrero 30 72 56 54
7 Rvo Portuense Club Futbol B Portuense 30 66 50 50
8 La Salle A La Salle A 30 60 59 49
9 Sanluqueño Atlético B Sanluqueño 30 59 57 46
10 CD Guadalcacín A Guadalcacín 30 61 78 33
11 San Fernando CD Isleño Fernando 30 52 66 27
12 Atletico Zabal A Atletico 30 47 81 27
13 Pueblo Nuevo La Granja A Pueblo Nuevo 30 48 74 26
14 Arcos A Arcos A 30 37 74 25
15 Novo Chiclana A Novo 30 38 119 16
16 Amigos Cruz Roja Jerez Amigos Cruz 30 24 112 9
TEMPORADA 2016/2017
3ª ANDALUZA CÁDIZ CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Conil Conil 32 186 19 83
2 San Fernando CD Isleño Fernando 32 147 16 81
3 Sancti-Petri B Sancti-Petri 32 114 41 77
4 Medina Balompié A Medina 32 151 38 76
5 Barbate Barbate 32 130 40 66
6 Chiclana CF A Chiclana 32 122 54 63
7 Futbol Vejer Futbol Vejer 32 99 60 57
8 CD Benalup CD Benalup 32 108 64 51
9 Burreños Asociación Burreños 32 109 64 45
10 Sporting Chiclana CD Sporting 32 85 73 44
11 Escuela Bahia San Fernando Escuela 32 76 82 42
12 Tiempo Libre Tiempo Libre 32 68 86 34
13 Novo Chiclana B Novo 32 53 92 33
14 Chiclana Industrial Chiclana 32 48 186 16
15 Futbol Sanix Futbol Sanix 32 28 180 12
16 Olimpico B Olimpico B 32 21 213 7
17 Pastora 1966 Pastora 1966 32 12 249 3
TEMPORADA 2015/2016
3ª ANDALUZA CÁDIZ CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Novo Chiclana CD Novo 26 105 17 71
2 Santic Petri A Santic Petri 26 102 32 60
3 Conil Conil 26 93 32 55
4 Barbate Barbate 26 103 26 55
5 Futbol Vejer A Futbol Vejer 26 78 36 54
6 Chiclana CF A Chiclana 26 84 40 44
7 Medina Balompié A Medina 26 86 62 40
8 Chiclana Industrial Chiclana 26 63 46 37
9 San Fernando CD Isleño Fernando 26 65 48 35
10 CD Benalup CD Benalup 26 59 87 25
11 Sporting Chiclana CD Sporting 26 32 78 21
12 Burreños Asociación Burreños 26 28 119 13
13 Futbol Sanix Futbol Sanix 26 42 152 9
14 Sanix La Isla Sanix Isla 26 23 188 3

  USO DE MEMORIA  
5,517,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1415
Total Execution Time  0.1427
  CADENA URL  
/historico/Conil-Cf-Cadete
  GET DATOS  
$_GET['/historico/Conil-Cf-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (52)  
0.0023  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 = 'Conil-Cf-Cadete' 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.0032  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 = 'Conil-Cf-Cadete' 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=68372 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=68372 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=68372 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=68372 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=68372 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=68372 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=68372 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=68372 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=68372 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=68372 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=68372 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=68372 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=68372 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=68372 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=68372 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=68372 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=68372 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 = 68954
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=68372 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=447 AND type_rel = 3
0.0024  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 = '68372' 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 = '68372' AND l.year = 2023 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 = '68372' 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 = 68954 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=68372 AND l.year in (2022,2023,2024) 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 (68954,65015,65013) 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.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 68954 AND teamId = 68372
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 65013 AND teamId = 68372
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 65015 AND teamId = 68372
0.0019  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 68954 AND t.round = 30 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 = '68372' 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 = '68372' 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 = '68372' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0024  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 = 68372 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2023_base` 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 = 68954 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.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 `tables2022_base` 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 = 65013 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.0020  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_base` 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 = 65015 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.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 `tables2022_base` 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 = 66039 AND t.round = 34 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_base` 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 = 59842 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.0020  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_base` 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 = 59851 AND t.round = 14 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_base` 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 = 60406 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.0020  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_base` 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 = 60441 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.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 `tables2020_base` 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 = 52409 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.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 `tables2020_base` 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 = 52943 AND t.round = 26 ORDER BY team.conference ASC,t.position 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 `tables2020_base` 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 = 53899 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.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 `tables2019_base` 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 = 45903 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 `tables2019_base` 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 = 45918 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 `tables2018_base` 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 = 41328 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 `tables2017_base` 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 = 34461 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_base` 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 = 17257 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC