4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sidi Kacem
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 2018/2019
BOTOLA 2
Equipo PJ GF GC Puntos
1 Renaissance Zemamra Renaissance 30 33 14 53
2 Raja Beni Mellal Raja Beni M. 30 38 27 53
3 Olympique Dcheïra Olympique 30 49 33 50
4 KAC Kenitra KAC Kenitra 30 44 33 46
5 Maghreb Fes Maghreb Fes 30 39 30 46
6 Racing de Casablanca Racing 30 43 34 42
7 Ittihad Khemisset Ittihad 30 34 29 40
8 Widad Temara Widad Temara 30 29 30 40
9 Chabab Atlas Khenifra Chabab Atlas 30 23 34 37
10 JS Soualem JS Soualem 30 34 36 36
11 Wydad Fès Wydad Fès 30 24 27 35
12 Sidi Kacem Sidi Kacem 30 34 41 35
13 Chabab Benguerir Chabab 30 27 32 33
14 AS Salé AS Salé 30 32 43 32
15 JSM Laayoune Laayoune 30 26 43 27
16 Kasba Tadla Kasba Tadla 30 21 44 21
TEMPORADA 2017/2018
BOTOLA 2
Equipo PJ GF GC Puntos
1 Mouloudia Oujda Mouloudia 30 48 27 60
2 Youssoufia Berrechid Youssoufia 30 43 21 56
3 Raja Beni Mellal Raja Beni M. 30 38 23 56
4 Chabab Benguerir Chabab 30 32 26 47
5 Olympique Dcheïra Olympique 30 27 28 42
6 Wydad Fès Wydad Fès 30 26 22 41
7 Maghreb Fes Maghreb Fes 30 38 29 40
8 JSM Laayoune Laayoune 30 29 31 39
9 Sidi Kacem Sidi Kacem 30 27 33 34
10 AS Salé AS Salé 30 33 32 33
11 KAC Kenitra KAC Kenitra 30 19 29 32
12 Ittihad Khemisset Ittihad 30 29 36 31
13 Widad Temara Widad Temara 30 23 32 31
14 Kasba Tadla Kasba Tadla 30 23 38 29
15 Rachad Bernoussi Rachad 30 24 38 27
16 USM Oujda USM Oujda 30 23 37 24
TEMPORADA 2016/2017
BOTOLA 2
Equipo PJ GF GC Puntos
1 Racing de Casablanca Racing 26 33 27 43
2 Rapide Oued Zem Rapide Oued 26 29 22 40
3 Mouloudia Oujda Mouloudia 26 29 22 38
4 JSM Laayoune Laayoune 26 24 21 38
5 AS Salé AS Salé 26 34 36 37
6 Maghreb Fes Maghreb Fes 26 34 26 37
7 Youssoufia Berrechid Youssoufia 26 26 25 36
8 Ittihad Khemisset Ittihad 26 27 25 35
9 Raja Beni Mellal Raja Beni M. 26 20 25 33
10 Widad Temara Widad Temara 26 19 20 32
11 USM Ait Melloul Melloul 26 20 21 30
12 Olympique Dcheïra Olympique 26 26 29 30
13 Sidi Kacem Sidi Kacem 26 20 26 30
14 Rachad Bernoussi Rachad 26 29 34 28
15 Wydad Fès Wydad Fès 26 28 34 27
16 US Temara US Temara 26 22 27 27
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 2007/2008
BOTOLA 2
Equipo PJ GF GC Puntos
1 AS Salé AS Salé 29 40 17 51
2 SCCM Mohamedia SCCM 28 31 21 45
3 US Temara US Temara 29 26 19 44
4 Ittihad Tanger Ittihad 29 17 15 42
5 Sidi Kacem Sidi Kacem 29 28 19 39
6 Chabab Houara Chabab 28 37 34 39
7 TAS Casablanca Casablanca 29 24 22 38
8 CWW Casablanca Casablanca 29 29 27 37
9 Union Mohammedia Union 29 20 22 37
10 Chabab Rif Hoceima Chabab 29 20 19 36
11 Settat Settat 28 20 19 35
12 Racing de Casablanca Racing 29 18 23 34
13 Rachad Bernoussi Rachad 28 30 30 33
14 Youssoufia Berrechid Youssoufia 29 22 22 32
15 UTS Rabat UTS Rabat 29 25 36 28
16 Hilal Nador Hilal Nador 29 15 57 19
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

  USO DE MEMORIA  
5,705,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1065
Total Execution Time  0.1076
  CADENA URL  
/historico/Sidi-Kacem
  GET DATOS  
$_GET['/historico/Sidi-Kacem']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0030  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 = 'Sidi-Kacem' 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.0019  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=59416 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=59416 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=59416 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1886 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1886 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1117409,803650,665337,323303,112682) ORDER BY n.cover_points DESC, update_date DESC
0.0024  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 = '59416' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '59416' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '59416' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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.0023  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=59416 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 75598 AND teamId = 59416
0.0019  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 = 75598 AND t.round = 3 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '59416' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '59416' and rp.type = 4
0.0019  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 = '59416' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 75598 WHERE rp.league_id = 75598 AND rp.teamId = 59416 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.0020  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 = 75598 WHERE rp.league_id = 75598 AND rp.teamId = 59416 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 75598 WHERE rp.league_id = 75598 AND rp.teamId = 59416 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 59416 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.0022  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 `tables2019` 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 = 44516 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 `tables2018` 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 = 38717 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 `tables2017` 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 = 34135 AND t.round = 26 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 `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.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 `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.0022  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 = 8691 AND t.round = 29 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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