4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Rayo Mjdh. Sub 19 C
TEMPORADA 2023/2024
1ª AUTO. MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 19 C Real Madrid 30 102 18 82
2 Torrejón Sub 19 Torrejón 30 80 42 66
3 Chopera Alcobendas Sub 19 Chopera 30 75 43 62
4 Santa Ana Sub 19 Santa 30 63 49 54
5 Rayo C. Alcobendas Sub 19 C Rayo 30 51 39 48
6 Las Rozas Sub 19 B Rozas 30 47 42 48
7 Aravaca Sub 19 Aravaca 30 63 63 46
8 Boadilla Sub 19 Boadilla 30 57 49 45
9 Nuevo Boadilla Sub 19 Nuevo 30 49 63 41
10 Atlético Madrid Sub 19 C Atlético 30 57 59 40
11 Tres Cantos Sub 19 Tres Cantos 30 57 69 38
12 Unión Adarve Sub 19 B Unión 30 39 49 37
13 Rayo Mjdh. Sub 19 C Rayo Mjdh. 30 45 66 29
14 Coslada Sub 19 Coslada 30 38 61 29
15 San Fernando Sub 19 Fernando 30 36 55 28
16 Pozuelo Alarcón Sub 19 Pozuelo 30 36 61 25
17 Canillas Sub 19 Canillas 30 40 67 25
18 San Sebastian Reyes Sub 19 Sebastian 30 47 87 23
TEMPORADA 2022/2023
1ª AUTO. MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 19 C Real Madrid 33 122 26 91
2 Rayo CI Alcobendas Sub 19 B Rayo 33 92 43 72
3 Fundacion Alcala Fundacion 33 87 48 66
4 Yebenes-San Bruno Sub 19 Yebenes-San 33 90 58 61
5 Chopera Alcobendas Sub 19 Chopera 33 75 54 61
6 Coslada Sub 19 Coslada 33 67 45 58
7 Nuevo Boadilla Sub 19 Nuevo 33 77 43 57
8 Moratalaz Sub 19 B Moratalaz 33 69 46 57
9 Unión Adarve Sub 19 B Unión 33 60 69 50
10 Santa Ana Sub 19 Santa 33 62 67 43
11 Canillas Sub 19 Canillas 33 65 74 42
12 Rayo Mjdh. Sub 19 C Rayo Mjdh. 33 55 56 41
13 Puerta Bonita A Puerta 33 70 96 39
14 Las Rozas Sub 19 B Rozas 33 69 67 38
15 Boadilla B Boadilla B 33 49 82 29
16 San Fernando Sub 19 Fernando 33 29 118 13
17 Villanueva del Pardillo A Villanueva 33 31 105 12
18 Chamartín Vergara A Chamartín 33 46 118 11
TEMPORADA 2021/2022
1ª AUTO. MADRID JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Fuenlabrada Sub 19 B Fuenlabrada 34 90 33 75
2 Atlético Madrid Sub 19 C Atlético 34 81 45 72
3 Rayo Mjdh. Sub 19 C Rayo Mjdh. 34 93 32 70
4 San Sebastian Reyes Sub 19 Sebastian 34 75 32 70
5 Getafe Sub 19 C Getafe 34 74 37 69
6 Leganés Sub 19 C Leganés 34 70 46 65
7 Moratalaz Sub 19 B Moratalaz 34 48 57 52
8 Navalcarnero A Navalcarnero 34 80 73 49
9 Canillas B Canillas B 34 51 49 49
10 Chamartín Vergara A Chamartín 34 74 74 45
11 Móstoles URJC Sub 19 B Móstoles 34 66 65 44
12 Unión Carrascal A Unión 34 62 99 41
13 Ciudad de Getafe A Ciudad 34 53 58 36
14 At. Casarrubuelos Casarrubuelo 34 50 65 36
15 Atlético de Pinto B Atlético 34 50 73 28
16 Inter de Valdemoro A Inter 34 41 80 26
17 Alcalá B Alcalá B 34 35 109 20
18 Sitio de Aranjuez Sitio 34 38 104 19
TEMPORADA 2020/2021
PREFERENTE MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Rayo Mjdh. Sub 19 C Rayo Mjdh. 19 70 11 52
2 Unión Adarve C Unión 19 61 21 49
3 Las Rozas Sub 19 B Rozas 19 56 14 41
4 Boadilla B Boadilla B 19 53 21 41
5 Galapagar A Galapagar A 19 53 34 34
6 Fundacion A Fundacion A 19 47 27 33
7 Colmenar Viejo A Colmenar 19 50 43 27
8 Nuevo Boadilla B Nuevo 19 44 50 26
9 Santa Ana B Santa Ana B 19 34 43 24
10 Barrio Pilar A Barrio Pilar 19 33 28 23
11 Trival Valderas Alcorcón C Trival 19 31 31 22
12 Torrelodones CF-Altter A Torrelodones 19 25 46 22
13 Tres Cantos A Tres Cantos 19 28 39 21
14 CF Pozuelo B Pozuelo 19 37 51 21
15 Electrocor Electrocor 19 27 33 20
16 Aravaca C Aravaca C 19 33 43 20
17 Siete Picos Colmenar B Siete Picos 19 29 48 20
18 Retamar Retamar 19 30 50 18
19 Celtic Castilla A Celtic 19 25 61 13
20 Tres Cantos Sub 19 Tres Cantos 19 14 86 9
TEMPORADA 2019/2020
PREFERENTE MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Chamartín Vergara A Chamartín 23 69 18 56
2 Sporting Hortaleza B Sporting 23 59 27 52
3 Rayo Mjdh. Sub 19 C Rayo Mjdh. 23 42 29 41
4 CF Pozuelo B Pozuelo 23 39 26 41
5 Barrio Pilar A Barrio Pilar 23 35 26 38
6 Las Rozas Sub 19 B Rozas 23 45 33 37
7 Galapagar A Galapagar A 23 52 46 35
8 Escuela Futbol de Brunete Escuela 23 51 48 35
9 Unión Adarve C Unión 23 40 31 33
10 Retamar Retamar 23 50 58 33
11 Electrocor Electrocor 23 40 42 29
12 Santa Ana B Santa Ana B 23 45 45 28
13 Siete Picos Colmenar B Siete Picos 23 38 63 25
14 Tres Cantos Sub 19 Tres Cantos 23 34 52 24
15 Aravaca C Aravaca C 23 44 54 23
16 Colmenar Viejo A Colmenar 23 29 43 19
17 Celtic Castilla A Celtic 23 32 61 18
18 Tres Cantos A Tres Cantos 23 29 71 13
TEMPORADA 2018/2019
PREFERENTE MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Nuevo Boadilla Sub 19 Nuevo 33 103 51 69
2 Villanueva del Pardillo A Villanueva 33 96 50 67
3 Tres Cantos Sub 19 Tres Cantos 34 78 48 65
4 Rayo Mjdh. Sub 19 C Rayo Mjdh. 34 78 50 63
5 Las Rozas Sub 19 B Rozas 34 84 55 59
6 San Sebastian Reyes Sub 19 Sebastian 33 67 43 55
7 Unión Adarve C Unión 33 69 49 55
8 Chamartín Vergara A Chamartín 33 72 74 49
9 Santa Ana B Santa Ana B 33 76 75 47
10 Celtic Castilla A Celtic 33 89 83 46
11 Retamar Retamar 34 68 74 44
12 CF Pozuelo B Pozuelo 34 68 71 43
13 Galapagar A Galapagar A 33 51 61 43
14 Aravaca C Aravaca C 33 47 57 38
15 Union Zona Norte B Union Zona. 33 74 98 36
16 Fundacion A Fundacion A 33 55 79 35
17 San Blas B San Blas B 33 39 148 9
18 Club San Agustin A Club Agustin 22 16 64 7
TEMPORADA 2017/2018
PREFERENTE MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Siete Picos Colmenar A Siete Picos 34 102 40 82
2 Colmenar Viejo A Colmenar 34 93 45 80
3 Futbol Alcobendas Sport Futbol 34 110 47 76
4 Rayo Mjdh. Sub 19 C Rayo Mjdh. 34 95 50 75
5 Chopera Alcobendas Sub 19 Chopera 34 108 71 63
6 Unión Adarve C Unión 34 63 34 61
7 Santa Ana B Santa Ana B 34 106 81 56
8 Escuela Futbol de Brunete Escuela 34 86 76 51
9 Villanueva del Pardillo A Villanueva 34 87 86 47
10 Tres Cantos Sub 19 Tres Cantos 34 79 92 44
11 Retamar Retamar 34 73 90 41
12 San Sebastian Reyes Sub 19 Sebastian 34 48 68 39
13 Tres Cantos A Tres Cantos 34 59 71 38
14 Zona Norte B Zona Norte 34 69 94 36
15 Alcobendas-Levitt B Alcobendas-L 34 57 97 34
16 Rayo CI Alcobendas Sub 19 B Rayo 34 35 78 18
17 Torrelodones A Torrelodones 34 40 105 18
18 Las Rozas C Las Rozas C 34 36 121 16
TEMPORADA 2016/2017
PREFERENTE MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 CF Pozuelo A Pozuelo 34 95 36 82
2 Galapagar A Galapagar A 34 109 52 78
3 Santa Ana B Santa Ana B 34 95 48 69
4 Unión Adarve C Unión 34 62 39 58
5 Escuela Futbol de Brunete Escuela 34 67 62 52
6 Torrejon B Torrejon B 34 66 62 51
7 Tres Cantos A Tres Cantos 34 63 60 48
8 Fundacion Recuerdo Fundacion 34 57 58 48
9 Retamar Retamar 34 52 61 47
10 Villanueva del Pardillo A Villanueva 34 68 66 46
11 Rayo Mjdh. Sub 19 C Rayo Mjdh. 34 64 64 45
12 Siete Picos Colmenar A Siete Picos 34 63 78 43
13 San Sebastian Reyes Sub 19 Sebastian 34 57 63 42
14 San Fernando C Fernando 34 74 85 42
15 Barrio Pilar B Barrio Pilar 34 39 66 39
16 Nuevo Boadilla Sub 19 Nuevo 34 58 88 31
17 Móstoles E Móstoles E 34 53 87 26
18 Union Collado Villalba B Union 34 43 110 22
TEMPORADA 2015/2016
PREFERENTE MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Rayo CI Alcobendas Sub 19 Rayo 34 107 43 78
2 Aravaca B Aravaca B 34 78 37 71
3 Rayo Mjdh. Sub 19 C Rayo Mjdh. 34 80 48 65
4 CF Pozuelo A Pozuelo 34 127 74 60
5 Galapagar A Galapagar A 34 81 57 58
6 Retamar Retamar 34 84 56 57
7 Fundacion Recuerdo Fundacion 34 66 69 54
8 Chopera Alcobendas Sub 19 Chopera 34 89 68 51
9 Unión Adarve C Unión 34 66 63 50
10 Tres Cantos A Tres Cantos 34 77 65 48
11 Siete Picos Colmenar A Siete Picos 34 71 63 47
12 Móstoles D Móstoles D 34 54 65 41
13 Futbol Alcobendas Sport Futbol 34 70 93 39
14 Barrio Pilar B Barrio Pilar 34 52 66 35
15 Colmenar Viejo B Colmenar 34 46 75 29
16 Jarama Race A Jarama Race 34 50 127 26
17 Moralzarzal Moralzarzal 34 49 120 19
18 Zona Norte B Zona Norte 34 32 90 18
TEMPORADA 2014/2015
PREFERENTE MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Torrelodones A Torrelodones 34 72 28 76
2 Alcobendas-Levitt B Alcobendas-L 34 99 39 74
3 Retamar Retamar 34 78 45 73
4 Moralzarzal Moralzarzal 34 77 52 63
5 Tres Cantos A Tres Cantos 34 56 33 62
6 CF Pozuelo A Pozuelo 34 97 59 58
7 Unión Adarve C Unión 34 76 45 58
8 Barrio Pilar B Barrio Pilar 34 50 56 45
9 Rayo Mjdh. Sub 19 C Rayo Mjdh. 34 60 57 41
10 Galapagar A Galapagar A 34 50 50 40
11 Rayo CI Alcobendas Sub 19 Rayo 34 76 77 40
12 Colmenar Viejo B Colmenar 34 56 69 40
13 Futbol Alcobendas Sport Futbol 34 51 101 38
14 Zona Norte B Zona Norte 34 49 56 37
15 Colegio El Prado Colegio 34 56 85 36
16 Calasanz Pozuelo A Calasanz 34 55 82 34
17 Las Rozas C Las Rozas C 34 57 85 32
18 Alpedrete Alpedrete 34 36 132 10

  USO DE MEMORIA  
6,006,608 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6110
Total Execution Time  0.6123
  CADENA URL  
/historico/Rayo-Majadahonda-C
  GET DATOS  
$_GET['/historico/Rayo-Majadahonda-C']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0159  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 = 'Rayo-Majadahonda-C' 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.0145  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=22026 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=22026 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0306  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 = 74253
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=22026 AND type_rel = 2
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=731 AND type_rel = 3
0.0158  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 731 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0150  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 (1067892,914706,889402,860480,829183) ORDER BY n.cover_points DESC, update_date DESC
0.0148  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 = '22026' ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '22026' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0151  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 = '22026' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0150  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 = 74253 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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=22026 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0149  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 (74253) 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.0146  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74253 AND teamId = 22026
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 74253 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0156  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 = '22026' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0149  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '22026' and rp.type = 4
0.0151  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 = '22026' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0152  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 = 22026 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0153  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_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 = 74253 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.0153  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 = 68909 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 64789 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.0151  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 = 64790 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.0151  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 = 61290 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 52060 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.0293  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 = 45651 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 39208 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 = 34188 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 16975 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 4597 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC