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

Sutjeska

Entrenador: Miljan Radovic

TEMPORADA 2023/2024
LIGA MONTENEGRO
Equipo PJ GF GC Puntos
1 Decic Decic 32 45 26 58
2 Budućnost Budućnost 32 59 39 55
3 Sutjeska Sutjeska 32 43 29 53
4 Mornar Mornar 32 36 29 52
5 Jezero Jezero 32 39 33 48
6 Petrovac Petrovac 32 34 33 41
7 Arsenal Tivat Arsenal 32 37 48 38
8 Jedinstvo Jedinstvo 32 34 47 29
9 Mladost DG Mladost DG 32 31 52 28
10 FK Rudar Pljevlja Rudar 32 22 44 24
TEMPORADA 2022/2023
LIGA MONTENEGRO
Equipo PJ GF GC Puntos
1 Budućnost Budućnost 36 61 37 70
2 Sutjeska Sutjeska 36 75 34 70
3 Decic Decic 36 44 37 50
4 Arsenal Tivat Arsenal 36 39 39 50
5 Jedinstvo Jedinstvo 36 43 54 47
6 Petrovac Petrovac 36 50 57 45
7 Jezero Jezero 36 35 38 43
8 Mornar Mornar 36 30 41 42
9 FK Rudar Pljevlja Rudar 36 36 51 38
10 Iskra Danilovgrad Iskra 36 33 58 31
TEMPORADA 2021/2022
LIGA MONTENEGRO
Equipo PJ GF GC Puntos
1 Sutjeska Sutjeska 36 64 29 75
2 Budućnost Budućnost 36 78 45 67
3 Decic Decic 36 54 44 56
4 Iskra Danilovgrad Iskra 36 48 45 51
5 Mornar Mornar 36 35 39 50
6 Jezero Jezero 36 42 46 48
7 Petrovac Petrovac 36 47 60 43
8 FK Rudar Pljevlja Rudar 36 35 56 36
9 Zeta Zeta 36 36 52 34
10 FK Podgorica Podgorica 36 38 61 34
TEMPORADA 2020/2021
LIGA MONTENEGRO
Equipo PJ GF GC Puntos
1 Budućnost Budućnost 36 65 29 85
2 Sutjeska Sutjeska 36 56 34 57
3 Decic Decic 36 39 28 54
4 FK Podgorica Podgorica 36 39 38 52
5 Jezero Jezero 36 28 34 45
6 Zeta Zeta 36 34 41 45
7 FK Rudar Pljevlja Rudar 36 38 50 45
8 Iskra Danilovgrad Iskra 36 28 29 44
9 Petrovac Petrovac 36 29 45 32
10 Titograd Podgorica Titograd 36 23 51 31
TEMPORADA 2019/2020
LIGA MONTENEGRO
Equipo PJ GF GC Puntos
1 Budućnost Budućnost 31 63 26 73
2 Sutjeska Sutjeska 31 57 31 55
3 Iskra Danilovgrad Iskra 31 43 33 53
4 Zeta Zeta 31 29 30 41
5 FK Podgorica Podgorica 31 34 27 40
6 Petrovac Petrovac 31 30 46 37
7 FK Rudar Pljevlja Rudar 31 38 57 35
8 Titograd Podgorica Titograd 31 29 38 31
9 Kom Podgorica Podgorica 31 36 45 29
10 Grbalj Grbalj 31 23 49 22
TEMPORADA 2018/2019
LIGA MONTENEGRO
Equipo PJ GF GC Puntos
1 Sutjeska Sutjeska 36 58 21 74
2 Budućnost Budućnost 36 56 25 65
3 Zeta Zeta 36 36 21 61
4 Titograd Podgorica Titograd 36 47 41 57
5 Iskra Danilovgrad Iskra 36 46 39 50
6 Grbalj Grbalj 36 45 36 48
7 Petrovac Petrovac 36 40 45 47
8 FK Rudar Pljevlja Rudar 36 35 44 41
9 Lovcen Lovcen 36 29 65 26
10 Mornar Mornar 36 17 72 12
TEMPORADA 2017/2018
LIGA MONTENEGRO
Equipo PJ GF GC Puntos
1 Sutjeska Sutjeska 36 55 23 79
2 Budućnost Budućnost 36 44 30 57
3 Titograd Podgorica Titograd 36 42 33 51
4 Grbalj Grbalj 36 39 39 50
5 FK Rudar Pljevlja Rudar 36 32 28 49
6 Zeta Zeta 36 40 35 49
7 Iskra Danilovgrad Iskra 36 33 34 45
8 Kom Podgorica Podgorica 36 36 45 43
9 Petrovac Petrovac 36 25 40 38
10 Decic Decic 36 25 64 21
TEMPORADA 2016/2017
LIGA MONTENEGRO
Equipo PJ GF GC Puntos
1 Zeta Zeta 33 38 17 60
2 Budućnost Budućnost 33 52 28 57
3 Titograd Podgorica Titograd 33 46 22 57
4 Sutjeska Sutjeska 33 43 25 55
5 Decic Decic 33 27 32 50
6 Iskra Danilovgrad Iskra 33 29 32 49
7 Grbalj Grbalj 33 28 25 46
8 FK Rudar Pljevlja Rudar 33 35 31 42
9 Petrovac Petrovac 33 30 50 39
10 FK Bokelj FK Bokelj 33 28 34 36
11 Lovcen Lovcen 33 25 36 34
12 Jedinstvo Jedinstvo 33 20 69 14
TEMPORADA 2015/2016
LIGA MONTENEGRO
Equipo PJ GF GC Puntos
1 Titograd Podgorica Titograd 33 53 28 67
2 Budućnost Budućnost 33 48 21 63
3 FK Rudar Pljevlja Rudar 33 39 26 58
4 FK Bokelj FK Bokelj 33 43 28 56
5 Sutjeska Sutjeska 33 46 31 54
6 Decic Decic 33 38 49 39
7 Grbalj Grbalj 33 38 49 38
8 Zeta Zeta 33 37 42 38
9 Lovcen Lovcen 33 32 42 36
10 Iskra Danilovgrad Iskra 33 29 51 34
11 Mornar Mornar 33 30 48 33
12 Petrovac Petrovac 33 33 51 33
TEMPORADA 2014/2015
LIGA MONTENEGRO
Equipo PJ GF GC Puntos
1 FK Rudar Pljevlja Rudar 33 58 18 72
2 Sutjeska Sutjeska 33 58 23 69
3 Budućnost Budućnost 33 46 20 63
4 Titograd Podgorica Titograd 33 53 36 57
5 Grbalj Grbalj 33 52 44 52
6 Lovcen Lovcen 33 42 32 50
7 Petrovac Petrovac 33 30 35 43
8 FK Bokelj FK Bokelj 33 38 45 41
9 Zeta Zeta 33 48 44 40
10 Mornar Mornar 33 32 63 32
11 Mogren Mogren 33 26 70 21
12 FK Berane FK Berane 33 25 78 13
TEMPORADA 2013/2014
LIGA MONTENEGRO
Equipo PJ GF GC Puntos
1 Sutjeska Sutjeska 33 46 21 63
2 Lovcen Lovcen 33 52 31 59
3 Celik Niksic Celik Niksic 33 47 28 54
4 Budućnost Budućnost 33 36 26 54
5 Petrovac Petrovac 33 37 31 46
6 Grbalj Grbalj 33 36 40 43
7 FK Rudar Pljevlja Rudar 33 32 31 42
8 Mogren Mogren 33 45 56 42
9 Zeta Zeta 33 39 57 40
10 Titograd Podgorica Titograd 33 38 46 39
11 Mornar Mornar 33 35 47 36
12 Decic Decic 33 32 61 24
TEMPORADA 2012/2013
LIGA MONTENEGRO
Equipo PJ GF GC Puntos
1 Sutjeska Sutjeska 33 50 31 65
2 Budućnost Budućnost 33 56 39 60
3 Celik Niksic Celik Niksic 33 41 35 53
4 Grbalj Grbalj 33 41 21 51
5 FK Rudar Pljevlja Rudar 33 42 40 51
6 Titograd Podgorica Titograd 33 39 48 39
7 Petrovac Petrovac 33 36 42 38
8 Zeta Zeta 33 43 45 37
9 Lovcen Lovcen 33 38 51 37
10 Mogren Mogren 33 33 42 36
11 Mornar Mornar 33 36 47 36
12 Jedinstvo Jedinstvo 33 31 45 36
TEMPORADA 2011/2012
LIGA MONTENEGRO
Equipo PJ GF GC Puntos
1 Budućnost Budućnost 33 82 27 80
2 FK Rudar Pljevlja Rudar 33 60 20 77
3 Zeta Zeta 33 55 40 60
4 Mogren Mogren 33 54 37 54
5 Petrovac Petrovac 33 36 39 48
6 Lovcen Lovcen 33 34 42 40
7 Titograd Podgorica Titograd 33 32 45 37
8 Sutjeska Sutjeska 33 29 36 36
9 Decic Decic 33 34 51 34
10 Grbalj Grbalj 33 28 49 34
11 FK Berane FK Berane 33 32 54 29
12 FK Bokelj FK Bokelj 33 21 57 21
TEMPORADA 2010/2011
LIGA MONTENEGRO
Equipo PJ GF GC Puntos
1 Mogren Mogren 33 60 24 73
2 Budućnost Budućnost 33 58 29 73
3 FK Rudar Pljevlja Rudar 33 44 29 55
4 Zeta Zeta 33 36 29 49
5 Titograd Podgorica Titograd 33 36 35 41
6 Decic Decic 33 24 33 39
7 Grbalj Grbalj 33 30 35 38
8 Lovcen Lovcen 33 29 35 38
9 Petrovac Petrovac 33 26 38 35
10 Sutjeska Sutjeska 33 32 54 34
11 Bar Bar 33 30 43 32
12 Mornar Mornar 33 24 45 32
TEMPORADA 2009/2010
LIGA MONTENEGRO
Equipo PJ GF GC Puntos
1 FK Rudar Pljevlja Rudar 33 56 26 71
2 Budućnost Budućnost 33 67 35 69
3 Mogren Mogren 33 49 34 57
4 Zeta Zeta 33 43 33 57
5 Grbalj Grbalj 33 66 42 53
6 Lovcen Lovcen 33 32 37 52
7 Sutjeska Sutjeska 33 33 36 40
8 Petrovac Petrovac 33 38 49 36
9 Decic Decic 33 27 35 35
10 Mornar Mornar 33 29 49 35
11 FK Berane FK Berane 33 28 49 30
12 Kom Podgorica Podgorica 33 16 59 18
TEMPORADA 2008/2009
LIGA MONTENEGRO
Equipo PJ GF GC Puntos
1 Mogren Mogren 33 62 24 74
2 Budućnost Budućnost 33 72 34 70
3 Sutjeska Sutjeska 33 45 23 63
4 Grbalj Grbalj 33 47 34 50
5 Zeta Zeta 33 36 41 46
6 FK Rudar Pljevlja Rudar 33 40 37 41
7 Petrovac Petrovac 33 42 57 41
8 Lovcen Lovcen 33 23 25 40
9 Kom Podgorica Podgorica 33 34 44 37
10 Jezero Jezero 33 30 62 33
11 Decic Decic 33 24 46 31
12 Jedinstvo Jedinstvo 33 28 56 29
TEMPORADA 2007/2008
LIGA MONTENEGRO
Equipo PJ GF GC Puntos
1 Budućnost Budućnost 33 43 13 66
2 Zeta Zeta 33 56 28 66
3 Mogren Mogren 33 46 21 66
4 Grbalj Grbalj 33 40 25 55
5 FK Rudar Pljevlja Rudar 33 38 26 52
6 Lovcen Lovcen 33 28 30 43
7 Decic Decic 33 26 37 38
8 Petrovac Petrovac 33 36 46 36
9 Kom Podgorica Podgorica 33 29 49 36
10 FK Bokelj FK Bokelj 33 24 38 32
11 Sutjeska Sutjeska 33 19 44 26
12 Titograd Podgorica Titograd 33 16 44 19
TEMPORADA 2006/2007
LIGA MONTENEGRO
Equipo PJ GF GC Puntos
1 Zeta Zeta 33 65 18 79
2 Budućnost Budućnost 33 58 12 76
3 Grbalj Grbalj 33 37 30 49
4 FK Rudar Pljevlja Rudar 33 37 32 47
5 Mogren Mogren 33 27 27 42
6 Petrovac Petrovac 33 24 37 40
7 Kom Podgorica Podgorica 33 27 31 38
8 Sutjeska Sutjeska 33 24 33 38
9 Titograd Podgorica Titograd 33 34 49 38
10 Decic Decic 33 29 46 34
11 Jedinstvo Jedinstvo 33 27 51 31
12 FK Berane FK Berane 33 25 48 28
TEMPORADA 2005/2006
SEGUNDA SERBIA Y MONTENEGRO GRUPO 1
Equipo PJ GF GC Puntos
1 FK Rudar Pljevlja Rudar 36 58 34 72
2 Sutjeska Sutjeska 36 40 28 56
3 Kom Podgorica Podgorica 36 37 32 52
4 Grbalj Grbalj 36 34 34 51
5 Mogren Mogren 36 35 31 48
6 FK Zora FK Zora 36 34 35 47
7 Petrovac Petrovac 36 33 34 47
8 Decic Decic 36 32 34 47
9 Mornar Mornar 36 23 46 34
10 FK Bokelj FK Bokelj 36 29 47 32
TEMPORADA 2004/2005
SERBIA Y MONTENEGRO
Equipo PJ GF GC Puntos
1 Partizan Belgrade Partizan 30 81 20 80
2 Crvena Zvezda Crvena 30 66 18 74
3 Zeta Zeta 30 52 30 59
4 OFK Beograd OFK Beograd 30 51 36 50
5 Zemun Zemun 30 31 34 43
6 Budućnost Budućnost 30 37 37 41
7 Hajduk Kula Hajduk Kula 30 34 37 39
8 Vojvodina Novi Sad Vojvodina 30 31 37 38
9 Železnik Železnik 30 38 45 38
10 Smederevo Smederevo 30 28 36 37
11 FK Obilic FK Obilic 30 35 47 36
12 Radnicki Jugopetrol Radnicki 30 33 38 35
13 Borac Čačak Borac 30 34 44 34
14 FK Cukaricki Cukaricki 30 32 41 32
15 Sutjeska Sutjeska 30 21 48 22
16 Hajduk Beograd Hajduk 30 20 76 12

  USO DE MEMORIA  
7,194,552 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6980
Total Execution Time  0.6994
  CADENA URL  
/historico/Sutjeska
  GET DATOS  
$_GET['/historico/Sutjeska']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (46)  
0.0142  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 = 'Sutjeska' 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.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=4025 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=4025 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=4025 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=4025 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=4025 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=4025 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4025 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4025 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (98537,465992,470423,670347,676759) ORDER BY n.cover_points DESC, update_date DESC
0.0132  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 = '4025' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '4025' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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 = 72100 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=4025 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (73615,72298,72100,71432,67749) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 72298 AND teamId = 4025
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 67749 AND teamId = 4025
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 72100 AND teamId = 4025
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 73615 AND teamId = 4025
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 4025
0.0126  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 = '4025' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4025' and rp.type = 4
0.0126  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 = '4025' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0140  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 = 72298 WHERE rp.league_id = 72298 AND rp.teamId = 4025 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.0138  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 = 72298 WHERE rp.league_id = 72298 AND rp.teamId = 4025 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 72298 WHERE rp.league_id = 72298 AND rp.teamId = 4025 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 4025 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72298 AND t.round = 32 ORDER BY team.conference ASC,t.position 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 `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 = 67916 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.0127  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 = 57800 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.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 `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 = 50179 AND t.round = 31 ORDER BY team.conference ASC,t.position 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 `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 = 44174 AND t.round = 36 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 `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 = 38715 AND t.round = 36 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 `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 = 33389 AND t.round = 33 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 = 15624 AND t.round = 33 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 `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 = 4189 AND t.round = 33 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 `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 = 2421 AND t.round = 33 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 = 2037 AND t.round = 33 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 `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 = 1362 AND t.round = 33 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 `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 = 1096 AND t.round = 33 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 `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 = 10742 AND t.round = 33 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 `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 = 10741 AND t.round = 33 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 `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 = 10740 AND t.round = 33 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 `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 = 10739 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 14738 AND t.round = 36 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 `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 = 10824 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC