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 1
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 30 78 15 75
2 CSKA Sofia CSKA Sofia 30 50 19 63
3 Cherno More Varna Cherno More 30 47 25 62
4 Lokomotiv Plovdiv Lokomotiv 30 50 34 55
5 Levski Sofia Levski Sofia 30 45 26 54
6 Levski Krumovgrad Levski 30 35 35 44
7 Botev Plovdiv Botev 30 47 33 44
8 CSKA 1948 Sofia CSKA 1948 S. 30 30 26 43
9 Arda Kardzhali Arda 30 32 32 39
10 Slavia Sofia Slavia Sofia 30 28 45 33
11 Beroe Beroe 30 24 42 33
12 Pirin Blagoevgrad Pirin 30 23 41 30
13 Hebar Pazardzhik Hebar 30 32 44 30
14 Lokomotiv Sofia Lokomotiv 30 22 56 28
15 Botev Vratsa Botev Vratsa 30 22 53 22
16 Etar Etar 30 17 56 14
TEMPORADA 2022/2023
LIGA BULGARIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 35 81 27 85
2 CSKA Sofia CSKA Sofia 35 65 17 84
3 CSKA 1948 Sofia CSKA 1948 S. 35 55 28 64
4 Levski Sofia Levski Sofia 35 47 22 61
5 Lokomotiv Plovdiv Lokomotiv 35 35 34 54
6 Cherno More Varna Cherno More 35 39 35 54
TEMPORADA 2021/2022
LIGA BULGARIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 31 77 25 79
2 CSKA Sofia CSKA Sofia 31 42 31 58
3 Botev Plovdiv Botev 31 38 33 53
4 Levski Sofia Levski Sofia 31 38 27 52
5 Cherno More Varna Cherno More 31 36 22 47
6 Slavia Sofia Slavia Sofia 31 35 38 37
TEMPORADA 2020/2021
LIGA BULGARIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 31 69 29 70
2 Lokomotiv Plovdiv Lokomotiv 31 48 23 61
3 CSKA Sofia CSKA Sofia 31 46 24 59
4 Arda Kardzhali Arda 31 42 37 50
5 CSKA 1948 Sofia CSKA 1948 S. 31 41 34 47
6 Beroe Beroe 31 42 38 39
TEMPORADA 2019/2020
LIGA BULGARIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 5 13 6 72
2 CSKA Sofia CSKA Sofia 5 11 5 59
3 Slavia Sofia Slavia Sofia 5 6 4 55
4 Levski Sofia Levski Sofia 5 7 11 53
5 Lokomotiv Plovdiv Lokomotiv 5 4 12 53
6 Beroe Beroe 5 6 9 49
TEMPORADA 2018/2019
LIGA BULGARIA GRUPO 3
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 10 14 5 79
2 CSKA Sofia CSKA Sofia 10 10 3 78
3 Levski Sofia Levski Sofia 10 13 13 66
4 Beroe Beroe 10 10 7 58
5 Cherno More Varna Cherno More 10 8 17 52
6 Botev Plovdiv Botev 10 5 15 50
TEMPORADA 2017/2018
LIGA BULGARIA GRUPO 3
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 10 28 9 88
2 CSKA Sofia CSKA Sofia 10 21 12 81
3 Levski Sofia Levski Sofia 10 18 13 64
4 Beroe Beroe 10 12 19 59
5 Botev Plovdiv Botev 10 18 20 56
6 Vereya Vereya 10 3 27 36
TEMPORADA 2016/2017
LIGA BULGARIA GRUPO 3
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 10 18 9 83
2 CSKA Sofia CSKA Sofia 10 16 5 67
3 Levski Sofia Levski Sofia 10 12 14 63
4 Dunav Ruse Dunav Ruse 10 14 13 55
5 Lokomotiv Plovdiv Lokomotiv 10 15 22 52
6 Cherno More Varna Cherno More 10 9 21 47
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 1
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 26 57 14 58
2 Litex Lovech Litex Lovech 26 59 26 57
3 CSKA Sofia CSKA Sofia 26 44 14 51
4 Botev Plovdiv Botev 26 45 21 46
5 Lokomotiv Plovdiv Lokomotiv 26 43 31 45
6 Levski Sofia Levski Sofia 26 45 24 44
7 Cherno More Varna Cherno More 26 31 21 43
8 Beroe Beroe 26 32 25 39
9 Slavia Sofia Slavia Sofia 26 35 38 31
10 Lokomotiv Sofia Lokomotiv 26 30 44 31
11 Chernomoretz Burgas Chernomoretz 26 30 46 22
12 Lyubimets Lyubimets 26 18 66 18
13 Pirin Gotse Delchev Pirin Gotse 26 23 71 15
14 Neftochimik Neftochimik 26 15 66 12

  USO DE MEMORIA  
6,135,760 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5986
Total Execution Time  0.5999
  CADENA URL  
/historico/Cska-Sofia
  GET DATOS  
$_GET['/historico/Cska-Sofia']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0129  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 = 'Cska-Sofia' 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.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=4068 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=4068 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0108  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=4068 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0109  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=4068 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  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=4068 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0109  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=4068 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0118  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 = 72087
0.0117  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.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4068 AND type_rel = 2
0.0109  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4068 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 (4645,15539,55420,73515,77796) ORDER BY n.cover_points DESC, update_date DESC
0.0126  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 = '4068' 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 = 73790 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0112  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 = 72100 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0124  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=4068 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (75896,73790,72100,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.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 75896 AND teamId = 4068
0.0116  SELECT count(id) as num_players from rel_players WHERE league_id = 72100 AND teamId = 4068
0.0115  SELECT count(id) as num_players from rel_players WHERE league_id = 73790 AND teamId = 4068
0.0258  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 4068
0.0110  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 = 75896 WHERE rp.league_id = 75896 AND rp.teamId = 4068 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.0110  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 = 75896 WHERE rp.league_id = 75896 AND rp.teamId = 4068 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0108  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 = 75896 WHERE rp.league_id = 75896 AND rp.teamId = 4068 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0119  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 = 4068 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75896 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.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 = 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.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 = 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.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 `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 = 71634 AND t.round = 5 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 `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.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 `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 = 67306 AND t.round = 5 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 = 62410 AND t.round = 5 ORDER BY team.conference ASC,t.position 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 `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 = 56789 AND t.round = 5 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 `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.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 `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 = 49314 AND t.round = 10 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 `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.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 `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 = 43226 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0121  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 = 33678 AND t.round = 26 ORDER BY team.conference 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 `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 = 38257 AND t.round = 10 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 `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.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 `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.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 `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.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 `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