4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2011/2012
LIGA CROATA HNL
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 30 73 11 75
2 HNK Hajduk Split Hajduk Split 30 50 24 54
3 NK Slaven Belupo Slaven 30 41 27 52
4 Split Split 30 43 32 50
5 HNK Cibalia HNK Cibalia 30 35 35 45
6 NK Zagreb NK Zagreb 30 36 42 45
7 Lokomotiva Lokomotiva 30 33 33 44
8 NK Osijek NK Osijek 30 45 38 43
9 NK Istra 1961 Istra 1961 30 35 33 42
10 Zadar Zadar 30 29 44 40
11 Inter Zapresic Inter 30 33 33 38
12 HNK Rijeka HNK Rijeka 30 29 29 38
13 Lučko Lučko 30 29 36 31
14 HNK Sibenik HNK Sibenik 30 27 39 27
15 NK Karlovac 1919 Karlovac 30 25 53 24
16 NK Varazdin NK Varazdin 30 16 70 8
TEMPORADA 2010/2011
LIGA CROATA HNL
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 30 52 12 72
2 HNK Hajduk Split Hajduk Split 30 54 32 55
3 Split Split 30 38 22 53
4 HNK Cibalia HNK Cibalia 30 33 24 44
5 Inter Zapresic Inter 30 31 35 42
6 NK Karlovac 1919 Karlovac 30 25 27 41
7 NK Slaven Belupo Slaven 30 34 30 40
8 NK Osijek NK Osijek 30 31 29 39
9 HNK Rijeka HNK Rijeka 30 29 35 39
10 Zadar Zadar 30 31 34 38
11 NK Varazdin NK Varazdin 30 32 38 36
12 HNK Sibenik HNK Sibenik 30 37 38 35
13 NK Zagreb NK Zagreb 30 32 39 35
14 Lokomotiva Lokomotiva 30 24 37 33
15 NK Istra 1961 Istra 1961 30 24 44 31
16 Hrvatski Dragovoljac Hrvatski 30 24 55 23
TEMPORADA 2009/2010
LIGA CROATA HNL
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 30 70 20 62
2 HNK Hajduk Split Hajduk Split 30 50 21 58
3 HNK Cibalia HNK Cibalia 30 46 20 57
4 HNK Sibenik HNK Sibenik 30 34 37 50
5 NK Osijek NK Osijek 30 49 36 47
6 NK Karlovac 1919 Karlovac 30 32 23 47
7 NK Slaven Belupo Slaven 30 44 45 43
8 Lokomotiva Lokomotiva 30 35 38 42
9 HNK Rijeka HNK Rijeka 30 49 44 40
10 NK Varazdin NK Varazdin 30 36 43 36
11 NK Istra 1961 Istra 1961 30 31 40 35
12 Zadar Zadar 30 27 41 34
13 NK Zagreb NK Zagreb 30 43 49 33
14 Inter Zapresic Inter 30 36 50 33
15 Medjimurje Cakovec Medjimurje 30 37 61 29
16 NK Croatia Sesvete Croatia 30 30 81 14
TEMPORADA 2008/2009
LIGA CROATA HNL
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 33 71 26 74
2 HNK Hajduk Split Hajduk Split 33 59 25 68
3 HNK Rijeka HNK Rijeka 33 50 44 56
4 NK Slaven Belupo Slaven 33 46 39 55
5 NK Zagreb NK Zagreb 33 38 39 47
6 HNK Sibenik HNK Sibenik 33 44 35 46
7 NK Osijek NK Osijek 33 40 41 41
8 HNK Cibalia HNK Cibalia 33 33 53 38
9 Inter Zapresic Inter 33 41 50 36
10 NK Varazdin NK Varazdin 33 41 55 35
11 Zadar Zadar 33 28 49 29
12 NK Croatia Sesvete Croatia 33 31 66 25
TEMPORADA 2007/2008
LIGA CROATA HNL
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 33 91 34 82
2 NK Slaven Belupo Slaven 33 45 29 54
3 NK Osijek NK Osijek 33 43 34 54
4 HNK Rijeka HNK Rijeka 33 53 41 53
5 HNK Hajduk Split Hajduk Split 33 57 41 52
6 NK Zagreb NK Zagreb 33 51 40 44
7 NK Varazdin NK Varazdin 33 46 53 40
8 HNK Cibalia HNK Cibalia 33 40 48 40
9 Zadar Zadar 33 49 61 40
10 HNK Sibenik HNK Sibenik 33 34 52 39
11 Inter Zapresic Inter 33 27 59 33
12 Medjimurje Cakovec Medjimurje 33 37 81 15
TEMPORADA 2006/2007
LIGA CROATA HNL
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 33 84 22 92
2 HNK Hajduk Split Hajduk Split 33 60 25 72
3 NK Zagreb NK Zagreb 33 58 40 58
4 NK Slaven Belupo Slaven 33 40 37 49
5 HNK Sibenik HNK Sibenik 33 50 48 49
6 NK Osijek NK Osijek 33 42 45 43
7 HNK Rijeka HNK Rijeka 33 51 53 42
8 NK Varazdin NK Varazdin 33 49 62 42
9 Medjimurje Cakovec Medjimurje 33 40 60 37
10 HNK Cibalia HNK Cibalia 33 33 53 32
11 NK Istra 1961 Istra 1961 33 28 40 29
12 Kamen Ingrad Velika Kamen Ingrad 33 27 77 11
TEMPORADA 2005/2006
LIGA CROATA HNL GRUPO 2
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 10 17 9 76
2 HNK Rijeka HNK Rijeka 10 19 8 65
3 NK Varazdin NK Varazdin 10 16 13 47
4 NK Osijek NK Osijek 10 6 16 44
5 HNK Hajduk Split Hajduk Split 10 12 14 40
6 Kamen Ingrad Velika Kamen Ingrad 10 7 17 38
TEMPORADA 2004/2005
LIGA CROATA HNL GRUPO 3
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 10 17 7 47
2 NK Osijek NK Osijek 10 12 13 41
3 Kamen Ingrad Velika Kamen Ingrad 10 6 11 41
4 NK Istra 1961 Istra 1961 10 7 8 35
5 Medimurje Medimurje 10 11 10 33
6 Zadar Zadar 10 11 15 32
TEMPORADA 2003/2004
LIGA CROATA HNL GRUPO 2
Equipo PJ GF GC Puntos
1 HNK Hajduk Split Hajduk Split 10 17 6 78
2 Dinamo Zagreb Dinamo 10 30 9 76
3 HNK Rijeka HNK Rijeka 10 10 16 42
4 NK Osijek NK Osijek 10 14 17 39
5 NK Varazdin NK Varazdin 10 12 17 38
6 Zadar Zadar 10 9 27 32
TEMPORADA 2002/2003
LIGA CROATA HNL GRUPO 1
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 22 51 17 57
2 HNK Hajduk Split Hajduk Split 22 42 14 50
3 NK Varazdin NK Varazdin 22 40 21 45
4 HNK Cibalia HNK Cibalia 22 28 28 32
5 Kamen Ingrad Velika Kamen Ingrad 22 23 22 30
6 NK Zagreb NK Zagreb 22 28 30 30
7 NK Slaven Belupo Slaven 22 24 26 29
8 NK Osijek NK Osijek 22 21 39 23
9 Zadar Zadar 22 21 40 21
10 HNK Rijeka HNK Rijeka 22 23 33 18
11 Pomorac Pomorac 22 26 41 17
12 HNK Sibenik HNK Sibenik 22 23 39 17
TEMPORADA 2001/2002
LIGA CROATA HNL
Equipo PJ GF GC Puntos
1 NK Zagreb NK Zagreb 30 71 24 67
2 HNK Hajduk Split Hajduk Split 30 61 28 65
3 Dinamo Zagreb Dinamo 30 58 30 59
4 NK Varazdin NK Varazdin 30 58 40 57
5 HNK Rijeka HNK Rijeka 30 46 37 51
6 NK Slaven Belupo Slaven 30 34 36 42
7 Pomorac Pomorac 30 36 41 40
8 NK Osijek NK Osijek 30 45 48 37
9 HNK Cibalia HNK Cibalia 30 34 37 36
10 HNK Sibenik HNK Sibenik 30 33 36 36
11 Zadar Zadar 30 43 47 36
12 Kamen Ingrad Velika Kamen Ingrad 30 28 46 35
13 Hrvatski Dragovoljac Hrvatski 30 34 45 34
14 NK Cakovec NK Cakovec 30 31 44 32
15 Marsonia Marsonia 30 37 46 30
16 Topolovac Topolovac 30 31 95 14
TEMPORADA 2000/2001
LIGA CROATA HNL GRUPO 1
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 22 49 23 46
2 NK Osijek NK Osijek 22 49 28 44
3 HNK Hajduk Split Hajduk Split 22 39 16 41
4 NK Zagreb NK Zagreb 22 43 38 34
5 NK Varazdin NK Varazdin 22 42 36 32
6 NK Slaven Belupo Slaven 22 28 23 32
7 NK Cakovec NK Cakovec 22 19 28 27
8 HNK Sibenik HNK Sibenik 22 21 30 26
9 Hrvatski Dragovoljac Hrvatski 22 28 45 23
10 HNK Cibalia HNK Cibalia 22 23 38 20
11 HNK Rijeka HNK Rijeka 22 17 32 19
12 Marsonia Marsonia 22 28 49 16
TEMPORADA 1999/2000
LIGA CROATA HNL
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 33 83 25 75
2 HNK Hajduk Split Hajduk Split 33 58 30 61
3 NK Osijek NK Osijek 33 55 49 53
4 HNK Rijeka HNK Rijeka 33 54 39 49
5 NK Slaven Belupo Slaven 33 34 34 49
6 HNK Cibalia HNK Cibalia 33 42 39 45
7 NK Varazdin NK Varazdin 33 32 44 40
8 NK Zagreb NK Zagreb 33 42 49 39
9 HNK Sibenik HNK Sibenik 33 33 50 34
10 Hrvatski Dragovoljac Hrvatski 33 36 58 33
11 Vukovar '91 Vukovar '91 33 32 56 30
12 NK Istra 1961 Istra 1961 33 33 61 30
TEMPORADA 1998/1999
LIGA CROATA HNL GRUPO 1
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 22 44 14 53
2 HNK Rijeka HNK Rijeka 22 35 18 52
3 HNK Hajduk Split Hajduk Split 22 38 17 42
4 NK Osijek NK Osijek 22 37 23 36
5 NK Varazdin NK Varazdin 22 40 36 30
6 Hrvatski Dragovoljac Hrvatski 22 17 23 25
7 HNK Sibenik HNK Sibenik 22 27 45 24
8 HNK Cibalia HNK Cibalia 22 22 29 23
9 NK Zagreb NK Zagreb 22 28 37 23
10 Zadar Zadar 22 27 40 21
11 NK Slaven Belupo Slaven 22 24 37 21
12 Suhopolje Suhopolje 22 22 42 19

  USO DE MEMORIA  
6,995,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.1505
Total Execution Time  0.1521
  CADENA URL  
/historico/Dinamo-Zagreb/2012
  GET DATOS  
$_GET['/historico/Dinamo-Zagreb/2012']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0040  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 = 1446
0.0024  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 = 42842
0.0025  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 = 42843
0.0025  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 = 1323
0.0025  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 = 27564
0.0025  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 = 27566
0.0039  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 = '9815' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 1446 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 42843 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 1342 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0036  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=9815 AND l.year in (2011,2012,2013) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (42898,42847,27566,22605,20751,2140,2023,1323,1253) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 2023 AND teamId = 9815
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 2140 AND teamId = 9815
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 1253 AND teamId = 9815
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 42847 AND teamId = 9815
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 42898 AND teamId = 9815
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 20751 AND teamId = 9815
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 22605 AND teamId = 9815
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 1323 AND teamId = 9815
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 27566 AND teamId = 9815
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 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 = 1446 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0034  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 events2012 e ON e.player_id = p.id AND e.league_id = 1446 WHERE rp.league_id = 1446 AND rp.teamId = 9815 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.0030  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 events2012 e ON e.player_id = p.id AND e.league_id = 1446 WHERE rp.league_id = 1446 AND rp.teamId = 9815 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 events2012 e ON e.player_id = p.id AND e.league_id = 1446 WHERE rp.league_id = 1446 AND rp.teamId = 9815 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037  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 = 9815 AND l.year <= 2012 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 1342 AND t.round = 30 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 `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 = 1069 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 `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 = 875 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 `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 = 458 AND t.round = 33 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 `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 = 8680 AND t.round = 33 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 `tables2007` 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 = 8681 AND t.round = 33 ORDER BY team.conference 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 `tables2006` 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 = 8683 AND t.round = 22 ORDER BY team.conference 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 `tables2006` 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 = 10233 AND t.round = 10 ORDER BY team.conference 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 `tables2005` 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 = 8685 AND t.round = 22 ORDER BY team.conference 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 `tables2005` 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 = 10243 AND t.round = 10 ORDER BY team.conference 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 `tables2004` 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 = 8686 AND t.round = 22 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 `tables2004` 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 = 10231 AND t.round = 10 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 `tables2003` 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 = 10230 AND t.round = 10 ORDER BY team.conference 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 `tables2003` 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 = 8688 AND t.round = 22 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 `tables2002` 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 = 8689 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 `tables2001` 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 = 10228 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 `tables2001` 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 = 8690 AND t.round = 22 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 `tables2000` 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 = 8692 AND t.round = 33 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 `tables1999` 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 = 10226 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC