4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Villanueva del Pardillo A
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 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 19 C Real Madrid 34 129 20 93
2 ED Moratalaz Sub 19 Moratalaz 34 75 38 65
3 Complutense Alcalá Sub 19 Complutense 34 72 45 62
4 Fundacion Alcala Fundacion 34 63 53 58
5 Rayo Mjdh. Sub 19 C Rayo Mjdh. 34 64 51 55
6 Rayo Vallecano Sub 19 C Rayo 34 71 59 53
7 Santa Ana Sub 19 Santa 34 61 65 51
8 Villaviciosa de Odón A Villaviciosa 34 71 77 50
9 Chopera Alcobendas Sub 19 Chopera 34 61 49 48
10 San Fernando B Fernando 34 59 56 48
11 Villanueva del Pardillo A Villanueva 34 52 59 46
12 Nuevo Boadilla Sub 19 Nuevo 34 70 72 43
13 Canillas Sub 19 Canillas 34 57 80 38
14 UD Sanse Sub 19 Sanse 34 50 81 38
15 CD Móstoles C Móstoles 34 53 72 36
16 Unión Adarve C Unión 34 38 71 31
17 Alcobendas Sub 19 Alcobendas 34 30 67 24
18 Aluche B Aluche B 34 40 101 23
TEMPORADA 2020/2021
1ª AUTO. MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 19 C Real Madrid 19 94 9 57
2 Unión Adarve Sub 19 B Unión 19 31 20 41
3 Sporting Hortaleza Sub 19 Sporting 19 52 25 40
4 Santa Ana Sub 19 Santa 19 55 44 34
5 Villanueva del Pardillo A Villanueva 19 28 22 30
6 Chamartín Vergara A Chamartín 19 33 28 30
7 Chopera Alcobendas Sub 19 Chopera 19 33 36 30
8 Alcalá B Alcalá B 19 28 35 30
9 UD Sanse Sub 19 Sanse 19 32 34 29
10 Canillas B Canillas B 19 29 30 26
11 Complutense Alcalá Sub 19 Complutense 19 36 44 26
12 Nuevo Boadilla Sub 19 Nuevo 19 39 38 24
13 Moratalaz Sub 19 B Moratalaz 19 32 30 23
14 Aravaca B Aravaca B 19 28 36 23
15 Union Zona Norte A Union Zona. 19 30 38 21
16 San Roque EFF Roque 19 25 44 21
17 Siete Picos Colmenar A Siete Picos 19 32 43 20
18 Torrejon B Torrejon B 19 27 62 16
19 CF Pozuelo A Pozuelo 19 20 33 15
20 Collado Villalba A Collado 19 24 57 11
TEMPORADA 2019/2020
1ª AUTO. MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 19 C Real Madrid 23 108 15 64
2 Rayo Vallecano Sub 19 C Rayo 23 82 26 61
3 Las Rozas CF Sub 19 Rozas 23 51 36 40
4 Alcalá B Alcalá B 23 44 38 39
5 Fuenlabrada Sub 19 B Fuenlabrada 23 40 23 36
6 Nuevo Boadilla Sub 19 Nuevo 23 47 40 36
7 Aravaca B Aravaca B 23 38 56 33
8 Canillas B Canillas B 23 37 38 32
9 Unión Adarve Sub 19 B Unión 23 33 45 32
10 Siete Picos Colmenar A Siete Picos 23 33 42 29
11 Villanueva del Pardillo A Villanueva 23 35 41 28
12 UD Sanse Sub 19 Sanse 23 42 52 27
13 Santa Ana Sub 19 Santa 23 46 60 26
14 Union Zona Norte A Union Zona. 23 38 58 24
15 CF Pozuelo A Pozuelo 23 31 56 24
16 Complutense Alcalá Sub 19 Complutense 23 31 40 19
17 Chopera Alcobendas Sub 19 Chopera 23 30 57 17
18 Collado Villalba A Collado 23 28 71 11
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
1ª MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Calasanz Pozuelo A Calasanz 29 66 38 55
2 Union Collado Villalba B Union 28 79 52 54
3 Villanueva del Pardillo A Villanueva 27 63 49 51
4 Las Rozas C Las Rozas C 29 65 57 47
5 Celtic Castilla A Celtic 27 79 62 45
6 Atletico Villalba Atletico 28 68 61 45
7 Galapagar B Galapagar B 28 47 42 43
8 Fuentelarreyna A Fuentelarrey 28 57 48 43
9 CF Pozuelo C Pozuelo 27 65 53 41
10 CD Villanueva De La Cañada Villanueva 28 59 53 41
11 Fundación A Fundación 28 68 56 40
12 Unión Adarve D Unión 28 46 64 32
13 Ciringanillos Ciringanillo 28 52 63 30
14 San Lorenzo San Lorenzo 29 60 88 28
15 Alpedrete Alpedrete 17 16 61 3
16 Santa Maria Caridad A Santa Maria 11 7 50 0
TEMPORADA 2014/2015
1ª MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Aravaca B Aravaca B 30 95 31 72
2 CF Pozuelo B Pozuelo 30 85 43 68
3 Union Collado Villalba B Union 30 106 66 56
4 Villanueva del Pardillo A Villanueva 30 79 41 56
5 Fuentelarreyna A Fuentelarrey 30 82 63 53
6 Santa Maria Caridad A Santa Maria 30 64 40 52
7 Las Rozas D Las Rozas D 30 74 51 50
8 San Agustin A Agustin 30 70 44 48
9 Ford A Ford A 30 66 59 48
10 Galapagar B Galapagar B 30 65 51 43
11 San Lorenzo San Lorenzo 30 53 67 32
12 Ciringanillos Ciringanillo 30 42 75 29
13 Calasanz Pozuelo B Calasanz 30 46 79 28
14 Masriver Masriver 30 38 90 22
15 Buen Consejo Buen Consejo 30 35 105 18
16 Torrelodones B Torrelodones 30 24 119 7

  USO DE MEMORIA  
5,975,848 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1196
Total Execution Time  0.1208
  CADENA URL  
/historico/Villanueva-Pardillo-Dimasu-Motor-A-Juven
  GET DATOS  
$_GET['/historico/Villanueva-Pardillo-Dimasu-Motor-A-Juven']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
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 = 'Villanueva-Pardillo-Dimasu-Motor-A-Juven' 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.0028  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 = 'Villanueva-Pardillo-Dimasu-Motor-A-Juven' 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=22105 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=22105 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=22105 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=22105 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=22105 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=22105 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=22105 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=22105 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=22105 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=22105 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 68909
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=22105 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=731 AND type_rel = 3
0.0022  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.0022  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.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 = '22105' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '22105' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '22105' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = '22105' 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 = 68909 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=22105 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (68909) 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_base WHERE league_id = 68909 AND teamId = 22105
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 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 = 68909 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '22105' 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 = '22105' 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 = '22105' 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 = 22105 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0028  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.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 `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.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 = 61288 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.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 = 51855 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.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 `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.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 `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.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 `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.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 `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 = 16978 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 `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 = 4601 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 68909 ORDER BY nameShow LIMIT 100