4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Qalali
TEMPORADA 2023/2024
SEGUNDA BAHRÉIN
Equipo PJ GF GC Puntos
1 Bahrain SC Bahrain SC 21 48 20 46
2 A'Ali A'Ali 21 45 16 43
3 Al Ittihad Bahrain Ittihad 22 39 25 43
4 Malkiya Malkiya 21 36 8 42
5 Budaiya Budaiya 22 32 12 41
6 Al Ittifaq Maqaba Ittifaq 22 41 28 32
7 Isa Town Isa Town 21 25 30 27
8 Buri Buri 22 19 27 24
9 Umm Al Hassam Hassam 21 22 35 18
10 Qalali Qalali 22 15 39 18
11 Etehad Al Reef Etehad Reef 21 19 54 17
12 Al Tadamun Buri Tadamun Buri 22 8 55 3
TEMPORADA 2022/2023
SEGUNDA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al Najma Manama Najma Manama 21 54 17 52
2 Busaiteen Busaiteen 21 40 23 38
3 A'Ali A'Ali 21 32 20 36
4 Alhassam Alhassam 21 28 28 31
5 Qalali Qalali 21 33 24 29
6 Al Ittifaq Maqaba Ittifaq 21 27 27 29
7 Buri Buri 21 29 31 28
8 Malkiya Malkiya 21 27 27 27
9 Isa Town Isa Town 21 31 34 26
10 Al Ittihad Bahrain Ittihad 21 23 28 26
11 Al Reef Al Reef 21 18 50 13
12 Al Tadamun Buri Tadamun Buri 21 14 47 7
TEMPORADA 2021/2022
SEGUNDA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al-Shabab Manama Al-Shabab 18 43 13 42
2 Bahrain SC Bahrain SC 18 35 19 38
3 Sitra Sitra 18 28 20 29
4 Malkiya Malkiya 18 27 23 27
5 Al Ittifaq Maqaba Ittifaq 18 29 25 26
6 Al Ittihad Bahrain Ittihad 18 31 32 22
7 Isa Town Isa Town 18 21 31 21
8 Busaiteen Busaiteen 18 23 34 20
9 Qalali Qalali 18 19 25 15
10 Al Tadamun Buri Tadamun Buri 18 20 54 9
TEMPORADA 2020/2021
SEGUNDA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al-Hala Al-Hala 18 43 18 41
2 Khalidiya Khalidiya 18 30 12 38
3 Al Ittifaq Maqaba Ittifaq 18 26 12 33
4 Isa Town Isa Town 18 36 22 32
5 Sitra Sitra 19 27 21 31
6 Al-Shabab Manama Al-Shabab 18 18 19 23
7 Bahrain SC Bahrain SC 18 21 20 21
8 Al Ittihad Bahrain Ittihad 19 29 39 21
9 Qalali Qalali 18 17 41 11
10 Al Tadamun Buri Tadamun Buri 18 15 58 5
TEMPORADA 2019/2020
SEGUNDA BAHRÉIN
Equipo PJ GF GC Puntos
1 Malkiya Malkiya 16 31 9 41
2 Bahrain SC Bahrain SC 16 37 16 34
3 Budaiya Budaiya 16 26 8 31
4 Isa Town Isa Town 16 32 15 26
5 Sitra Sitra 16 33 19 26
6 Qalali Qalali 16 27 21 24
7 Al Ittihad Bahrain Ittihad 16 20 37 13
8 Al Ittifaq Maqaba Ittifaq 16 14 41 11
9 Al Tadamun Buri Tadamun Buri 16 6 60 0
TEMPORADA 2018/2019
SEGUNDA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al Ahli Manama Ahli Manama 12 40 6 32
2 Sitra Sitra 11 22 15 25
3 Busaiteen Busaiteen 11 21 11 23
4 Isa Town Isa Town 12 17 13 22
5 Al Ittihad Bahrain Ittihad 12 20 9 18
6 Bahrain SC Bahrain SC 11 13 15 12
7 Al Tadamun Buri Tadamun Buri 12 14 30 7
8 Qalali Qalali 11 8 29 6
9 Al Ittifaq Maqaba Ittifaq 12 5 32 1
TEMPORADA 2017/2018
SEGUNDA BAHRÉIN
Equipo PJ GF GC Puntos
1 Budaiya Budaiya 16 36 10 43
2 Al-Hala Al-Hala 16 41 14 40
3 Busaiteen Busaiteen 16 38 13 36
4 Isa Town Isa Town 16 29 19 28
5 Bahrain SC Bahrain SC 16 21 22 18
6 Sitra Sitra 16 33 36 17
7 Qalali Qalali 16 15 29 11
8 Al Tadamun Buri Tadamun Buri 16 15 32 11
9 Al Ittifaq Maqaba Ittifaq 16 11 64 1
TEMPORADA 2016/2017
SEGUNDA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al-Shabab Manama Al-Shabab 16 41 14 42
2 Al Ittihad Al Ittihad 16 27 11 33
3 Budaiya Budaiya 16 37 19 25
4 Busaiteen Busaiteen 16 28 27 20
5 Isa Town Isa Town 16 22 36 18
6 Sitra Sitra 16 29 29 17
7 Al Ittifaq Maqaba Ittifaq 16 30 33 17
8 Al Tadamun Buri Tadamun Buri 16 12 32 13
9 Qalali Qalali 16 20 45 12
TEMPORADA 2015/2016
SEGUNDA BAHRÉIN
Equipo PJ GF GC Puntos
1 Bahrain SC Bahrain SC 16 26 14 34
2 Al Najma Manama Najma Manama 16 35 14 33
3 Al Ittihad Al Ittihad 16 27 13 33
4 Al-Shabab Manama Al-Shabab 16 36 13 31
5 Budaiya Budaiya 16 24 22 26
6 Isa Town Isa Town 16 17 20 20
7 Al Tadamun Buri Tadamun Buri 16 11 37 10
8 Al Ittifaq Maqaba Ittifaq 16 15 38 8
9 Qalali Qalali 16 18 38 7
TEMPORADA 2014/2015
SEGUNDA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al Ahli Manama Ahli Manama 16 37 12 38
2 Sitra Sitra 16 43 16 35
3 Al Najma Manama Najma Manama 16 31 14 30
4 Budaiya Budaiya 16 31 23 29
5 Al Ittihad Al Ittihad 16 35 19 24
6 Isa Town Isa Town 16 33 30 21
7 Al Tadamun Buri Tadamun Buri 16 23 42 13
8 Qalali Qalali 16 17 54 9
9 Al Ittifaq Maqaba Ittifaq 16 13 53 1
TEMPORADA 2013/2014
SEGUNDA BAHRÉIN
Equipo PJ GF GC Puntos
1 East Riffa East Riffa 16 46 3 44
2 Bahrain SC Bahrain SC 16 39 8 41
3 Al Ahli Manama Ahli Manama 16 50 24 33
4 Al Ittihad Bahrain Ittihad 16 26 20 29
5 Budaiya Budaiya 16 24 36 16
6 Isa Town Isa Town 16 24 40 14
7 Qalali Qalali 16 18 40 14
8 Al Ittifaq Maqaba Ittifaq 16 21 39 11
9 Al Tadamun Buri Tadamun Buri 16 19 57 5
TEMPORADA 2008/2009
LIGA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al-Muharraq Al-Muharraq 18 50 9 45
2 Al-Riffa Al-Riffa 18 51 11 44
3 Al Ahli Manama Ahli Manama 18 35 10 42
4 East Riffa East Riffa 18 38 22 40
5 Busaiteen Busaiteen 18 38 22 32
6 Al Najma Manama Najma Manama 18 29 19 31
7 Manama Manama 18 38 27 30
8 Al-Shabab Manama Al-Shabab 18 37 31 30
9 Malkiya Malkiya 18 23 18 29
10 Al-Hala Al-Hala 18 29 20 28
11 Al-Hadd Al-Hadd 18 35 32 28
12 Sitra Sitra 18 22 25 25
13 Bahrain SC Bahrain SC 18 26 21 22
14 Budaiya Budaiya 18 15 26 18
15 Qalali Qalali 18 19 40 12
16 Al Ittihad Bahrain Ittihad 18 16 41 10
17 Al Ittifaq Maqaba Ittifaq 18 12 43 8
18 Isa Town Isa Town 18 11 54 5
19 Al Tadamun Buri Tadamun Buri 18 10 63 2

  USO DE MEMORIA  
5,867,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.5712
Total Execution Time  0.5726
  CADENA URL  
/historico/Qalali
  GET DATOS  
$_GET['/historico/Qalali']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0118  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 = 'Qalali' 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.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=57521 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=57521 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=57521 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=57521 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0215  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 = 74151
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 = 74277
0.0124  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 = 74466
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=57521 AND type_rel = 2
0.0112  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1428 AND type_rel = 3
0.0139  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 = '57521' ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '57521' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0133  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 = '57521' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0116  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 = 74151 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0118  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 = 74277 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0118  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 = 74466 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  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=57521 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0107  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 (74466,74277,74151) 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.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 74151 AND teamId = 57521
0.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 74466 AND teamId = 57521
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 74277 AND teamId = 57521
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 = 74151 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0110  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 = '57521' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '57521' and rp.type = 4
0.0107  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 = '57521' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 74151 WHERE rp.league_id = 74151 AND rp.teamId = 57521 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.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 = 74151 WHERE rp.league_id = 74151 AND rp.teamId = 57521 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 = 74151 WHERE rp.league_id = 74151 AND rp.teamId = 57521 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0113  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 = 57521 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 = 74151 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 = 69253 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.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 = 64136 AND t.round = 18 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 = 60332 AND t.round = 18 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 = 51240 AND t.round = 18 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 `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 = 45913 AND t.round = 13 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 `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 = 40386 AND t.round = 18 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 `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 = 37151 AND t.round = 18 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 `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 = 15777 AND t.round = 18 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 `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 = 8465 AND t.round = 18 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 `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 = 8955 AND t.round = 18 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 `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 = 8939 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 74151 ORDER BY nameShow LIMIT 100