4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
15 jugadores
Standard Lieja Sub 18 Standard Lieja
Naïm Van Attenhoven Naïm Van Attenhoven 21 años 186cm POR
Fostave Mabani Fostave Mabani 22 años 166cm DEF
L. Kalala L. Kalala 22 años 174cm DEF
A. Calut A. Calut 21 años 180cm DEF
Youness Behti Youness Behti 21 años 171cm MED
D. Pavlovic D. Pavlovic 22 años 178cm 77kg MED
J. Landu J. Landu 22 años 178cm MED
Anaxis Anaxis 23 años MED
O. Dumont O. Dumont 22 años 182cm MED
T. Itangishaka T. Itangishaka 23 años 191cm MED
I. El Abbassi I. El Abbassi 20 años 170cm MED
F. Engolo F. Engolo 21 años 173cm 62kg DEL
G. D´asaro G. D´asaro 21 años 173cm 70kg DEL
A. Camara A. Camara 19 años DEL
Steve Yanken Steve Yanken 20 años 180cm 65kg DEL
15 jugadores
Genk Sub 18 Genk Sub 18
Tobe Leysen Tobe Leysen 22 años 189cm 83kg POR
J. Takidine J. Takidine 21 años 170cm 71kg DEF
T. Rommens T. Rommens 21 años 185cm DEF
D. Arabaci D. Arabaci 21 años 170cm DEF
L. Beerten L. Beerten 21 años DEF
D. Dierckx D. Dierckx 21 años 192cm 79kg DEF
P. Dwomoh P. Dwomoh 19 años 188cm 69kg MED
M. Balouk M. Balouk 21 años 172cm MED
Jay Geusens Jay Geusens 22 años 185cm MED
Ismael Saibari Ismael Saibari 23 años 185cm 73kg MED
K. Van De Perre K. Van De Perre 20 años 181cm MED
Sam Krawczyk Sam Krawczyk 21 años 188cm 73kg DEL
S. Diawara S. Diawara 20 años 187cm DEL
Tarik Radi Tarik Radi 21 años 173cm DEL
Faissal Boujemaoui Faissal Boujemaoui 21 años 173cm DEL

Clasificación

Equipo PJ GF GC Puntos
1 Genk Sub 18 Genk Sub 18 22 59 21 45
2 Standard Lieja Sub 18 Standard 22 63 28 45
3 Sporting Charleroi Sub 18 Sporting 22 55 39 42
4 KV Mechelen Sub 18 Mechelen 22 45 27 37
5 KAA Gent Sub 18 Gent 22 54 43 33
6 Club Brugge Sub 18 Club Brugge 22 55 35 32
7 Zulte-Waregem Sub 18 Zulte-Warege 22 39 47 31
8 Leuven Sub 18 Leuven 22 37 48 30
9 Anderlecht Sub 18 Anderlecht 22 38 35 25
10 AS Eupen Sub 18 Eupen 22 39 67 21
11 Lokeren Sub 18 Lokeren 22 21 71 15
12 Sint-Truiden Sub 18 Sint-Truiden 22 26 70 13

  USO DE MEMORIA  
4,779,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0067
Controller Execution Time ( Home / Category )  0.2842
Total Execution Time  0.2909
  CADENA URL  
/liga_belga_sub182020/grupo1/jugadores
  GET DATOS  
$_GET['/liga_belga_sub182020/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0105  SELECT type FROM routes WHERE alias = 'liga_belga_sub182020'
0.0213  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_belga_sub18' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2330 AND type_rel = 3
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2330 ORDER BY order_id ASC
0.0106  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2330 GROUP BY l.categoryId
0.0106  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=2330 GROUP BY l.year ORDER BY l.year DESC
0.0107  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 = 56399 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 56399 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0109  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 = 56399 AND dt.id IN (136551,136548,136543,136547,136545,136544,136550,136546,136549,136554,136552,136553) ORDER BY dt.relations DESC,dp.role ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 21:54:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-02 21:54:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-02 21:54:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-02 21:54:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0113  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_belga_sub18' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0108  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 events2020 e ON e.player_id = p.id AND e.league_id = 56399 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 56399 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.0107  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 events2020 e ON e.player_id = p.id AND e.league_id = 56399 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 56399 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0108  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 events2020 e ON e.player_id = p.id AND e.league_id = 56399 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 56399 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0119  SELECT *,(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 = 56399 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC