4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del NAC Breda Sub 21
TEMPORADA 2023/2024
SEGUNDA PAÍSES BAJOS SUB 21 GRUPO 2
Equipo PJ GF GC Puntos
1 ADO Den Haag Sub 21 Haag 11 22 10 24
2 NAC Breda Sub 21 Breda 11 22 19 19
3 Roda JC Sub 21 Roda 11 24 25 18
4 Volendam Sub 21 Volendam 11 24 14 17
5 Vitesse Sub 21 Vitesse 11 15 18 16
6 Heerenveen Sub 21 Heerenveen 11 13 14 14
7 Willem II Sub 21 Willem 11 17 19 9
8 Dordrecht Sub 21 Dordrecht 11 15 33 8
TEMPORADA 2022/2023
LIGA PAÍSES BAJOS SUB 21 GRUPO 2
Equipo PJ GF GC Puntos
1 Almere City Sub 21 Almere City 14 37 18 34
2 De Graafschap Sub 21 Graafschap 14 31 20 27
3 Feyenoord Sub 21 Feyenoord 14 28 15 26
4 ADO Den Haag Sub 21 Haag 14 20 22 20
5 Twente / Heracles Sub 21 Twente 14 17 24 17
6 Groningen Sub 21 Groningen 14 23 24 16
7 PEC Zwolle Sub 21 Zwolle 14 17 29 11
8 NAC Breda Sub 21 Breda 14 19 40 10
TEMPORADA 2021/2022
LIGA PAÍSES BAJOS SUB 21 GRUPO 3
Equipo PJ GF GC Puntos
1 Feyenoord Sub 21 Feyenoord 7 17 5 17
2 PEC Zwolle Sub 21 Zwolle 7 11 7 14
3 Almere City Sub 21 Almere City 7 15 11 12
4 ADO Den Haag Sub 21 Haag 7 13 9 11
5 Groningen Sub 21 Groningen 7 13 9 10
6 Willem II Sub 21 Willem 7 8 11 9
7 NEC Nijmegen Sub 21 Nijmegen 7 8 18 3
8 NAC Breda Sub 21 Breda 7 5 20 2
TEMPORADA 2019/2020
BELOFTEN EREDIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 Go Ahead Eagles Sub 21 Ahead Eagles 5 8 5 9
2 Feyenoord Sub 21 Feyenoord 4 9 4 8
3 Vitesse Sub 21 Vitesse 3 10 4 7
4 Heerenveen Sub 21 Heerenveen 4 14 10 7
5 Groningen Sub 21 Groningen 4 8 7 7
6 PEC Zwolle Sub 21 Zwolle 4 9 7 6
7 FC Emmen Sub 21 Emmen 5 8 9 5
8 Cambuur Sub 21 Cambuur 4 7 13 3
9 De Graafschap Sub 21 Graafschap 3 3 10 3
10 Heracles Sub 21 Heracles 3 2 4 1
11 Twente Sub 21 Twente 3 1 6 1
12 RKC Waalwijk Sub 21 Waalwijk 4 17 2 12
13 NAC Breda Sub 21 Breda 3 4 0 9
14 NEC Nijmegen Sub 21 Nijmegen 4 10 7 7
15 VVV-Venlo Sub 21 VVV-Venlo 4 11 7 6
16 Willem II Sub 21 Willem 3 5 5 6
17 Roda JC Sub 21 Roda 4 6 6 4
18 Den Bosch Sub 21 Bosch 4 6 9 4
19 Dordrecht Sub 21 Dordrecht 4 7 8 3
20 Fortuna Sittard Sub 21 Fortuna 3 5 6 3
21 FC Eindhoven Sub 21 Eindhoven 4 3 12 3
22 Excelsior Sub 21 Excelsior 3 2 14 0
TEMPORADA 2018/2019
BELOFTEN EREDIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 Heracles Sub 21 Heracles 9 42 7 25
2 NEC Nijmegen Sub 21 Nijmegen 9 19 17 15
3 Twente Sub 21 Twente 9 15 15 15
4 PEC Zwolle Sub 21 Zwolle 9 20 14 14
5 FC Emmen Sub 21 Emmen 9 12 7 14
6 Go Ahead Eagles Sub 21 Ahead Eagles 9 19 16 14
7 De Graafschap Sub 21 Graafschap 9 26 16 13
8 Heerenveen Sub 21 Heerenveen 9 20 25 10
9 Cambuur Sub 21 Cambuur 9 13 20 7
10 Achilles '29 Sub 21 Achilles 9 4 53 3
11 Fortuna Sittard Sub 21 Fortuna 10 26 9 24
12 Feyenoord Sub 21 Feyenoord 10 30 9 22
13 Willem II Sub 21 Willem 10 21 12 18
14 RKC Waalwijk Sub 21 Waalwijk 10 17 12 18
15 ADO Den Haag Sub 21 Haag 10 14 20 16
16 NAC Breda Sub 21 Breda 10 12 10 14
17 Excelsior Sub 21 Excelsior 10 21 21 13
18 FC Eindhoven Sub 21 Eindhoven 10 18 26 12
19 Roda JC Sub 21 Roda 9 17 22 9
20 VVV/Helmond Sport Sub 21 VVV/Helmond 9 8 24 7
21 Dordrecht Sub 21 Dordrecht 10 10 29 5
TEMPORADA 2017/2018
BELOFTEN EREDIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 Heerenveen Sub 21 Heerenveen 16 43 23 33
2 Cambuur Sub 21 Cambuur 16 27 23 27
3 ADO Den Haag Sub 21 Haag 16 33 27 26
4 NEC Nijmegen Sub 21 Nijmegen 16 25 26 25
5 Heracles Sub 21 Heracles 16 27 28 24
6 Feyenoord Sub 21 Feyenoord 16 27 27 18
7 Excelsior Sub 21 Excelsior 16 22 25 18
8 NAC Breda Sub 21 Breda 16 19 28 15
9 RKC Waalwijk Sub 21 Waalwijk 16 28 44 13
TEMPORADA 2016/2017
BELOFTEN EREDIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 Heerenveen Sub 21 Heerenveen 11 31 12 22
2 Feyenoord Sub 21 Feyenoord 10 21 13 20
3 Excelsior Sub 21 Excelsior 11 18 16 17
4 NAC Breda Sub 21 Breda 11 21 19 14
5 ADO Den Haag Sub 21 Haag 11 21 23 14
6 Cambuur Sub 21 Cambuur 11 13 20 14
7 Heracles Sub 21 Heracles 10 13 21 12
8 Roda JC Sub 21 Roda 11 15 29 9
TEMPORADA 2015/2016
BELOFTEN EREDIVISIE
Equipo PJ GF GC Puntos
1 Feyenoord Sub 21 Feyenoord 14 41 19 35
2 ADO Den Haag Sub 21 Haag 14 31 20 27
3 Heerenveen Sub 21 Heerenveen 14 31 16 25
4 Heracles Sub 21 Heracles 14 39 30 22
5 Cambuur Sub 21 Cambuur 14 30 23 22
6 PEC Zwolle Sub 21 Zwolle 14 21 39 13
7 Willem II Sub 21 Willem 14 15 34 8
8 VVV-Venlo Sub 21 VVV-Venlo 14 11 38 5
9 Excelsior Sub 21 Excelsior 12 29 10 28
10 NAC Breda Sub 21 Breda 12 25 20 19
11 Go Ahead Eagles Sub 21 Ahead Eagles 12 19 17 17
12 Roda JC Sub 21 Roda 12 21 22 17
13 NEC Nijmegen Sub 21 Nijmegen 12 19 18 14
14 Fortuna Sittard Sub 21 Fortuna 12 17 33 12
15 Dordrecht Sub 21 Dordrecht 12 16 26 11
16 Utrecht Sub 23 Utrecht 20 43 24 40
17 Vitesse Sub 23 Vitesse 20 55 37 38
18 Jong AZ Jong AZ 20 41 21 36
19 Jong Sparta Jong Sparta 20 45 38 36
20 Groningen Sub 21 Groningen 20 42 30 33
21 Twente Sub 21 Twente 20 31 29 31
22 Jong Almere City Jong Almere 20 49 47 27
23 Jong Volendam Jong 20 43 31 26
24 De Graafschap Sub 21 Graafschap 20 32 44 22
25 Brabant United Sub 23 Brabant 20 25 50 15
26 Achilles '29 Sub 21 Achilles 20 17 72 7
TEMPORADA 2014/2015
BELOFTEN EREDIVISIE GRUPO 2
Equipo PJ GF GC Puntos
1 Heracles Sub 21 Heracles 12 24 10 25
2 NAC Breda Sub 21 Breda 12 22 15 24
3 Roda JC Sub 21 Roda 12 26 17 19
4 NEC Nijmegen Sub 21 Nijmegen 12 16 15 14
5 Go Ahead Eagles Sub 21 Ahead Eagles 12 16 17 14
6 Brabant United Sub 23 Brabant 12 14 23 12
7 Fortuna Sittard Sub 21 Fortuna 12 11 32 8
8 Utrecht Sub 23 Utrecht 12 33 14 29
9 Groningen Sub 21 Groningen 12 30 12 26
10 ADO Den Haag Sub 21 Haag 12 21 18 16
11 PEC Zwolle Sub 21 Zwolle 12 22 21 16
12 Jong Volendam Jong 12 21 27 16
13 Dordrecht Sub 21 Dordrecht 12 24 31 14
14 De Graafschap Sub 21 Graafschap 12 7 35 4
15 Vitesse Sub 23 Vitesse 14 40 16 31
16 Willem II Sub 21 Willem 14 32 24 25
17 Feyenoord Sub 21 Feyenoord 14 32 27 23
18 Jong AZ Jong AZ 14 33 25 21
19 Heerenveen Sub 21 Heerenveen 14 29 23 20
20 VVV-Venlo Sub 21 VVV-Venlo 14 21 41 14
21 Jong Sparta Jong Sparta 14 26 37 12
22 Jong Almere City Jong Almere 14 26 46 11
TEMPORADA 2013/2014
BELOFTEN EREDIVISIE
Equipo PJ GF GC Puntos
1 Vitesse Sub 23 Vitesse 20 54 37 39
2 Groningen Sub 21 Groningen 20 43 30 39
3 Heracles Sub 21 Heracles 20 43 35 35
4 Heerenveen Sub 21 Heerenveen 20 60 36 34
5 ADO Den Haag Sub 21 Haag 20 45 34 29
6 NEC Nijmegen Sub 21 Nijmegen 20 37 31 28
7 VVV-Venlo Sub 21 VVV-Venlo 20 36 42 28
8 PEC Zwolle Sub 21 Zwolle 20 41 50 28
9 Fortuna Sittard Sub 21 Fortuna 20 34 51 19
10 Jong Volendam Jong 20 30 47 15
11 Dordrecht Sub 21 Dordrecht 20 32 62 14
12 Feyenoord Sub 21 Feyenoord 20 50 17 44
13 Willem II Sub 21 Willem 20 34 18 39
14 RKC Waalwijk Sub 21 Waalwijk 20 30 34 34
15 De Graafschap Sub 21 Graafschap 20 40 42 31
16 Jong AZ Jong AZ 20 47 34 30
17 Jong Sparta Jong Sparta 20 35 32 29
18 Roda JC Sub 21 Roda 20 27 31 27
19 Utrecht Sub 23 Utrecht 20 29 28 20
20 NAC Breda Sub 21 Breda 20 32 43 20
21 Jong Almere City Jong Almere 20 37 50 17
22 Den Bosch Sub 21 Bosch 20 26 58 13
TEMPORADA 2012/2013
BELOFTEN EREDIVISIE GRUPO 2
Equipo PJ GF GC Puntos
1 Jong AZ Jong AZ 22 75 31 52
2 Jong Volendam Jong 22 53 50 39
3 Jong Sparta Jong Sparta 22 47 30 37
4 VVV-Venlo Sub 21 VVV-Venlo 22 41 33 34
5 De Graafschap Sub 21 Graafschap 22 43 48 33
6 PEC Zwolle Sub 21 Zwolle 22 42 34 32
7 Roda JC Sub 21 Roda 22 36 38 31
8 ADO Den Haag Sub 21 Haag 22 41 38 28
9 Willem II Sub 21 Willem 22 27 38 27
10 Fortuna Sittard Sub 21 Fortuna 22 39 48 23
11 Den Bosch Sub 21 Bosch 22 31 46 23
12 PSV Sub 21 PSV Sub 21 13 28 26 20
13 Dordrecht Sub 21 Dordrecht 22 27 68 14
14 Groningen Sub 21 Groningen 2 2 0 4
15 Heerenveen Sub 21 Heerenveen 2 7 6 4
16 Feyenoord Sub 21 Feyenoord 2 7 5 3
17 Twente Sub 21 Twente 1 6 4 3
18 Heracles Sub 21 Heracles 1 1 0 3
19 Jong Ajax Jong Ajax 2 1 2 3
20 Utrecht Sub 21 Utrecht 1 3 4 0
21 Vitesse Sub 21 Vitesse 1 1 2 0
22 NAC Breda Sub 21 Breda 1 0 3 0
23 NEC Nijmegen Sub 21 Nijmegen 2 0 4 0
TEMPORADA 2011/2012
BELOFTEN EREDIVISIE GRUPO 2
Equipo PJ GF GC Puntos
1 NAC Breda Sub 21 Breda 21 49 28 37
2 Den Bosch Sub 21 Bosch 18 37 22 34
3 Willem II Sub 21 Willem 19 29 23 34
4 Jong Volendam Jong 25 39 48 26
5 VVV-Venlo Sub 21 VVV-Venlo 17 27 38 21
6 Dordrecht Sub 21 Dordrecht 18 22 44 12

  USO DE MEMORIA  
6,075,848 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6836
Total Execution Time  0.6848
  CADENA URL  
/historico/Nac-Breda-Sub-21
  GET DATOS  
$_GET['/historico/Nac-Breda-Sub-21']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0136  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 = 'Nac-Breda-Sub-21' 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.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=120882 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=120882 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=120882 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0252  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 = 72954
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=120882 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 120882 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0132  SELECT /*35 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 (657856) ORDER BY n.cover_points DESC, update_date DESC
0.0145  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 = '120882' ORDER BY l.year DESC,cat.coefficient DESC
0.0141  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 = '120882' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '120882' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0135  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 = 72955 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0137  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=120882 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0162  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 (72955,70876) 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.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 72955 AND teamId = 120882
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 70876 AND teamId = 120882
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 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 = 72954 AND t.round = 11 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0130  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 = '120882' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '120882' and rp.type = 4
0.0128  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 = '120882' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0135  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72954 WHERE rp.league_id = 72954 AND rp.teamId = 120882 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72954 WHERE rp.league_id = 72954 AND rp.teamId = 120882 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72954 WHERE rp.league_id = 72954 AND rp.teamId = 120882 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 120882 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0127  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` 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 = 72955 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.0127  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` 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 = 72954 AND t.round = 11 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 `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 = 68772 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.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` 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 = 70876 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.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` 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 = 66845 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.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` 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 = 67132 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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` 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 = 51476 AND t.round = 11 ORDER BY team.conference ASC,t.position 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 `tables2019` 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 = 49582 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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` 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 = 49578 AND t.round = 11 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 `tables2018` 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 = 49628 AND t.round = 18 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` 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 = 49637 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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` 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 = 16023 AND t.round = 22 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 `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 = 49665 AND t.round = 10 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 `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 = 9455 AND t.round = 14 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 `tables2014` 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 = 49668 AND t.round = 22 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 `tables2013` 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 = 49669 AND t.round = 7 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 `tables2013` 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 = 49670 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 `tables2012` 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 = 49672 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  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 = 72954 ORDER BY nameShow LIMIT 100