4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Stade Marocain
TEMPORADA 2023/2024
BOTOLA 2
Equipo PJ GF GC Puntos
1 CODM Meknes CODM Meknes 24 28 18 48
2 Kawkab Marrakech Kawkab 24 32 21 43
3 USM Oujda USM Oujda 24 26 15 40
4 Difaâ El Jadida Difaâ 24 21 16 40
5 Raja Beni Mellal Raja Beni M. 24 40 25 36
6 Stade Marocain Stade 24 29 29 34
7 Olympique Khouribga Olympique 24 26 25 32
8 Chabab Atlas Khenifra Chabab Atlas 24 18 15 31
9 JS d'El Massira d'El Massira 24 32 33 31
10 Olympique Dcheïra Olympique 24 23 26 29
11 Chabab Benguerir Chabab 24 20 21 28
12 Wydad Fès Wydad Fès 24 20 28 26
13 Rapide Oued Zem Rapide Oued 24 16 21 25
14 Racing de Casablanca Racing 24 22 30 23
15 Ittifaq Marrakech Ittifaq 24 11 24 22
16 AS Salé AS Salé 24 22 39 18
TEMPORADA 2022/2023
BOTOLA 2
Equipo PJ GF GC Puntos
1 Renaissance Zemamra Renaissance 30 29 15 54
2 Stade Marocain Stade 30 38 27 52
3 Youssoufia Berrechid Youssoufia 30 34 26 52
4 Rapide Oued Zem Rapide Oued 30 40 28 49
5 Olympique Dcheïra Olympique 30 38 27 47
6 USM Oujda USM Oujda 30 21 23 41
7 Chabab Benguerir Chabab 30 26 19 40
8 Chabab Atlas Khenifra Chabab Atlas 30 33 38 37
9 JS d'El Massira d'El Massira 29 36 38 36
10 Ittifaq Marrakech Ittifaq 30 31 33 36
11 Racing de Casablanca Racing 30 28 31 36
12 AS Salé AS Salé 30 39 43 34
13 Wydad Fès Wydad Fès 30 30 38 34
14 Raja Beni Mellal Raja Beni M. 29 23 34 31
15 Ittihad Khemisset Ittihad 30 18 30 28
16 Widad Temara Widad Temara 30 20 34 23
TEMPORADA 2021/2022
BOTOLA 2
Equipo PJ GF GC Puntos
1 Moghreb Tetouan Moghreb 30 47 19 66
2 UTS Rabat UTS Rabat 30 40 31 55
3 Olympique Dcheïra Olympique 30 28 22 44
4 Renaissance Zemamra Renaissance 30 39 32 44
5 JS d'El Massira d'El Massira 30 25 33 41
6 AS Salé AS Salé 30 32 33 40
7 Stade Marocain Stade 30 36 34 40
8 Ittihad Khemisset Ittihad 30 27 32 39
9 Chabab Benguerir Chabab 30 23 24 37
10 Raja Beni Mellal Raja Beni M. 30 24 30 37
11 Racing de Casablanca Racing 30 33 39 36
12 Wydad Fès Wydad Fès 30 30 33 35
13 Chabab Atlas Khenifra Chabab Atlas 30 29 29 34
14 USM Oujda USM Oujda 30 34 36 34
15 TAS Casablanca Casablanca 30 27 31 34
16 Kawkab Marrakech Kawkab 30 27 43 24
TEMPORADA 2020/2021
BOTOLA 2
Equipo PJ GF GC Puntos
1 Olympique Khouribga Olympique 30 38 25 54
2 JS Soualem JS Soualem 30 36 20 53
3 Wydad Fès Wydad Fès 30 40 28 49
4 Olympique Dcheïra Olympique 30 40 30 48
5 UTS Rabat UTS Rabat 30 39 34 48
6 Ittihad Khemisset Ittihad 30 35 33 41
7 Stade Marocain Stade 30 37 37 40
8 Chabab Benguerir Chabab 30 34 39 38
9 Racing de Casablanca Racing 30 35 36 37
10 Kawkab Marrakech Kawkab 30 32 26 37
11 Chabab Atlas Khenifra Chabab Atlas 30 35 39 36
12 Raja Beni Mellal Raja Beni M. 30 21 27 36
13 TAS Casablanca Casablanca 30 35 40 35
14 AS Salé AS Salé 30 28 36 35
15 KAC Kenitra KAC Kenitra 30 27 37 35
16 Widad Temara Widad Temara 30 20 45 20
TEMPORADA 2011/2012
BOTOLA 2
Equipo PJ GF GC Puntos
1 Raja Beni Mellal Raja Beni M. 30 25 15 48
2 RSB Berkane RSB Berkane 30 29 27 47
3 TAS Casablanca Casablanca 30 32 27 46
4 Union Mohammedia Union 30 38 27 43
5 Kawkab Marrakech Kawkab 30 29 19 42
6 AS Salé AS Salé 30 32 24 41
7 USM Ait Melloul Melloul 30 37 40 40
8 Racing de Casablanca Racing 30 27 24 39
9 Youssoufia Berrechid Youssoufia 30 33 34 39
10 Mouloudia Oujda Mouloudia 30 26 31 39
11 Kasba Tadla Kasba Tadla 30 22 27 35
12 Ittihad Tanger Ittihad 30 21 26 34
13 Rachad Bernoussi Rachad 30 26 33 33
14 US Temara US Temara 30 15 20 32
15 Chabab Houara Chabab 30 22 32 31
16 Stade Marocain Stade 30 26 34 29
TEMPORADA 2010/2011
BOTOLA 2
Equipo PJ GF GC Puntos
1 CODM Meknes CODM Meknes 34 35 10 64
2 Ittihad Khemisset Ittihad 34 43 29 61
3 USM Ait Melloul Melloul 34 42 24 61
4 Youssoufia Berrechid Youssoufia 34 33 20 59
5 TAS Casablanca Casablanca 34 26 25 50
6 Mouloudia Oujda Mouloudia 34 29 29 47
7 Union Mohammedia Union 34 28 28 46
8 Chabab Houara Chabab 34 28 29 46
9 Rachad Bernoussi Rachad 34 27 29 43
10 Racing de Casablanca Racing 34 38 36 42
11 Ittihad Tanger Ittihad 34 28 33 40
12 AS Salé AS Salé 34 38 39 39
13 US Temara US Temara 34 25 26 39
14 Stade Marocain Stade 34 18 24 39
15 Raja Al Hoceima Raja Hoceima 34 18 29 35
16 Fkih Ben Salah Fkih Salah 34 27 39 35
17 SCCM Mohamedia SCCM 34 25 33 33
18 Hilal Nador Hilal Nador 34 18 44 25
TEMPORADA 2009/2010
BOTOLA 2
Equipo PJ GF GC Puntos
1 Kasba Tadla Kasba Tadla 36 34 23 65
2 Chabab Rif Hoceima Chabab 36 32 23 61
3 Union Mohammedia Union 36 38 25 58
4 CODM Meknes CODM Meknes 36 38 26 58
5 US Temara US Temara 36 39 35 56
6 Chabab Houara Chabab 36 38 28 53
7 Stade Marocain Stade 36 36 33 52
8 Racing de Casablanca Racing 36 36 36 52
9 Raja Al Hoceima Raja Hoceima 36 37 36 48
10 Youssoufia Berrechid Youssoufia 36 39 35 43
11 Mouloudia Oujda Mouloudia 36 30 34 43
12 TAS Casablanca Casablanca 36 28 28 42
13 Ittihad Tanger Ittihad 36 28 33 42
14 Rachad Bernoussi Rachad 36 26 37 42
15 Fkih Ben Salah Fkih Salah 36 29 36 41
16 SCCM Mohamedia SCCM 36 26 37 41
17 Chabab Atlas Khenifra Chabab Atlas 36 31 46 40
18 Settat Settat 36 29 40 38
19 Sidi Kacem Sidi Kacem 36 33 36 36
TEMPORADA 2008/2009
BOTOLA 2
Equipo PJ GF GC Puntos
1 FUS Rabat FUS Rabat 34 43 13 66
2 Wydad Fès Wydad Fès 34 39 22 61
3 Stade Marocain Stade 34 34 28 60
4 Chabab Rif Hoceima Chabab 34 37 30 51
5 Chabab Houara Chabab 34 42 31 50
6 Racing de Casablanca Racing 34 37 36 50
7 Union Mohammedia Union 34 32 27 47
8 CODM Meknes CODM Meknes 34 31 30 44
9 Ittihad Tanger Ittihad 34 27 26 44
10 Fkih Ben Salah Fkih Salah 34 34 34 44
11 Youssoufia Berrechid Youssoufia 34 31 32 43
12 Sidi Kacem Sidi Kacem 34 25 39 38
13 US Temara US Temara 34 23 35 36
14 TAS Casablanca Casablanca 34 19 23 35
15 Settat Settat 34 27 40 35
16 Rachad Bernoussi Rachad 34 31 34 34
17 Olympique Marrakech Olympique 34 24 36 34
18 CWW Casablanca Casablanca 34 26 46 26
TEMPORADA 2006/2007
BOTOLA 2
Equipo PJ GF GC Puntos
1 FUS Rabat FUS Rabat 30 32 14 55
2 KAC Kenitra KAC Kenitra 30 37 21 53
3 Chabab Houara Chabab 30 26 18 47
4 UTS Rabat UTS Rabat 30 27 21 43
5 Sidi Kacem Sidi Kacem 30 27 27 42
6 Rachad Bernoussi Rachad 30 22 14 41
7 SCCM Mohamedia SCCM 30 20 24 39
8 US Temara US Temara 30 30 27 37
9 Racing de Casablanca Racing 30 27 27 37
10 Youssoufia Berrechid Youssoufia 30 18 21 36
11 Union Mohammedia Union 30 23 28 36
12 Settat Settat 30 25 30 35
13 CWW Casablanca Casablanca 30 26 38 33
14 Hilal Nador Hilal Nador 30 19 29 32
15 Stade Marocain Stade 30 19 28 31
16 RSB Berkane RSB Berkane 30 22 33 28
TEMPORADA 2001/2002
BOTOLA PRO
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

  USO DE MEMORIA  
6,197,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4719
Total Execution Time  0.4731
  CADENA URL  
/historico/Stade-Marocain
  GET DATOS  
$_GET['/historico/Stade-Marocain']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0139  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 = 'Stade-Marocain' 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.0126  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=59422 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=59422 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=59422 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=59422 AND type_rel = 2
0.0152  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 = '59422' 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 = '59422' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0136  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 = '59422' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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=59422 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (75598,73593) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 73593 AND teamId = 59422
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 75598 AND teamId = 59422
0.0127  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 = '59422' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '59422' and rp.type = 4
0.0127  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 = '59422' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128  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 = 73593 WHERE rp.league_id = 73593 AND rp.teamId = 59422 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.0126  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 = 73593 WHERE rp.league_id = 73593 AND rp.teamId = 59422 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 73593 WHERE rp.league_id = 73593 AND rp.teamId = 59422 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 59422 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 = 69255 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2022` 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 = 64195 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2021` 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 = 60253 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2012` 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 = 8702 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables2011` 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 = 8700 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 8697 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 8693 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 8687 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 `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