4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Udinese Sub 19
TEMPORADA 2019/2020
CAMPIONATO PRIMAVERA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Milan Sub 19 Milan 19 61 14 53
2 SPAL Sub 19 SPAL Sub 19 18 40 29 37
3 Udinese Sub 19 Udinese 19 39 24 35
4 Hellas Verona Sub 19 Hellas 18 36 26 33
5 Pordenone Sub 19 Pordenone 19 25 33 26
6 Virtus Entella Sub 19 Virtus 19 33 46 22
7 Spezia Sub 19 Spezia 18 25 29 19
8 Brescia Sub 19 Brescia 18 31 41 19
9 Parma Sub 19 Parma 18 25 40 19
10 Venezia Sub 19 Venezia 18 25 34 17
11 Cittadella Sub 19 Cittadella 17 22 35 15
12 Cremonese Sub 19 Cremonese 17 19 30 12
TEMPORADA 2018/2019
CAMPIONATO PRIMAVERA 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Atalanta Sub 19 Atalanta 30 77 37 67
2 Inter Sub 19 Inter 30 54 40 56
3 Roma Sub 19 Roma Sub 19 30 80 43 55
4 Torino Sub 19 Torino 30 67 44 51
5 Fiorentina Sub 19 Fiorentina 30 48 39 50
6 Cagliari Sub 19 Cagliari 30 40 41 43
7 Chievo Verona Sub 19 Chievo 30 50 58 43
8 Juventus Sub 19 Juventus 30 56 54 42
9 Palermo Sub 19 Palermo 30 34 49 38
10 Napoli Sub 19 Napoli 30 38 49 37
11 Sampdoria Sub 19 Sampdoria 30 31 28 35
12 Sassuolo Sub 19 Sassuolo 30 43 47 35
13 Empoli Sub 19 Empoli 30 43 50 33
14 Genoa Sub 19 Genoa 30 39 54 32
15 Milan Sub 19 Milan 30 40 59 31
16 Udinese Sub 19 Udinese 30 24 72 15
TEMPORADA 2017/2018
CAMPIONATO PRIMAVERA 1 GRUPO 1
Equipo PJ GF GC Puntos
1 Atalanta Sub 19 Atalanta 30 71 36 62
2 Inter Sub 19 Inter 30 53 30 58
3 Roma Sub 19 Roma Sub 19 30 53 41 55
4 Fiorentina Sub 19 Fiorentina 30 55 41 54
5 Torino Sub 19 Torino 30 52 33 52
6 Juventus Sub 19 Juventus 30 41 34 46
7 Milan Sub 19 Milan 30 40 40 44
8 Chievo Verona Sub 19 Chievo 30 42 47 43
9 Genoa Sub 19 Genoa 30 43 55 37
10 Sassuolo Sub 19 Sassuolo 30 48 52 36
11 Sampdoria Sub 19 Sampdoria 30 37 52 33
12 Napoli Sub 19 Napoli 30 40 58 33
13 Hellas Verona Sub 19 Hellas 30 39 48 32
14 Udinese Sub 19 Udinese 30 35 57 32
15 Bologna Sub 19 Bologna 30 38 43 29
16 Lazio Sub 19 Lazio 30 28 48 19
TEMPORADA 2016/2017
CAMPIONATO PRIMAVERA 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Juventus Sub 19 Juventus 26 60 20 61
2 Chievo Verona Sub 19 Chievo 26 61 25 54
3 Empoli Sub 19 Empoli 26 69 39 52
4 Torino Sub 19 Torino 26 49 26 52
5 Sassuolo Sub 19 Sassuolo 26 51 29 52
6 Udinese Sub 19 Udinese 26 40 40 37
7 SSC Bari Sub 19 Bari 26 35 49 30
8 Pro Vercelli Sub 19 Vercelli 26 34 40 29
9 Carpi Sub 19 Carpi 26 27 39 28
10 Pescara Sub 19 Pescara 26 33 45 27
11 Cittadella Sub 19 Cittadella 26 25 41 27
12 Ascoli Sub 19 Ascoli 26 32 42 26
13 Benevento Sub 19 Benevento 26 26 51 22
14 Avellino Sub 19 Avellino 26 28 84 15
TEMPORADA 2015/2016
CAMPIONATO PRIMAVERA 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Inter Sub 19 Inter 26 50 18 60
2 Atalanta Sub 19 Atalanta 26 53 23 57
3 Milan Sub 19 Milan 26 58 31 52
4 Chievo Verona Sub 19 Chievo 26 45 22 49
5 Cagliari Sub 19 Cagliari 26 52 41 48
6 Hellas Verona Sub 19 Hellas 26 38 26 46
7 Udinese Sub 19 Udinese 26 33 31 32
8 Cesena Sub 19 Cesena 26 32 36 32
9 Bologna Sub 19 Bologna 26 28 35 32
10 Como Sub 19 Como Sub 19 26 32 48 26
11 Perugia Sub 19 Perugia 26 31 54 24
12 Brescia Sub 19 Brescia 26 41 64 22
13 Vicenza Sub 19 Vicenza 26 26 43 19
14 Salernitana Sub 19 Salernitana 26 21 68 16
TEMPORADA 2014/2015
CAMPIONATO PRIMAVERA 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Inter Sub 19 Inter 26 60 18 57
2 Milan Sub 19 Milan 26 76 33 52
3 Chievo Verona Sub 19 Chievo 26 37 22 45
4 Udinese Sub 19 Udinese 26 43 29 44
5 Atalanta Sub 19 Atalanta 26 43 26 41
6 Cesena Sub 19 Cesena 26 38 27 40
7 Hellas Verona Sub 19 Hellas 26 35 34 38
8 Perugia Sub 19 Perugia 26 33 48 32
9 Sassuolo Sub 19 Sassuolo 26 29 38 31
10 Pescara Sub 19 Pescara 26 36 50 29
11 Cittadella Sub 19 Cittadella 26 38 50 25
12 Cagliari Sub 19 Cagliari 26 26 40 25
13 Brescia Sub 19 Brescia 26 32 49 25
14 Virtus Lanciano Sub 19 Virtus 26 13 75 9
TEMPORADA 2013/2014
CAMPIONATO PRIMAVERA 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Chievo Verona Sub 19 Chievo 26 59 29 58
2 Atalanta Sub 19 Atalanta 26 57 31 54
3 Milan Sub 19 Milan 26 60 31 51
4 Inter Sub 19 Inter 26 54 33 50
5 Udinese Sub 19 Udinese 26 47 24 47
6 Brescia Sub 19 Brescia 26 47 38 41
7 Padova Sub 19 Padova 26 35 31 39
8 Hellas Verona Sub 19 Hellas 26 45 37 35
9 Cagliari Sub 19 Cagliari 26 37 37 35
10 Varese Sub 19 Varese 26 37 46 33
11 Pescara Sub 19 Pescara 26 36 49 27
12 Ternana Sub 19 Ternana 26 31 59 20
13 Virtus Lanciano Sub 19 Virtus 26 29 72 13
14 Cittadella Sub 19 Cittadella 26 21 78 3
TEMPORADA 2012/2013
CAMPIONATO PRIMAVERA 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Milan Sub 19 Milan 26 63 38 58
2 Atalanta Sub 19 Atalanta 26 54 19 57
3 Inter Sub 19 Inter 26 46 23 57
4 Chievo Verona Sub 19 Chievo 26 56 23 49
5 Cesena Sub 19 Cesena 26 36 26 42
6 Varese Sub 19 Varese 26 31 28 42
7 Bologna Sub 19 Bologna 26 50 40 39
8 Padova Sub 19 Padova 26 32 39 30
9 Brescia Sub 19 Brescia 26 24 35 28
10 Udinese Sub 19 Udinese 26 36 51 25
11 Sassuolo Sub 19 Sassuolo 26 40 57 25
12 Cittadella Sub 19 Cittadella 26 27 60 20
13 Modena Sub 19 Modena 26 22 59 19
14 Hellas Verona Sub 19 Hellas 26 20 39 18
TEMPORADA 2011/2012
CAMPIONATO PRIMAVERA 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Milan Sub 19 Milan 26 67 33 53
2 Inter Sub 19 Inter 26 51 21 53
3 Varese Sub 19 Varese 26 39 24 50
4 Chievo Verona Sub 19 Chievo 26 43 22 47
5 AlbinoLeffe Sub 19 AlbinoLeffe 26 46 31 47
6 Bologna Sub 19 Bologna 26 38 36 39
7 Padova Sub 19 Padova 26 29 33 33
8 Udinese Sub 19 Udinese 26 39 54 30
9 Cittadella Sub 19 Cittadella 26 40 57 30
10 Atalanta Sub 19 Atalanta 26 38 40 29
11 Brescia Sub 19 Brescia 26 30 39 26
12 Cesena Sub 19 Cesena 26 24 39 24
13 Vicenza Sub 19 Vicenza 26 39 61 23
14 Hellas Verona Sub 19 Hellas 26 24 57 21
TEMPORADA 2010/2011
CAMPIONATO PRIMAVERA 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Varese Sub 19 Varese 26 44 19 57
2 Atalanta Sub 19 Atalanta 26 53 26 56
3 Milan Sub 19 Milan 26 55 24 54
4 Inter Sub 19 Inter 26 48 26 54
5 Chievo Verona Sub 19 Chievo 26 40 23 51
6 Udinese Sub 19 Udinese 26 45 33 38
7 Brescia Sub 19 Brescia 26 40 43 37
8 AlbinoLeffe Sub 19 AlbinoLeffe 26 34 37 35
9 Cagliari Sub 19 Cagliari 26 40 45 34
10 Triestina Sub 19 Triestina 26 39 49 27
11 Cittadella Sub 19 Cittadella 26 34 46 25
12 Padova Sub 19 Padova 26 23 45 22
13 Vicenza Sub 19 Vicenza 26 22 48 17
14 Portogruaro-Summaga Sub 19 Portogruaro- 26 10 63 3
TEMPORADA 2009/2010
CAMPIONATO PRIMAVERA 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Inter Sub 19 Inter 26 56 15 60
2 Milan Sub 19 Milan 26 65 31 54
3 Chievo Verona Sub 19 Chievo 26 30 16 49
4 Atalanta Sub 19 Atalanta 26 35 22 49
5 Brescia Sub 19 Brescia 26 44 33 47
6 Udinese Sub 19 Udinese 26 43 31 46
7 AlbinoLeffe Sub 19 AlbinoLeffe 26 21 24 37
8 Mantova Sub 19 Mantova 26 34 35 36
9 Cesena Sub 19 Cesena 26 28 25 34
10 Triestina Sub 19 Triestina 26 23 42 24
11 Bologna Sub 19 Bologna 26 24 40 23
12 Padova Sub 19 Padova 26 21 43 19
13 Cittadella Sub 19 Cittadella 26 16 51 11
14 Vicenza Sub 19 Vicenza 26 21 53 10
TEMPORADA 2008/2009
CAMPIONATO PRIMAVERA 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Inter Sub 19 Inter 26 54 21 57
2 Chievo Verona Sub 19 Chievo 26 49 17 55
3 Udinese Sub 19 Udinese 26 43 26 47
4 AlbinoLeffe Sub 19 AlbinoLeffe 26 35 28 46
5 Treviso Sub 19 Treviso 26 43 39 40
6 Milan Sub 19 Milan 26 32 24 37
7 Brescia Sub 19 Brescia 26 41 29 35
8 Vicenza Sub 19 Vicenza 26 31 40 34
9 Atalanta Sub 19 Atalanta 26 25 22 32
10 Mantova Sub 19 Mantova 26 29 49 26
11 Cagliari Sub 19 Cagliari 26 24 40 23
12 Triestina Sub 19 Triestina 26 23 42 22
13 Cittadella Sub 19 Cittadella 26 23 51 20
14 Rimini Sub 19 Rimini 26 29 53 17
TEMPORADA 2007/2008
CAMPIONATO PRIMAVERA 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Udinese Sub 19 Udinese 26 58 30 61
2 Chievo Verona Sub 19 Chievo 26 39 13 55
3 Fiorentina Sub 19 Fiorentina 26 53 19 54
4 Inter Sub 19 Inter 26 60 31 54
5 Milan Sub 19 Milan 26 41 24 48
6 Atalanta Sub 19 Atalanta 26 43 21 44
7 Empoli Sub 19 Empoli 26 39 28 40
8 Treviso Sub 19 Treviso 26 37 36 39
9 Cesena Sub 19 Cesena 26 40 38 35
10 Rimini Sub 19 Rimini 26 33 36 27
11 AlbinoLeffe Sub 19 AlbinoLeffe 26 34 50 26
12 Ravenna Sub 19 Ravenna 26 15 55 17
13 Vicenza Sub 19 Vicenza 26 18 64 9
14 Triestina Sub 19 Triestina 26 15 80 7

  USO DE MEMORIA  
6,330,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.6525
Total Execution Time  0.6540
  CADENA URL  
/historico/Udinese-Sub19/2020
  GET DATOS  
$_GET['/historico/Udinese-Sub19/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
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 = 'Udinese-Sub19' AND l.year = 2020 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=60511 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=60511 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=60511 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0251  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 = 51125
0.0130  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 = 51053
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60511 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 60511 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0126  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 (112572) ORDER BY n.cover_points DESC, update_date DESC
0.0131  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 = '60511' ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '60511' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '60511' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 51125 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 = 51053 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=60511 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (58822,58756,51712,45163) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 58822 AND teamId = 60511
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 45163 AND teamId = 60511
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 51712 AND teamId = 60511
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 58756 AND teamId = 60511
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 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 = 51125 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '60511' 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 = '60511' and rp.type = 4
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 = '60511' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2020 e ON e.player_id = p.id AND e.league_id = 51125 WHERE rp.league_id = 51125 AND rp.teamId = 60511 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.0132  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 events2020 e ON e.player_id = p.id AND e.league_id = 51125 WHERE rp.league_id = 51125 AND rp.teamId = 60511 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 events2020 e ON e.player_id = p.id AND e.league_id = 51125 WHERE rp.league_id = 51125 AND rp.teamId = 60511 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 60511 AND l.year <= 2020 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 `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 = 51125 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.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` 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 = 45163 AND t.round = 30 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 = 40232 AND t.round = 30 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 `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 = 37893 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 `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 = 15857 AND t.round = 26 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 `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 = 9267 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 `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 = 44183 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 `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 = 44186 AND t.round = 26 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 `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 = 44189 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 `tables2011` 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 = 44192 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 `tables2010` 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 = 44195 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 `tables2009` 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 = 44198 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 `tables2008` 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 = 44201 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 51125 ORDER BY nameShow LIMIT 100