4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Bayelsa United
TEMPORADA 2023/2024
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Enugu Rangers Enugu 32 46 31 57
2 Enyimba Enyimba 32 38 26 55
3 Remo Stars Remo Stars 31 38 27 53
4 Shooting Stars Shooting 32 39 29 52
5 Lobi Stars Lobi Stars 32 36 31 52
6 Plateau United Plateau 32 46 33 50
7 Katsina United Katsina 32 32 30 48
8 Bendel Insurance Bendel 32 28 25 45
9 Kano Pillars Kano Pillars 32 40 41 44
10 Niger Tornadoes Niger 31 29 32 42
11 Sporting Lagos FC Sporting 32 33 34 41
12 Abia Warriors Abia 31 34 38 41
13 Rivers United Rivers 27 33 25 40
14 Kwara United Kwara United 31 25 28 40
15 Bayelsa United Bayelsa 32 36 41 39
16 Doma United FC Doma United 32 22 33 39
17 Akwa United Akwa United 32 34 35 37
18 Sunshine Stars Sunshine 31 28 34 36
19 Heartland Owerri Heartland 32 28 39 29
20 Gombe United Gombe United 32 25 58 28
TEMPORADA 2022/2023
PREMIER LEAGUE NIGERIA GRUPO 1
Equipo PJ GF GC Puntos
1 Bendel Insurance Bendel 18 22 11 34
2 Remo Stars Remo Stars 18 21 14 33
3 Enyimba Enyimba 18 25 12 32
4 Akwa United Akwa United 18 24 14 32
5 Plateau United Plateau 18 29 23 26
6 Shooting Stars Shooting 18 20 20 23
7 Gombe United Gombe United 18 10 20 19
8 Kwara United Kwara United 18 11 22 17
9 Nasarawa United Nasarawa 18 15 23 14
10 El Kanemi Warriors Kanemi 18 10 28 10
11 Rivers United Rivers 18 24 15 34
12 Lobi Stars Lobi Stars 18 20 17 30
13 Sunshine Stars Sunshine 18 20 14 27
14 Abia Warriors Abia 18 22 24 27
15 Doma United FC Doma United 18 15 15 26
16 Bayelsa United Bayelsa 18 27 24 24
17 Niger Tornadoes Niger 18 16 16 23
18 Enugu Rangers Enugu 18 16 16 21
19 Wikki Tourist Wikki 18 18 23 19
20 Dakkada Dakkada 18 15 29 13
TEMPORADA 2014/2015
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Enyimba Enyimba 38 48 27 70
2 Warri Wolves FC Warri Wolves 38 62 29 66
3 Nasarawa United Nasarawa 38 47 35 63
4 Wikki Tourist Wikki 38 45 36 63
5 Giwa Giwa 38 44 42 63
6 Sunshine Stars Sunshine 38 58 38 61
7 Heartland Owerri Heartland 38 46 40 56
8 Kano Pillars Kano Pillars 38 45 39 55
9 Shooting Stars Shooting 38 39 39 53
10 Abia Warriors Abia 38 39 43 53
11 Ifeanyi Ubah Ifeanyi Ubah 38 37 40 50
12 Enugu Rangers Enugu 38 46 51 49
13 El Kanemi Warriors Kanemi 38 38 56 49
14 Lobi Stars Lobi Stars 38 34 39 47
15 Akwa United Akwa United 38 33 43 47
16 Dolphin Port Harcourt Dolphin Port 38 38 40 45
17 Sharks Sharks 38 28 39 42
18 Kwara United Kwara United 38 32 46 42
19 Taraba Taraba 38 30 47 37
20 Bayelsa United Bayelsa 38 28 48 34
TEMPORADA 2013/2014
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Kano Pillars Kano Pillars 38 57 41 65
2 Enyimba Enyimba 38 50 27 64
3 Warri Wolves FC Warri Wolves 38 49 38 61
4 Nasarawa United Nasarawa 38 46 37 61
5 Giwa Giwa 38 44 37 59
6 Lobi Stars Lobi Stars 38 40 46 59
7 Abia Warriors Abia 38 51 40 58
8 Enugu Rangers Enugu 38 45 37 58
9 Dolphin Port Harcourt Dolphin Port 38 45 34 55
10 Heartland Owerri Heartland 38 36 27 55
11 Sunshine Stars Sunshine 38 51 47 54
12 Taraba Taraba 38 35 41 53
13 Sharks Sharks 38 42 39 52
14 El Kanemi Warriors Kanemi 38 43 35 51
15 Bayelsa United Bayelsa 38 50 54 51
16 Akwa United Akwa United 38 27 34 51
17 Gombe United Gombe United 38 42 41 50
18 Crown Crown 38 30 56 39
19 Kaduna United FC Kaduna 38 33 55 38
20 Nembe City FC Nembe City 38 23 73 28
TEMPORADA 2012/2013
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Kano Pillars Kano Pillars 38 45 39 63
2 Enyimba Enyimba 38 32 19 62
3 Bayelsa United Bayelsa 38 42 39 61
4 El Kanemi Warriors Kanemi 38 41 33 60
5 Enugu Rangers Enugu 38 47 37 58
6 Warri Wolves FC Warri Wolves 38 42 33 55
7 Gombe United Gombe United 38 38 46 55
8 Sharks Sharks 38 35 32 53
9 Dolphin Port Harcourt Dolphin Port 38 32 33 53
10 Kaduna United FC Kaduna 38 37 45 53
11 Heartland Owerri Heartland 38 39 32 52
12 Sunshine Stars Sunshine 38 39 35 52
13 Nasarawa United Nasarawa 38 36 41 52
14 Lobi Stars Lobi Stars 38 35 40 52
15 Nembe City FC Nembe City 38 31 47 52
16 Akwa United Akwa United 38 40 46 51
17 Kwara United Kwara United 38 32 32 50
18 ABS FC ABS FC 38 35 43 50
19 Wikki Tourist Wikki 38 40 41 49
20 Shooting Stars Shooting 38 41 46 46
TEMPORADA 2009/2010
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Enyimba Enyimba 38 43 25 70
2 Kano Pillars Kano Pillars 38 48 29 66
3 Sunshine Stars Sunshine 38 39 30 64
4 Kwara United Kwara United 38 43 34 60
5 Enugu Rangers Enugu 38 34 22 58
6 Warri Wolves FC Warri Wolves 38 50 43 58
7 Niger Tornadoes Niger 38 42 38 55
8 Heartland Owerri Heartland 38 37 33 54
9 Gombe United Gombe United 38 34 33 52
10 Kaduna United FC Kaduna 38 40 45 52
11 Shooting Stars Shooting 38 27 33 52
12 Dolphin Port Harcourt Dolphin Port 38 39 39 51
13 Lobi Stars Lobi Stars 38 34 37 51
14 Ocean Boys Ocean Boys 38 32 36 50
15 Zamfara United Zamfara 38 30 46 49
16 Sharks Sharks 38 45 41 48
17 Wikki Tourist Wikki 38 40 38 47
18 Bayelsa United Bayelsa 38 40 46 47
19 Gateway FC Gateway FC 38 33 46 40
20 Ranchers Bees Ranchers 38 23 59 36
TEMPORADA 2008/2009
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Bayelsa United Bayelsa 38 50 27 70
2 Heartland Owerri Heartland 38 47 27 67
3 Enyimba Enyimba 38 38 29 64
4 Warri Wolves FC Warri Wolves 38 45 36 58
5 Niger Tornadoes Niger 38 37 31 56
6 Enugu Rangers Enugu 38 34 28 56
7 Kano Pillars Kano Pillars 38 35 35 54
8 Ocean Boys Ocean Boys 38 28 34 54
9 Sharks Sharks 38 41 37 53
10 Kaduna United FC Kaduna 38 32 43 53
11 Gateway FC Gateway FC 38 32 34 51
12 Gombe United Gombe United 38 28 35 51
13 Sunshine Stars Sunshine 38 34 32 50
14 Wikki Tourist Wikki 38 26 37 49
15 Zamfara United Zamfara 38 44 43 48
16 Akwa United Akwa United 38 41 42 48
17 JUTH FC JUTH FC 38 26 28 47
18 Lobi Stars Lobi Stars 38 33 38 47
19 Nasarawa United Nasarawa 38 27 47 39
20 Abuja FC Abuja FC 38 23 38 37
TEMPORADA 2007/2008
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Kano Pillars Kano Pillars 38 43 28 64
2 Heartland Owerri Heartland 38 41 25 63
3 Bayelsa United Bayelsa 38 36 22 63
4 Sunshine Stars Sunshine 38 43 28 61
5 Niger Tornadoes Niger 38 45 38 60
6 Enyimba Enyimba 38 44 32 59
7 Lobi Stars Lobi Stars 38 46 36 58
8 Enugu Rangers Enugu 38 31 26 57
9 Wikki Tourist Wikki 37 43 42 53
10 Gombe United Gombe United 38 37 42 52
11 Zamfara United Zamfara 38 32 39 52
12 Sharks Sharks 38 46 42 50
13 Ocean Boys Ocean Boys 38 31 33 50
14 Akwa United Akwa United 38 35 44 48
15 JUTH FC JUTH FC 38 28 42 48
16 Nasarawa United Nasarawa 37 28 35 46
17 Kwara United Kwara United 38 33 43 46
18 Jigawa Golden Stars Jigawa 38 29 37 42
19 Prime FC Prime FC 38 21 39 41
20 Bendel Insurance Bendel 38 26 45 39
TEMPORADA 2006/2007
PREMIER LEAGUE NIGERIA
Equipo PJ GF GC Puntos
1 Wikki Tourist Wikki 18 20 13 33
2 Enugu Rangers Enugu 18 20 11 30
3 Heartland Owerri Heartland 18 17 13 29
4 Kwara United Kwara United 18 26 18 28
5 Kano Pillars Kano Pillars 18 20 14 28
6 Prime FC Prime FC 18 19 23 24
7 Ocean Boys Ocean Boys 18 15 21 24
8 Niger Tornadoes Niger 18 10 15 21
9 Kaduna United FC Kaduna 18 15 23 16
10 Adamawa United FC Adamawa 18 11 22 14
11 Enyimba Enyimba 18 19 6 32
12 Gombe United Gombe United 18 19 16 26
13 Bendel Insurance Bendel 18 20 18 26
14 Lobi Stars Lobi Stars 18 13 11 26
15 Bayelsa United Bayelsa 18 17 20 25
16 Zamfara United Zamfara 18 15 18 25
17 Nasarawa United Nasarawa 18 17 18 24
18 Akwa United Akwa United 18 15 19 23
19 Dolphin Port Harcourt Dolphin Port 18 13 11 21
20 El Kanemi Warriors Kanemi 18 10 21 19
TEMPORADA 2005/2006
PREMIER LEAGUE NIGERIA GRUPO 1
Equipo PJ GF GC Puntos
1 Kwara United Kwara United 18 20 14 34
2 Wikki Tourist Wikki 18 18 16 31
3 Dolphin Port Harcourt Dolphin Port 18 24 17 29
4 Kano Pillars Kano Pillars 18 26 22 29
5 Bayelsa United Bayelsa 18 18 15 25
6 Enugu Rangers Enugu 18 19 19 25
7 El Kanemi Warriors Kanemi 18 22 24 25
8 Bendel Insurance Bendel 18 16 20 23
9 Ranchers Bees Ranchers 18 16 21 20
10 Berger Berger 18 10 21 15

  USO DE MEMORIA  
6,347,064 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.6422
Total Execution Time  0.6444
  CADENA URL  
/historico/Bayelsa-United
  GET DATOS  
$_GET['/historico/Bayelsa-United']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0155  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 = 'Bayelsa-United' 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.0161  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=15881 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0172  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=15881 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0296  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 = 73889
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15881 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=490 AND type_rel = 3
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 490 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0156  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 (1162543,1162408,1154996,1008473,812430) ORDER BY n.cover_points DESC, update_date DESC
0.0151  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 = '15881' ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '15881' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '15881' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0156  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 = 73889 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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=15881 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (73889) 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.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 73889 AND teamId = 15881
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 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 = 73889 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0148  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 = '15881' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '15881' 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 = '15881' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0158  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 = 73889 WHERE rp.league_id = 73889 AND rp.teamId = 15881 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.0162  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 = 73889 WHERE rp.league_id = 73889 AND rp.teamId = 15881 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 73889 WHERE rp.league_id = 73889 AND rp.teamId = 15881 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 15881 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 = 73889 AND t.round = 32 ORDER BY team.conference ASC,t.position 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 `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 = 70854 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.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 `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 = 10205 AND t.round = 38 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 `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 = 3764 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 3238 AND t.round = 38 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 `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 = 10752 AND t.round = 38 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 = 10751 AND t.round = 38 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 `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 = 10750 AND t.round = 38 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 `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 = 10749 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 `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 = 24151 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC