4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
2 jugadores
JS Saoura Sub 21 Saoura
R. Bin Alal R. Bin Alal
K. Mounir K. Mounir 19 años MED
4 jugadores
MC Alger Sub 21 MC Alger Sub 21
Zabih Zabih
Anatov Anatov
Abdali Abdali
O. Romaric O. Romaric 19 años DEL
2 jugadores
Belouizdad Sub 21 Belouizdad
M. Azzi M. Azzi 21 años 178cm DEF
A. Bouras A. Bouras 22 años 184cm MED
1 jugadores
CS Constantine Sub 21 Constantine
A. Belhadj Chekal A. Belhadj Chekal 21 años MED

JUGADORES DESTACADOS

Clasificación

Equipo PJ GF GC Puntos
1 Belouizdad Sub 21 Belouizdad 21 49 17 46
2 MC Alger Sub 21 Alger 21 45 15 45
3 CS Constantine Sub 21 Constantine 21 23 15 39
4 JS Saoura Sub 21 Saoura 21 33 27 39
5 Kabylie Sub 21 Kabylie 21 36 21 38
6 Ben Aknoun Sub 21 Aknoun 21 27 10 36
7 ES Sétif Sub 21 Sétif 21 29 20 34
8 USM Alger Sub 21 Alger 21 31 22 33
9 Souf Sub 21 Souf Sub 21 20 14 29 24
10 Paradou Sub 21 Paradou 21 20 28 22
11 Chlef Sub 21 Chlef 21 16 30 21
12 USM Khenchela Sub 21 Khenchela 21 13 24 20
13 El Bayadh Sub 21 Bayadh 20 15 30 20
14 Biskra Sub 21 Biskra 21 15 35 20
15 MC Oran Sub 21 Oran 21 17 36 17
16 Magra Sub 21 Magra 21 13 37 9

  USO DE MEMORIA  
4,955,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.0653
Total Execution Time  0.0686
  CADENA URL  
/liga_argelia_sub_212024/grupo1/jugadores
  GET DATOS  
$_GET['/liga_argelia_sub_212024/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_argelia_sub_212024'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_argelia_sub_21' 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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1559 AND type_rel = 3
0.0020  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1559 ORDER BY order_id ASC
0.0020  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 = 74131 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74131 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0030  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 = 74131 AND dt.id IN (60620,60623,60610,60614,60621,60612,60619,60611,60613,65913,100657,122565,151805,151804,160782,160781) ORDER BY dt.relations DESC,dp.role ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 13:14:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 13:14:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 13:14:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 13:14:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_argelia_sub_21' 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.0024  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 = 74131 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74131 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.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 = 74131 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74131 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 = 74131 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74131 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 = 74131 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC