4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Union Collado Villalba B
TEMPORADA 2022/2023
2ª MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Cerceda Cerceda 28 110 35 78
2 San Agustin Los Negrales Agustin 28 155 39 74
3 Union Collado Villalba B Union 28 135 35 72
4 Atletico Leones Castilla Atletico 28 99 51 58
5 Moralzarzal CF Moralzarzal 28 81 60 53
6 Collado Villalba B Collado 28 82 58 47
7 Alberto Cogorro Alberto 28 78 63 43
8 Becerril de La Sierra Becerril 28 69 80 35
9 Electrocor Las Rozas C Electrocor 28 66 74 32
10 Torrelodones CF B Torrelodones 28 71 92 30
11 Atletico Cercedilla Atletico 28 72 101 30
12 CD Galapagar D Galapagar 28 70 112 30
13 FC Villanueva Del Pardillo Villanueva 28 47 117 13
14 Gimnastica Colmenarejo B Gimnastica 28 49 140 12
15 UD San Lorenzo B Lorenzo 28 28 155 4
TEMPORADA 2021/2022
2ª MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Gimnastica Colmenarejo Gimnastica 28 85 28 71
2 Alpedrete C Alpedrete C 28 114 37 65
3 Alberto Cogorro Alberto 28 107 34 61
4 San Agustin Los Negrales Agustin 28 102 71 55
5 Deporte y Punto Deporte 28 69 43 55
6 Union Collado Villalba B Union 28 73 50 46
7 Atletico Leones Castilla Atletico 28 68 49 39
8 Moralzarzal CF Moralzarzal 27 68 49 39
9 ADC Castilla Castilla 28 58 72 38
10 Atletico Villalba Atletico 28 56 66 31
11 Torrelodones CF B Torrelodones 28 58 79 29
12 Atletico Cercedilla Atletico 28 51 103 22
13 Becerril de La Sierra Becerril 28 48 99 17
14 CD El Escorial B Escorial 27 34 125 11
15 CD Galapagar D Galapagar 28 43 129 8
TEMPORADA 2020/2021
2ª MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Alpedrete B Alpedrete B 15 64 27 36
2 CD El Escorial Escorial 15 59 25 36
3 Alberto Cogorro Alberto 15 58 18 34
4 AD Collado Mediano Collado 15 47 22 33
5 San Agustin Los Negrales Agustin 15 52 39 31
6 Atletico Leones Castilla Atletico 15 35 24 26
7 Gimnastica Colmenarejo Gimnastica 15 37 28 25
8 ADC Castilla Castilla 15 31 41 24
9 Union Collado Villalba B Union 15 21 29 19
10 Atletico Cercedilla Atletico 15 37 43 18
11 Moralzarzal CF Moralzarzal 15 35 34 16
12 Deporte Y Punto Bcm A Deporte 15 29 33 16
13 Torrelodones CF B Torrelodones 15 15 40 11
14 Atletico Villalba Atletico 15 17 66 8
15 CD Galapagar D Galapagar 15 23 53 7
16 Club Union Collado Villalba Club Union. 15 29 67 5
TEMPORADA 2019/2020
1ª MADRID JUVENIL
Equipo PJ GF GC Puntos
1 Torrelodones CF-Altter A Torrelodones 23 51 27 55
2 Boadilla B Boadilla B 23 59 26 51
3 Nuevo Boadilla B Nuevo 23 72 36 50
4 Calasanz Pozuelo A Calasanz 23 76 40 49
5 Las Rozas CF-Dimasu C Rozas 23 69 31 45
6 Alpedrete Alpedrete 23 51 42 39
7 Union Collado Villalba B Union 23 54 48 39
8 Galapagar B Galapagar B 23 43 46 34
9 Prodet Pozuelo Liceo Soroll Prodet 23 65 72 33
10 Hoyo de Manzanares Hoyo 23 59 53 31
11 Fundacion B Fundacion B 23 52 58 30
12 Puerta Madrid Puerta 23 50 65 27
13 UD San Lorenzo A Lorenzo 23 43 51 26
14 Colegio El Prado B Colegio 23 45 74 19
15 FPA Las Rozas Rozas 23 31 53 18
16 K-2 K-2 23 44 67 18
17 Escuela Europea Escuela 23 26 72 15
18 Union de Aravaca A Union 23 38 67 14
TEMPORADA 2018/2019
1ª MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Electrocor Electrocor 34 115 39 81
2 Siete Picos Colmenar B Siete Picos 34 127 51 76
3 Union de Aravaca A Union 34 114 55 68
4 Hoyo de Manzanares Hoyo 34 107 72 65
5 Torrelodones A Torrelodones 34 65 44 63
6 Boadilla B Boadilla B 34 82 54 53
7 Escuela Europea Escuela 34 78 77 52
8 Las Rozas C Las Rozas C 34 82 56 49
9 K-2 K-2 34 73 89 45
10 Union Collado Villalba B Union 34 82 101 44
11 Calasanz Pozuelo A Calasanz 34 59 89 44
12 Nuevo Boadilla B Nuevo 34 72 70 41
13 CF Pozuelo C Pozuelo 34 80 104 39
14 CD Villanueva De La Cañada Villanueva 34 57 81 37
15 Colmenar Viejo B Colmenar 34 62 106 33
16 San Fernando Escolapios Fernando 34 73 120 30
17 Aravaca D Aravaca D 34 45 99 27
18 Deporte y Punto Deporte 34 49 115 19
TEMPORADA 2017/2018
1ª MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Aravaca C Aravaca C 30 104 35 74
2 Fundación A Fundación 30 80 33 67
3 Fuentelarreyna A Fuentelarrey 30 83 45 65
4 Union Collado Villalba B Union 30 64 49 49
5 Santa Maria Caridad A Santa Maria 30 63 49 49
6 CF Pozuelo C Pozuelo 30 63 52 46
7 Barrio Pilar B Barrio Pilar 30 67 53 45
8 Union de Aravaca A Union 30 74 77 44
9 Calasanz Pozuelo A Calasanz 30 73 73 43
10 Valdeluz A Valdeluz A 30 58 59 42
11 Electrocor Electrocor 30 41 60 35
12 CD Villanueva De La Cañada Villanueva 30 43 63 34
13 Galapagar B Galapagar B 30 37 66 27
14 Atletico Villalba Atletico 30 40 75 24
15 Virgen de Mirasierra Virgen 30 43 92 18
16 Collado Villalba Collado 30 52 104 18
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,701,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1220
Total Execution Time  0.1234
  CADENA URL  
/historico/Union-Collado-Villalba-Juvenil-B
  GET DATOS  
$_GET['/historico/Union-Collado-Villalba-Juvenil-B']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0024  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 = 'Union-Collado-Villalba-Juvenil-B' 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.0037  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 = 'Union-Collado-Villalba-Juvenil-B' 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=134395 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=134395 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=134395 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=134395 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=134395 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=134395 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=134395 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=134395 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=134395 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=134395 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=134395 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=134395 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0030  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 = 69892
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=134395 AND type_rel = 2
0.0032  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 = '134395' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '134395' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 69892 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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=134395 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (69892,64225) 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.0021  SELECT count(id) as num_players from rel_players_base WHERE league_id = 69892 AND teamId = 134395
0.0021  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64225 AND teamId = 134395
0.0023  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 = '134395' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '134395' 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 = '134395' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0026  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 = 134395 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 69892 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 = 64225 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 `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 = 64239 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 `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 = 61243 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.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 = 61259 AND t.round = 15 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 = 52078 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 `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 = 45683 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 = 39876 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 `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.0030  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