4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
3 jugadores
USM El Harrach USM El Harrach
F. Boughidah F. Boughidah 35 años MED
Y. Bouabdallah Y. Bouabdallah 31 años 183cm DEL
D. Boulemdaïs D. Boulemdaïs DEL
4 jugadores
CA Batna CA Batna
K. Ali Haïmoud K. Ali Haïmoud 24 años DEF
Y. Beldjilali Y. Beldjilali 24 años MED
C. Chérif C. Chérif 27 años 184cm DEL
I. Ansel I. Ansel DEL
13 jugadores
USM Annaba USM Annaba
Ziadi Ziadi
A. Haraz A. Haraz
D. Belhani D. Belhani
Samahid Samahid
A. Ittihad A. Ittihad
Belhar Belhar
K. Belhani K. Belhani
A. Toumi A. Toumi 30 años
Bilhanid Bilhanid
K. Bouaziz K. Bouaziz
A. Belhani A. Belhani 37 años POR
S. Khadir S. Khadir 29 años 183cm 78kg DEF
A. Harraz A. Harraz 20 años DEL
8 jugadores
Khroub Khroub
M. Ramzi M. Ramzi 26 años
Subaie Subaie
M. Ramita M. Ramita
M. Bousif M. Bousif 26 años
A. Bouchanene A. Bouchanene 22 años DEF
H. Heriat H. Heriat 36 años MED
M. Fenniri M. Fenniri 26 años MED
M. Akziz M. Akziz 24 años DEL
6 jugadores
MO Constantine MO Constantine
J. Nour J. Nour
Zamuj Zamuj
Malek A. Malek A.
Zervin Zervin
Jaber Noureddine Jaber Noureddine
S. Khadir S. Khadir 29 años 183cm 78kg DEF
2 jugadores
HB Chelghoum Laid Chelghoum Laid
M. Benbelabbas M. Benbelabbas 23 años DEF
Djamil Belabed Djamil Belabed 21 años MED
1 jugadores
Khemis El Khechna Khemis Khechna
K. Al-Khasna K. Al-Khasna
17 jugadores
Olympique Akbou Olympique Akbou
M. Bellounes M. Bellounes 30 años
Hamek Abbes Hamek Abbes
Mibarakou Mibarakou
Mouloud Mizi Mouloud Mizi 31 años
Hamak Hamak
A. Walid A. Walid
Z. Mebarakou Z. Mebarakou 35 años 188cm DEF
S. Bouteldja S. Bouteldja 29 años DEF
A. Bounoua A. Bounoua 33 años 170cm MED
Mansour Achour Mansour Achour 28 años MED
Gherbi Gherbi 19 años DEL
O. Adrar O. Adrar 24 años DEL
M. Benbournane M. Benbournane 26 años DEL
A. Zouari A. Zouari 34 años 167cm DEL
M. Chelfaoui M. Chelfaoui 27 años DEL
M. Boulaouidet M. Boulaouidet 34 años 189cm 84kg DEL
S. Lachahab S. Lachahab 24 años DEL

JUGADORES DESTACADOS

Clasificación

Equipo PJ GF GC Puntos
1 Olympique Akbou Olympique 25 50 14 61
2 MSP Batna MSP Batna 25 38 19 48
3 CA Batna CA Batna 25 22 13 41
4 MO Constantine Constantine 25 27 27 38
5 JS Bordj Ménaïel Bordj 25 27 23 36
6 Khemis El Khechna Khemis 25 24 18 35
7 RB Ouargla RB Ouargla 25 17 24 34
8 Khroub Khroub 25 32 23 33
9 Teleghma Teleghma 25 34 35 32
10 Oued Magrane Oued Magrane 25 23 32 32
11 Aïn M'lila Aïn M'lila 25 22 29 30
12 USM El Harrach Harrach 25 27 31 29
13 HB Chelghoum Laid Chelghoum 25 23 28 27
14 USM Annaba USM Annaba 25 20 26 27
15 Ghozlane Ghozlane 25 23 38 25
16 El Eulma El Eulma 25 14 43 16

  USO DE MEMORIA  
5,341,592 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0802
Total Execution Time  0.0823
  CADENA URL  
/ligue_2_argelia2024/grupo1/jugadores
  GET DATOS  
$_GET['/ligue_2_argelia2024/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0021  SELECT type FROM routes WHERE alias = 'ligue_2_argelia2024'
0.0054  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_2_argelia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=400 AND type_rel = 3
0.0025  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 400 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 (1083754,961158,245286,244317,87628) ORDER BY n.cover_points DESC, update_date DESC
0.0017  SELECT id,name,alias,stepParent FROM categories WHERE parentId=400 ORDER BY order_id ASC
0.0021  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73814 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73814 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0048  SELECT dp.nick,dp.alias,dp.role,p.id,p.teamId,dp.height,dp.weight,p.team_id,p.player_id,p.squadNumber,dp.CountryCode,dp.age FROM rel_players p INNER JOIN dataplayers dp ON dp.id = p.player_id INNER JOIN datateams dt ON dt.id = p.teamId WHERE p.league_id = 73814 AND dt.id IN (11507,11505,11513,13735,16527,59578,13625,83454,59580,108028,153402,88107,126923,119178,146170,119186) ORDER BY dt.relations DESC,dp.role ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 07:40:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 07:40:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 07:40:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-05 07:40:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_2_argelia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0046  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73814 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73814 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73814 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73814 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73814 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73814 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0044  SELECT *,(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 = 73814 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC