4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA BAHRÉIN
Equipo PJ GF GC Puntos
1 Khalidiya Khalidiya 17 36 14 36
2 Al-Riffa Al-Riffa 18 29 20 33
3 Al-Muharraq Al-Muharraq 18 33 24 31
4 Al Ahli Manama Ahli Manama 17 23 23 26
5 Manama Manama 17 20 20 23
6 Al Najma Manama Najma Manama 17 32 32 20
7 Al-Shabab Manama Al-Shabab 18 22 28 20
8 Sitra Sitra 18 23 28 20
9 East Riffa East Riffa 18 21 26 20
10 Al-Hala Al-Hala 18 16 29 19
11 Busaiteen Busaiteen 17 19 24 18
12 Al-Hidd Al-Hidd 17 22 28 17
TEMPORADA 2022/2023
LIGA BAHRÉIN
Equipo PJ GF GC Puntos
1 Khalidiya Khalidiya 22 45 23 42
2 Manama Manama 22 35 16 41
3 Al-Muharraq Al-Muharraq 22 34 12 40
4 Al-Riffa Al-Riffa 22 37 19 39
5 Sitra Sitra 22 30 20 38
6 Al Ahli Manama Ahli Manama 22 24 23 31
7 Al-Hidd Al-Hidd 22 29 38 27
8 Al-Shabab Manama Al-Shabab 22 21 25 27
9 East Riffa East Riffa 22 24 26 24
10 Al-Hala Al-Hala 22 22 34 21
11 Bahrain SC Bahrain SC 22 22 32 19
12 Budaiya Budaiya 22 10 65 5
TEMPORADA 2021/2022
LIGA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al-Riffa Al-Riffa 18 32 9 42
2 Manama Manama 18 31 13 39
3 Khalidiya Khalidiya 18 24 13 30
4 Al-Muharraq Al-Muharraq 18 23 18 30
5 Al-Hala Al-Hala 18 21 24 25
6 East Riffa East Riffa 18 24 22 24
7 Al Ahli Manama Ahli Manama 18 18 29 17
8 Budaiya Budaiya 18 18 30 14
9 Al-Hidd Al-Hidd 18 13 27 13
10 Al Najma Manama Najma Manama 18 12 31 8
TEMPORADA 2020/2021
LIGA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al-Riffa Al-Riffa 18 31 13 45
2 East Riffa East Riffa 18 32 20 35
3 Manama Manama 18 26 18 31
4 Al-Muharraq Al-Muharraq 18 24 15 27
5 Al-Hadd Al-Hadd 18 26 23 27
6 Al Ahli Manama Ahli Manama 18 17 25 21
7 Budaiya Budaiya 18 11 19 17
8 Al Najma Manama Najma Manama 18 17 31 15
9 Malkiya Malkiya 18 11 26 13
10 Busaiteen Busaiteen 18 17 22 12
TEMPORADA 2019/2020
LIGA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al-Hadd Al-Hadd 18 29 16 41
2 Al-Muharraq Al-Muharraq 18 32 16 40
3 Al-Riffa Al-Riffa 17 50 24 37
4 Al Najma Manama Najma Manama 17 25 22 26
5 East Riffa East Riffa 17 19 20 25
6 Manama Manama 18 18 22 20
7 Al Ahli Manama Ahli Manama 18 19 22 17
8 Busaiteen Busaiteen 18 17 30 16
9 Al-Shabab Manama Al-Shabab 18 15 37 14
10 Al-Hala Al-Hala 17 14 29 10
TEMPORADA 2018/2019
LIGA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al-Riffa Al-Riffa 16 33 13 34
2 Manama Manama 17 31 23 31
3 Al-Muharraq Al-Muharraq 16 33 18 30
4 Al Najma Manama Najma Manama 17 26 20 28
5 Al-Hadd Al-Hadd 17 26 22 25
6 East Riffa East Riffa 17 19 18 22
7 Al-Shabab Manama Al-Shabab 17 22 30 19
8 Al-Hala Al-Hala 17 18 29 18
9 Budaiya Budaiya 17 17 35 15
10 Malkiya Malkiya 17 15 32 13
TEMPORADA 2017/2018
LIGA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al-Muharraq Al-Muharraq 18 31 7 45
2 Al Najma Manama Najma Manama 18 34 26 30
3 Manama Manama 18 33 20 29
4 Malkiya Malkiya 18 36 30 28
5 Al-Shabab Manama Al-Shabab 18 19 20 24
6 Al-Hadd Al-Hadd 18 22 30 21
7 Al-Riffa Al-Riffa 18 22 31 19
8 East Riffa East Riffa 18 24 32 17
9 Al Ahli Manama Ahli Manama 18 21 34 16
10 Al Ittihad Al Ittihad 18 22 34 14
TEMPORADA 2016/2017
LIGA BAHRÉIN
Equipo PJ GF GC Puntos
1 Malkiya Malkiya 18 24 16 33
2 Al-Riffa Al-Riffa 18 32 16 31
3 Al-Hadd Al-Hadd 18 27 23 31
4 Manama Manama 18 29 19 30
5 Al-Muharraq Al-Muharraq 18 30 23 29
6 East Riffa East Riffa 18 23 25 22
7 Al Ahli Manama Ahli Manama 18 16 24 20
8 Al Najma Manama Najma Manama 18 20 32 17
9 Bahrain SC Bahrain SC 18 18 27 16
10 Al-Hala Al-Hala 18 11 25 14
TEMPORADA 2015/2016
LIGA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al-Hadd Al-Hadd 18 39 15 42
2 Al-Muharraq Al-Muharraq 18 31 21 32
3 Malkiya Malkiya 18 23 20 27
4 Al-Riffa Al-Riffa 18 22 26 23
5 East Riffa East Riffa 18 22 18 22
6 Al Ahli Manama Ahli Manama 18 22 21 22
7 Manama Manama 18 17 27 21
8 Al-Hala Al-Hala 18 22 31 20
9 Busaiteen Busaiteen 18 17 31 20
10 Sitra Sitra 18 20 25 18
TEMPORADA 2014/2015
LIGA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al-Muharraq Al-Muharraq 18 41 18 40
2 Al-Hadd Al-Hadd 18 30 15 39
3 Manama Manama 18 31 20 33
4 East Riffa East Riffa 18 30 24 33
5 Al-Riffa Al-Riffa 18 26 17 31
6 Busaiteen Busaiteen 18 17 31 19
7 Al-Hala Al-Hala 18 22 39 19
8 Malkiya Malkiya 18 17 29 18
9 Bahrain SC Bahrain SC 18 22 29 13
10 Al-Shabab Manama Al-Shabab 18 12 26 8
TEMPORADA 2013/2014
LIGA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al-Riffa Al-Riffa 18 24 12 38
2 Manama Manama 18 33 16 37
3 Al-Hadd Al-Hadd 18 32 16 34
4 Al-Muharraq Al-Muharraq 18 26 14 34
5 Busaiteen Busaiteen 18 27 26 22
6 Al-Hala Al-Hala 18 21 20 20
7 Malkiya Malkiya 18 18 24 20
8 Al-Shabab Manama Al-Shabab 18 18 26 17
9 Al Najma Manama Najma Manama 18 15 29 13
10 Sitra Sitra 18 14 45 6
TEMPORADA 2012/2013
LIGA BAHRÉIN
Equipo PJ GF GC Puntos
1 Busaiteen Busaiteen 18 44 12 44
2 Al-Muharraq Al-Muharraq 18 48 17 42
3 Al-Hadd Al-Hadd 18 38 19 37
4 Al-Riffa Al-Riffa 18 25 25 28
5 Manama Manama 18 36 31 23
6 Al Najma Manama Najma Manama 18 18 30 22
7 Al-Hala Al-Hala 18 26 33 16
8 Al-Shabab Manama Al-Shabab 18 22 38 13
9 Malkiya Malkiya 18 18 35 13
10 Bahrain SC Bahrain SC 18 24 59 11
TEMPORADA 2011/2012
LIGA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al-Riffa Al-Riffa 18 34 16 45
2 Al-Muharraq Al-Muharraq 18 41 13 38
3 Busaiteen Busaiteen 18 34 28 34
4 Al-Hadd Al-Hadd 18 23 26 22
5 Al-Hala Al-Hala 18 29 33 21
6 Bahrain SC Bahrain SC 18 25 29 21
7 Al Najma Manama Najma Manama 18 24 26 20
8 Manama Manama 18 20 29 20
9 Al Ahli Manama Ahli Manama 18 15 28 18
10 East Riffa East Riffa 18 19 36 15
TEMPORADA 2010/2011
LIGA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al-Riffa Al-Riffa 11 25 12 23
2 Al-Muharraq Al-Muharraq 11 18 12 21
3 Al Ahli Manama Ahli Manama 11 23 15 20
4 Al-Hadd Al-Hadd 13 24 23 20
5 Manama Manama 12 20 21 15
6 Busaiteen Busaiteen 12 16 21 12
7 Al-Hala Al-Hala 12 11 25 8
8 Al Najma Manama Najma Manama 12 12 20 7
9 Al-Shabab Manama Al-Shabab 0 0 0 0
10 Malkiya Malkiya 0 0 0 0
TEMPORADA 2009/2010
LIGA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al Ahli Manama Ahli Manama 18 26 17 41
2 Al-Muharraq Al-Muharraq 18 38 20 40
3 Al-Riffa Al-Riffa 18 36 18 38
4 Al Najma Manama Najma Manama 18 27 18 32
5 Busaiteen Busaiteen 18 29 23 23
6 Manama Manama 18 23 33 18
7 Al-Shabab Manama Al-Shabab 18 18 35 17
8 Al-Hala Al-Hala 18 27 30 16
9 Malkiya Malkiya 18 18 31 16
10 East Riffa East Riffa 18 21 38 13
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
TEMPORADA 2007/2008
LIGA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al-Muharraq Al-Muharraq 22 66 14 52
2 Busaiteen Busaiteen 22 45 23 42
3 Al Ahli Manama Ahli Manama 22 36 28 42
4 Al-Riffa Al-Riffa 22 40 22 40
5 East Riffa East Riffa 22 28 36 30
6 Al Najma Manama Najma Manama 22 33 26 28
7 Manama Manama 22 27 36 28
8 Al Ittihad Bahrain Ittihad 22 26 39 24
9 Al-Hala Al-Hala 22 28 50 22
10 Al-Shabab Manama Al-Shabab 22 30 44 21
11 Al-Hadd Al-Hadd 22 20 39 20
12 Bahrain SC Bahrain SC 22 19 41 19
TEMPORADA 2006/2007
LIGA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al-Muharraq Al-Muharraq 22 56 17 53
2 Al-Riffa Al-Riffa 22 34 16 41
3 Al Najma Manama Najma Manama 22 32 23 38
4 Busaiteen Busaiteen 22 35 27 33
5 Bahrain SC Bahrain SC 22 27 32 29
6 Al-Hala Al-Hala 22 42 44 28
7 Al-Shabab Manama Al-Shabab 22 30 29 27
8 Al Ahli Manama Ahli Manama 22 30 31 27
9 East Riffa East Riffa 22 27 32 27
10 Malkiya Malkiya 22 22 30 22
11 Manama Manama 22 23 38 22
12 Sitra Sitra 22 16 55 12
TEMPORADA 2005/2006
LIGA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al-Muharraq Al-Muharraq 18 29 17 38
2 Al Ahli Manama Ahli Manama 18 47 20 37
3 Al-Riffa Al-Riffa 18 36 17 33
4 Al Najma Manama Najma Manama 18 29 28 25
5 Sitra Sitra 18 25 33 22
6 Malkiya Malkiya 18 27 23 20
7 East Riffa East Riffa 18 29 36 20
8 Busaiteen Busaiteen 18 19 29 20
9 Al-Shabab Manama Al-Shabab 18 21 39 18
10 Bahrain SC Bahrain SC 18 16 36 13
TEMPORADA 2004/2005
LIGA BAHRÉIN
Equipo PJ GF GC Puntos
1 Al-Riffa Al-Riffa 18 40 18 40
2 Al-Muharraq Al-Muharraq 18 36 18 36
3 Al Ahli Manama Ahli Manama 18 30 26 33
4 Al-Shabab Manama Al-Shabab 18 33 28 32
5 Al Najma Manama Najma Manama 18 33 18 31
6 Busaiteen Busaiteen 18 25 28 23
7 Bahrain SC Bahrain SC 18 21 30 18
8 East Riffa East Riffa 18 26 33 17
9 Manama Manama 18 22 41 15
10 Al-Hala Al-Hala 18 16 42 8

  USO DE MEMORIA  
6,840,096 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7665
Total Execution Time  0.7677
  CADENA URL  
/historico/Muharraq
  GET DATOS  
$_GET['/historico/Muharraq']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0295  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 = 73656
0.0159  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 = 75196
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15456 AND type_rel = 2
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=431 AND type_rel = 3
0.0154  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 431 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0150  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 (1091300,1091289,1090156,1015512,810293) ORDER BY n.cover_points DESC, update_date DESC
0.0164  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 = '15456' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = 73656 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152  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=15456 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (75196,74466,73656,71471) 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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 73656 AND teamId = 15456
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 71471 AND teamId = 15456
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 74466 AND teamId = 15456
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 75196 AND teamId = 15456
0.0151  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 = 73656 AND t.round = 18 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0149  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 = '15456' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '15456' and rp.type = 4
0.0146  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 = '15456' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0152  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 = 73656 WHERE rp.league_id = 73656 AND rp.teamId = 15456 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.0146  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 = 73656 WHERE rp.league_id = 73656 AND rp.teamId = 15456 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 73656 WHERE rp.league_id = 73656 AND rp.teamId = 15456 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157  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 = 15456 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0152  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 = 73656 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.0161  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 = 69339 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.0159  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 = 64023 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.0161  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 = 60287 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.0162  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 = 51286 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.0154  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 = 45331 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 40385 AND t.round = 18 ORDER BY team.conference 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 `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 = 37150 AND t.round = 18 ORDER BY team.conference 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 `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 = 15754 AND t.round = 18 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 `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 = 4835 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 3637 AND t.round = 18 ORDER BY team.conference 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 `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 = 3022 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 8945 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 8943 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 8941 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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.0164  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 `tables2008` 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 = 8937 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables2007` 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 = 8935 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 8934 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 `tables2005` 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 = 8930 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC