4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Balkan Botevgrad
TEMPORADA 2023/2024
TERCERA BULGARIA V AFG GRUPO 2
Equipo PJ GF GC Puntos
1 FK Minyor Pernik Minyor 29 60 19 75
2 CSKA Sofia II CSKA Sofia 29 54 25 66
3 Vihren Vihren 30 48 38 51
4 Slivnishki Geroy Slivnishki 30 44 34 50
5 Botev Ihtiman Botev 30 49 42 49
6 Balkan Botevgrad Balkan 29 50 45 45
7 Rilski Sportist Rilski 30 43 45 42
8 Chavdar Etropole Chavdar 29 46 47 41
9 Levski Sofia II Levski Sofia 29 47 38 40
10 Kyustendil Kyustendil 29 47 39 40
11 Vitosha Bistritsa Vitosha 30 22 25 37
12 Septemvri Sofia II Septemvri 30 39 37 37
13 Septemvri Simitli Septemvri 30 40 43 36
14 CSKA 1948 Sofia III CSKA 1948 S. 30 40 43 35
15 Kostinbrod Kostinbrod 30 34 51 35
16 Bansko Bansko 30 33 42 35
17 Oborishte Oborishte 30 37 64 33
18 Slavia Sofia II Slavia Sofia 29 37 51 31
19 Pirin Razlog Pirin Razlog 29 22 47 26
20 Hebar II Hebar II 30 27 44 26
TEMPORADA 2022/2023
TERCERA BULGARIA V AFG GRUPO 5
Equipo PJ GF GC Puntos
1 Marek Marek 10 14 6 43
2 Vihren Vihren 10 19 9 33
3 Kyustendil Kyustendil 10 12 12 29
4 Chavdar Etropole Chavdar 10 11 12 28
5 Bansko Bansko 9 11 12 21
6 CSKA Sofia II CSKA Sofia 9 15 15 19
7 Slivnishki Geroy Slivnishki 10 12 13 19
8 Balkan Botevgrad Balkan 10 19 21 19
9 Kostinbrod Kostinbrod 10 9 17 18
10 Septemvri Simitli Septemvri 10 9 14 17
TEMPORADA 2021/2022
TERCERA BULGARIA V AFG GRUPO 3
Equipo PJ GF GC Puntos
1 Belasitsa Belasitsa 38 90 26 88
2 Vitosha Bistritsa Vitosha 38 81 25 81
3 Chavdar Etropole Chavdar 38 70 20 80
4 Kyustendil Kyustendil 38 75 26 80
5 Oborishte Oborishte 38 69 51 74
6 Balkan Botevgrad Balkan 38 62 38 71
7 Bansko Bansko 38 56 36 68
8 Pirin Gotse Delchev Pirin Gotse 38 48 51 51
9 Granit Vladaya Granit 38 40 60 48
10 Rilski Sportist Rilski 38 56 64 48
11 Pirin Razlog Pirin Razlog 38 49 50 47
12 Nadezhda Dobroslavtsi Nadezhda 38 50 62 46
13 Kostinbrod Kostinbrod 38 44 53 46
14 Septemvri Sofia II Septemvri 38 64 77 45
15 Slivnishki Geroy Slivnishki 38 44 47 44
16 Botev Ihtiman Botev 38 40 55 43
17 Vihren Vihren 38 58 70 43
18 Hebar II Hebar II 38 43 56 41
19 Pirin Blagoevgrad II Pirin 38 24 82 17
20 Levski Chepintsi Levski 38 17 131 3
TEMPORADA 2020/2021
TERCERA BULGARIA V AFG GRUPO 2
Equipo PJ GF GC Puntos
1 Marek Marek 34 84 24 82
2 Kyustendil Kyustendil 34 63 14 82
3 Belasitsa Belasitsa 34 68 27 78
4 Vihren Vihren 34 63 25 75
5 Oborishte Oborishte 34 55 41 60
6 Balkan Botevgrad Balkan 34 62 34 58
7 Chavdar Etropole Chavdar 34 62 46 51
8 Botev Ihtiman Botev 34 53 41 46
9 Pirin Gotse Delchev Pirin Gotse 34 37 32 45
10 Pirin Razlog Pirin Razlog 34 40 59 41
11 Slivnishki Geroy Slivnishki 34 38 44 36
12 Nadezhda Dobroslavtsi Nadezhda 34 40 56 36
13 Rilski Sportist Rilski 34 30 45 34
14 Bansko Bansko 34 28 47 34
15 Levski Chepintsi Levski 34 34 72 34
16 Granit Vladaya Granit 34 34 65 32
17 Perun Perun 34 25 77 22
18 Velbazhd Kyustendil Velbazhd 34 16 83 16
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 2017/2018
TERCERA BULGARIA V AFG GRUPO 3
Equipo PJ GF GC Puntos
1 CSKA 1948 Sofia CSKA 1948 S. 34 95 16 92
2 Hebar Pazardzhik Hebar 34 72 24 84
3 Vihren Vihren 34 70 49 62
4 FK Minyor Pernik Minyor 34 53 42 54
5 Bansko Bansko 34 48 34 53
6 Chavdar Etropole Chavdar 34 63 49 52
7 Septemvri Simitli Septemvri 34 46 37 50
8 Slivnishki Geroy Slivnishki 34 50 41 46
9 Belasitsa Belasitsa 34 40 46 42
10 Balkan Botevgrad Balkan 34 49 60 41
11 Botev Ihtiman Botev 34 41 64 40
12 Pirin Razlog Pirin Razlog 34 40 40 38
13 Svoboda Svoboda 34 37 59 38
14 Marek Marek 34 35 48 37
15 Rilski Sportist Rilski 34 40 51 36
16 Germaneya Germaneya 34 38 63 35
17 Pirin Gotse Delchev Pirin Gotse 34 27 66 32
18 OFK Elin Pelin Elin Pelin 34 34 89 21
TEMPORADA 2016/2017
TERCERA BULGARIA V AFG GRUPO 4
Equipo PJ GF GC Puntos
1 Strumska Slava Strumska 34 76 20 78
2 Septemvri Simitli Septemvri 34 62 28 72
3 FK Minyor Pernik Minyor 34 58 37 68
4 Slivnishki Geroy Slivnishki 34 69 39 59
5 Belasitsa Belasitsa 34 52 34 59
6 Hebar Pazardzhik Hebar 34 68 41 58
7 Chavdar Etropole Chavdar 34 60 46 53
8 Marek Marek 34 51 50 52
9 Rilski Sportist Rilski 34 53 61 43
10 Pirin Gotse Delchev Pirin Gotse 34 45 41 42
11 Pirin Razlog Pirin Razlog 34 36 55 41
12 Balkan Botevgrad Balkan 34 54 55 40
13 Germaneya Germaneya 34 52 52 38
14 Botev Ihtiman Botev 34 49 72 38
15 Svoboda Svoboda 34 36 75 37
16 Vihren Vihren 34 36 46 37
17 Velbazhd Kyustendil Velbazhd 34 44 63 32
18 Chepinets Chepinets 34 33 119 18
TEMPORADA 2011/2012
TERCERA BULGARIA V AFG GRUPO 4
Equipo PJ GF GC Puntos
1 Pirin Razlog Pirin Razlog 36 93 20 93
2 Perun Perun 36 83 20 89
3 Rilski Sportist Rilski 36 66 29 68
4 Oborishte Oborishte 36 76 35 67
5 Marek Marek 36 62 31 63
6 Vitosha Bistritsa Vitosha 36 53 36 61
7 Velbazhd Velbazhd 36 57 54 57
8 Germaneya Germaneya 36 50 51 52
9 Chepinets Chepinets 36 68 50 49
10 Belasitsa Belasitsa 36 54 47 48
11 Mesta Mesta 36 51 51 46
12 Kostinbrod Kostinbrod 36 42 50 46
13 Septemvri Sofia Septemvri 36 38 49 44
14 Hebar 2011 Hebar 2011 71 61 218 43
15 Minyor Bobov dol Minyor Bobov 36 45 62 42
16 Vitosha Dolna Dikanya Vitosha 36 48 68 42
17 Strumska Slava Strumska 36 44 63 36
18 Levski Elin Pelin Levski Elin 35 28 85 20
19 Balkan Botevgrad Balkan 0 0 0 0
TEMPORADA 2010/2011
TERCERA BULGARIA V AFG GRUPO 1
Equipo PJ GF GC Puntos
1 Slivnishki Geroy Slivnishki 38 108 24 93
2 Pirin Razlog Pirin Razlog 38 89 28 85
3 Vitosha Bistritsa Vitosha 38 70 24 85
4 Perun Perun 38 89 31 79
5 Mesta Mesta 38 71 38 69
6 Kostinbrod Kostinbrod 38 82 47 61
7 Lokomotiv Septemvri Lokomotiv 38 75 55 59
8 Balkan Botevgrad Balkan 38 61 51 56
9 Septemvri Sofia Septemvri 38 59 54 56
10 Velbazhd Velbazhd 38 73 59 54
11 Minyor Bobov dol Minyor Bobov 38 62 58 54
12 Vitosha Dolna Dikanya Vitosha 38 58 53 53
13 Benkovski Pazardzhik Benkovski 38 57 57 48
14 Strumska Slava Strumska 38 57 78 47
15 Chepinets Chepinets 38 49 75 42
16 Germaneya Germaneya 38 39 58 39
17 Levski Elin Pelin Levski Elin 38 52 100 36
18 Hebar Pazardzhik Hebar 38 54 93 32
19 Botev Ihtiman Botev 37 20 133 16
20 Avangard Avangard 37 37 146 14
TEMPORADA 2009/2010
SEGUNDA BULGARIA B PFG GRUPO 2
Equipo PJ GF GC Puntos
1 Vidima-Rakovski Vidima-Rakov 30 53 32 60
2 Bansko Bansko 30 50 22 59
3 Akademik Sofia Akademik 30 49 37 59
4 Vihren Vihren 30 45 24 56
5 Etar Etar 30 47 38 47
6 Botev Vratsa Botev Vratsa 30 39 26 45
7 Septemvri Simitli Septemvri 30 40 34 43
8 Chavdar Etropole Chavdar 30 34 32 43
9 Balkan Botevgrad Balkan 30 35 28 41
10 Marek Marek 30 36 36 41
11 Pirin Gotse Delchev Pirin Gotse 30 35 38 40
12 Kom-Minyor Kom-Minyor 30 36 43 38
13 Botev Krivodol Botev 30 21 40 31
14 Rilski Sportist Rilski 30 32 49 30
15 Bdin Bdin 30 26 48 20
16 Belite Orli Belite Orli 30 20 71 10
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 2005/2006
SEGUNDA BULGARIA B PFG GRUPO 1
Equipo PJ GF GC Puntos
1 Chernomoretz Burgas Chernomoretz 26 54 15 62
2 Rilski Sportist Rilski 26 53 25 61
3 Spartak Pleven Spartak 26 58 18 59
4 Vidima-Rakovski Vidima-Rakov 26 39 26 43
5 Belite Orli Belite Orli 26 34 32 38
6 Pirin Gotse Delchev Pirin Gotse 26 39 26 37
7 Hebar Pazardzhik Hebar 26 35 35 33
8 Etar Etar 26 31 39 30
9 Minyor Bobov dol Minyor Bobov 26 34 37 29
10 Lokomotiv Mezdra Lokomotiv 26 25 46 27
11 Montana Montana 26 23 47 26
12 FK Minyor Pernik Minyor 26 25 43 24
13 Yantra Gabrovo Yantra 26 23 52 22
14 Balkan Botevgrad Balkan 26 11 43 19

  USO DE MEMORIA  
7,045,000 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4713
Total Execution Time  0.4734
  CADENA URL  
/historico/Balkan-Botevgrad
  GET DATOS  
$_GET['/historico/Balkan-Botevgrad']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0124  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 = 'Balkan-Botevgrad' 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.0106  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=63851 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=63851 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=63851 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=63851 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=63851 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0222  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 = 73546
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=63851 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=238 AND type_rel = 3
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 238 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0121  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 (77796,59747,55420,15539) ORDER BY n.cover_points DESC, update_date DESC
0.0109  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 = '63851' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0109  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 = 73546 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106  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 = 73001 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0111  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 = 73001 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0109  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 = 63851 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0111  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 = 73001 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.0110  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 = 68508 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 71263 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 63580 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.0111  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 = 57814 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.0110  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.0157  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.0111  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 = 39352 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 34149 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 24584 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 24587 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 14032 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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.0109  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 = 14021 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC