4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Wydad Casablanca Wydad 30 33 16 61
2 FAR Rabat FAR Rabat 30 41 14 58
3 Olympique Khouribga Olympique 30 44 23 53
4 Raja Casablanca Raja 30 34 24 51
5 Hassania Agadir Hassania 30 31 24 49
6 CODM Meknes CODM Meknes 30 23 25 41
7 Difaâ El Jadida Difaâ 30 29 26 40
8 Ittihad Khemisset Ittihad 30 20 26 36
9 AS Salé AS Salé 30 18 26 35
10 Olympic Safi Olympic Safi 30 26 27 34
11 Mouloudia Oujda Mouloudia 30 27 30 34
12 Moghreb Tetouan Moghreb 30 19 27 33
13 JSM Laayoune Laayoune 30 23 26 32
14 Ittihad Tanger Ittihad 30 22 29 29
15 SCCM Mohamedia SCCM 30 15 35 27
16 UTS Rabat UTS Rabat 30 12 39 19
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 FAR Rabat FAR Rabat 30 35 9 62
2 Raja Casablanca Raja 30 42 17 60
3 Wydad Casablanca Wydad 30 32 14 50
4 Olympic Safi Olympic Safi 30 25 22 41
5 JSM Laayoune Laayoune 30 26 25 39
6 Ittihad Khemisset Ittihad 30 18 21 37
7 Hassania Agadir Hassania 30 19 21 36
8 Olympique Khouribga Olympique 30 24 29 36
9 UTS Rabat UTS Rabat 30 27 33 36
10 AS Salé AS Salé 30 25 33 35
11 SCCM Mohamedia SCCM 30 18 24 34
12 Mouloudia Oujda Mouloudia 30 21 27 33
13 CODM Meknes CODM Meknes 30 16 22 33
14 Ittihad Tanger Ittihad 30 19 28 33
15 Maghreb Fes Maghreb Fes 30 22 26 32
16 Kawkab Marrakech Kawkab 30 17 35 27
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Raja Casablanca Raja 30 37 18 56
2 FAR Rabat FAR Rabat 30 36 17 56
3 AS Salé AS Salé 30 33 23 51
4 Wydad Casablanca Wydad 30 19 8 49
5 Olympique Khouribga Olympique 30 30 17 48
6 CODM Meknes CODM Meknes 30 30 22 48
7 Mouloudia Oujda Mouloudia 30 23 29 39
8 Maghreb Fes Maghreb Fes 30 28 32 38
9 Hassania Agadir Hassania 30 23 26 37
10 Kawkab Marrakech Kawkab 30 24 24 36
11 JS d'El Massira d'El Massira 30 20 25 35
12 Ittihad Tanger Ittihad 30 15 19 34
13 SCC Mohammédia Mohammédia 30 13 26 31
14 Ittihad Khemisset Ittihad 30 17 24 29
15 Settat Settat 30 15 29 27
16 KAC Kenitra KAC Kenitra 30 14 38 18
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Hassania Agadir Hassania 30 32 12 54
2 Raja Casablanca Raja 30 36 18 52
3 Wydad Casablanca Wydad 30 25 15 52
4 CODM Meknes CODM Meknes 30 25 16 52
5 Maghreb Fes Maghreb Fes 30 34 20 49
6 Olympique Khouribga Olympique 30 27 24 44
7 SCC Mohammédia Mohammédia 30 23 26 37
8 JS d'El Massira d'El Massira 30 25 32 34
9 FAR Rabat FAR Rabat 30 27 29 33
10 TAS Casablanca Casablanca 30 23 27 33
11 Ittihad Khemisset Ittihad 30 22 30 33
12 Settat Settat 30 19 26 32
13 Kawkab Marrakech Kawkab 30 25 34 32
14 KAC Kenitra KAC Kenitra 30 20 24 31
15 Ittihad Tanger Ittihad 30 22 38 30
16 FUS Rabat FUS Rabat 30 13 27 27
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Hassania Agadir Hassania 30 41 9 65
2 Wydad Casablanca Wydad 30 38 12 62
3 Raja Casablanca Raja 30 42 18 55
4 Maghreb Fes Maghreb Fes 30 31 16 52
5 Olympique Khouribga Olympique 30 32 22 47
6 FAR Rabat FAR Rabat 30 27 24 42
7 TAS Casablanca Casablanca 30 24 26 41
8 Ittihad Khemisset Ittihad 30 22 29 35
9 JS d'El Massira d'El Massira 30 32 45 35
10 CODM Meknes CODM Meknes 30 18 25 34
11 Settat Settat 30 20 34 32
12 Kawkab Marrakech Kawkab 30 25 30 31
13 FUS Rabat FUS Rabat 30 17 22 31
14 Ittihad Tanger Ittihad 30 27 35 31
15 Stade Marocain Stade 30 21 41 30
16 Raja Beni Mellal Raja Beni M. 30 18 47 20
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 Raja Casablanca Raja 30 33 12 64
2 FUS Rabat FUS Rabat 30 32 17 55
3 Maghreb Fes Maghreb Fes 30 33 22 48
4 Settat Settat 30 26 19 48
5 Olympique Khouribga Olympique 30 25 19 42
6 Wydad Casablanca Wydad 30 34 25 41
7 Kawkab Marrakech Kawkab 30 24 21 41
8 FAR Rabat FAR Rabat 30 25 35 37
9 Ittihad Khemisset Ittihad 30 24 31 35
10 TAS Casablanca Casablanca 30 26 38 33
11 CODM Meknes CODM Meknes 30 21 25 32
12 Hassania Agadir Hassania 30 21 29 31
13 JS d'El Massira d'El Massira 30 27 33 30
14 Raja Beni Mellal Raja Beni M. 30 26 32 30
15 SCC Mohammédia Mohammédia 30 21 30 30
16 Racing de Casablanca Racing 30 13 23 26

  USO DE MEMORIA  
5,613,408 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4086
Total Execution Time  0.4107
  CADENA URL  
/marruecos2006/grupo1/historico
  GET DATOS  
$_GET['/marruecos2006/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0147  SELECT type FROM routes WHERE alias = 'marruecos2006'
0.0301  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'marruecos' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0156  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 = 8682 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 65 AND group_code = 1 and tables = 1 AND year <= 2006 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 8682 AND t.round = 31 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 `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 = 8679 AND t.round = 30 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 `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 = 23624 AND t.round = 30 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 `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 = 23628 AND t.round = 30 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 `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 = 23631 AND t.round = 30 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 `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 = 23635 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 03:21:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 03:21:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 03:21:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 03:21:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'marruecos' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0149  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 events2006 e ON e.player_id = p.id AND e.league_id = 8682 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8682 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.0147  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 events2006 e ON e.player_id = p.id AND e.league_id = 8682 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8682 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0151  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 events2006 e ON e.player_id = p.id AND e.league_id = 8682 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8682 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0198  SELECT *,(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 = 8682 AND t.round = 31 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC