4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sporting Hortaleza A
TEMPORADA 2022/2023
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid C Real Madrid 26 255 14 78
2 At. Chopera Sub 12 Chopera 26 135 47 69
3 Colegio El Prado A Colegio 26 159 66 59
4 Fundacion A Fundacion A 26 122 61 55
5 Sporting Hortaleza A Sporting 26 116 72 48
6 San Sebastian Reyes A Sebastian 26 109 95 43
7 Tres Cantos A Tres Cantos 26 106 104 39
8 Deportivo Av Santa Ana A Deportivo 26 97 89 35
9 Fundación Recuerdo Fundación 26 86 103 33
10 Highlands El Encinar Highlands 26 67 119 28
11 Union Deportiva Tres Cantos Union 26 78 123 24
12 Colmenar Viejo B Colmenar 26 54 168 10
13 Esperanza A Esperanza A 26 44 172 9
14 Chamartin Vergara A Chamartin 26 48 252 6
TEMPORADA 2021/2022
DIVISIÓN HONOR MADRID ALEVÍN F11 GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Sub 12 Atlético 30 174 9 88
2 Real Madrid Sub 12 B Real Madrid 30 172 10 83
3 R. Ciudad Alcobendas Sub 12 Ciudad 30 81 31 64
4 Getafe Sub 12 B Getafe 30 102 28 62
5 Unión Adarve Sub 12 Unión 30 57 61 53
6 At. Chpr. Alcobendas Sub 12 Chpr. 30 45 57 50
7 Fundacion Rayo Vallecano A Fundacion 30 53 62 48
8 Canillas Canillas 30 53 72 39
9 Colegio Miramadrid Colegio 30 33 53 38
10 Las Rozas A Las Rozas A 30 34 55 36
11 Atletico Madrileño Sub 12 Atletico 30 43 82 33
12 Sporting Hortaleza A Sporting 30 46 72 32
13 Villa Rosa A Villa Rosa 30 38 83 28
14 CD Leganés Sub 12 B Leganés 30 29 90 19
15 Complutense Alcala A Complutense 30 29 106 9
16 San Sebastian Reyes A Sebastian 30 27 145 7
TEMPORADA 2020/2021
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Sub 12 Atlético 17 115 4 49
2 Real Madrid Sub 12 B Real Madrid 17 105 2 49
3 Canillas Canillas 17 35 25 36
4 Sporting Hortaleza A Sporting 17 22 19 34
5 Villa Rosa A Villa Rosa 17 43 23 33
6 Unión Adarve Sub 12 Unión 17 35 26 32
7 Electrocor Las Rozas A Electrocor 17 34 23 31
8 Rayo Majadahonda Rayo 17 22 14 30
9 Aravaca A Aravaca A 17 31 35 25
10 Union Zona Norte Sub 12 Union Zona. 17 17 22 21
11 Getafe D Getafe D 17 19 28 21
12 Atletico Villalba A Atletico 17 24 45 17
13 CDE FPA Las Rozas A Rozas 17 19 55 15
14 San Roque A San Roque A 17 13 39 12
15 Torrelodones A Torrelodones 17 14 59 10
16 Club San Agustin A Club Agustin 17 11 47 9
17 Ciudad del Futbol B Ciudad 17 10 52 8
18 Gredos-San Diego Gredos-San 17 0 51 0
TEMPORADA 2019/2020
1ª MADRID ALEVÍN GRUPO 13
Equipo PJ GF GC Puntos
1 Valdebebas A Valdebebas 14 86 21 39
2 Sporting Hortaleza A Sporting 14 76 15 37
3 San Agustin A Agustin 14 72 35 30
4 Chamartin C Chamartin C 14 44 36 25
5 Ntra Sra del Buen Consejo D Ntra Buen C. 13 48 39 22
6 San Agustin B Agustin 14 62 55 21
7 Valdebebas B Valdebebas 14 53 44 19
8 Sporting Hortaleza B Sporting 13 34 47 13
9 CD Las Tablas Tablas 13 25 53 8
10 Valdeluz Valdeluz 13 15 100 4
11 Buen Consejo C Buen Consejo 14 29 99 2
TEMPORADA 2018/2019
1ª MADRID ALEVÍN GRUPO 8
Equipo PJ GF GC Puntos
1 Castilla Chamartin Castilla 24 191 54 67
2 Castilla Chamartin B Castilla 24 114 42 57
3 Virgen de Mirasierra C Virgen 24 133 57 53
4 Sporting Hortaleza A Sporting 24 104 49 51
5 Liceo Europeo Liceo 24 127 68 48
6 Sporting Las Tablas Sporting 24 104 58 43
7 Colegio Suizo de Madrid Colegio 24 109 117 30
8 Futbol Alcobendas Sport Futbol 24 98 127 29
9 Sporting Las Tablas B Sporting 23 67 94 25
10 Sporting Hortaleza B Sporting 24 86 91 24
11 E Academia de Futbol Alcobe Academia 24 52 155 15
12 Sporting Seis de Diciembre Sporting 24 43 153 10
13 Sporting Seis de Diciembre Sporting 23 20 183 0
TEMPORADA 2017/2018
1ª MADRID ALEVÍN GRUPO 8
Equipo PJ GF GC Puntos
1 Club Fuentelarreyna A Club 24 145 19 72
2 Futbol Alcobendas Sport Futbol 24 177 44 64
3 Liceo Europeo A Liceo 24 145 51 54
4 Colegio Suizo de Madrid Colegio 24 109 58 49
5 Club Fuentelarreyna B Club 24 111 59 48
6 Virgen de Mirasierra C Virgen 24 86 75 41
7 E Academia de Futbol Alcobe Academia 24 49 86 29
8 Liceo Europeo B Liceo 24 63 91 28
9 Sporting Hortaleza A Sporting 24 49 93 19
10 Sporting Hortaleza B Sporting 24 53 142 15
11 Sporting Seis de Diciembre Sporting 24 49 129 14
12 Castilla Chamartin Castilla 24 69 134 13
13 Santa Helena Santa Helena 24 34 158 9
TEMPORADA 2016/2017
1ª AUTO. MADRID ALEVÍN F7 GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Sub 12 Atlético 25 129 15 75
2 Real Madrid Sub 12 B Real Madrid 25 162 11 69
3 Union Zona Norte Sub 12 Union Zona. 26 45 30 47
4 Deportivo Av Santa Ana A Deportivo 26 60 55 42
5 R. Ciudad Alcobendas Sub 12 Ciudad 26 39 40 39
6 Alcobendas Levitt A Alcobendas 26 41 39 36
7 Atletico Madrileño A Atletico 25 38 51 35
8 Unión Adarve Sub 12 Unión 26 35 54 32
9 Rayo Majadahonda Rayo 26 24 52 32
10 Nuevo Boadilla Sub 12 Nuevo 25 29 56 27
11 Las Rozas A Las Rozas A 26 30 59 27
12 EFMO Boadilla Sub 12 EFMO 26 31 68 27
13 Sporting Hortaleza A Sporting 25 21 81 12
14 At. Chpr. Alcobendas Sub 12 Chpr. 25 20 93 8
TEMPORADA 2015/2016
1ª AUTO. MADRID ALEVÍN F7 GRUPO 2
Equipo PJ GF GC Puntos
1 Alcala A Alcala A 26 87 12 70
2 Real Madrid C Real Madrid 26 88 31 62
3 Sporting Hortaleza A Sporting 26 75 30 60
4 Alameda de Osuna A Alameda 26 45 43 44
5 Coslada A Coslada A 26 61 47 42
6 Vicalvaro A Vicalvaro A 26 41 54 37
7 Club Fundacion Rayo Valleca Club 26 38 41 36
8 San Fernando A Fernando 26 39 56 34
9 Complutense Alcala A Complutense 26 35 40 34
10 Club Atletico de Madrid D Club 26 44 35 32
11 Canillas Canillas 26 41 42 31
12 Getafe C Getafe C 26 33 61 22
13 Naya A Naya A 26 26 92 10
14 Chamartin Vergara A Chamartin 26 13 82 3
TEMPORADA 2014/2015
1ª AUTO. MADRID ALEVÍN F7 GRUPO 2
Equipo PJ GF GC Puntos
1 Alcala A Alcala A 26 89 16 61
2 Atlético C Atlético C 26 66 30 55
3 Real Madrid C Real Madrid 26 86 16 54
4 Coslada A Coslada A 26 57 24 47
5 Canillas Canillas 26 71 33 46
6 Getafe C Getafe C 26 65 30 42
7 Sporting Hortaleza A Sporting 26 47 37 42
8 Vicalvaro A Vicalvaro A 26 54 44 40
9 Club Fundacion Rayo Valleca Club 26 44 34 37
10 Complutense Alcala A Complutense 26 61 60 34
11 San Blas A San Blas A 26 36 47 27
12 EF Concepcion Sub 12 Concepcion 26 30 83 12
13 Parque Granada A Parque 26 16 110 7
14 Atletico Torrejon Ardoz A Atletico 26 17 175 4

  USO DE MEMORIA  
5,494,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.6505
Total Execution Time  0.6523
  CADENA URL  
/historico/Ad-Sporting-Hortaleza-A-Alevin
  GET DATOS  
$_GET['/historico/Ad-Sporting-Hortaleza-A-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0130  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 = 'Ad-Sporting-Hortaleza-A-Alevin' 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.0139  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 = 'Ad-Sporting-Hortaleza-A-Alevin' 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.0125  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=38915 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=38915 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=38915 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=38915 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=38915 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=38915 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=38915 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=38915 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=38915 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=38915 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=38915 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=38915 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=38915 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=38915 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=38915 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=984 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 984 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  SELECT /*53 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 (930948,914706,76448) ORDER BY n.cover_points DESC, update_date DESC
0.0128  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 = '38915' ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '38915' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '38915' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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=38915 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (70516,64881) 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.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64881 AND teamId = 38915
0.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70516 AND teamId = 38915
0.0126  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 = '38915' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  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 = '38915' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0129  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 = 38915 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 = 70516 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.0130  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 = 64881 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.0128  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 = 61490 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 52472 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.0129  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 = 52666 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.0128  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 = 45481 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 46915 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 41677 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 42209 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 36344 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 34513 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 17996 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 6529 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC