4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SCC Mohammédia

SCC Mohammédia

Entrenador: Noureddine Ziyati

Temporada 2023/2024
TEMPORADA 2023/2024
BOTOLA PRO
Equipo PJ GF GC Puntos
1 FAR Rabat FAR Rabat 27 58 19 64
2 Raja Casablanca Raja 26 43 14 60
3 RSB Berkane RSB Berkane 25 30 15 43
4 Wydad Casablanca Wydad 27 30 25 41
5 FUS Rabat FUS Rabat 27 27 26 39
6 Olympic Safi Olympic Safi 27 26 23 38
7 UTS Rabat UTS Rabat 27 29 29 37
8 Moghreb Tetouan Moghreb 26 23 21 34
9 Renaissance Zemamra Renaissance 27 31 32 34
10 Maghreb Fes Maghreb Fes 27 30 32 30
11 Hassania Agadir Hassania 27 26 37 30
12 Ittihad Tanger Ittihad 27 27 36 29
13 JS Soualem JS Soualem 27 26 39 27
14 SCC Mohammédia Mohammédia 27 19 36 24
15 Mouloudia Oujda Mouloudia 27 19 41 24
16 Youssoufia Berrechid Youssoufia 27 18 37 20
TEMPORADA 2022/2023
BOTOLA PRO
Equipo PJ GF GC Puntos
1 FAR Rabat FAR Rabat 30 50 19 67
2 Wydad Casablanca Wydad 30 47 21 66
3 FUS Rabat FUS Rabat 30 36 16 55
4 Olympic Safi Olympic Safi 30 34 28 47
5 Raja Casablanca Raja 30 31 26 44
6 RSB Berkane RSB Berkane 30 31 29 44
7 Hassania Agadir Hassania 30 30 29 39
8 UTS Rabat UTS Rabat 30 34 40 36
9 JS Soualem JS Soualem 30 31 40 36
10 Maghreb Fes Maghreb Fes 30 27 33 34
11 Mouloudia Oujda Mouloudia 30 30 35 32
12 SCC Mohammédia Mohammédia 30 27 36 31
13 Moghreb Tetouan Moghreb 30 28 41 30
14 Ittihad Tanger Ittihad 30 23 39 29
15 Olympique Khouribga Olympique 30 29 36 28
16 Difaâ El Jadida Difaâ 30 24 44 25
TEMPORADA 2021/2022
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Wydad Casablanca Wydad 30 46 24 63
2 Raja Casablanca Raja 30 41 21 60
3 FAR Rabat FAR Rabat 30 38 29 48
4 Maghreb Fes Maghreb Fes 30 28 17 45
5 FUS Rabat FUS Rabat 30 34 30 43
6 RSB Berkane RSB Berkane 30 39 33 41
7 Olympic Safi Olympic Safi 30 29 27 39
8 Difaâ El Jadida Difaâ 30 32 40 38
9 JS Soualem JS Soualem 30 37 38 36
10 Olympique Khouribga Olympique 30 32 37 36
11 SCC Mohammédia Mohammédia 30 27 32 34
12 Hassania Agadir Hassania 30 26 30 34
13 Ittihad Tanger Ittihad 30 31 41 33
14 Mouloudia Oujda Mouloudia 30 35 38 33
15 Rapide Oued Zem Rapide Oued 30 19 39 29
16 Youssoufia Berrechid Youssoufia 30 25 43 26
TEMPORADA 2020/2021
BOTOLA PRO
Equipo PJ GF GC Puntos
1 Wydad Casablanca Wydad 30 58 26 67
2 Raja Casablanca Raja 30 48 26 59
3 FAR Rabat FAR Rabat 30 39 29 51
4 RSB Berkane RSB Berkane 30 37 36 45
5 Mouloudia Oujda Mouloudia 30 38 35 42
6 Hassania Agadir Hassania 30 23 24 37
7 Maghreb Fes Maghreb Fes 30 30 34 36
8 Ittihad Tanger Ittihad 30 29 36 36
9 SCC Mohammédia Mohammédia 30 26 25 35
10 FUS Rabat FUS Rabat 30 32 36 35
11 Difaâ El Jadida Difaâ 30 32 40 35
12 Olympic Safi Olympic Safi 30 30 41 35
13 Youssoufia Berrechid Youssoufia 30 23 33 33
14 Rapide Oued Zem Rapide Oued 30 28 36 33
15 Moghreb Tetouan Moghreb 30 36 43 32
16 Renaissance Zemamra Renaissance 30 31 40 30
TEMPORADA 2019/2020
BOTOLA 2
Equipo PJ GF GC Puntos
1 Maghreb Fes Maghreb Fes 30 40 25 52
2 SCC Mohammédia Mohammédia 30 38 26 51
3 Olympique Dcheïra Olympique 30 44 33 48
4 Racing de Casablanca Racing 30 27 18 46
5 JS Soualem JS Soualem 30 25 21 45
6 Widad Temara Widad Temara 30 31 31 41
7 Wydad Fès Wydad Fès 30 29 27 40
8 Chabab Atlas Khenifra Chabab Atlas 30 27 33 39
9 Ittihad Khemisset Ittihad 30 40 43 36
10 KAC Kenitra KAC Kenitra 30 30 33 36
11 TAS Casablanca Casablanca 30 29 34 35
12 Kawkab Marrakech Kawkab 30 28 31 33
13 Chabab Benguerir Chabab 30 26 32 33
14 AS Salé AS Salé 30 25 30 33
15 Sidi Kacem Sidi Kacem 30 28 34 32
16 Chabab Rif Hoceima Chabab 30 24 40 27
TEMPORADA 2003/2004
BOTOLA PRO
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
TEMPORADA 2002/2003
BOTOLA PRO
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
TEMPORADA 2000/2001
BOTOLA PRO
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,972,488 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5032
Total Execution Time  0.5043
  CADENA URL  
/historico/Sporting-Club-Chabab-Mohammedia
  GET DATOS  
$_GET['/historico/Sporting-Club-Chabab-Mohammedia']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0155  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 = 'Sporting-Club-Chabab-Mohammedia' 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.0145  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=86010 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=86010 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=86010 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0295  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 75598
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=86010 AND type_rel = 2
0.0170  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 = '86010' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0179  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 = '86010' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0150  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73592 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 75598 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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=86010 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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,73592) 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.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 73592 AND teamId = 86010
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 75598 AND teamId = 86010
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 FROM `tables2024` 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 = 73592 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0159  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 = 73592 WHERE rp.league_id = 73592 AND rp.teamId = 86010 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.0164  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 = 73592 WHERE rp.league_id = 73592 AND rp.teamId = 86010 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152  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 = 73592 WHERE rp.league_id = 73592 AND rp.teamId = 86010 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 86010 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 64194 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.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 `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 = 60252 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.0151  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 `tables2020` 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 = 50044 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.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 `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.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 `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.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 `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