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 30 24 42 33
2 Hebar Pazardzhik Hebar 30 32 44 30
3 Pirin Blagoevgrad Pirin 31 24 43 30
4 Lokomotiv Sofia Lokomotiv 30 22 56 28
5 Botev Vratsa Botev Vratsa 31 24 54 25
6 Etar Etar 30 17 56 14
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
LIGA BULGARIA GRUPO 3
Equipo PJ GF GC Puntos
1 Slavia Sofia Slavia Sofia 32 28 44 34
2 Botev Vratsa Botev Vratsa 32 31 45 30
3 Montana Montana 32 26 52 28
4 Etar Etar 32 25 53 28
TEMPORADA 2019/2020
LIGA BULGARIA GRUPO 3
Equipo PJ GF GC Puntos
1 Cherno More Varna Cherno More 3 7 3 47
2 Etar Etar 3 3 3 31
3 Tsarsko Selo Tsarsko Selo 3 3 4 31
4 Vitosha Bistritsa Vitosha 3 0 3 6
5 Botev Plovdiv Botev 3 6 4 36
6 Arda Kardzhali Arda 3 1 2 35
7 Botev Vratsa Botev Vratsa 3 5 4 26
8 Dunav Ruse Dunav Ruse 3 4 6 22
TEMPORADA 2018/2019
LIGA BULGARIA GRUPO 2
Equipo PJ GF GC Puntos
1 Botev Vratsa Botev Vratsa 6 20 4 14
2 Etar Etar 6 9 4 11
3 Vitosha Bistritsa Vitosha 6 9 10 9
4 Vereya Vereya 6 1 21 0
5 Septemvri Sofia Septemvri 6 9 6 12
6 Dunav Ruse Dunav Ruse 6 11 8 9
7 Slavia Sofia Slavia Sofia 6 9 11 6
8 Lokomotiv Plovdiv Lokomotiv 6 5 9 3
TEMPORADA 2017/2018
LIGA BULGARIA GRUPO 1
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 26 63 13 66
2 CSKA Sofia CSKA Sofia 26 59 14 63
3 Levski Sofia Levski Sofia 26 37 14 50
4 Beroe Beroe 26 33 24 45
5 Botev Plovdiv Botev 26 44 29 42
6 Vereya Vereya 26 24 34 35
7 Slavia Sofia Slavia Sofia 26 34 37 32
8 Lokomotiv Plovdiv Lokomotiv 26 22 37 31
9 Septemvri Sofia Septemvri 26 25 42 31
10 Cherno More Varna Cherno More 26 24 32 27
11 Pirin Blagoevgrad Pirin 26 20 28 26
12 Etar Etar 26 24 45 21
13 Dunav Ruse Dunav Ruse 26 17 38 21
14 Vitosha Bistritsa Vitosha 26 12 51 8
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 4
Equipo PJ GF GC Puntos
1 Etar Etar 30 100 16 82
2 Botev Vratsa Botev Vratsa 30 101 17 81
3 Akademik Svishtov Akademik 30 58 34 59
4 OFK Levski OFK Levski 30 49 33 48
5 Kariana Erden Kariana 30 49 44 47
6 Vihar Slavyanovo Vihar 30 44 38 46
7 Pavlikeni Pavlikeni 30 39 52 46
8 Partizan Partizan 30 47 40 44
9 FC Sevlievo FC Sevlievo 30 49 56 42
10 Botev Lukovit Botev 30 47 56 41
11 Tryavna Tryavna 30 36 42 36
12 Bdin Bdin 30 48 75 34
13 Juventus Malchika Juventus 30 32 62 31
14 Yantra Gabrovo Yantra 30 29 50 29
15 Parva Atomna Parva Atomna 30 23 65 15
16 Gigant Belene Gigant 30 21 92 11
TEMPORADA 2014/2015
TERCERA BULGARIA V AFG GRUPO 4
Equipo PJ GF GC Puntos
1 Spartak Pleven Spartak 26 92 8 71
2 Etar Etar 26 68 20 62
3 Akademik Svishtov Akademik 26 56 19 54
4 Bdin Bdin 26 61 35 52
5 OFK Levski OFK Levski 26 43 24 47
6 Botev Lukovit Botev 26 46 53 37
7 Yantra Gabrovo Yantra 26 43 54 32
8 Pavlikeni Pavlikeni 26 40 54 30
9 Juventus Malchika Juventus 26 37 56 30
10 Kom Berkovitsa Berkovitsa 26 43 64 30
11 Partizan Partizan 26 39 62 29
12 Vidima-Rakovski Vidima-Rakov 26 23 57 24
13 Parva Atomna Parva Atomna 26 31 45 21
14 Sitomir Sitomir 26 12 83 4
TEMPORADA 2013/2014
TERCERA BULGARIA V AFG GRUPO 3
Equipo PJ GF GC Puntos
1 Lokomotiv Mezdra Lokomotiv 23 72 19 55
2 Etar Etar 23 50 13 53
3 Botev Lukovit Botev 23 45 23 53
4 Gorna Lokomotiv Oryahovitsa Gorna 23 80 23 52
5 Spartak Pleven Spartak 23 52 22 51
6 Partizan Partizan 23 34 35 40
7 Bdin Bdin 23 36 29 32
8 Vidima-Rakovski Vidima-Rakov 23 43 31 31
9 Parva Atomna Parva Atomna 23 35 34 29
10 Gigant Belene Gigant 22 20 39 21
11 Sitomir Sitomir 23 24 46 20
12 Yantra Gabrovo Yantra 22 14 53 18
13 OFK Levski OFK Levski 23 26 50 17
14 Pavlikeni Pavlikeni 23 22 69 16
15 Kom Berkovitsa Berkovitsa 23 28 48 15
16 Tryavna Tryavna 23 14 61 14
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
SEGUNDA BULGARIA B PFG GRUPO 1
Equipo PJ GF GC Puntos
1 Etar Etar 27 31 14 53
2 Botev Plovdiv Botev 27 40 17 51
3 Neftochimik Neftochimik 27 46 28 49
4 Lyubimets Lyubimets 27 42 22 48
5 Chernomorets Pomorie Chernomorets 27 38 29 37
6 OFC Sliven 2000 Sliven 2000 27 29 23 36
7 Spartak Varna Spartak 27 27 35 36
8 Dobrudzha Dobrich Dobrudzha 27 22 28 32
9 Nesebar Nesebar 27 24 44 26
10 Dorostol Dorostol 27 6 65 2
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
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

  USO DE MEMORIA  
6,582,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4312
Total Execution Time  0.4331
  CADENA URL  
/historico/Etar
  GET DATOS  
$_GET['/historico/Etar']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0214  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.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6321 AND type_rel = 2
0.0110  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6321 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0109  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 (708427,945189) ORDER BY n.cover_points DESC, update_date DESC
0.0114  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 = '6321' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = 72087 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 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.0129  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 = 6321 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0118  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.0124  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.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 `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.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 `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 = 57193 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.0107  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 = 62411 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.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 `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 = 49907 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.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 = 56790 AND t.round = 3 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 `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 = 43917 AND t.round = 26 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 `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 = 49313 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118  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 = 43225 AND t.round = 6 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 `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 = 38727 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124  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.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 `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 = 15845 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 `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 = 4372 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  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 = 3576 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0122  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.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 = 1737 AND t.round = 27 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 `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.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.0106  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 75897 ORDER BY nameShow LIMIT 100