4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Genk Sub 18 Genk Sub 18 17 42 24 40
2 Anderlecht Sub 18 Anderlecht 17 44 16 36
3 Standard Lieja Sub 18 Standard 16 31 17 33
4 Leuven Sub 18 Leuven 18 38 26 32
5 KAA Gent Sub 18 Gent 17 34 22 31
6 Club Brugge Sub 18 Club Brugge 17 29 29 27
7 Antwerp Sub 18 Antwerp 18 21 33 18
8 Zulte-Waregem Sub 18 Zulte-Warege 18 27 40 16
9 Sporting Charleroi Sub 18 Sporting 18 21 43 10
10 KV Mechelen Sub 18 Mechelen 18 17 54 4
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 KAA Gent Sub 18 Gent 22 56 20 50
2 Anderlecht Sub 18 Anderlecht 22 56 25 46
3 Sporting Charleroi Sub 18 Sporting 22 47 34 46
4 Genk Sub 18 Genk Sub 18 22 45 25 39
5 Club Brugge Sub 18 Club Brugge 22 43 38 36
6 Standard Lieja Sub 18 Standard 22 44 51 30
7 KV Mechelen Sub 18 Mechelen 22 49 41 29
8 Leuven Sub 18 Leuven 22 40 51 23
9 AS Eupen Sub 18 Eupen 22 31 47 21
10 Zulte-Waregem Sub 18 Zulte-Warege 22 22 49 18
11 Antwerp Sub 18 Antwerp 22 25 50 17
12 KVC Westerlo Sub 18 Westerlo 22 34 61 17
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Genk Sub 18 Genk Sub 18 24 93 30 62
2 Club Brugge Sub 18 Club Brugge 24 74 31 58
3 Anderlecht Sub 18 Anderlecht 24 58 40 45
4 Standard Lieja Sub 18 Standard 24 55 37 43
5 KAA Gent Sub 18 Gent 24 51 42 37
6 Zulte-Waregem Sub 18 Zulte-Warege 24 34 40 34
7 Sporting Charleroi Sub 18 Sporting 24 32 42 32
8 Sint-Truiden Sub 18 Sint-Truiden 24 28 34 30
9 KV Mechelen Sub 18 Mechelen 24 45 52 27
10 Antwerp Sub 18 Antwerp 24 29 46 25
11 Leuven Sub 18 Leuven 24 39 56 24
12 Cercle Brugge Sub 18 Cercle 24 44 80 20
13 KVC Westerlo Sub 18 Westerlo 24 21 73 2
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2019/2020
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
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Genk Sub 18 Genk Sub 18 22 68 25 53
2 Club Brugge Sub 18 Club Brugge 22 52 23 50
3 KAA Gent Sub 18 Gent 22 60 32 45
4 Standard Lieja Sub 18 Standard 22 47 27 41
5 Anderlecht Sub 18 Anderlecht 22 42 29 38
6 Sporting Charleroi Sub 18 Sporting 22 37 32 33
7 Leuven Sub 18 Leuven 22 42 31 32
8 Sint-Truiden Sub 18 Sint-Truiden 22 37 47 30
9 KV Mechelen Sub 18 Mechelen 22 26 33 26
10 Lokeren Sub 18 Lokeren 22 22 57 17
11 Cercle Brugge Sub 18 Cercle 22 19 76 10
12 Zulte-Waregem Sub 18 Zulte-Warege 22 21 61 5

  USO DE MEMORIA  
5,111,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0034
Controller Execution Time ( Home / Category )  0.3958
Total Execution Time  0.3992
  CADENA URL  
/liga_belga_sub182024/grupo1/historico
  GET DATOS  
$_GET['/liga_belga_sub182024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0125  SELECT type FROM routes WHERE alias = 'liga_belga_sub182024'
0.0252  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 = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2330 AND type_rel = 3
0.0128  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2330 ORDER BY order_id ASC
0.0125  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2330 GROUP BY l.categoryId
0.0126  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.0126  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 = 73591 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2330 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 73591 AND t.round = 18 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 `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 = 68366 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
0.0126  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 = 59156 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
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 = 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
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 = 59258 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 16:32:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 16:32:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 16:32:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 16:32:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  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 = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0127  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 = 73591 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73591 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.0165  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 = 73591 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73591 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0130  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 = 73591 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73591 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0135  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 = 73591 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC