4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del JS Soualem

JS Soualem

Entrenador: Mahmoud Sebky

Temporada 2023/2024
TEMPORADA 2023/2024
BOTOLA PRO
Equipo PJ GF GC Puntos
1 FAR Rabat FAR Rabat 26 57 17 64
2 Raja Casablanca Raja 26 43 14 60
3 RSB Berkane RSB Berkane 25 30 15 43
4 Wydad Casablanca Wydad 26 29 24 40
5 FUS Rabat FUS Rabat 26 27 24 39
6 Olympic Safi Olympic Safi 26 25 22 37
7 UTS Rabat UTS Rabat 26 27 29 34
8 Moghreb Tetouan Moghreb 25 23 21 33
9 Renaissance Zemamra Renaissance 26 29 32 31
10 Maghreb Fes Maghreb Fes 26 29 31 29
11 Ittihad Tanger Ittihad 26 26 35 28
12 Hassania Agadir Hassania 26 24 36 27
13 JS Soualem JS Soualem 27 26 39 27
14 SCC Mohammédia Mohammédia 26 19 34 24
15 Mouloudia Oujda Mouloudia 27 19 41 24
16 Youssoufia Berrechid Youssoufia 26 18 37 19
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 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

  USO DE MEMORIA  
5,683,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.4625
Total Execution Time  0.4638
  CADENA URL  
/historico/Club-Chabab-Raidi-Salmi
  GET DATOS  
$_GET['/historico/Club-Chabab-Raidi-Salmi']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0255  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 = 73592
0.0132  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.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=87100 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65 AND type_rel = 3
0.0131  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 65 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0134  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 (1295470,1280408,1237692,1233231,1227627) ORDER BY n.cover_points DESC, update_date DESC
0.0142  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 = '87100' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0142  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 = '87100' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0139  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.0144  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.0151  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=87100 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 73592 AND teamId = 87100
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 75598 AND teamId = 87100
0.0126  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 = '87100' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '87100' and rp.type = 4
0.0126  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 = '87100' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0137  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 = 87100 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.0134  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 = 87100 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 87100 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  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 = 87100 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 `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 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 `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 = 68951 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 = 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.0130  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.0128  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.0128  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