4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Inter Bratislava
TEMPORADA 2023/2024
CUARTA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Inter Bratislava Inter 21 80 9 56
2 Rohoznik Rohoznik 21 41 20 44
3 Dunajská Lužná Dunajská 21 38 21 43
4 Slovan Ivanka pri Dunaji Slovan 21 50 27 40
5 Bernolákovo Bernolákovo 21 33 24 37
6 Tomášov Tomášov 21 40 26 37
7 Rovinka Rovinka 21 44 30 35
8 MŠK Senec MŠK Senec 21 35 29 32
9 Nová Dedinka Nová 21 36 31 28
10 Rusovce Rusovce 21 42 39 26
11 Slovan Modra Slovan Modra 21 27 45 21
12 Domino Bratislava Domino 21 18 39 18
13 NMSK 1922 Bratislava NMSK 1922 B. 21 15 38 16
14 Slovan Most Slovan Most 21 17 54 14
15 Pezinok Pezinok 21 24 49 14
16 Vrakuňa Vrakuňa 21 14 73 11
TEMPORADA 2022/2023
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Malženice Malženice 29 57 21 65
2 Sered Sered 29 55 22 57
3 Slovan Galanta Slovan 29 59 34 56
4 Beluša Beluša 29 65 29 55
5 OK Častkovce Častkovce 29 53 39 47
6 Nove Mesto Nad Vahom Nove Mesto. 29 42 43 42
7 Veľké Ludince Veľké 29 39 32 41
8 Podkonice Podkonice 29 39 31 39
9 Hamsik Academy Hamsik 29 34 32 38
10 Slovan Duslo Sala Slovan Duslo 29 45 49 38
11 Fomat Martin Fomat Martin 29 46 42 36
12 Bánová Bánová 29 48 48 35
13 Inter Bratislava Inter 29 34 44 31
14 Kalna nad Hronom Kalna Hronom 15 25 23 22
15 Nové Zámky Nové Zámky 29 20 92 10
16 Vrakuňa Vrakuňa 29 23 103 7
TEMPORADA 2021/2022
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 FK Rača FK Rača 30 93 31 75
2 Slovan Ivanka pri Dunaji Slovan 30 63 23 72
3 Inter Bratislava Inter 30 79 18 69
4 Rusovce Rusovce 30 61 31 60
5 Rovinka Rovinka 30 57 26 58
6 Vrakuňa Vrakuňa 30 61 49 52
7 FC Malacky FC Malacky 30 47 38 52
8 MŠK Senec MŠK Senec 30 35 48 37
9 Tomášov Tomášov 30 43 46 35
10 Pezinok Pezinok 30 39 51 32
11 Dunajská Lužná Dunajská 30 35 56 32
12 Bernolákovo Bernolákovo 30 31 56 29
13 Nová Dedinka Nová 30 29 73 21
14 Slovan Most Slovan Most 30 23 62 20
15 SFC Kalinkovo Kalinkovo 30 25 62 19
16 Lokomotiva DNV Lokomotiva 30 19 70 18
TEMPORADA 2020/2021
TERCERA ESLOVAQUIA GRUPO 4
Equipo PJ GF GC Puntos
1 Rohoznik Rohoznik 15 32 6 37
2 Inter Bratislava Inter 15 53 21 31
3 FK Rača FK Rača 15 37 19 31
4 Rovinka Rovinka 15 34 19 27
5 FC Malacky FC Malacky 15 28 14 27
6 Slovan Ivanka pri Dunaji Slovan 15 26 23 22
7 MŠK Senec MŠK Senec 14 19 27 22
8 Tomášov Tomášov 15 20 35 22
9 Pezinok Pezinok 15 32 30 21
10 Slovan Most Slovan Most 15 24 32 20
11 Bernolákovo Bernolákovo 15 24 24 19
12 Dunajská Lužná Dunajská 14 18 27 14
13 Lokomotiva DNV Lokomotiva 15 13 38 12
14 Báhoň Báhoň 15 17 27 11
15 SFC Kalinkovo Kalinkovo 15 22 38 10
16 Rusovce Rusovce 15 15 34 9
TEMPORADA 2019/2020
TERCERA ESLOVAQUIA GRUPO 4
Equipo PJ GF GC Puntos
1 Dunajská Lužná Dunajská 15 44 11 37
2 Inter Bratislava Inter 15 46 16 35
3 FK Rača FK Rača 15 36 25 31
4 Slovan Most Slovan Most 15 24 14 29
5 FC Malacky FC Malacky 15 25 20 25
6 Rohoznik Rohoznik 15 35 18 24
7 MŠK Senec MŠK Senec 15 26 27 23
8 Rovinka Rovinka 15 23 31 20
9 Slovan Ivanka pri Dunaji Slovan 15 25 26 18
10 Bernolákovo Bernolákovo 15 17 29 17
11 Rusovce Rusovce 15 20 26 16
12 Lokomotiva DNV Lokomotiva 15 21 31 14
13 Báhoň Báhoň 15 12 27 13
14 SFC Kalinkovo Kalinkovo 15 18 36 12
15 Pezinok Pezinok 15 20 41 9
16 Tomášov Tomášov 15 12 26 8
TEMPORADA 2018/2019
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Pohronie Pohronie 30 48 25 61
2 Poprad Poprad 30 52 36 58
3 Skalica Skalica 30 47 32 53
4 Liptovsky Mikulas Liptovsky 30 56 41 50
5 MFK Dukla MFK Dukla 30 49 35 46
6 Komárno Komárno 30 48 38 46
7 Dubnica Dubnica 30 55 42 45
8 FC Petržalka Petržalka 30 41 38 45
9 Žilina II Žilina II 30 54 59 41
10 Bardejov Bardejov 30 41 46 39
11 Lokomotíva Košice Lokomotíva 30 38 44 38
12 Šamorín Šamorín 30 46 48 37
13 Slavoj Trebišov Slavoj 30 24 44 30
14 Inter Bratislava Inter 30 37 56 29
15 Tatran Prešov Tatran 30 30 41 27
16 Odeva Lipany Odeva Lipany 30 23 64 24
TEMPORADA 2017/2018
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Sered Sered 30 73 25 66
2 Skalica Skalica 30 46 27 62
3 Poprad Poprad 30 45 25 52
4 Lokomotíva Košice Lokomotíva 30 50 35 51
5 Žilina II Žilina II 30 71 41 49
6 Komárno Komárno 30 49 58 43
7 Šamorín Šamorín 30 38 34 42
8 Inter Bratislava Inter 30 45 46 41
9 Pohronie Pohronie 30 41 35 38
10 Slavoj Trebišov Slavoj 30 27 44 37
11 Liptovsky Mikulas Liptovsky 30 38 39 36
12 Bardejov Bardejov 30 39 47 35
13 Nove Mesto Nad Vahom Nove Mesto. 30 33 57 32
14 Spišská Nová Ves Spišská 30 32 60 30
15 Lokomotiva Zvolen Lokomotiva 30 26 53 28
16 Podbrezová II Podbrezová 30 24 51 26
TEMPORADA 2016/2017
TERCERA ESLOVAQUIA GRUPO 4
Equipo PJ GF GC Puntos
1 Inter Bratislava Inter 30 93 11 76
2 Rohoznik Rohoznik 30 102 23 75
3 Tomášov Tomášov 30 78 48 58
4 Dunajská Lužná Dunajská 30 67 42 51
5 Vajnory Vajnory 30 57 41 49
6 Slovan Ivanka pri Dunaji Slovan 30 51 55 47
7 Lokomotiva DNV Lokomotiva 30 73 51 44
8 FK Rača FK Rača 30 51 41 40
9 Rovinka Rovinka 30 53 59 39
10 Báhoň Báhoň 30 45 56 36
11 Slovan Most Slovan Most 30 37 50 34
12 Lozorno Lozorno 30 41 59 34
13 Pezinok Pezinok 30 35 65 34
14 FC Malacky FC Malacky 30 51 66 33
15 Bernolákovo Bernolákovo 30 39 67 33
16 Kráľová pri Senci Kráľová 30 19 158 1
TEMPORADA 2015/2016
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Svätý Jur Svätý Jur 30 89 34 66
2 Inter Bratislava Inter 31 71 21 63
3 Rohoznik Rohoznik 30 65 32 60
4 FK Rača FK Rača 30 54 26 51
5 Báhoň Báhoň 30 46 37 51
6 Rovinka Rovinka 31 46 38 49
7 Tomášov Tomášov 30 56 52 47
8 Pezinok Pezinok 30 47 46 43
9 Slovan Most Slovan Most 30 43 41 40
10 Slovan Ivanka pri Dunaji Slovan 30 40 47 37
11 Lokomotiva DNV Lokomotiva 30 43 42 36
12 Kráľová pri Senci Kráľová 31 38 56 30
13 Bernolákovo Bernolákovo 30 33 62 29
14 Lozorno Lozorno 31 37 72 29
15 Viničné Viničné 30 36 87 23
16 Slovenský Grob Slovenský 30 28 79 18
TEMPORADA 2014/2015
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Dunajská Lužná Dunajská 30 81 22 74
2 Rohoznik Rohoznik 30 61 19 69
3 FK Rača FK Rača 30 64 29 57
4 Kráľová pri Senci Kráľová 30 42 25 50
5 Slovan Most Slovan Most 30 37 31 48
6 Inter Bratislava Inter 30 46 41 47
7 Svätý Jur Svätý Jur 30 52 35 43
8 Rovinka Rovinka 30 41 41 42
9 Lozorno Lozorno 30 34 37 41
10 Tomášov Tomášov 30 33 38 41
11 Báhoň Báhoň 30 33 47 36
12 Bernolákovo Bernolákovo 30 42 57 35
13 Slovenský Grob Slovenský 30 36 69 25
14 Viničné Viničné 30 28 69 21
15 Slovan Ivanka pri Dunaji Slovan 30 19 60 21
16 Stupava Stupava 30 22 51 19
TEMPORADA 2008/2009
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Inter Bratislava Inter 33 64 27 67
2 Trenčín Trenčín 33 74 27 66
3 Podbrezová Podbrezová 33 51 24 65
4 LAFC Lučenec LAFC 33 54 44 55
5 Sobota Sobota 33 37 29 49
6 Baník Horná Nitra Baník 33 43 40 46
7 Slovan Duslo Sala Slovan Duslo 33 35 43 45
8 Ružomberok II Ružomberok 33 49 52 43
9 Zemplin Michalovce Zemplin 33 42 48 41
10 Futura Humenné Futura 33 35 51 39
11 Košice II Košice II 33 32 57 26
12 DAC II DAC II 33 18 92 10
TEMPORADA 2007/2008
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Tatran Prešov Tatran 33 64 14 77
2 Podbrezová Podbrezová 33 49 34 55
3 Inter Bratislava Inter 33 49 40 53
4 LAFC Lučenec LAFC 33 53 45 51
5 Sobota Sobota 33 40 32 50
6 Baník Horná Nitra Baník 33 46 56 43
7 Slovan Duslo Sala Slovan Duslo 33 41 46 41
8 Košice II Košice II 33 41 47 37
9 Zemplin Michalovce Zemplin 33 33 43 37
10 Futura Humenné Futura 33 30 37 36
11 Slavoj Trebišov Slavoj 33 31 60 34
12 Stará Ľubovňa Stará 33 35 58 30
TEMPORADA 2006/2007
LIGA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 Spartak Trnava Spartak 14 18 13 25
2 Dubnica Dubnica 14 16 15 23
3 Zlaté Moravce Zlaté 14 20 15 22
4 Trenčín Trenčín 14 20 17 21
5 Inter Bratislava Inter 14 14 15 19
6 Eldus Mocenok Eldus 14 16 18 18
7 Sobota Sobota 14 20 23 15
8 Slovan Duslo Sala Slovan Duslo 14 15 23 8
TEMPORADA 2005/2006
LIGA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Ruzomberok Ruzomberok 36 65 28 80
2 FC Petržalka Petržalka 36 58 33 74
3 Spartak Trnava Spartak 36 57 31 68
4 Žilina Žilina 36 69 44 60
5 Nitra Nitra 36 42 48 45
6 Dukla Dukla 36 37 42 42
7 Trenčín Trenčín 36 31 49 42
8 Dubnica Dubnica 36 41 55 40
9 Inter Bratislava Inter 36 27 62 30
10 Púchov Púchov 36 29 64 26
TEMPORADA 2004/2005
LIGA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 FC Petržalka Petržalka 36 64 28 72
2 Žilina Žilina 36 73 34 65
3 Dukla Dukla 36 45 38 52
4 Dubnica Dubnica 36 42 43 51
5 Spartak Trnava Spartak 36 39 37 46
6 Púchov Púchov 36 31 43 46
7 Ruzomberok Ruzomberok 36 50 57 43
8 Trenčín Trenčín 36 36 50 43
9 Inter Bratislava Inter 36 37 60 38
10 Sobota Sobota 36 30 57 32
TEMPORADA 2003/2004
LIGA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Žilina Žilina 36 62 35 64
2 Dukla Dukla 36 58 36 64
3 Ruzomberok Ruzomberok 36 54 48 55
4 Spartak Trnava Spartak 36 47 47 53
5 Trenčín Trenčín 36 37 43 48
6 Dubnica Dubnica 36 41 42 46
7 Inter Bratislava Inter 36 38 44 45
8 FC Petržalka Petržalka 36 43 44 44
9 Púchov Púchov 36 34 54 39
10 Slovan Bratislava Slovan 36 37 58 29
TEMPORADA 2002/2003
LIGA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Žilina Žilina 36 69 31 70
2 FC Petržalka Petržalka 36 49 32 67
3 Slovan Bratislava Slovan 36 60 42 63
4 Spartak Trnava Spartak 36 55 47 56
5 Púchov Púchov 36 46 47 50
6 Inter Bratislava Inter 36 48 58 43
7 Dubnica Dubnica 36 41 52 43
8 Ruzomberok Ruzomberok 36 45 60 42
9 Trenčín Trenčín 36 48 69 38
10 FC VSS Kosice Kosice 36 41 64 30
TEMPORADA 2001/2002
LIGA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Žilina Žilina 36 62 37 69
2 Púchov Púchov 36 48 33 62
3 Inter Bratislava Inter 36 53 39 56
4 Ruzomberok Ruzomberok 36 49 41 54
5 Trenčín Trenčín 36 45 43 54
6 Slovan Bratislava Slovan 36 42 39 51
7 FC Petržalka Petržalka 36 51 45 47
8 Dubnica Dubnica 36 38 48 38
9 Tatran Prešov Tatran 36 35 66 31
10 FC VSS Kosice Kosice 36 30 62 31
TEMPORADA 2000/2001
LIGA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Inter Bratislava Inter 36 73 28 80
2 Slovan Bratislava Slovan 36 84 49 71
3 Ruzomberok Ruzomberok 36 51 48 55
4 FC Petržalka Petržalka 36 59 55 54
5 Žilina Žilina 36 41 46 45
6 Púchov Púchov 36 47 53 40
7 Tatran Prešov Tatran 36 44 54 40
8 Trenčín Trenčín 36 35 59 39
9 FC VSS Kosice Kosice 36 42 61 37
10 Spartak Trnava Spartak 36 39 62 34

  USO DE MEMORIA  
7,155,000 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1575
Total Execution Time  0.1590
  CADENA URL  
/historico/Inter-Bratislava
  GET DATOS  
$_GET['/historico/Inter-Bratislava']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0039  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-Bratislava' 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.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=51722 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=51722 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=51722 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=51722 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 72794
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=51722 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2728 AND type_rel = 3
0.0031  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 = '51722' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0029  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 = '51722' 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 = 72794 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=51722 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (72794,72674,71432,68511) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 68511 AND teamId = 51722
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72794 AND teamId = 51722
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72674 AND teamId = 51722
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 51722
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 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 = 72794 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 events2024 e ON e.player_id = p.id AND e.league_id = 72794 WHERE rp.league_id = 72794 AND rp.teamId = 51722 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.0026  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 = 72794 WHERE rp.league_id = 72794 AND rp.teamId = 51722 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 72794 WHERE rp.league_id = 72794 AND rp.teamId = 51722 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 51722 AND l.year <= 2024 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 `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 = 72794 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.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 `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 = 68511 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 `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 = 63445 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.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 `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 = 57029 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.0041  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 = 50486 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.0039  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 = 44175 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 `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 = 39124 AND t.round = 30 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 `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 = 34133 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 = 15810 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0047  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 = 9375 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 14263 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 14264 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 `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 = 10335 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 10340 AND t.round = 36 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 = 10339 AND t.round = 36 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 = 10338 AND t.round = 36 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 `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 = 14258 AND t.round = 36 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 = 23713 AND t.round = 36 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 `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 = 23715 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC