4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Al-Batin

Al-Batin

Entrenador: Quim Machado

Temporada 2019/2020
TEMPORADA 2019/2020
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Batin Al-Batin 38 52 28 76
2 Al Qadsiah FC Qadsiah 38 71 38 75
3 Al-Ain FC Al-Ain FC 38 57 29 72
4 Al Bukayriyah Bukayriyah 38 65 41 64
5 Al-Nahdha Al-Nahdha 38 55 47 60
6 Al-Jabalain FC Al-Jabalain 38 56 39 57
7 Ohod Ohod 38 51 42 57
8 Jeddah Club Jeddah Club 38 49 49 54
9 Al-Thqba Al-Thqba 38 61 46 53
10 Al-Tai SC Al-Tai SC 38 40 38 48
11 Najran Najran 38 49 51 48
12 Al-Shoalah FC Al-Shoalah 38 43 44 47
13 Al Jeel Al Jeel 38 38 52 46
14 Al-Kawkab Al-Kawkab 38 39 47 45
15 Al-Khaleej Al-Khaleej 38 45 50 44
16 Al Najoom Al Najoom 38 44 62 41
17 Al Mojzel Al Mojzel 38 37 64 39
18 Al-Taqadom Al-Taqadom 38 42 66 38
19 Al-Ansar FC Al-Ansar FC 38 34 62 35
20 Hottain Hottain 38 47 80 31
TEMPORADA 2018/2019
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Nassr Al-Nassr 30 69 27 70
2 Al-Hilal SFC Al-Hilal 30 66 33 69
3 Al-Taawoun Al-Taawoun 30 61 31 56
4 Al-Ahli SFC Al-Ahli SFC 30 68 41 55
5 Al-Shabab Al-Shabab 30 39 25 54
6 Al-Faisaly FC Al-Faisaly 30 51 47 43
7 Al-Wehda Al-Wehda 30 41 41 42
8 Al-Raed Al-Raed 30 38 48 38
9 Al-Fateh SC Al-Fateh SC 30 32 45 35
10 Al-Ittihad Al-Ittihad 30 44 45 34
11 Al-Ettifaq Al-Ettifaq 30 40 55 33
12 Al-Fayha Al-Fayha 30 36 52 32
13 Al-Hazem SC Al-Hazem SC 30 33 50 31
14 Al Qadsiah FC Qadsiah 30 34 51 28
15 Al-Batin Al-Batin 30 29 53 25
16 Ohod Ohod 30 25 62 21
TEMPORADA 2017/2018
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Hilal SFC Al-Hilal 26 47 23 56
2 Al-Ahli SFC Al-Ahli SFC 26 59 26 55
3 Al-Nassr Al-Nassr 26 47 34 44
4 Al-Ettifaq Al-Ettifaq 26 37 46 36
5 Al-Fateh SC Al-Fateh SC 26 34 39 36
6 Al-Faisaly FC Al-Faisaly 26 39 33 35
7 Al-Taawoun Al-Taawoun 26 43 36 34
8 Al-Fayha Al-Fayha 26 36 40 34
9 Al-Ittihad Al-Ittihad 26 34 41 33
10 Al-Shabab Al-Shabab 26 36 36 31
11 Al-Batin Al-Batin 26 35 46 31
12 Al Qadsiah FC Qadsiah 26 28 41 25
13 Al-Raed Al-Raed 26 43 53 24
14 Ohod Ohod 26 24 48 18
TEMPORADA 2016/2017
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Hilal SFC Al-Hilal 26 63 16 66
2 Al-Ahli SFC Al-Ahli SFC 26 57 30 55
3 Al-Nassr Al-Nassr 26 44 25 52
4 Al-Ittihad Al-Ittihad 26 57 37 52
5 Al-Raed Al-Raed 26 37 47 35
6 Al-Shabab Al-Shabab 26 28 32 33
7 Al-Taawoun Al-Taawoun 26 33 40 31
8 Al-Fateh SC Al-Fateh SC 26 33 39 29
9 Al-Faisaly FC Al-Faisaly 26 30 41 28
10 Al Qadsiah FC Qadsiah 26 38 38 28
11 Al-Ettifaq Al-Ettifaq 26 31 45 27
12 Al-Batin Al-Batin 26 31 43 26
13 Al-Khaleej Al-Khaleej 26 32 51 23
14 Al-Wehda Al-Wehda 26 35 65 17
TEMPORADA 2015/2016
PRIMERA ARABIA SAUDÍ GRUPO 2
Equipo PJ GF GC Puntos
1 Al-Raed Al-Raed 2 5 3 3
2 Al-Batin Al-Batin 2 3 5 3
TEMPORADA 2014/2015
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al Qadsiah FC Qadsiah 30 49 21 63
2 Al-Wehda Al-Wehda 30 60 27 62
3 Al-Nahdha Al-Nahdha 30 50 31 61
4 Al-Ettifaq Al-Ettifaq 30 50 32 52
5 Al-Tai SC Al-Tai SC 30 47 42 49
6 Al Jeel Al Jeel 30 42 40 42
7 Al Watani Al Watani 30 35 31 40
8 Al-Riyadh SC Al-Riyadh 30 41 44 40
9 Al-Hazem SC Al-Hazem SC 30 42 42 39
10 Al-Batin Al-Batin 30 37 34 36
11 Al-Fayha Al-Fayha 30 30 42 34
12 Al Mojzel Al Mojzel 30 35 43 32
13 Al-Diriyah Al-Diriyah 30 29 54 30
14 Al-Safa Al-Safa 30 29 46 29
15 Abha Abha 30 36 56 25
16 Hottain Hottain 30 25 52 20
TEMPORADA 2013/2014
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Hajer FC Hajer FC 30 45 28 57
2 Al-Khaleej Al-Khaleej 30 57 27 55
3 Al-Wehda Al-Wehda 30 48 28 52
4 Al-Tai SC Al-Tai SC 30 35 29 46
5 Al-Riyadh SC Al-Riyadh 30 52 44 45
6 Al Qadsiah FC Qadsiah 30 31 23 45
7 Al-Hazem SC Al-Hazem SC 30 37 35 44
8 Al-Diriyah Al-Diriyah 30 42 43 41
9 Al-Batin Al-Batin 30 39 38 40
10 Abha Abha 30 41 40 39
11 Al Jeel Al Jeel 30 37 42 38
12 Al Watani Al Watani 30 36 41 35
13 Hottain Hottain 30 35 56 30
14 Ohod Ohod 30 35 51 28
15 Al-Ansar FC Al-Ansar FC 30 27 50 27
16 Al-Kawkab Al-Kawkab 30 39 61 24
TEMPORADA 2012/2013
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Orubah FC Al-Orubah 30 51 30 59
2 Al-Nahdha Al-Nahdha 30 50 32 55
3 Al-Khaleej Al-Khaleej 30 49 37 55
4 Al-Riyadh SC Al-Riyadh 30 40 30 55
5 Al Qadsiah FC Qadsiah 30 43 32 45
6 Hottain Hottain 30 52 44 43
7 Al-Tai SC Al-Tai SC 30 42 40 42
8 Abha Abha 30 40 45 41
9 Al-Ansar FC Al-Ansar FC 30 33 37 38
10 Al-Batin Al-Batin 30 42 41 36
11 Al Watani Al Watani 30 34 44 36
12 Al-Hazem SC Al-Hazem SC 30 30 38 35
13 Al Jeel Al Jeel 30 36 42 34
14 Sdoos Club Sdoos Club 30 37 43 30
15 Al-Najma FC Al-Najma FC 30 28 47 29
16 Jeddah Club Jeddah Club 30 28 53 25
TEMPORADA 2011/2012
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Shoalah FC Al-Shoalah 30 48 34 55
2 Al-Wehda Al-Wehda 30 59 37 54
3 Al-Nahdha Al-Nahdha 30 39 24 52
4 Abha Abha 30 36 28 49
5 Al-Hazem SC Al-Hazem SC 30 39 28 48
6 Al-Tai SC Al-Tai SC 30 42 26 47
7 Al Jeel Al Jeel 30 32 28 47
8 Al-Khaleej Al-Khaleej 30 41 41 43
9 Hottain Hottain 30 53 52 38
10 Al-Orubah FC Al-Orubah 30 24 38 37
11 Al Watani Al Watani 30 31 45 36
12 Al-Riyadh SC Al-Riyadh 30 27 23 34
13 Al-Batin Al-Batin 30 39 50 34
14 Ohod Ohod 30 30 42 28
15 Damac FC Damac FC 30 33 51 26
16 Al Suqoor Al Suqoor 30 28 54 23
TEMPORADA 2010/2011
SEGUNDA ARABIA SAUDÍ GRUPO 2
Equipo PJ GF GC Puntos
1 Al-Batin Al-Batin 18 34 12 41
2 Al Suqoor Al Suqoor 18 40 21 40
3 Al-Jabalain FC Al-Jabalain 18 32 12 33
4 Al-Oyoon Al-Oyoon 18 26 23 30
5 Al Hamadah Al Hamadah 18 30 24 26
6 Al Ramh Al Ramh 18 31 25 22
7 Al-Diriyah Al-Diriyah 18 26 27 22
8 Najd Najd 18 23 27 21
9 Al-Qalah Al-Qalah 18 10 38 6
10 Al Zaytoon Al Zaytoon 18 14 57 6
TEMPORADA 2009/2010
SEGUNDA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Najma FC Al-Najma FC 26 53 22 55
2 Al Jeel Al Jeel 26 44 28 49
3 Jeddah Club Jeddah Club 26 42 31 44
4 Al-Nahdha Al-Nahdha 26 37 27 43
5 Al-Orubah FC Al-Orubah 26 37 37 43
6 Al-Jabalain FC Al-Jabalain 26 37 29 41
7 Sdoos Club Sdoos Club 26 35 33 41
8 Al-Batin Al-Batin 26 36 39 34
9 Al-Arabi SC Al-Arabi SC 26 33 39 30
10 Al Hamadah Al Hamadah 26 30 33 29
11 Al-Fayha Al-Fayha 26 31 42 29
12 Najd Najd 26 23 46 28
13 Al-Okhdood Al-Okhdood 26 29 33 27
14 Al-Diriyah Al-Diriyah 26 18 46 12
TEMPORADA 2008/2009
SEGUNDA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Shoalah FC Al-Shoalah 26 58 32 51
2 Al-Adalah Club Al-Adalah 26 51 30 50
3 Al Hamadah Al Hamadah 26 47 37 47
4 Al-Nahdha Al-Nahdha 26 31 24 43
5 Al-Jabalain FC Al-Jabalain 26 35 28 39
6 Al-Najma FC Al-Najma FC 26 29 42 35
7 Al-Batin Al-Batin 25 36 33 33
8 Al-Okhdood Al-Okhdood 26 37 43 31
9 Jeddah Club Jeddah Club 26 39 43 29
10 Al Jeel Al Jeel 25 26 33 28
11 Al-Qaisumah FC Al-Qaisumah 26 21 26 26
12 Al-Fayha Al-Fayha 26 29 41 26
13 Al Mojzel Al Mojzel 26 29 42 24
14 Al-Diriyah Al-Diriyah 26 33 47 23

  USO DE MEMORIA  
6,329,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1339
Total Execution Time  0.1352
  CADENA URL  
/historico/Al-Baten/2020
  GET DATOS  
$_GET['/historico/Al-Baten/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0032  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 = 'Al-Baten' AND l.year = 2020 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.0019  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=17261 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=17261 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=17261 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  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 = 51562
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17261 AND type_rel = 2
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 17261 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0025  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 (359037,359919,360163,362405,1234398) ORDER BY n.cover_points DESC, update_date DESC
0.0038  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 = '17261' ORDER BY l.year DESC,cat.coefficient DESC
0.0031  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 = '17261' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0034  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 = '17261' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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 = 51562 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 50042 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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=17261 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (60211,59048,50042,43475) 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.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 59048 AND teamId = 17261
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 50042 AND teamId = 17261
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 60211 AND teamId = 17261
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 17261
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 50042 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '17261' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17261' and rp.type = 4
0.0021  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 = '17261' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0030  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 events2020 e ON e.player_id = p.id AND e.league_id = 50042 WHERE rp.league_id = 50042 AND rp.teamId = 17261 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.0025  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 events2020 e ON e.player_id = p.id AND e.league_id = 50042 WHERE rp.league_id = 50042 AND rp.teamId = 17261 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 events2020 e ON e.player_id = p.id AND e.league_id = 50042 WHERE rp.league_id = 50042 AND rp.teamId = 17261 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 17261 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  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 = 43671 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 38735 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 33397 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 15470 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 28698 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 3878 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 3553 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 8881 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 8880 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 27932 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 27939 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 27942 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 50042 ORDER BY nameShow LIMIT 100