4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Dunajská Lužná
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 Slovan Most Slovan Most 22 18 54 17
14 NMSK 1922 Bratislava NMSK 1922 B. 22 15 39 16
15 Pezinok Pezinok 21 24 49 14
16 Vrakuňa Vrakuňa 21 14 73 11
TEMPORADA 2022/2023
CUARTA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Rovinka Rovinka 29 81 25 74
2 FC Malacky FC Malacky 29 60 17 68
3 Slovan Ivanka pri Dunaji Slovan 29 73 31 63
4 Tomášov Tomášov 29 56 36 48
5 Rusovce Rusovce 29 40 34 45
6 MŠK Senec MŠK Senec 29 31 24 42
7 Slovan Most Slovan Most 29 36 41 37
8 Domino Bratislava Domino 29 34 42 36
9 Nová Dedinka Nová 29 28 37 36
10 Pezinok Pezinok 29 28 46 32
11 Dunajská Lužná Dunajská 29 27 43 31
12 Rohoznik Rohoznik 29 29 51 30
13 Bernolákovo Bernolákovo 29 33 48 28
14 NMSK 1922 Bratislava NMSK 1922 B. 29 27 49 28
15 SFC Kalinkovo Kalinkovo 29 21 48 24
16 Jarovce Bratislava Jarovce 29 34 66 18
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
TERCERA ESLOVAQUIA GRUPO 4
Equipo PJ GF GC Puntos
1 Slovan Bratislava II Slovan 30 114 27 80
2 FK Rača FK Rača 30 77 37 64
3 Rohoznik Rohoznik 30 52 39 56
4 Báhoň Báhoň 30 55 38 52
5 Slovan Most Slovan Most 30 57 36 50
6 Dunajská Lužná Dunajská 30 53 33 48
7 Tomášov Tomášov 30 48 45 47
8 Lokomotiva DNV Lokomotiva 30 53 49 46
9 Rovinka Rovinka 30 69 71 45
10 FC Malacky FC Malacky 30 42 40 40
11 Pezinok Pezinok 30 37 51 38
12 Bernolákovo Bernolákovo 30 28 48 30
13 Rusovce Rusovce 30 38 68 29
14 Slovan Ivanka pri Dunaji Slovan 30 33 55 27
15 Lozorno Lozorno 30 34 65 17
16 Vajnory Vajnory 30 25 113 7
TEMPORADA 2017/2018
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 FC Petržalka Petržalka 30 101 18 79
2 Rohoznik Rohoznik 30 103 18 74
3 Dunajská Lužná Dunajská 30 78 24 69
4 Slovan Bratislava II Slovan 30 109 29 61
5 FK Rača FK Rača 30 59 33 57
6 Slovan Most Slovan Most 30 58 34 57
7 Tomášov Tomášov 30 46 62 41
8 Báhoň Báhoň 30 50 55 37
9 Slovan Ivanka pri Dunaji Slovan 30 43 61 33
10 Bernolákovo Bernolákovo 30 40 74 33
11 Rovinka Rovinka 30 41 67 30
12 Lokomotiva DNV Lokomotiva 30 40 53 29
13 Pezinok Pezinok 30 33 50 29
14 Vajnory Vajnory 30 40 111 26
15 Lozorno Lozorno 30 34 75 23
16 Svätý Jur Svätý Jur 30 27 138 7
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
SEGUNDA ESLOVAQUIA GRUPO 4
Equipo PJ GF GC Puntos
1 Spartak Trnava II Spartak 10 20 6 25
2 Dukla Dukla 10 21 8 20
3 Poprad Poprad 8 21 8 20
4 Nove Mesto Nad Vahom Nove Mesto. 10 16 14 16
5 Teplička nad Váhom Teplička 8 13 12 13
6 Spišská Nová Ves Spišská 8 17 13 10
7 Dunajská Lužná Dunajská 10 11 14 10
8 Sobota Sobota 8 11 16 10
9 Slovan Duslo Sala Slovan Duslo 10 13 19 8
10 Senec Senec 10 9 29 5
11 Haniska Haniska 8 3 16 4
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 2013/2014
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Sered Sered 30 86 27 70
2 Skalica Skalica 30 70 26 68
3 Nove Mesto Nad Vahom Nove Mesto. 30 50 26 62
4 Slovan Bratislava II Slovan 30 83 35 59
5 Topoľčany Topoľčany 30 45 22 56
6 Dunajská Lužná Dunajská 30 60 35 51
7 Horses Surovce Horses 30 59 49 46
8 Slovan Nemsova Slovan 30 36 39 40
9 Spartak Vráble Spartak 30 33 38 37
10 Nové Zámky Nové Zámky 30 35 52 35
11 Vrbové Vrbové 30 33 47 34
12 FC Petržalka Petržalka 30 40 52 32
13 FK Rača FK Rača 30 34 48 29
14 Púchov Púchov 30 34 51 28
15 Slovan Levice Slovan 30 30 69 23
16 Piešťany Piešťany 30 8 120 7
TEMPORADA 2012/2013
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Spartak Trnava II Spartak 30 59 30 55
2 Slovan Bratislava II Slovan 30 55 40 50
3 Sered Sered 30 62 48 50
4 Slovan Levice Slovan 30 40 30 49
5 Piešťany Piešťany 30 46 37 49
6 Topoľčany Topoľčany 30 51 51 46
7 Nové Zámky Nové Zámky 30 51 38 45
8 Spartak Vráble Spartak 30 47 47 44
9 Dunajská Lužná Dunajská 30 30 28 41
10 Nove Mesto Nad Vahom Nove Mesto. 30 37 37 39
11 FC Petržalka Petržalka 30 30 43 36
12 OSK Moravany nad Váhom Moravany 30 40 55 35
13 Slovan Nemsova Slovan 30 30 37 34
14 Domino Bratislava Domino 30 29 44 34
15 Vrbové Vrbové 30 21 38 34
16 Nitra II Nitra II 30 27 52 29
TEMPORADA 2011/2012
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Slovan Duslo Sala Slovan Duslo 28 62 25 59
2 Šamorín Šamorín 28 48 21 52
3 Nove Mesto Nad Vahom Nove Mesto. 28 45 36 51
4 Sered Sered 28 45 28 48
5 Spartak Vráble Spartak 28 43 35 41
6 Slovan Bratislava II Slovan 28 49 45 41
7 Spartak Trnava II Spartak 28 60 55 39
8 Dunajská Lužná Dunajská 28 29 39 39
9 Vrbové Vrbové 28 27 40 36
10 Nové Zámky Nové Zámky 28 34 34 34
11 Nitra II Nitra II 28 39 43 34
12 Pezinok Pezinok 28 23 35 34
13 OSK Moravany nad Váhom Moravany 28 32 52 30
14 Slovan Nemsova Slovan 28 38 52 29
15 Topoľčany Topoľčany 28 29 63 18
16 Púchov Púchov 0 0 0 0

  USO DE MEMORIA  
6,443,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5785
Total Execution Time  0.5797
  CADENA URL  
/historico/Dunajska-Luzna
  GET DATOS  
$_GET['/historico/Dunajska-Luzna']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0143  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 = 'Dunajska-Luzna' 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.0126  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=51714 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=51714 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=51714 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255  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 = 72674
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=51714 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 51714 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 (1411) ORDER BY n.cover_points DESC, update_date 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 = '51714' AND l.year = 2024 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 = '51714' 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 = 72794 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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=51714 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0131  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) 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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 72794 AND teamId = 51714
0.0143  SELECT count(id) as num_players from rel_players WHERE league_id = 72674 AND teamId = 51714
0.0134  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 = '51714' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '51714' and rp.type = 4
0.0127  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 = '51714' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 72794 WHERE rp.league_id = 72794 AND rp.teamId = 51714 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.0126  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 = 51714 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 51714 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 = 51714 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 70546 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.0137  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.0144  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.0142  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.0143  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 = 44374 AND t.round = 30 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 `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 = 39125 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 = 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.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 = 15807 AND t.round = 22 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 `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 = 23888 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 = 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.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 `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 = 24448 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 `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 = 24456 AND t.round = 30 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 `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 = 24468 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC