4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Zesco United Zesco United 29 41 16 60
2 Nchanga Rangers Nchanga 29 34 20 53
3 Green Buffaloes Green 28 37 17 50
4 Power Dynamos Power 30 36 21 50
5 Zanaco Zanaco 27 37 20 44
6 Nkana FC Nkana FC 28 27 24 42
7 Nkwazi Nkwazi 30 24 37 37
8 Red Arrows Red Arrows 28 31 30 35
9 Konkola Blades Konkola 28 25 30 35
10 Kabwe Warriors Kabwe 28 24 23 34
11 Roan United Roan United 27 17 26 34
12 Choma Eagles Choma Eagles 29 22 24 32
13 Forest Rangers Forest 28 21 29 30
14 City of Lusaka City Lusaka 27 15 37 24
15 Lusaka Dynamos Lusaka 30 20 43 23
16 National Assembly National 28 24 38 22
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Zanaco Zanaco 30 50 18 63
2 Zesco United Zesco United 30 36 16 63
3 Power Dynamos Power 30 34 22 54
4 City of Lusaka City Lusaka 30 29 25 48
5 Choma Eagles Choma Eagles 30 30 25 45
6 Green Buffaloes Green 30 31 28 45
7 Red Arrows Red Arrows 30 33 22 43
8 Forest Rangers Forest 30 29 30 41
9 Konkola Blades Konkola 30 27 28 39
10 Roan United Roan United 30 33 36 37
11 Kabwe Warriors Kabwe 30 20 23 37
12 Lusaka Dynamos Lusaka 30 26 26 36
13 Chambishi Chambishi 30 23 33 33
14 Zamtel Zamtel 30 13 31 27
15 Nakambala Leopards Nakambala 30 17 39 22
16 Young Arrows Young Arrows 30 18 47 15
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Zesco United Zesco United 30 33 14 51
2 Red Arrows Red Arrows 30 30 16 48
3 Green Buffaloes Green 30 33 23 47
4 Zanaco Zanaco 30 32 33 45
5 Power Dynamos Power 30 31 23 44
6 Kabwe Warriors Kabwe 30 29 28 43
7 Young Arrows Young Arrows 30 29 23 42
8 City of Lusaka City Lusaka 30 24 23 40
9 Konkola Blades Konkola 30 24 24 37
10 Chambishi Chambishi 30 22 35 37
11 Roan United Roan United 30 31 37 36
12 Lusaka Dynamos Lusaka 30 17 19 35
13 Nchanga Rangers Nchanga 30 21 29 35
14 Nkana FC Nkana FC 30 25 34 33
15 Nkwazi Nkwazi 30 20 30 32
16 Green Eagles Green Eagles 30 31 41 30
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Zesco United Zesco United 30 50 15 68
2 Green Buffaloes Green 30 39 25 53
3 Power Dynamos Power 30 41 25 51
4 Kabwe Warriors Kabwe 30 34 22 51
5 Young Arrows Young Arrows 30 38 32 46
6 Lusaka Dynamos Lusaka 30 25 25 46
7 Zanaco Zanaco 30 38 25 45
8 Konkola Blades Konkola 30 29 26 40
9 Red Arrows Red Arrows 30 22 26 35
10 Nchanga Rangers Nchanga 30 25 31 34
11 Roan United Roan United 30 25 36 34
12 City of Lusaka City Lusaka 30 22 33 34
13 Zamtel Zamtel 30 17 29 29
14 Forest Rangers Forest 30 20 30 27
15 Nakambala Leopards Nakambala 30 24 51 25
16 National Assembly National 30 17 35 23
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Zanaco Zanaco 30 57 18 71
2 Green Buffaloes Green 30 44 24 57
3 Power Dynamos Power 30 40 30 51
4 Kabwe Warriors Kabwe 31 34 25 45
5 Forest Rangers Forest 30 24 20 45
6 Konkola Blades Konkola 30 28 21 44
7 Lusaka Dynamos Lusaka 31 37 40 41
8 Nakambala Leopards Nakambala 30 30 37 40
9 Zesco United Zesco United 29 24 21 38
10 Red Arrows Red Arrows 30 44 40 37
11 National Assembly National 30 30 31 37
12 Nkwazi Nkwazi 30 28 37 36
13 Nchanga Rangers Nchanga 29 25 33 35
14 Lusaka Celtic Lusaka 30 20 38 26
15 Kitwe United Kitwe United 30 9 31 23
16 Chambishi Chambishi 30 16 44 19

  USO DE MEMORIA  
5,413,896 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0879
Total Execution Time  0.0898
  CADENA URL  
/premier_league_zambia2010/grupo1/historico
  GET DATOS  
$_GET['/premier_league_zambia2010/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0020  SELECT type FROM routes WHERE alias = 'premier_league_zambia2010'
0.0048  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_zambia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2010 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0021  SELECT id,name,alias,stepParent FROM categories WHERE parentId=480 ORDER BY order_id ASC
0.0024  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 = 8544 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 480 AND group_code = 1 and tables = 1 AND year <= 2010 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0030  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 = 8544 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 16299 AND t.round = 30 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 `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 = 16300 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 `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 = 16301 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 16302 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 02:24:40' 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=2 AND last_update > '2024-05-01 02:24:40' 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-01 02:24:40' 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-01 02:24:40' 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_zambia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2010 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  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 events2010 e ON e.player_id = p.id AND e.league_id = 8544 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8544 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.0020  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 events2010 e ON e.player_id = p.id AND e.league_id = 8544 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8544 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  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 events2010 e ON e.player_id = p.id AND e.league_id = 8544 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8544 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0044  SELECT *,(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 = 8544 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC