4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Olympique Dcheïra
TEMPORADA 2023/2024
BOTOLA 2
Equipo PJ GF GC Puntos
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 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 2015/2016
BOTOLA 2
Equipo PJ GF GC Puntos
1 Chabab Atlas Khenifra Chabab Atlas 30 30 21 49
2 Kasba Tadla Kasba Tadla 30 24 20 49
3 AS Salé AS Salé 30 32 29 42
4 Rachad Bernoussi Rachad 30 31 27 41
5 US Temara US Temara 30 31 29 41
6 Youssoufia Berrechid Youssoufia 30 27 25 41
7 Racing de Casablanca Racing 30 37 38 41
8 Olympique Dcheïra Olympique 30 20 21 39
9 Raja Beni Mellal Raja Beni M. 30 24 29 39
10 JSM Laayoune Laayoune 30 35 32 38
11 Ittihad Khemisset Ittihad 30 23 22 38
12 Widad Temara Widad Temara 30 26 22 37
13 USM Ait Melloul Melloul 30 29 28 37
14 Wydad Fès Wydad Fès 30 28 32 37
15 Olympique Marrakech Olympique 30 24 28 37
16 CODM Meknes CODM Meknes 30 24 42 31
TEMPORADA 2014/2015
BOTOLA 2
Equipo PJ GF GC Puntos
1 Ittihad Tanger Ittihad 30 22 11 54
2 Mouloudia Oujda Mouloudia 30 32 22 49
3 USM Ait Melloul Melloul 30 39 24 48
4 Kasba Tadla Kasba Tadla 30 29 22 48
5 Youssoufia Berrechid Youssoufia 30 34 25 46
6 Raja Beni Mellal Raja Beni M. 30 21 16 39
7 JSM Laayoune Laayoune 30 24 24 37
8 AS Salé AS Salé 30 23 26 37
9 US Temara US Temara 30 33 37 36
10 CODM Meknes CODM Meknes 30 28 29 35
11 Widad Temara Widad Temara 30 23 26 35
12 Racing de Casablanca Racing 30 27 35 35
13 Olympique Dcheïra Olympique 30 24 32 33
14 Wydad Fès Wydad Fès 30 19 28 33
15 Chabab Houara Chabab 30 23 31 31
16 Union Mohammedia Union 30 22 35 28

  USO DE MEMORIA  
5,874,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1127
Total Execution Time  0.1139
  CADENA URL  
/historico/Olympique-Dcheira
  GET DATOS  
$_GET['/historico/Olympique-Dcheira']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0029  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 = 'Olympique-Dcheira' 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.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=19309 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=19309 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=19309 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 = 73593
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19309 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=409 AND type_rel = 3
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 409 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0025  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 (975843,911464,803650,73999) ORDER BY n.cover_points DESC, update_date DESC
0.0025  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 = '19309' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 73593 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=19309 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73593 AND teamId = 19309
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 75598 AND teamId = 19309
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 = 73593 AND t.round = 24 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 = '19309' 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 = '19309' and rp.type = 4
0.0021  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 = '19309' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0023  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 = 19309 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 = 73593 WHERE rp.league_id = 73593 AND rp.teamId = 19309 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 19309 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 19309 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,team.teamId 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 = 73593 AND t.round = 24 ORDER BY team.conference ASC,t.position 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 `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.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 `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.0023  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.0023  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.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 `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.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 `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.0023  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.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 `tables2016` 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 = 15522 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables2015` 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 = 4197 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73593 ORDER BY nameShow LIMIT 100