4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2006/2007
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
Ver
TEMPORADA 2005/2006
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
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Enyimba Enyimba 38 63 22 72
2 Enugu Rangers Enugu 38 33 22 67
3 Heartland Owerri Heartland 38 35 30 65
4 Gombe United Gombe United 38 37 28 64
5 Shooting Stars Shooting 39 42 36 61
6 Dolphin Port Harcourt Dolphin Port 38 37 34 58
7 Kwara United Kwara United 38 34 30 55
8 Berger Berger 39 34 39 55
9 Sharks Sharks 38 42 37 54
10 Kano Pillars Kano Pillars 37 37 39 53
11 Lobi Stars Lobi Stars 38 41 39 51
12 Nasarawa United Nasarawa 38 39 50 51
13 Zamfara United Zamfara 39 36 45 50
14 Bendel Insurance Bendel 37 40 44 49
15 Niger Tornadoes Niger 37 37 35 47
16 El Kanemi Warriors Kanemi 37 33 37 47
17 Wikki Tourist Wikki 38 26 34 47
18 NPA NPA 39 41 50 47
19 Ifeanyi Ubah Ifeanyi Ubah 38 36 49 46
20 Gateway FC Gateway FC 38 27 50 34

  USO DE MEMORIA  
5,356,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0026
Controller Execution Time ( Home / Category )  0.0876
Total Execution Time  0.0902
  CADENA URL  
/premier_league_nigeria2007/grupo1/historico
  GET DATOS  
$_GET['/premier_league_nigeria2007/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'premier_league_nigeria2007'
0.0054  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_nigeria' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2007 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0023  SELECT id,name,alias,stepParent FROM categories WHERE parentId=490 ORDER BY order_id ASC
0.0023  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 10749 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 490 AND group_code = 1 and tables = 1 AND year <= 2007 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0031  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.0034  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
0.0060  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 = 24158 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 13:21:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-03 13:21:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-03 13:21:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-03 13:21:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_nigeria' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2007 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0022  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2007 e ON e.player_id = p.id AND e.league_id = 10749 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10749 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0021  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2007 e ON e.player_id = p.id AND e.league_id = 10749 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10749 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0022  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2007 e ON e.player_id = p.id AND e.league_id = 10749 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10749 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0053  SELECT *,(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