4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sporting Charleroi Sub 16
TEMPORADA 2023/2024
LIGA BELGA SUB 16
Equipo PJ GF GC Puntos
1 KAA Gent Sub 16 Gent 18 50 26 45
2 Anderlecht Sub 16 Anderlecht 18 55 26 35
3 Genk Sub 16 Genk Sub 16 18 51 24 35
4 Standard de Liège Sub 16 Standard 18 28 34 30
5 Club Brugge Sub 16 Club Brugge 17 39 33 26
6 Sporting Charleroi Sub 16 Sporting 17 31 32 23
7 Antwerp Sub 16 Antwerp 18 27 32 22
8 Zulte-Waregem Sub 16 Zulte-Warege 18 15 31 18
9 Leuven Sub 16 Leuven 18 24 43 10
10 KV Mechelen Sub 16 Mechelen 18 18 57 7
TEMPORADA 2022/2023
LIGA BELGA SUB 16 GRUPO 1
Equipo PJ GF GC Puntos
1 Genk Sub 16 Genk Sub 16 22 69 11 64
2 Anderlecht Sub 16 Anderlecht 22 74 23 54
3 Standard de Liège Sub 16 Standard 22 43 26 41
4 Sporting Charleroi Sub 16 Sporting 22 42 31 39
5 Club Brugge Sub 16 Club Brugge 22 56 37 37
6 Antwerp Sub 16 Antwerp 22 31 51 25
7 KAA Gent Sub 16 Gent 22 40 52 23
8 Zulte-Waregem Sub 16 Zulte-Warege 22 32 48 21
9 AS Eupen Sub 16 Eupen 22 28 55 21
10 Leuven Sub 16 Leuven 22 29 42 19
11 KVC Westerlo Sub 16 Westerlo 22 22 51 16
12 KV Mechelen Sub 16 Mechelen 22 36 75 16
TEMPORADA 2021/2022
LIGA BELGA SUB 16
Equipo PJ GF GC Puntos
1 Anderlecht Sub 16 Anderlecht 24 72 17 64
2 Genk Sub 16 Genk Sub 16 24 71 37 54
3 Standard de Liège Sub 16 Standard 24 43 37 43
4 Sporting Charleroi Sub 16 Sporting 24 50 40 41
5 Club Brugge Sub 16 Club Brugge 24 55 36 40
6 Sint-Truiden Sub 16 Sint-Truiden 24 39 38 33
7 KAA Gent Sub 16 Gent 23 40 47 31
8 Leuven Sub 16 Leuven 24 46 44 30
9 Antwerp Sub 16 Antwerp 24 38 45 23
10 KV Mechelen Sub 16 Mechelen 24 32 53 21
11 Zulte-Waregem Sub 16 Zulte-Warege 24 27 47 18
12 Cercle Brugge Sub 16 Cercle 23 33 72 17
13 KVC Westerlo Sub 16 Westerlo 24 33 66 15
TEMPORADA 2020/2021
LIGA BELGA SUB 16
Equipo PJ GF GC Puntos
1 Anderlecht Sub 16 Anderlecht 7 21 4 21
2 Genk Sub 16 Genk Sub 16 8 28 12 21
3 Standard de Liège Sub 16 Standard 8 22 13 18
4 KAA Gent Sub 16 Gent 8 27 26 17
5 KV Mechelen Sub 16 Mechelen 8 12 16 11
6 Club Brugge Sub 16 Club Brugge 8 20 16 10
7 Zulte-Waregem Sub 16 Zulte-Warege 7 7 14 7
8 Leuven Sub 16 Leuven 7 11 16 6
9 Sporting Charleroi Sub 16 Sporting 8 13 19 6
10 KVC Westerlo Sub 16 Westerlo 7 9 18 5
11 Sint-Truiden Sub 16 Sint-Truiden 4 2 6 1
12 Cercle Brugge Sub 16 Cercle 6 12 24 0
TEMPORADA 2019/2020
LIGA BELGA SUB 16
Equipo PJ GF GC Puntos
1 Genk Sub 16 Genk Sub 16 22 86 27 58
2 Anderlecht Sub 16 Anderlecht 22 57 27 47
3 Standard de Liège Sub 16 Standard 22 51 35 42
4 Sint-Truiden Sub 16 Sint-Truiden 21 44 20 40
5 Club Brugge Sub 16 Club Brugge 22 54 33 39
6 Sporting Charleroi Sub 16 Sporting 22 31 34 31
7 KAA Gent Sub 16 Gent 21 35 37 26
8 AS Eupen Sub 16 Eupen 22 31 53 25
9 Leuven Sub 16 Leuven 22 31 54 19
10 KV Mechelen Sub 16 Mechelen 22 42 65 16
11 Zulte-Waregem Sub 16 Zulte-Warege 22 25 51 15
12 Lokeren Sub 16 Lokeren 22 30 81 14

  USO DE MEMORIA  
5,013,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0723
Total Execution Time  0.0736
  CADENA URL  
/historico/Sporting-Charleroi-Sub16
  GET DATOS  
$_GET['/historico/Sporting-Charleroi-Sub16']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0041  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 = 74110
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=123759 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2200 AND type_rel = 3
0.0023  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 = '123759' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 74110 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=123759 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0057  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 (74112) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 74112 AND teamId = 123759
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 74110 AND t.round = 18 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = 74110 WHERE rp.league_id = 74110 AND rp.teamId = 123759 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.0034  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 = 74110 WHERE rp.league_id = 74110 AND rp.teamId = 123759 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 74110 WHERE rp.league_id = 74110 AND rp.teamId = 123759 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 123759 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  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 = 74110 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.0021  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 = 68367 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.0022  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 = 63905 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 59147 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.0021  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 = 51893 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