4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sloga Doboj

Sloga Doboj

Entrenador: Vlado Jagodic

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Borac Banja Luka Borac Banja 29 54 18 69
2 Zrinjski Zrinjski 29 61 25 64
3 Velež Mostar Velež 29 39 24 49
4 Sarajevo Sarajevo 29 51 34 48
5 Posušje Posušje 29 30 25 41
6 Sloga Doboj Sloga Doboj 29 33 43 41
7 Siroki Brijeg Siroki 29 32 37 35
8 Željeznicar Željeznicar 29 26 35 33
9 GOŠK Gabela GOŠK Gabela 29 32 53 32
10 Igman Konjic Igman Konjic 29 34 57 31
11 FK Tuzla City Tuzla City 29 42 52 27
12 Zvijezda 09 Zvijezda 09 29 30 61 20
TEMPORADA 2022/2023
LIGA BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Zrinjski Zrinjski 33 66 21 78
2 Borac Banja Luka Borac Banja 33 39 32 58
3 Željeznicar Željeznicar 33 42 35 53
4 Sarajevo Sarajevo 33 50 46 52
5 Siroki Brijeg Siroki 33 38 36 48
6 Velež Mostar Velež 33 40 37 45
7 FK Tuzla City Tuzla City 33 43 46 37
8 Igman Konjic Igman Konjic 33 42 48 37
9 Sloga Doboj Sloga Doboj 33 40 55 37
10 Posušje Posušje 33 28 46 37
11 Leotar Leotar 33 29 46 34
12 Sloboda Tuzla Sloboda 33 32 41 32
TEMPORADA 2021/2022
PRIMERA RS BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Krupa na Vrbasu Krupa Vrbasu 30 73 16 75
2 Sloga Doboj Sloga Doboj 30 67 20 68
3 Sloboda Novi Grad Sloboda Novi 30 52 16 65
4 Zvijezda 09 Zvijezda 09 30 61 30 58
5 Sutjeska Foča Sutjeska 30 59 39 55
6 Drina Zvornik Drina 30 49 36 50
7 Slavija Slavija 30 40 41 43
8 FK Omarska FK Omarska 30 34 41 39
9 Ljubic Prnjavor Ljubic 30 52 57 38
10 Tekstilac Derventa Tekstilac 30 25 34 37
11 Željezničar Banja Luka Željezniča 30 40 47 33
12 FK Modrica FK Modrica 30 33 63 31
13 Kozara Gradiška Kozara 30 36 47 29
14 FK Podrinje FK Podrinje 30 27 57 27
15 Kozarska Dubica Kozarska 30 22 51 24
16 Buducnost Pilica Buducnost 30 20 95 10
TEMPORADA 2020/2021
PRIMERA RS BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Rudar Prijedor Rudar 30 51 20 63
2 Leotar Leotar 30 47 27 54
3 Zvijezda 09 Zvijezda 09 30 50 33 53
4 Željezničar Banja Luka Željezniča 30 46 37 46
5 Tekstilac Derventa Tekstilac 30 35 36 45
6 Sloboda Novi Grad Sloboda Novi 30 25 27 44
7 FK Modrica FK Modrica 30 52 37 43
8 Kozara Gradiška Kozara 30 34 28 42
9 Slavija Slavija 30 30 33 41
10 Kozarska Dubica Kozarska 30 35 38 39
11 Sloga Doboj Sloga Doboj 30 34 29 38
12 Ljubic Prnjavor Ljubic 30 45 45 38
13 Drina Zvornik Drina 30 39 50 38
14 Sutjeska Foča Sutjeska 30 39 40 35
15 FK Podrinje FK Podrinje 30 17 56 21
16 Jedinstvo Brcko Jedinstvo 30 29 72 18
TEMPORADA 2017/2018
PRIMERA RS BOSNIA-HERZEGOVINA GRUPO 2
Equipo PJ GF GC Puntos
1 Zvijezda 09 Zvijezda 09 10 28 8 30
2 Rudar Prijedor Rudar 10 19 5 22
3 FK Podrinje FK Podrinje 10 14 23 9
4 Slavija Slavija 10 8 19 9
5 Drina Zvornik Drina 10 10 11 8
6 Tekstilac Derventa Tekstilac 10 6 19 5
TEMPORADA 2016/2017
PRIMERA RS BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Borac Banja Luka Borac Banja 32 61 12 81
2 FK Podrinje FK Podrinje 32 47 29 59
3 Rudar Prijedor Rudar 32 59 40 52
4 Drina Zvornik Drina 32 39 29 52
5 Sloga Doboj Sloga Doboj 32 61 52 47
6 Sloboda Mrkonjic Grad Sloboda 32 43 51 46
7 Slavija Slavija 32 51 41 42
8 Zvijezda 09 Zvijezda 09 32 36 51 42
9 Kozara Gradiška Kozara 32 39 44 36
10 Tekstilac Derventa Tekstilac 32 18 26 36
11 Sutjeska Foča Sutjeska 32 30 52 33
12 FK Borac Samac Borac Samac 32 24 81 11
TEMPORADA 2013/2014
PRIMERA RS BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Drina Zvornik Drina 26 38 16 53
2 FK Podrinje FK Podrinje 26 51 32 44
3 Sloboda Mrkonjic Grad Sloboda 26 49 32 44
4 Kozara Gradiška Kozara 26 32 26 42
5 Drina HE Visegrad Drina 26 42 34 40
6 FK Napredak Donji Sepak Napredak 26 34 27 39
7 Sloboda Novi Grad Sloboda Novi 26 40 32 38
8 Sutjeska Foča Sutjeska 26 24 30 36
9 Proleter Proleter 26 42 41 35
10 Sloga Doboj Sloga Doboj 26 27 30 35
11 Mladost Gacko Mladost 26 26 30 35
12 FK Modrica FK Modrica 26 25 31 32
13 FK Borac Samac Borac Samac 26 25 42 20
14 Rudar Ugljevik Rudar 26 12 64 12
TEMPORADA 2012/2013
PRIMERA RS BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Mladost Velika Obarska Mladost 52 84 72 86
2 Sloboda Mrkonjic Grad Sloboda 26 35 22 43
3 Kozara Gradiška Kozara 26 42 39 43
4 Sloga Doboj Sloga Doboj 26 46 29 42
5 FK Podrinje FK Podrinje 26 44 26 41
6 Drina HE Visegrad Drina 26 29 31 37
7 FK Modrica FK Modrica 26 39 39 36
8 Sloboda Novi Grad Sloboda Novi 26 32 35 36
9 Drina Zvornik Drina 26 39 38 35
10 Sutjeska Foča Sutjeska 26 26 21 31
11 Rudar Ugljevik Rudar 26 30 45 30
12 FK Borac Samac Borac Samac 26 28 45 28
13 Ljubic Prnjavor Ljubic 26 27 59 21
TEMPORADA 2011/2012
PRIMERA RS BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Radnik Bijeljina Radnik 26 31 19 50
2 Sloga Doboj Sloga Doboj 26 48 31 49
3 Sloboda Mrkonjic Grad Sloboda 26 40 21 46
4 Sutjeska Foča Sutjeska 26 34 36 38
5 Crvena Zemlja Crvena 26 40 35 37
6 FK Modrica FK Modrica 26 31 22 36
7 Drina HE Visegrad Drina 26 22 25 36
8 FK Podrinje FK Podrinje 26 32 29 34
9 Drina Zvornik Drina 26 24 23 33
10 Mladost Gacko Mladost 26 25 33 33
11 Rudar Ugljevik Rudar 26 27 30 32
12 Sloboda Novi Grad Sloboda Novi 26 24 32 32
13 Laktaši Laktaši 26 34 55 28
14 Proleter Proleter 26 34 55 20
TEMPORADA 2010/2011
PRIMERA RS BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Kozara Gradiška Kozara 26 46 12 58
2 Radnik Bijeljina Radnik 26 38 20 43
3 Sutjeska Foča Sutjeska 26 37 27 43
4 Mladost Gacko Mladost 26 35 38 40
5 FK Podrinje FK Podrinje 26 39 27 39
6 Sloga Doboj Sloga Doboj 26 35 41 38
7 Proleter Proleter 26 30 26 37
8 Sloboda Novi Grad Sloboda Novi 26 37 33 36
9 FK Modrica FK Modrica 26 32 33 35
10 Laktaši Laktaši 26 21 28 35
11 Sloboda Mrkonjic Grad Sloboda 26 30 33 30
12 Drina HE Visegrad Drina 26 26 36 29
13 Famos Vojkovici Famos 26 29 42 28
14 BSK Banja Luka Banja Luka 26 15 54 17
TEMPORADA 2009/2010
PRIMERA RS BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Drina Zvornik Drina 26 39 18 47
2 Radnik Bijeljina Radnik 26 47 32 43
3 BSK Banja Luka Banja Luka 26 34 26 39
4 Proleter Proleter 26 27 22 37
5 Kozara Gradiška Kozara 26 35 22 36
6 Sutjeska Foča Sutjeska 26 31 30 36
7 Sloga Doboj Sloga Doboj 26 27 25 35
8 Sloboda Novi Grad Sloboda Novi 26 29 28 35
9 Famos Vojkovici Famos 26 28 34 35
10 Mladost Gacko Mladost 26 31 43 35
11 Drina HE Visegrad Drina 26 28 30 34
12 Romanija Pale Romanija 26 32 33 32
13 Ljubic Prnjavor Ljubic 26 26 52 25
14 Sloga Trn Sloga Trn 26 25 44 21
TEMPORADA 2008/2009
PRIMERA RS BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Rudar Prijedor Rudar 30 49 19 64
2 Kozara Gradiška Kozara 30 54 25 57
3 Radnik Bijeljina Radnik 30 50 32 52
4 Proleter Proleter 30 39 35 41
5 Sloga Doboj Sloga Doboj 30 29 33 41
6 Sutjeska Foča Sutjeska 30 34 34 40
7 Ljubic Prnjavor Ljubic 30 35 41 40
8 Drina Zvornik Drina 30 39 38 39
9 Sloboda Novi Grad Sloboda Novi 30 37 37 39
10 Famos Vojkovici Famos 30 40 46 39
11 Mladost Gacko Mladost 30 28 37 39
12 Drina HE Visegrad Drina 30 29 44 39
13 BSK Banja Luka Banja Luka 30 35 42 38
14 FK Borac Samac Borac Samac 30 33 40 37
15 Glasinac Sokolac Glasinac 30 31 45 34
16 Jedinstvo Brcko Jedinstvo 30 31 45 33
TEMPORADA 2007/2008
PRIMERA RS BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Borac Banja Luka Borac Banja 30 62 29 67
2 Sloga Doboj Sloga Doboj 30 60 41 53
3 Kozara Gradiška Kozara 30 44 25 52
4 Sloboda Novi Grad Sloboda Novi 30 43 29 50
5 Famos Vojkovici Famos 30 48 38 48
6 Sutjeska Foča Sutjeska 30 39 32 46
7 Ljubic Prnjavor Ljubic 30 39 34 46
8 Drina Zvornik Drina 30 42 30 45
9 Proleter Proleter 30 49 42 42
10 Drina HE Visegrad Drina 30 38 48 41
11 Mladost Gacko Mladost 30 23 36 40
12 BSK Banja Luka Banja Luka 30 42 47 38
13 Radnik Bijeljina Radnik 30 39 36 37
14 FK Borac Samac Borac Samac 30 30 44 32
15 Rudar Ugljevik Rudar 30 22 47 24
16 Jedinstvo Crkvina Jedinstvo 30 14 76 9
TEMPORADA 2006/2007
PRIMERA RS BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Laktaši Laktaši 30 45 21 59
2 FK Borac Samac Borac Samac 30 61 32 55
3 Rudar Ugljevik Rudar 30 35 24 47
4 Drina Zvornik Drina 30 41 21 46
5 Sloga Doboj Sloga Doboj 30 33 34 45
6 Drina HE Visegrad Drina 30 42 36 44
7 Glasinac Sokolac Glasinac 30 34 35 44
8 Ljubic Prnjavor Ljubic 30 29 37 44
9 Sloboda Novi Grad Sloboda Novi 30 49 43 43
10 Kozara Gradiška Kozara 30 41 38 43
11 Famos Vojkovici Famos 30 37 36 43
12 Mladost Gacko Mladost 30 41 41 42
13 BSK Banja Luka Banja Luka 30 32 33 42
14 Jedinstvo Brcko Jedinstvo 30 27 34 42
15 Rudar Prijedor Rudar 30 36 41 40
16 Omladinac Omladinac 30 20 97 4
TEMPORADA 2005/2006
PRIMERA RS BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Borac Banja Luka Borac Banja 30 50 19 62
2 Ljubic Prnjavor Ljubic 30 45 28 53
3 Drina Zvornik Drina 30 39 28 50
4 Kozara Gradiška Kozara 30 37 33 47
5 BSK Banja Luka Banja Luka 30 34 36 47
6 Rudar Prijedor Rudar 30 36 39 44
7 Rudar Ugljevik Rudar 30 40 34 43
8 Sloga Doboj Sloga Doboj 30 37 31 43
9 Glasinac Sokolac Glasinac 30 32 28 43
10 Mladost Gacko Mladost 30 39 43 43
11 Jedinstvo Brcko Jedinstvo 30 38 38 40
12 Sloboda Novi Grad Sloboda Novi 30 36 51 40
13 Famos Vojkovici Famos 30 34 35 39
14 Laktaši Laktaši 30 44 49 39
15 Sloga Trn Sloga Trn 30 27 37 34
16 Nikos Kanbera Nikos 30 18 57 16

  USO DE MEMORIA  
6,640,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1362
Total Execution Time  0.1374
  CADENA URL  
/historico/Sloga-Doboj
  GET DATOS  
$_GET['/historico/Sloga-Doboj']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0034  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 = 'Sloga-Doboj' 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=13139 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=13139 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=13139 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=13139 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0038  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 = 74195
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13139 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=185 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 185 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  SELECT /*53 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 (1289591,1234413,1101072,1046862,1046324) ORDER BY n.cover_points DESC, update_date DESC
0.0031  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 = '13139' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 74195 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 = 72411 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  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=13139 AND l.year in (2023,2024,2025) 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 (74195,72411,71432) 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 = 72411 AND teamId = 13139
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 74195 AND teamId = 13139
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13139
0.0049  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 = 72411 WHERE rp.league_id = 72411 AND rp.teamId = 13139 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.0062  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 = 72411 WHERE rp.league_id = 72411 AND rp.teamId = 13139 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0044  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 = 72411 WHERE rp.league_id = 72411 AND rp.teamId = 13139 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 = 13139 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72411 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.0021  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 = 68030 AND t.round = 33 ORDER BY team.conference ASC,t.position 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 `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 = 63575 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.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 `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 = 57038 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.0021  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 = 38953 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 `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 = 43369 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 43368 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 `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 = 33946 AND t.round = 32 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 `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 = 14709 AND t.round = 26 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 `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 = 2832 AND t.round = 26 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 `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 = 14710 AND t.round = 26 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 `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 = 14711 AND t.round = 26 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 = 14712 AND t.round = 26 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 `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 = 14713 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 `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 = 14714 AND t.round = 30 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 = 14717 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 14719 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC