4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Reino de Granada
TEMPORADA 2022/2023
2ª ANDALUZA GRANADA CADETE
Equipo PJ GF GC Puntos
1 Español Albolote Sub 16 Español 30 86 35 68
2 Ciudad de Granada Ciudad 30 93 48 65
3 CD Estrellas Chana Barrio Estrellas 30 82 42 63
4 Santa Fe Santa Fe 30 85 47 54
5 CD We Futbol Club B Futbol Club 30 60 39 53
6 CD Medina Lauxa Medina Lauxa 30 59 56 51
7 Reino de Granada Reino 30 60 50 47
8 Costa Tropical Costa 30 62 62 44
9 C.D. Huetor Tajar C.D. Huetor 30 56 66 43
10 Arenas de Armilla C Arenas 30 63 56 42
11 CD Zaidin CD Zaidin 30 70 62 41
12 CD Churriana de la Vega CF Churriana 30 57 65 35
13 Ogijares 89 Ogijares 89 30 56 81 32
14 Atarfe Industrial C.F. A Atarfe 30 48 89 20
15 Puerto de Motril Puerto 30 38 93 17
16 Sierra Nevada Cenes Sierra 30 44 128 8
TEMPORADA 2021/2022
4ª ANDALUZA GRANADA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Iznalloz Iznalloz 28 117 39 77
2 Valderrubio Fútbol 98 Valderrubio 28 113 47 65
3 UD Maracena D Maracena 28 133 53 60
4 Ciudad de Granada Ciudad 28 103 47 60
5 Club Deportivo Benalúa Club 28 102 68 56
6 Sporting Club de GÜevejar Sporting 28 101 73 47
7 We Futbol Club Sub 16 Futbol Club 28 99 77 44
8 Español Albolote Sub 16 Español 28 78 73 43
9 Reino de Granada Reino 28 57 53 38
10 Caniles Caniles 28 56 71 33
11 Alfacar Alfacar 28 58 80 30
12 CF Cullar CF Cullar 28 44 98 20
13 Cme Club Montañero Estudian Club 28 38 122 15
14 Estrellas Parque Nueva Gran Estrellas 28 49 119 13
15 Rayo Eneas Rayo Eneas 28 25 153 6
TEMPORADA 2020/2021
2ª ANDALUZA GRANADA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 CD We Futbol Club B Futbol Club 7 31 10 21
2 Arenas de Armilla C Arenas 7 22 8 18
3 Atlético La Zubia Atlético 7 23 9 16
4 Ciudad de Granada Ciudad 6 11 10 10
5 Zaidin Zaidin 7 13 13 10
6 Ogijares 89 A Ogijares 7 15 16 7
7 Reino de Granada Reino 7 13 21 7
8 UD Motril UD Motril 6 7 16 4
9 Calahonda-Carchuna Calahonda-Ca 6 12 20 3
10 Granada Origen Granada 6 9 33 0
TEMPORADA 2019/2020
4ª ANDALUZA GRANADA CADETE
Equipo PJ GF GC Puntos
1 CD Colegio Mulhacen Colegio 14 76 17 37
2 CD Inacua CD Inacua 14 43 18 30
3 CD UD Monachil Monachil 14 44 21 28
4 CD Estrellas Chana Barrio Estrellas 14 63 19 25
5 UD Rayo Eneas A Rayo Eneas 14 58 21 25
6 Pinos Puente Club De Fútbol Pinos Puente 14 27 24 23
7 C.D. Huetor Tajar C.D. Huetor 13 27 37 22
8 Fuente Vaqueros Fuente 13 43 39 18
9 CD Medina Lauxa Medina Lauxa 14 32 42 16
10 CD Cijuela 2008 Cijuela 2008 14 31 45 12
11 Reino de Granada Reino 14 21 75 9
12 CD Churriana de la Vega CF Churriana 14 12 119 0
TEMPORADA 2018/2019
3ª ANDALUZA GRANADA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Medina Lauxa Medina Lauxa 30 117 25 79
2 Celtic Celtic 30 129 36 75
3 UD Maracena C Maracena 30 112 40 73
4 Reino de Granada Reino 30 135 56 68
5 Comarcal Comarcal 30 121 79 58
6 Alfacar Alfacar 30 63 49 43
7 Guadix Atletico Guadix 30 67 69 42
8 Granada Base Granada Base 30 73 89 39
9 Ciudad de Granada Abogados Ciudad 30 65 73 33
10 Gabia Atletico Gabia 30 60 85 32
11 Caniles Caniles 30 59 80 31
12 Atarfe Industrial Sub 16 Atarfe 30 78 104 31
13 Vandalia de Peligros Vandalia 30 68 117 30
14 Colegio Mulhacen Colegio 30 83 109 29
15 Ogijares 89 Ogijares 89 30 61 114 27
16 Estrellas Chana Barrio A Estrellas 30 26 192 7
TEMPORADA 2017/2018
3ª ANDALUZA GRANADA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Huescar Huescar 15 80 14 43
2 Celtic Celtic 15 44 13 38
3 Colegio Mulhacen Colegio 15 58 42 31
4 Guadix Atletico Guadix 15 41 32 27
5 UD Maracena C Maracena 15 42 40 26
6 Vandalia de Peligros Vandalia 15 36 33 25
7 Granada Noroeste Granada 15 42 42 25
8 Ciudad de Granada Base Live Ciudad 15 37 36 23
9 Campotejar Campotejar 15 51 38 19
10 Reino de Granada Reino 15 32 31 19
11 Ciudad de Baza Ciudad Baza 15 33 35 17
12 Club Deportivo Benalúa Club 15 53 59 15
13 Iznalloz Iznalloz 15 26 39 15
14 Guadix Guadix 15 17 67 9
15 Deifontes Deifontes 15 16 50 7
16 Albolote Soccer Alda Albolote 15 23 60 5
TEMPORADA 2016/2017
2ª ANDALUZA GRANADA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 UD Motril UD Motril 30 183 28 83
2 Calahonda-Carchuna Calahonda-Ca 30 140 34 75
3 Arenas de Armilla Sub 16 Arenas 30 117 61 71
4 Puerto de Motril Puerto 30 111 64 59
5 Cullar Vega Base A Cullar Vega 30 89 80 55
6 Granada Base Granada Base 30 101 60 53
7 Albolote Soccer Alda Albolote 30 91 53 51
8 UD Maracena B Maracena 30 127 80 50
9 Granada 74 Granada 74 30 75 66 44
10 Huetor Vega Huetor Vega 30 77 72 37
11 Almuñecar 77 Almuñecar 30 64 84 30
12 Otura CF. Otura CF. 30 50 131 27
13 Reino de Granada Reino 30 55 120 24
14 Atletico Salobreña Atletico 30 33 98 16
15 Churriana de la Vega Churriana 30 43 140 13
16 Cultural Asako Motril Cultural 30 31 216 2
TEMPORADA 2015/2016
4ª ANDALUZA GRANADA CADETE GRUPO 4
Equipo PJ GF GC Puntos
1 CD We Futbol Club B Futbol Club 20 157 16 60
2 Chauchina Chauchina 20 67 31 47
3 Reino de Granada Reino 20 70 49 41
4 Cijuela 2008 Cijuela 2008 20 71 62 35
5 Progress R1 Progress R1 20 57 51 32
6 UD Maracena D Maracena 20 65 45 29
7 Fuente Vaqueros Fuente 20 46 43 28
8 Pinos Puente Pinos Puente 20 69 96 27
9 Valderrubio Fútbol 98 Valderrubio 20 25 122 8
10 Santa Fe Santa Fe 20 39 78 6
11 Nazari Nazari 20 33 106 4

  USO DE MEMORIA  
5,531,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.1525
Total Execution Time  0.1541
  CADENA URL  
/historico/Cf-Reino-De-Granada-Cadete
  GET DATOS  
$_GET['/historico/Cf-Reino-De-Granada-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
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 = 'Cf-Reino-De-Granada-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.0036  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 = 'Cf-Reino-De-Granada-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.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=69370 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=69370 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=69370 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=69370 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=69370 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=69370 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=69370 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=69370 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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=69370 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027  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=69370 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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=69370 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=69370 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0033  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=69370 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=69370 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0029  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 = 70163
0.0028  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 = 70187
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=69370 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=532 AND type_rel = 3
0.0022  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 = '69370' ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '69370' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '69370' 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 = 70163 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 70187 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=69370 AND l.year in (2022,2023,2024) 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 (70187,70163,66154) 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 = 70163 AND teamId = 69370
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70187 AND teamId = 69370
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 66154 AND teamId = 69370
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 = '69370' 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 = '69370' 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 = '69370' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 = 69370 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 = 70187 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 `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 = 70163 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 `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 = 66041 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.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 `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 = 66094 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.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 `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 = 66154 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 `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 = 59522 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.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 `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 = 59784 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.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 `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 = 52415 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 `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 = 52792 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 `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 = 45936 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 `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 = 40615 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0102  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 = 35177 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 `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 = 17373 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC