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 ES Setif ES Setif 30 32 19 54
2 JS Kabylie JS Kabylie 30 33 20 52
3 JSM Béjaïa Béjaïa 30 30 19 49
4 USM Alger USM Alger 30 32 25 47
5 Chlef Chlef 30 29 22 46
6 MC Oran MC Oran 30 28 25 42
7 NA Hussein Dey Hussein 30 27 33 41
8 Bordj Bou Arreridj Bordj 30 24 38 40
9 USM Blida USM Blida 30 33 28 39
10 CR Belouizdad Belouizdad 30 34 37 39
11 MC Alger MC Alger 30 34 30 38
12 Tlemcen Tlemcen 30 24 32 38
13 El Annasser El Annasser 30 33 35 36
14 Paradou Paradou 30 31 32 34
15 ASM Oran ASM Oran 30 28 38 27
16 CA Batna CA Batna 30 28 47 27
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 JS Kabylie JS Kabylie 30 47 21 58
2 USM Alger USM Alger 30 49 30 57
3 Chlef Chlef 30 45 25 52
4 ES Setif ES Setif 30 30 26 47
5 Bordj Bou Arreridj Bordj 30 22 23 46
6 MC Alger MC Alger 30 42 35 44
7 CR Belouizdad Belouizdad 30 30 31 40
8 Paradou Paradou 30 36 38 40
9 CA Batna CA Batna 30 32 35 38
10 USM Blida USM Blida 30 25 30 38
11 NA Hussein Dey Hussein 30 27 35 38
12 MC Oran MC Oran 30 35 41 37
13 Tlemcen Tlemcen 30 25 33 37
14 CS Constantine Constantine 30 27 35 36
15 USM Annaba USM Annaba 30 32 40 35
16 Biskra Biskra 30 13 39 20
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 USM Alger USM Alger 30 54 26 67
2 JS Kabylie JS Kabylie 30 43 20 54
3 MC Alger MC Alger 30 38 43 49
4 NA Hussein Dey Hussein 30 28 18 43
5 USM Blida USM Blida 30 36 29 42
6 Bordj Bou Arreridj Bordj 30 31 25 42
7 Chlef Chlef 30 30 32 41
8 CS Constantine Constantine 30 33 42 40
9 MC Oran MC Oran 30 35 36 39
10 ES Setif ES Setif 30 37 36 38
11 USM Annaba USM Annaba 30 30 36 37
12 Tlemcen Tlemcen 30 32 27 36
13 CR Belouizdad Belouizdad 30 24 34 36
14 El Annasser El Annasser 30 31 34 35
15 GC Mascara GC Mascara 30 33 47 32
16 US Chaouia US Chaouia 30 17 47 23
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 JS Kabylie JS Kabylie 30 40 21 61
2 USM Alger USM Alger 30 49 23 58
3 NA Hussein Dey Hussein 30 31 19 49
4 ES Setif ES Setif 30 41 31 47
5 MC Alger MC Alger 30 35 34 47
6 MC Oran MC Oran 30 34 33 44
7 USM Blida USM Blida 30 34 29 41
8 Chlef Chlef 30 19 22 40
9 Chabab Ahly Chabab Ahly 30 32 28 38
10 Tlemcen Tlemcen 30 22 25 38
11 US Chaouia US Chaouia 30 24 37 38
12 USM Annaba USM Annaba 30 40 37 37
13 CR Belouizdad Belouizdad 30 38 32 36
14 CA Batna CA Batna 30 27 36 33
15 RC Kouba RC Kouba 30 23 39 29
16 JSM Béjaïa Béjaïa 30 17 60 17
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 USM Alger USM Alger 30 52 17 58
2 USM Blida USM Blida 30 32 22 51
3 NA Hussein Dey Hussein 30 32 24 51
4 JS Kabylie JS Kabylie 30 38 24 49
5 CR Belouizdad Belouizdad 30 28 20 45
6 MC Oran MC Oran 30 41 40 43
7 USM Annaba USM Annaba 30 31 33 39
8 ES Setif ES Setif 30 32 36 39
9 RC Kouba RC Kouba 30 33 32 38
10 JSM Béjaïa Béjaïa 30 18 23 38
11 Tlemcen Tlemcen 30 29 28 36
12 CA Batna CA Batna 30 17 23 36
13 Chlef Chlef 30 25 30 34
14 Chabab Ahly Chabab Ahly 30 24 40 34
15 ASM Oran ASM Oran 30 18 41 27
16 MO Constantine Constantine 30 29 46 26
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 USM Alger USM Alger 30 37 24 57
2 JS Kabylie JS Kabylie 30 47 24 52
3 CR Belouizdad Belouizdad 30 47 33 52
4 Tlemcen Tlemcen 30 39 24 51
5 MC Oran MC Oran 30 31 31 45
6 MO Constantine Constantine 30 28 30 44
7 Chabab Ahly Chabab Ahly 30 31 46 41
8 ES Setif ES Setif 30 30 30 40
9 ASM Oran ASM Oran 30 37 33 39
10 USM Annaba USM Annaba 30 31 43 39
11 USM Blida USM Blida 30 37 28 38
12 JSM Béjaïa Béjaïa 30 22 27 38
13 CA Batna CA Batna 30 25 29 37
14 RC Kouba RC Kouba 30 33 36 34
15 MC Alger MC Alger 30 27 33 34
16 Aïn M'lila Aïn M'lila 30 15 46 23
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 CR Belouizdad Belouizdad 30 41 21 62
2 USM Alger USM Alger 30 51 28 55
3 JS Kabylie JS Kabylie 30 47 28 52
4 USM Blida USM Blida 30 42 30 47
5 ASM Oran ASM Oran 30 38 32 44
6 USM Annaba USM Annaba 30 39 33 42
7 ES Setif ES Setif 30 42 37 42
8 MC Oran MC Oran 30 30 33 41
9 Tlemcen Tlemcen 30 32 44 40
10 JSM Béjaïa Béjaïa 30 33 33 39
11 MO Constantine Constantine 30 31 33 39
12 CA Batna CA Batna 30 28 36 39
13 Aïn M'lila Aïn M'lila 30 25 37 37
14 MC Alger MC Alger 30 34 43 36
15 USM El Harrach Harrach 30 24 41 29
16 CS Constantine Constantine 30 17 45 19

  USO DE MEMORIA  
5,728,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.3539
Total Execution Time  0.3570
  CADENA URL  
/liga_argelia2007/grupo1/historico
  GET DATOS  
$_GET['/liga_argelia2007/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0105  SELECT type FROM routes WHERE alias = 'liga_argelia2007'
0.0216  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_argelia' 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.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 311 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0108  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 (1303338,1285339,1182390,1158851,1149674) ORDER BY n.cover_points DESC, update_date DESC
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=311 ORDER BY order_id ASC
0.0107  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 = 8617 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 311 AND group_code = 1 and tables = 1 AND year <= 2007 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0109  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 = 8617 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 8618 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 8619 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2004` 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 = 27451 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0120  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 `tables2003` 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 = 27460 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 `tables2002` 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 = 27462 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2001` 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 = 27466 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 19:26:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 19:26:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 19:26:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 19:26:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_argelia' 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.0107  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 = 8617 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8617 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.0106  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 = 8617 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8617 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0106  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 = 8617 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8617 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0117  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 = 8617 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC