4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sportist Svoge
TEMPORADA 2023/2024
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 Spartak Varna Spartak 30 51 22 63
2 Septemvri Sofia Septemvri 30 41 24 58
3 Marek Marek 30 31 21 54
4 Montana Montana 30 38 28 50
5 Dobrudzha Dobrich Dobrudzha 30 42 28 49
6 Yantra Gabrovo Yantra 30 35 32 44
7 Ludogorets II Ludogorets 30 35 30 42
8 Spartak Pleven Spartak 30 27 27 42
9 Dunav Ruse Dunav Ruse 30 27 31 42
10 Strumska Slava Strumska 30 28 28 41
11 Litex Lovech Litex Lovech 30 25 29 41
12 CSKA 1948 Sofia II CSKA 1948 S. 30 32 34 40
13 Belasitsa Belasitsa 30 33 29 37
14 Chernomorets 1919 Burgas Chernomorets 30 28 35 34
15 Sportist Svoge Sportist 30 28 39 33
16 Maritsa Plovdiv Maritsa 30 28 46 28
17 Chernomorets Balchik Chernomorets 30 28 45 27
18 Bdin Bdin 30 12 41 18
TEMPORADA 2022/2023
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 CSKA 1948 Sofia II CSKA 1948 S. 34 60 17 74
2 Etar Etar 34 47 22 63
3 Levski Krumovgrad Levski 34 43 33 60
4 Ludogorets II Ludogorets 34 42 35 57
5 Sportist Svoge Sportist 34 41 40 52
6 Dunav Ruse Dunav Ruse 34 47 38 50
7 Maritsa Plovdiv Maritsa 34 36 46 47
8 Litex Lovech Litex Lovech 34 32 28 44
9 Montana Montana 34 37 39 44
10 Yantra Gabrovo Yantra 34 31 34 44
11 Spartak Pleven Spartak 34 44 44 42
12 Belasitsa Belasitsa 34 33 41 41
13 Dobrudzha Dobrich Dobrudzha 34 38 40 39
14 Strumska Slava Strumska 34 35 44 39
15 FK Minyor Pernik Minyor 34 33 35 38
16 Sozopol Sozopol 34 32 52 38
17 Vitosha Bistritsa Vitosha 34 34 50 36
18 Botev Plovdiv II Botev 34 25 52 28
TEMPORADA 2021/2022
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 Septemvri Sofia Septemvri 36 77 35 70
2 Spartak Varna Spartak 36 64 39 70
3 Hebar Pazardzhik Hebar 36 54 33 70
4 Etar Etar 36 69 42 68
5 FK Minyor Pernik Minyor 36 50 35 63
6 Ludogorets II Ludogorets 36 70 48 61
7 Montana Montana 36 39 31 58
8 Strumska Slava Strumska 36 40 37 54
9 Maritsa Plovdiv Maritsa 36 51 48 50
10 Sportist Svoge Sportist 36 38 46 48
11 CSKA 1948 Sofia II CSKA 1948 S. 36 53 50 45
12 Dobrudzha Dobrich Dobrudzha 36 39 45 45
13 Litex Lovech Litex Lovech 36 41 42 45
14 Yantra Gabrovo Yantra 36 30 46 40
15 Sozopol Sozopol 36 40 56 39
16 Botev Plovdiv II Botev 36 34 47 38
17 Marek Marek 36 29 46 36
18 Septemvri Simitli Septemvri 36 41 68 33
19 Levski 2020 Lom Levski 2020 36 12 77 8
20 Neftochimik Neftochimik 0 0 0 0
TEMPORADA 2020/2021
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 Pirin Blagoevgrad Pirin 29 63 26 62
2 Lokomotiv Sofia Lokomotiv 30 65 30 62
3 Septemvri Sofia Septemvri 29 51 29 53
4 Ludogorets II Ludogorets 30 56 38 50
5 Sportist Svoge Sportist 30 43 36 49
6 Hebar Pazardzhik Hebar 30 50 36 48
7 Sozopol Sozopol 30 35 40 39
8 Litex Lovech Litex Lovech 29 33 31 36
9 FK Minyor Pernik Minyor 29 27 37 36
10 Strumska Slava Strumska 30 31 37 34
11 Yantra Gabrovo Yantra 30 30 47 34
12 Septemvri Simitli Septemvri 30 34 42 33
13 Kariana Erden Kariana 25 29 44 31
14 Dobrudzha Dobrich Dobrudzha 29 25 46 27
15 Neftochimik Neftochimik 30 27 61 27
16 Gorna Lokomotiv Oryahovitsa Gorna 30 24 43 25
17 Vitosha Bistritsa Vitosha 0 0 0 0
TEMPORADA 2019/2020
TERCERA BULGARIA V AFG GRUPO 2
Equipo PJ GF GC Puntos
1 FK Minyor Pernik Minyor 18 34 6 42
2 Septemvri Simitli Septemvri 17 31 11 41
3 Sportist Svoge Sportist 18 31 21 37
4 Vihren Vihren 18 29 14 37
5 Oborishte Oborishte 18 30 10 34
6 Kyustendil Kyustendil 18 27 17 32
7 Slivnishki Geroy Slivnishki 18 27 22 27
8 Bansko Bansko 17 26 18 26
9 Chavdar Etropole Chavdar 18 30 26 23
10 Belasitsa Belasitsa 18 21 26 22
11 Botev Ihtiman Botev 18 14 24 22
12 Nadezhda Dobroslavtsi Nadezhda 18 28 35 18
13 Pirin Razlog Pirin Razlog 18 12 22 17
14 Marek Marek 18 19 39 16
15 Balkan Botevgrad Balkan 18 16 33 15
16 Rilski Sportist Rilski 18 13 33 11
17 Perun Perun 18 9 40 7
TEMPORADA 2018/2019
TERCERA BULGARIA V AFG GRUPO 2
Equipo PJ GF GC Puntos
1 Hebar Pazardzhik Hebar 34 73 19 90
2 Oborishte Oborishte 34 60 27 75
3 Vihren Vihren 34 52 35 62
4 Slivnishki Geroy Slivnishki 34 60 35 58
5 FK Minyor Pernik Minyor 34 57 37 58
6 Bansko Bansko 34 56 37 57
7 Pirin Razlog Pirin Razlog 34 47 35 51
8 Rilski Sportist Rilski 34 47 42 49
9 Belasitsa Belasitsa 34 43 37 46
10 Marek Marek 34 35 37 41
11 Chavdar Etropole Chavdar 34 54 47 40
12 Septemvri Simitli Septemvri 34 34 36 40
13 Balkan Botevgrad Balkan 34 41 57 38
14 Sportist Svoge Sportist 34 45 61 37
15 Nadezhda Dobroslavtsi Nadezhda 34 40 61 37
16 Botev Ihtiman Botev 34 35 75 32
17 Germaneya Germaneya 34 36 70 30
18 Velbazhd Velbazhd 34 22 89 8
TEMPORADA 2014/2015
TERCERA BULGARIA V AFG GRUPO 3
Equipo PJ GF GC Puntos
1 Oborishte Oborishte 30 91 21 70
2 FK Minyor Pernik Minyor 30 56 21 65
3 Pirin Gotse Delchev Pirin Gotse 30 53 18 62
4 Vitosha Bistritsa Vitosha 30 57 22 60
5 Slivnishki Geroy Slivnishki 30 69 38 58
6 Belasitsa Belasitsa 30 48 33 51
7 Strumska Slava Strumska 30 38 36 42
8 Vihren Vihren 30 37 40 39
9 Velbazhd Velbazhd 30 38 42 37
10 Koneliano German Koneliano 30 46 80 37
11 Balkan Varvara Balkan 30 47 69 34
12 Germaneya Germaneya 30 32 55 33
13 Chepinets Chepinets 30 35 58 32
14 Rilski Sportist Rilski 30 26 46 27
15 Sportist Svoge Sportist 30 26 69 20
16 Mesta Mesta 30 15 66 15
TEMPORADA 2013/2014
TERCERA BULGARIA V AFG GRUPO 4
Equipo PJ GF GC Puntos
1 Septemvri Simitli Septemvri 15 24 7 35
2 Pirin Blagoevgrad Pirin 15 32 6 34
3 Slivnishki Geroy Slivnishki 15 32 9 33
4 FK Minyor Pernik Minyor 15 29 7 32
5 Oborishte Oborishte 15 25 16 29
6 Vihren Vihren 15 17 17 22
7 Belasitsa Belasitsa 15 19 15 20
8 Velbazhd Velbazhd 15 19 21 20
9 Mesta Mesta 15 14 25 20
10 Balkan Varvara Balkan 15 18 20 19
11 Strumska Slava Strumska 15 11 14 16
12 Sportist Svoge Sportist 15 15 21 15
13 Germaneya Germaneya 15 11 19 15
14 Chepinets Chepinets 15 17 27 14
15 Botev Ihtiman Botev 15 10 30 9
16 Septemvri Sofia Septemvri 15 9 48 6
TEMPORADA 2011/2012
SEGUNDA BULGARIA B PFG GRUPO 2
Equipo PJ GF GC Puntos
1 Pirin Gotse Delchev Pirin Gotse 27 41 12 62
2 Sportist Svoge Sportist 27 44 23 56
3 Bdin Bdin 27 42 20 51
4 Bansko Bansko 27 36 24 40
5 Chavdar Etropole Chavdar 27 36 33 39
6 Septemvri Simitli Septemvri 27 35 33 34
7 Akademik Sofia Akademik 27 25 33 31
8 Slivnishki Geroy Slivnishki 27 28 48 25
9 Malesh Malesh 27 19 38 22
10 Chavdar Byala Chavdar 27 14 56 12
TEMPORADA 2010/2011
SEGUNDA BULGARIA B PFG GRUPO 2
Equipo PJ GF GC Puntos
1 Botev Vratsa Botev Vratsa 30 52 28 62
2 Sportist Svoge Sportist 30 36 15 52
3 Etar Etar 30 33 19 51
4 Bansko Bansko 30 42 35 48
5 Chavdar Etropole Chavdar 30 37 34 44
6 Septemvri Simitli Septemvri 30 30 31 43
7 Vihren Vihren 30 37 32 42
8 Pirin Gotse Delchev Pirin Gotse 30 27 38 36
9 Chavdar Byala Chavdar 30 27 36 34
10 Malesh Malesh 30 22 37 32
11 Botev Krivodol Botev 30 25 63 17
12 Kom-Minyor Kom-Minyor 0 0 0 0
TEMPORADA 2009/2010
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Litex Lovech Litex Lovech 30 59 17 70
2 CSKA Sofia CSKA Sofia 30 51 22 58
3 Levski Sofia Levski Sofia 30 57 26 57
4 Lokomotiv Sofia Lokomotiv 30 47 33 52
5 Chernomoretz Burgas Chernomoretz 30 44 29 51
6 Slavia Sofia Slavia Sofia 30 34 28 50
7 Cherno More Varna Cherno More 30 40 28 48
8 FK Minyor Pernik Minyor 30 38 26 45
9 Pirin Blagoevgrad Pirin 30 34 32 43
10 Beroe Beroe 30 30 36 38
11 Montana Montana 30 30 37 36
12 Lokomotiv Plovdiv Lokomotiv 30 36 52 33
13 OFC Sliven 2000 Sliven 2000 30 29 40 32
14 Lokomotiv Mezdra Lokomotiv 30 27 48 27
15 Sportist Svoge Sportist 30 23 59 19
16 Botev Plovdiv Botev 30 12 78 1
TEMPORADA 2008/2009
SEGUNDA BULGARIA B PFG GRUPO 2
Equipo PJ GF GC Puntos
1 Montana Montana 30 63 21 70
2 Sportist Svoge Sportist 30 54 25 63
3 Bansko Bansko 30 52 23 60
4 Chavdar Etropole Chavdar 30 45 30 54
5 Balkan Botevgrad Balkan 30 38 34 49
6 Rilski Sportist Rilski 30 34 39 49
7 Vidima-Rakovski Vidima-Rakov 30 31 25 43
8 Akademik Sofia Akademik 30 39 35 42
9 Pirin Gotse Delchev Pirin Gotse 30 48 39 40
10 Botev Krivodol Botev 30 32 46 38
11 Kom-Minyor Kom-Minyor 30 32 47 33
12 Belite Orli Belite Orli 30 27 43 29
13 Etar Etar 30 36 45 28
14 Marek Marek 30 29 48 28
15 Chavdar Byala Chavdar 30 31 41 26
16 Spartak Pleven Spartak 30 10 60 14
TEMPORADA 2007/2008
SEGUNDA BULGARIA B PFG GRUPO 2
Equipo PJ GF GC Puntos
1 Lokomotiv Mezdra Lokomotiv 26 56 12 63
2 FK Minyor Pernik Minyor 26 45 31 47
3 Chavdar Etropole Chavdar 26 39 23 46
4 Rilski Sportist Rilski 26 44 33 45
5 Belite Orli Belite Orli 26 33 31 38
6 Sportist Svoge Sportist 26 35 30 36
7 Montana Montana 26 29 29 34
8 Etar Etar 26 33 39 34
9 Akademik Sofia Akademik 26 41 43 32
10 Spartak Pleven Spartak 26 29 40 32
11 Pirin Gotse Delchev Pirin Gotse 26 28 33 31
12 Chavdar Byala Chavdar 26 19 34 25
13 Yantra Gabrovo Yantra 26 31 48 24
14 Velbazhd Velbazhd 26 20 56 18

  USO DE MEMORIA  
6,750,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5741
Total Execution Time  0.5753
  CADENA URL  
/historico/Sportist-Svoge
  GET DATOS  
$_GET['/historico/Sportist-Svoge']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0158  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 = 'Sportist-Svoge' 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.0129  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=4609 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=4609 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=4609 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=4609 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4609 AND type_rel = 2
0.0138  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 = '4609' ORDER BY l.year DESC,cat.coefficient 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 = '4609' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '4609' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=4609 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 (73790,72088,71950,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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 72088 AND teamId = 4609
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 71950 AND teamId = 4609
0.0137  SELECT count(id) as num_players from rel_players WHERE league_id = 73790 AND teamId = 4609
0.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 4609
0.0129  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 = '4609' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0130  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 = '4609' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0163  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 = 72088 WHERE rp.league_id = 72088 AND rp.teamId = 4609 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.0159  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 = 72088 WHERE rp.league_id = 72088 AND rp.teamId = 4609 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 72088 WHERE rp.league_id = 72088 AND rp.teamId = 4609 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0142  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 = 4609 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0254  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 = 72088 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.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 `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 = 68063 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 63160 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `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 = 57213 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `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 = 51127 AND t.round = 19 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 `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 = 44690 AND t.round = 34 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 `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 = 4373 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 = 3577 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 `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 = 1738 AND t.round = 27 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 `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 = 14033 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 `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 = 8795 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 `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 = 14031 AND t.round = 30 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 = 14030 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC