4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA BULGARIA GRUPO 3
Equipo PJ GF GC Puntos
1 Beroe Beroe 31 27 42 36
2 Lokomotiv Sofia Lokomotiv 31 24 56 31
3 Hebar Pazardzhik Hebar 31 32 46 30
4 Pirin Blagoevgrad Pirin 31 24 43 30
5 Botev Vratsa Botev Vratsa 31 24 54 25
6 Etar Etar 31 17 59 14
TEMPORADA 2022/2023
LIGA BULGARIA GRUPO 4
Equipo PJ GF GC Puntos
1 Arda Kardzhali Arda 36 47 36 58
2 Slavia Sofia Slavia Sofia 36 37 31 58
3 Lokomotiv Sofia Lokomotiv 36 37 49 42
4 Botev Plovdiv Botev 36 41 49 36
TEMPORADA 2021/2022
LIGA BULGARIA GRUPO 4
Equipo PJ GF GC Puntos
1 Lokomotiv Sofia Lokomotiv 32 27 46 34
2 Pirin Blagoevgrad Pirin 32 40 53 33
3 Botev Vratsa Botev Vratsa 32 30 55 28
4 Tsarsko Selo Tsarsko Selo 32 22 38 26
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
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 CSKA 1948 Sofia CSKA 1948 S. 21 59 18 55
2 Septemvri Sofia Septemvri 20 47 19 52
3 Montana Montana 22 43 17 45
4 Lokomotiv Sofia Lokomotiv 22 37 18 42
5 Neftochimik Neftochimik 21 35 29 33
6 Hebar Pazardzhik Hebar 21 35 30 33
7 Litex Lovech Litex Lovech 20 29 15 32
8 Kariana Erden Kariana 20 30 24 32
9 Gorna Lokomotiv Oryahovitsa Gorna 21 32 30 29
10 Botev Galabovo Botev 22 26 32 28
11 Ludogorets II Ludogorets 22 23 25 27
12 Pirin Blagoevgrad Pirin 20 24 29 25
13 Strumska Slava Strumska 21 21 34 22
14 Chernomorets Balchik Chernomorets 20 15 27 22
15 Spartak Varna Spartak 22 9 42 13
16 Spartak Pleven Spartak 22 13 41 10
17 Pomorie Pomorie 27 15 63 6
TEMPORADA 2018/2019
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 Tsarsko Selo Tsarsko Selo 30 68 27 76
2 Montana Montana 30 49 22 63
3 Arda Kardzhali Arda 30 44 18 62
4 CSKA 1948 Sofia CSKA 1948 S. 30 39 18 59
5 Litex Lovech Litex Lovech 30 43 26 45
6 Strumska Slava Strumska 30 36 44 37
7 Chernomorets Balchik Chernomorets 30 27 35 37
8 Lokomotiv Sofia Lokomotiv 30 25 28 36
9 Gorna Lokomotiv Oryahovitsa Gorna 30 30 43 36
10 Pomorie Pomorie 30 35 49 36
11 Ludogorets II Ludogorets 30 31 43 32
12 Botev Galabovo Botev 30 32 38 31
13 Kariana Erden Kariana 30 29 38 31
14 Pirin Blagoevgrad Pirin 30 29 49 31
15 Nesebar Nesebar 30 33 51 27
16 Dobrudzha Dobrich Dobrudzha 30 17 38 22
TEMPORADA 2017/2018
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 Botev Vratsa Botev Vratsa 30 46 20 64
2 Lokomotiv Sofia Lokomotiv 30 51 27 63
3 Tsarsko Selo Tsarsko Selo 30 56 28 63
4 Montana Montana 30 50 20 56
5 Nesebar Nesebar 30 42 43 44
6 Pomorie Pomorie 30 36 32 41
7 Botev Galabovo Botev 30 37 40 41
8 Gorna Lokomotiv Oryahovitsa Gorna 30 42 39 40
9 Ludogorets II Ludogorets 30 40 50 40
10 Litex Lovech Litex Lovech 30 26 26 39
11 Chernomorets Balchik Chernomorets 30 37 40 39
12 Strumska Slava Strumska 30 31 43 36
13 Oborishte Oborishte 30 26 32 33
14 Maritsa Plovdiv Maritsa 30 34 45 33
15 Sozopol Sozopol 30 25 47 24
16 Neftochimik Neftochimik 30 15 62 9
TEMPORADA 2016/2017
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 Etar Etar 30 52 27 61
2 Septemvri Sofia Septemvri 30 52 26 59
3 Vitosha Bistritsa Vitosha 30 37 23 53
4 Sozopol Sozopol 30 38 25 50
5 Tsarsko Selo Tsarsko Selo 30 54 39 48
6 Lokomotiv Sofia Lokomotiv 30 47 34 47
7 Pomorie Pomorie 30 36 32 47
8 Ludogorets II Ludogorets 30 39 33 44
9 Nesebar Nesebar 30 39 47 40
10 Botev Vratsa Botev Vratsa 30 42 41 38
11 Oborishte Oborishte 30 30 39 37
12 Botev Galabovo Botev 30 28 39 34
13 CSKA Sofia II CSKA Sofia 30 44 49 33
14 Spartak Pleven Spartak 30 44 52 33
15 Bansko Bansko 30 26 55 25
16 Levski Karlovo Levski 30 24 71 16
TEMPORADA 2015/2016
TERCERA BULGARIA V AFG GRUPO 3
Equipo PJ GF GC Puntos
1 CSKA Sofia CSKA Sofia 32 146 10 94
2 Vitosha Bistritsa Vitosha 32 72 16 74
3 Slivnishki Geroy Slivnishki 32 80 35 69
4 Strumska Slava Strumska 32 58 36 60
5 FK Minyor Pernik Minyor 32 55 35 59
6 Vihren Vihren 32 48 36 55
7 Chiko Byaga Chiko Byaga 32 57 67 43
8 Septemvri Sofia Septemvri 32 67 62 42
9 Belasitsa Belasitsa 32 41 52 39
10 Botev Ihtiman Botev 32 52 66 37
11 Rilski Sportist Rilski 32 41 43 35
12 Velbazhd Velbazhd 32 42 56 34
13 Sofia 2010 Sofia 2010 32 51 72 34
14 Chepinets Chepinets 32 35 72 32
15 Pirin Gotse Delchev Pirin Gotse 32 33 63 28
16 Germaneya Germaneya 32 20 122 19
17 Balkan Varvara Balkan 32 25 80 17
18 Lokomotiv Sofia Lokomotiv 0 0 0 0
TEMPORADA 2014/2015
LIGA BULGARIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 10 17 10 63
2 Beroe Beroe 10 12 9 55
3 Lokomotiv Sofia Lokomotiv 10 10 7 55
4 Litex Lovech Litex Lovech 10 12 12 54
5 CSKA Sofia CSKA Sofia 10 6 12 52
6 Botev Plovdiv Botev 10 6 13 42
TEMPORADA 2013/2014
LIGA BULGARIA GRUPO 3
Equipo PJ GF GC Puntos
1 Beroe Beroe 12 26 4 70
2 Slavia Sofia Slavia Sofia 12 22 8 55
3 Lokomotiv Sofia Lokomotiv 12 16 8 54
4 Chernomoretz Burgas Chernomoretz 12 26 16 44
5 Neftochimik Neftochimik 12 11 26 25
6 Pirin Gotse Delchev Pirin Gotse 12 12 20 22
7 Lyubimets Lyubimets 12 7 38 21
TEMPORADA 2012/2013
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 30 58 13 72
2 Levski Sofia Levski Sofia 30 59 20 71
3 CSKA Sofia CSKA Sofia 30 54 20 63
4 Botev Plovdiv Botev 30 51 21 60
5 Litex Lovech Litex Lovech 30 56 24 50
6 Chernomoretz Burgas Chernomoretz 30 32 29 47
7 Beroe Beroe 30 36 38 45
8 Slavia Sofia Slavia Sofia 30 40 35 42
9 Lokomotiv Plovdiv Lokomotiv 30 37 34 39
10 Cherno More Varna Cherno More 30 33 39 35
11 Pirin Gotse Delchev Pirin Gotse 30 27 57 34
12 Lokomotiv Sofia Lokomotiv 30 27 38 31
13 Botev Vratsa Botev Vratsa 30 23 51 31
14 FK Minyor Pernik Minyor 30 20 49 20
15 Montana Montana 30 27 57 16
16 Etar Etar 30 20 75 13
TEMPORADA 2011/2012
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 30 73 16 70
2 CSKA Sofia CSKA Sofia 30 60 19 69
3 Levski Sofia Levski Sofia 30 61 28 62
4 Chernomoretz Burgas Chernomoretz 30 57 23 60
5 Litex Lovech Litex Lovech 30 57 28 59
6 Lokomotiv Plovdiv Lokomotiv 30 44 39 57
7 Cherno More Varna Cherno More 30 46 25 52
8 Slavia Sofia Slavia Sofia 30 42 36 51
9 FK Minyor Pernik Minyor 30 35 40 36
10 Beroe Beroe 30 30 37 35
11 Montana Montana 30 29 51 31
12 Botev Vratsa Botev Vratsa 30 30 44 29
13 Lokomotiv Sofia Lokomotiv 30 26 50 24
14 Vidima-Rakovski Vidima-Rakov 30 19 59 15
15 Kaliakra Kaliakra 30 26 77 11
16 Svetkavitsa Svetkavitsa 30 8 71 8
TEMPORADA 2010/2011
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Litex Lovech Litex Lovech 30 56 13 75
2 Levski Sofia Levski Sofia 30 67 24 72
3 CSKA Sofia CSKA Sofia 30 53 26 61
4 Lokomotiv Plovdiv Lokomotiv 30 54 28 52
5 Lokomotiv Sofia Lokomotiv 30 47 33 52
6 Cherno More Varna Cherno More 30 36 28 51
7 Beroe Beroe 30 33 34 46
8 Chernomoretz Burgas Chernomoretz 30 19 28 37
9 FK Minyor Pernik Minyor 30 33 45 36
10 Slavia Sofia Slavia Sofia 30 34 38 32
11 Montana Montana 30 30 46 32
12 Kaliakra Kaliakra 30 19 40 30
13 Pirin Blagoevgrad Pirin 30 32 39 27
14 Vidima-Rakovski Vidima-Rakov 30 26 52 25
15 Akademik Sofia Akademik 30 16 51 20
16 OFC Sliven 2000 Sliven 2000 30 22 52 19
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

  USO DE MEMORIA  
6,531,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.6727
Total Execution Time  0.6744
  CADENA URL  
/historico/Lokomotiv-Sofia
  GET DATOS  
$_GET['/historico/Lokomotiv-Sofia']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0257  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 = 75897
0.0140  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 = 73790
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5869 AND type_rel = 2
0.0136  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5869 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0135  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 (59747) ORDER BY n.cover_points DESC, update_date DESC
0.0179  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 = '5869' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0134  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 = 75897 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  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 = 73790 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0142  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=5869 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0129  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 (75897,73790,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 = 75897 AND teamId = 5869
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 73790 AND teamId = 5869
0.0137  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 5869
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 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 = 75897 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0130  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 = '5869' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5869' and rp.type = 4
0.0129  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 = '5869' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139  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 = 75897 WHERE rp.league_id = 75897 AND rp.teamId = 5869 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.0132  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 = 75897 WHERE rp.league_id = 75897 AND rp.teamId = 5869 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 75897 WHERE rp.league_id = 75897 AND rp.teamId = 5869 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 5869 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72087 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.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 `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 = 75897 AND t.round = 1 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 = 67855 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.0138  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 = 71636 AND t.round = 6 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 `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 = 63159 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 67308 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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.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 `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 = 50137 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.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 `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 = 43937 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 = 38793 AND t.round = 30 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 `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 = 34065 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 `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 = 15844 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 = 3815 AND t.round = 22 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 `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 = 11703 AND t.round = 10 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 `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 = 2453 AND t.round = 26 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 `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 = 10193 AND t.round = 14 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 = 1934 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 `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 = 1621 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 8796 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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