4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Tabor Sežana
TEMPORADA 2023/2024
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 Nafta Lendava Nafta 27 53 26 55
2 Primorje Primorje 27 44 25 53
3 ND Gorica ND Gorica 27 48 23 51
4 Beltinci Beltinci 27 39 19 50
5 Brinje-Grosuplje Brinje-Grosu 27 48 29 48
6 Triglav Kranj Triglav 27 42 27 48
7 Bistrica iz Slovenske Bistrica 27 40 38 41
8 Rudar Velenje Rudar 27 32 44 33
9 Dekani Dekani 27 30 35 30
10 ND Bilje ND Bilje 27 41 50 30
11 NK Tolmin NK Tolmin 27 29 43 29
12 ND Dravinja Kostroj Dravinja 27 27 42 29
13 NK Krka NK Krka 27 33 47 27
14 Ilirija 1911 Ilirija 1911 27 27 41 25
15 Tabor Sežana Tabor 27 34 56 25
16 Fužinar Fužinar 27 30 52 24
TEMPORADA 2022/2023
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 NK Olimpija Ljubljana Olimpija 36 60 39 73
2 Celje Celje 36 53 34 67
3 Maribor Maribor 36 70 43 62
4 Domžale Domžale 36 50 42 52
5 NS Mura NS Mura 36 50 45 52
6 FC Koper FC Koper 36 46 40 50
7 Radomlje Radomlje 36 35 53 44
8 NK Bravo NK Bravo 36 33 41 36
9 ND Gorica ND Gorica 36 31 57 27
10 Tabor Sežana Tabor 36 29 63 24
TEMPORADA 2021/2022
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 Maribor Maribor 36 57 37 70
2 FC Koper FC Koper 36 54 38 67
3 NK Olimpija Ljubljana Olimpija 36 53 38 62
4 NS Mura NS Mura 36 57 50 57
5 NK Bravo NK Bravo 36 33 33 49
6 Radomlje Radomlje 36 47 52 46
7 Domžale Domžale 36 47 46 45
8 Celje Celje 36 46 50 42
9 Tabor Sežana Tabor 36 30 41 30
10 Aluminij Aluminij 36 33 72 24
TEMPORADA 2020/2021
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 NS Mura NS Mura 36 50 26 63
2 Maribor Maribor 36 64 41 63
3 NK Olimpija Ljubljana Olimpija 36 45 35 59
4 Domžale Domžale 36 52 41 55
5 NK Bravo NK Bravo 36 39 39 45
6 Tabor Sežana Tabor 36 40 44 44
7 Aluminij Aluminij 36 31 41 43
8 Celje Celje 36 36 41 43
9 FC Koper FC Koper 36 41 56 42
10 ND Gorica ND Gorica 36 24 58 29
TEMPORADA 2019/2020
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 Celje Celje 36 74 36 69
2 NK Olimpija Ljubljana Olimpija 36 73 44 67
3 Maribor Maribor 36 66 39 67
4 NS Mura NS Mura 36 54 42 56
5 Aluminij Aluminij 36 58 48 55
6 NK Bravo NK Bravo 36 50 53 49
7 Tabor Sežana Tabor 36 45 51 46
8 Domžale Domžale 36 52 64 43
9 Triglav Kranj Triglav 36 44 87 32
10 Rudar Velenje Rudar 36 28 80 12
TEMPORADA 2018/2019
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 NK Bravo NK Bravo 30 70 28 69
2 Tabor Sežana Tabor 30 59 22 63
3 Radomlje Radomlje 30 71 38 59
4 NK Krka NK Krka 30 59 41 54
5 Nafta Lendava Nafta 30 52 35 50
6 Fužinar Fužinar 30 46 34 48
7 Drava Ptuj Drava Ptuj 30 49 35 45
8 Roltek Dob Roltek Dob 30 46 42 40
9 ND Bilje ND Bilje 30 33 54 36
10 NK Rogaška NK Rogaška 30 35 50 34
11 Beltinci Beltinci 30 35 57 31
12 Brda Dobrovo Brda Dobrovo 30 35 46 29
13 Dekani Dekani 30 44 65 28
14 Brežice Brežice 30 32 52 26
15 Ilirija 1911 Ilirija 1911 30 33 65 26
16 Ankaran Hrvatini Ankaran 30 27 62 25
TEMPORADA 2017/2018
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 NS Mura NS Mura 30 86 22 72
2 Drava Ptuj Drava Ptuj 30 68 37 66
3 Nafta Lendava Nafta 30 69 28 64
4 Radomlje Radomlje 30 58 47 57
5 NK Krka NK Krka 30 49 47 49
6 NK Bravo NK Bravo 30 55 32 49
7 Tabor Sežana Tabor 30 46 37 48
8 Ilirija 1911 Ilirija 1911 30 44 53 39
9 Brda Dobrovo Brda Dobrovo 30 37 42 38
10 Roltek Dob Roltek Dob 30 41 46 37
11 Dekani Dekani 30 39 64 36
12 Brežice Brežice 30 36 51 30
13 NK Rogaška NK Rogaška 30 42 54 27
14 Fužinar Fužinar 30 46 70 26
15 Zarica Kranj Zarica Kranj 30 36 64 25
16 NK Verzej NK Verzej 30 23 81 16
TEMPORADA 2016/2017
TERCERA ESLOVENIA 3. SNL GRUPO 4
Equipo PJ GF GC Puntos
1 Tabor Sežana Tabor 18 37 9 42
2 ND Adria Miren Adria Miren 18 43 17 41
3 Dekani Dekani 18 45 20 40
4 ND Bilje ND Bilje 18 33 19 31
5 Fama Vipava Fama Vipava 18 32 23 28
6 MNK Izola MNK Izola 18 26 24 25
7 NK Tolmin NK Tolmin 18 32 30 21
8 Ilirska Bistrica Ilirska 18 20 43 16
9 Ajdovščina Škou Ajdovščina 18 12 32 8
10 Postojna Postojna 18 7 70 4
TEMPORADA 2015/2016
TERCERA ESLOVENIA 3. SNL GRUPO 4
Equipo PJ GF GC Puntos
1 Brda Dobrovo Brda Dobrovo 27 70 22 54
2 Dekani Dekani 27 49 20 52
3 Ajdovščina Škou Ajdovščina 25 48 28 47
4 ND Adria Miren Adria Miren 27 43 33 43
5 Fama Vipava Fama Vipava 27 42 56 41
6 ND Bilje ND Bilje 27 37 43 38
7 Tabor Sežana Tabor 27 40 42 37
8 MNK Izola MNK Izola 26 31 35 34
9 Ilirska Bistrica Ilirska 26 22 49 21
10 Cerknica Cerknica 27 21 75 9
TEMPORADA 2014/2015
TERCERA ESLOVENIA 3. SNL GRUPO 4
Equipo PJ GF GC Puntos
1 Ajdovščina Škou Ajdovščina 25 63 24 57
2 MNK Izola MNK Izola 25 73 30 54
3 ND Bilje ND Bilje 26 49 31 46
4 Brda Dobrovo Brda Dobrovo 26 52 36 46
5 Dekani Dekani 26 48 44 37
6 Tabor Sežana Tabor 26 51 46 33
7 Ilirska Bistrica Ilirska 25 32 58 23
8 ND Adria Miren Adria Miren 25 18 47 20
9 Cerknica Cerknica 26 22 61 19
10 Portorož Piran Portorož 14 16 47 4
TEMPORADA 2013/2014
TERCERA ESLOVENIA 3. SNL GRUPO 2
Equipo PJ GF GC Puntos
1 NK Tolmin NK Tolmin 26 58 21 60
2 Zarica Kranj Zarica Kranj 26 56 36 53
3 MNK Izola MNK Izola 26 66 47 40
4 Ivančna Gorica Ivančna 26 41 32 40
5 Zagorje Zagorje 26 36 30 40
6 Rudar Trbovlje Rudar 26 32 38 40
7 Dekani Dekani 26 47 28 39
8 Brda Dobrovo Brda Dobrovo 26 31 19 38
9 Tabor Sežana Tabor 26 42 33 34
10 Ajdovščina Škou Ajdovščina 26 38 47 30
11 ND Adria Miren Adria Miren 26 37 59 30
12 Jezero Medvode Jezero 26 32 33 29
13 Sava Kranj Sava Kranj 26 38 49 27
14 Kamnik Kamnik 26 16 98 8
TEMPORADA 2012/2013
TERCERA ESLOVENIA 3. SNL GRUPO 2
Equipo PJ GF GC Puntos
1 Ankaran Hrvatini Ankaran 22 50 37 43
2 NK Tolmin NK Tolmin 23 40 30 42
3 MNK Izola MNK Izola 22 43 29 35
4 Brda Dobrovo Brda Dobrovo 23 43 33 35
5 ND Adria Miren Adria Miren 22 39 35 34
6 Tabor Sežana Tabor 22 39 29 33
7 Zagorje Zagorje 22 33 27 31
8 Dekani Dekani 22 33 30 31
9 Ivančna Gorica Ivančna 22 30 37 30
10 Rudar Trbovlje Rudar 22 20 29 29
11 Zarica Kranj Zarica Kranj 22 26 37 23
12 Kamnik Kamnik 22 27 56 21
13 ND Bilje ND Bilje 22 32 46 13
14 Ilirska Bistrica Ilirska 0 0 0 0
TEMPORADA 2008/2009
TERCERA ESLOVENIA 3. SNL GRUPO 2
Equipo PJ GF GC Puntos
1 Šencur Šencur 25 66 20 60
2 Dekani Dekani 25 56 30 51
3 Radomlje Radomlje 25 56 33 47
4 NK Krka NK Krka 25 52 37 45
5 Brda Dobrovo Brda Dobrovo 25 38 28 38
6 Zarica Kranj Zarica Kranj 25 36 26 38
7 Roltek Dob Roltek Dob 25 41 40 32
8 Sava Kranj Sava Kranj 25 33 48 31
9 NK Tolmin NK Tolmin 25 33 37 28
10 Kamnik Kamnik 25 27 40 27
11 ND Slovan Ljubljana Slovan 25 29 58 27
12 ND Adria Miren Adria Miren 25 30 49 24
13 NK Korte NK Korte 25 25 45 23
14 Tabor Sežana Tabor 13 7 38 6
TEMPORADA 2003/2004
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 Rudar Velenje Rudar 32 84 37 69
2 Bela Krajina Bela Krajina 32 62 32 65
3 Zagorje Zagorje 32 62 33 65
4 ND Dravinja Kostroj Dravinja 32 53 34 51
5 Aluminij Aluminij 32 50 39 50
6 Ivančna Gorica Ivančna 32 43 46 47
7 NK Krsko NK Krsko 32 41 63 35
8 Svoboda Ljubljana Svoboda 32 48 47 34
9 Triglav Kranj Triglav 32 43 53 34
10 Bonifika Izola Bonifika 32 31 58 27
11 Brda Dobrovo Brda Dobrovo 32 25 64 20
12 Tabor Sežana Tabor 22 20 56 14
TEMPORADA 2001/2002
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 Dravograd Dravograd 30 76 24 74
2 NK Ljubljana Ljubljana 30 89 12 72
3 Aluminij Aluminij 30 73 22 71
4 Ivančna Gorica Ivančna 30 65 32 57
5 NK Drava Ptuj Drava Ptuj 30 57 36 51
6 Bela Krajina Bela Krajina 30 65 40 48
7 ND Dravinja Kostroj Dravinja 30 37 24 43
8 Dekani Dekani 30 46 43 41
9 Nafta Lendava Nafta 30 46 52 39
10 Železničar Maribor Železničar 30 37 44 39
11 Zagorje Zagorje 30 36 45 37
12 Brda Dobrovo Brda Dobrovo 30 33 61 33
13 Triglav Bakovci Triglav 30 29 85 24
14 Tabor Sežana Tabor 30 31 73 23
15 NK Pohorje NK Pohorje 30 36 73 15
16 NK Krka NK Krka 30 15 105 8
TEMPORADA 2000/2001
LIGA ESLOVENA SNL
Equipo PJ GF GC Puntos
1 Maribor Maribor 33 61 36 62
2 NK Olimpija Ljubljana Olimpija 33 73 46 60
3 Primorje Primorje 33 47 34 56
4 NK Mura NK Mura 33 43 39 51
5 Celje Celje 33 59 52 50
6 FC Koper FC Koper 33 43 43 46
7 ND Gorica ND Gorica 33 52 46 43
8 Rudar Velenje Rudar 33 43 44 43
9 NK Korotan Prevalje Korotan 33 44 51 43
10 Domžale Domžale 33 44 64 37
11 Dravograd Dravograd 33 48 62 35
12 Tabor Sežana Tabor 33 34 74 28

  USO DE MEMORIA  
6,735,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6623
Total Execution Time  0.6636
  CADENA URL  
/historico/Tabor-Sezana
  GET DATOS  
$_GET['/historico/Tabor-Sezana']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0156  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 = 'Tabor-Sezana' 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=61113 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=61113 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=61113 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=61113 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61113 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=389 AND type_rel = 3
0.0150  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 = '61113' 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 = '61113' 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 = '61113' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 72187 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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=61113 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0150  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 (73730,72187,71432,68029) 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.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 68029 AND teamId = 61113
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 72187 AND teamId = 61113
0.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 73730 AND teamId = 61113
0.0167  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 61113
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 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 = 72187 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0155  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 = '61113' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61113' and rp.type = 4
0.0149  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 = '61113' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0172  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 = 72187 WHERE rp.league_id = 72187 AND rp.teamId = 61113 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.0166  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 = 72187 WHERE rp.league_id = 72187 AND rp.teamId = 61113 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 72187 WHERE rp.league_id = 72187 AND rp.teamId = 61113 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 61113 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72187 AND t.round = 28 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 `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 = 68029 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.0151  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 = 63210 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.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 `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 = 57294 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.0161  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 = 49909 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.0159  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 = 33923 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 15894 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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 = 9373 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 = 24374 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 24379 AND t.round = 24 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 `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 = 24397 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC