4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Inter Zapresic
TEMPORADA 2021/2022
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 NK Varazdin NK Varazdin 30 56 29 63
2 NK Rudes NK Rudes 30 56 27 56
3 Inter Zapresic Inter 30 34 29 48
4 NK Jarun NK Jarun 30 46 38 44
5 NK Kustošija Kustošija 30 39 35 42
6 HNK Cibalia HNK Cibalia 30 44 42 41
7 Dinamo Zagreb II Dinamo 30 37 44 41
8 NK Solin NK Solin 30 41 41 40
9 HNK Orijent Rijeka Orijent 30 44 49 40
10 NK Dugopolje Dugopolje 30 40 46 40
11 Bijelo Brdo Bijelo Brdo 30 30 41 39
12 Dubrava Tim kabel Dubrava 30 39 39 39
13 NK Croatia Zmijavci Croatia 30 32 43 38
14 NK Sesvete NK Sesvete 30 37 41 34
15 NK Osijek II Osijek 30 25 36 34
16 NK Opatija NK Opatija 30 27 47 25
TEMPORADA 2020/2021
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 Hrvatski Dragovoljac Hrvatski 34 49 39 59
2 NK Rudes NK Rudes 34 52 41 57
3 Bijelo Brdo Bijelo Brdo 34 52 40 55
4 HNK Cibalia HNK Cibalia 34 50 43 51
5 NK Kustošija Kustošija 34 43 38 51
6 NK Sesvete NK Sesvete 34 62 59 51
7 NK Opatija NK Opatija 34 42 41 50
8 NK Dugopolje Dugopolje 34 49 45 48
9 Dubrava Tim kabel Dubrava 34 45 46 46
10 HNK Orijent Rijeka Orijent 34 52 49 45
11 Inter Zapresic Inter 34 49 41 45
12 NK Croatia Zmijavci Croatia 34 52 53 44
13 Dinamo Zagreb II Dinamo 34 45 41 43
14 NK Osijek II Osijek 34 42 42 42
15 Hajduk Split II Hajduk Split 34 58 60 41
16 NK Solin NK Solin 34 45 56 38
17 Junak Sinj Junak Sinj 34 46 58 34
18 Medjimurje Cakovec Medjimurje 34 44 85 34
TEMPORADA 2019/2020
LIGA CROATA HNL
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 36 62 20 80
2 Lokomotiva Lokomotiva 36 57 38 65
3 HNK Rijeka HNK Rijeka 36 58 42 64
4 NK Osijek NK Osijek 36 47 29 62
5 HNK Hajduk Split Hajduk Split 36 60 41 60
6 HNK Gorica HNK Gorica 36 44 48 49
7 NK Slaven Belupo Slaven 36 34 51 39
8 NK Varazdin NK Varazdin 36 29 50 36
9 NK Istra 1961 Istra 1961 36 27 59 25
10 Inter Zapresic Inter 36 32 72 17
TEMPORADA 2018/2019
LIGA CROATA HNL
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 36 74 20 92
2 HNK Rijeka HNK Rijeka 36 70 36 67
3 NK Osijek NK Osijek 36 61 36 62
4 HNK Hajduk Split Hajduk Split 36 59 39 62
5 HNK Gorica HNK Gorica 36 57 46 59
6 Lokomotiva Lokomotiva 36 51 43 49
7 NK Slaven Belupo Slaven 36 41 53 37
8 Inter Zapresic Inter 36 40 84 31
9 NK Istra 1961 Istra 1961 36 31 73 25
10 NK Rudes NK Rudes 36 26 80 14
TEMPORADA 2017/2018
LIGA CROATA HNL
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 36 68 34 73
2 HNK Rijeka HNK Rijeka 36 75 32 70
3 HNK Hajduk Split Hajduk Split 36 70 38 66
4 NK Osijek NK Osijek 36 53 38 56
5 Lokomotiva Lokomotiva 36 47 48 51
6 NK Slaven Belupo Slaven 36 35 45 43
7 Inter Zapresic Inter 36 43 64 43
8 NK Rudes NK Rudes 36 41 62 40
9 NK Istra 1961 Istra 1961 36 28 60 27
10 HNK Cibalia HNK Cibalia 36 36 75 26
TEMPORADA 2016/2017
LIGA CROATA HNL
Equipo PJ GF GC Puntos
1 HNK Rijeka HNK Rijeka 36 71 23 88
2 Dinamo Zagreb Dinamo 36 68 24 86
3 HNK Hajduk Split Hajduk Split 36 70 31 69
4 NK Osijek NK Osijek 36 52 37 66
5 Lokomotiva Lokomotiva 36 41 38 44
6 NK Istra 1961 Istra 1961 36 33 49 39
7 NK Slaven Belupo Slaven 36 36 45 38
8 Inter Zapresic Inter 36 26 57 28
9 HNK Cibalia HNK Cibalia 36 26 79 21
10 Split Split 36 12 52 18
TEMPORADA 2015/2016
LIGA CROATA HNL
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 36 67 19 85
2 HNK Rijeka HNK Rijeka 36 56 20 77
3 HNK Hajduk Split Hajduk Split 36 46 28 61
4 Lokomotiva Lokomotiva 36 56 53 52
5 Inter Zapresic Inter 36 39 48 47
6 Split Split 36 28 29 46
7 NK Slaven Belupo Slaven 36 41 42 42
8 NK Osijek NK Osijek 36 27 49 34
9 NK Istra 1961 Istra 1961 36 23 58 24
10 NK Zagreb NK Zagreb 36 27 64 17
TEMPORADA 2014/2015
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 Inter Zapresic Inter 30 48 25 58
2 NK Sesvete NK Sesvete 30 53 30 53
3 HNK Gorica HNK Gorica 30 46 26 51
4 NK Rudes NK Rudes 30 36 28 42
5 Imotski Imotski 30 31 38 38
6 HNK Cibalia HNK Cibalia 30 36 44 38
7 NK Dugopolje Dugopolje 30 27 32 34
8 Segesta Segesta 30 31 42 34
9 Lučko Lučko 30 24 35 33
10 Hrvatski Dragovoljac Hrvatski 30 30 42 33
11 Bistra Bistra 30 18 38 27
12 Pomorac Pomorac 0 0 0 0
TEMPORADA 2013/2014
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
TEMPORADA 2012/2013
LIGA CROATA HNL
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 33 68 20 77
2 Lokomotiva Lokomotiva 33 54 38 57
3 HNK Rijeka HNK Rijeka 33 46 42 53
4 HNK Hajduk Split Hajduk Split 33 45 31 52
5 Split Split 33 49 37 52
6 NK Istra 1961 Istra 1961 33 35 32 44
7 NK Osijek NK Osijek 33 25 33 39
8 NK Slaven Belupo Slaven 33 35 50 39
9 Zadar Zadar 33 39 61 36
10 Inter Zapresic Inter 33 36 41 35
11 HNK Cibalia HNK Cibalia 33 29 44 32
12 NK Zagreb NK Zagreb 33 28 60 27
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
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 Inter Zapresic Inter 30 60 28 68
2 Zadar Zadar 30 55 25 65
3 NK Croatia Sesvete Croatia 30 67 38 59
4 Hrvatski Dragovoljac Hrvatski 30 60 25 58
5 NK Solin NK Solin 30 58 33 53
6 Imotski Imotski 30 41 44 44
7 Belisce Belisce 30 46 40 42
8 Pomorac Pomorac 30 53 51 42
9 Vukovar '91 Vukovar '91 30 40 42 35
10 NK HASK Zagreb HASK Zagreb 30 44 49 35
11 Mosor Mosor 30 37 46 35
12 Marsonia Marsonia 30 38 50 34
13 Moslavina Moslavina 29 40 56 30
14 NK Koprivnica Koprivnica 30 42 66 29
15 Bjelovar Bjelovar 29 24 62 18
16 NK Cakovec NK Cakovec 30 37 87 16
TEMPORADA 2005/2006
LIGA CROATA HNL GRUPO 3
Equipo PJ GF GC Puntos
1 NK Istra 1961 Istra 1961 10 15 10 45
2 NK Slaven Belupo Slaven 10 17 10 41
3 HNK Cibalia HNK Cibalia 10 9 12 37
4 NK Zagreb NK Zagreb 10 7 16 37
5 Medimurje Medimurje 10 14 8 36
6 Inter Zapresic Inter 10 13 19 31
TEMPORADA 2004/2005
LIGA CROATA HNL GRUPO 1
Equipo PJ GF GC Puntos
1 HNK Hajduk Split Hajduk Split 22 39 23 42
2 HNK Rijeka HNK Rijeka 22 37 23 38
3 NK Slaven Belupo Slaven 22 29 25 37
4 Inter Zapresic Inter 22 25 22 35
5 NK Varazdin NK Varazdin 22 39 30 34
6 Dinamo Zagreb Dinamo 22 38 30 33
7 NK Zagreb NK Zagreb 22 27 24 33
8 Kamen Ingrad Velika Kamen Ingrad 22 30 28 32
9 NK Osijek NK Osijek 22 29 32 30
10 NK Istra 1961 Istra 1961 22 21 23 26
11 Zadar Zadar 22 25 55 16
12 Medjimurje Cakovec Medjimurje 22 18 42 13

  USO DE MEMORIA  
6,499,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7324
Total Execution Time  0.7336
  CADENA URL  
/historico/Inter-Zapre0161ic
  GET DATOS  
$_GET['/historico/Inter-Zapre0161ic']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0159  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 = 'Inter-Zapre0161ic' 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.0145  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=3976 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=3976 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3976 AND type_rel = 2
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3976 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0153  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 (44313,127096,843404) ORDER BY n.cover_points DESC, update_date DESC
0.0157  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 = '3976' ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '3976' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0152  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 = '3976' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0151  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 = '3976' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0150  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=3976 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (71432,68391) 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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 68391 AND teamId = 3976
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 3976
0.0148  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 = '3976' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '3976' and rp.type = 4
0.0146  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 = '3976' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0176  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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 3976 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.0170  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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 3976 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0210  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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 3976 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 3976 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0171  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 = 63277 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.0164  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` 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 = 57734 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.0148  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 = 49969 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 38724 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 33347 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 15430 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 4157 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 8701 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 2023 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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.0149  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.0148  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.0150  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.0152  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.0152  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 = 8710 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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.0158  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 = 10244 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 10232 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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