4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Mechelen Sub 21
TEMPORADA 2023/2024
DIVISIÓN BELGA 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Belisia Bilzen Belisia 34 71 37 71
2 Sporting Hasselt Sporting 34 67 37 67
3 Lyra-Lierse Lyra-Lierse 34 61 47 60
4 Rupel Boom Rupel Boom 34 62 58 60
5 Racing Mechelen Racing 34 61 46 55
6 KFC Houtvenne Houtvenne 34 48 43 55
7 Bocholter Bocholter 34 59 46 54
8 Tongeren Tongeren 34 50 48 48
9 FC Lebbeke FC Lebbeke 34 49 53 47
10 Mechelen Sub 21 Mechelen 34 57 49 46
11 Berchem Sport Berchem 34 44 43 46
12 Diegem Sport Diegem Sport 34 62 63 45
13 Wezel Wezel 34 59 67 43
14 Hades Hades 34 54 60 42
15 KFC Lille KFC Lille 34 48 60 40
16 Tempo Overijse Tempo 34 33 59 28
17 KSC City Pirates City Pirates 34 41 86 25
18 Londerzeel Londerzeel 34 34 58 25
TEMPORADA 2022/2023
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Cappellen Cappellen 34 61 37 66
2 Hades Hades 34 51 32 62
3 Sporting Hasselt Sporting 34 52 42 58
4 Belisia Bilzen Belisia 34 55 37 56
5 Tongeren Tongeren 34 61 56 56
6 Lyra-Lierse Lyra-Lierse 34 64 45 55
7 Mechelen Sub 21 Mechelen 34 60 48 54
8 Diegem Sport Diegem Sport 34 56 51 52
9 Bocholt Bocholt 34 54 46 49
10 Racing Mechelen Racing 34 45 36 47
11 KFC Lille KFC Lille 34 55 59 46
12 KSC City Pirates City Pirates 34 56 75 44
13 Londerzeel Londerzeel 34 51 48 41
14 Berchem Sport Berchem 34 45 61 38
15 FC Lebbeke FC Lebbeke 34 47 64 38
16 KFC Turnhout Turnhout 34 68 81 34
17 Pepingen-Halle Pepingen-Hal 34 36 66 28
18 Beerschot-Wilrijk Sub 21 Beerschot-Wi 34 40 73 27
TEMPORADA 2021/2022
LIGA BELGA SUB 21
Equipo PJ GF GC Puntos
1 Genk Sub 21 Genk Sub 21 22 65 22 57
2 Anderlecht Sub 21 Anderlecht 22 51 16 50
3 Club Brugge Sub 21 Club Brugge 22 48 13 43
4 Standard Liège Sub 21 Standard 22 37 29 41
5 KAA Gent Sub 21 Gent 22 38 29 40
6 Sint-Truiden Sub 21 Sint-Truiden 22 27 40 23
7 Sporting Charleroi Sub 21 Sporting 22 21 47 22
8 OH Leuven Sub 21 Leuven 22 27 39 21
9 Cercle Brugge Sub 21 Cercle 22 27 35 21
10 Antwerp Sub 21 Antwerp 22 26 42 20
11 Jong Essevee Jong Essevee 22 28 52 18
12 Mechelen Sub 21 Mechelen 22 18 49 16
TEMPORADA 2020/2021
LIGA BELGA SUB 21
Equipo PJ GF GC Puntos
1 Anderlecht Sub 21 Anderlecht 6 13 3 14
2 Standard Liège Sub 21 Standard 8 12 8 14
3 Genk Sub 21 Genk Sub 21 5 12 4 13
4 KAS Eupen Sub 21 Eupen 7 14 8 12
5 KAA Gent Sub 21 Gent 5 8 10 7
6 OH Leuven Sub 21 Leuven 8 7 10 7
7 SK Beveren Sub 21 Beveren 7 7 21 4
8 Mechelen Sub 21 Mechelen 8 4 13 3
TEMPORADA 2019/2020
LIGA BELGA SUB 21
Equipo PJ GF GC Puntos
1 Anderlecht Sub 21 Anderlecht 15 33 21 29
2 Club Brugge Sub 21 Club Brugge 13 28 21 27
3 KAA Gent Sub 21 Gent 16 36 22 26
4 Mechelen Sub 21 Mechelen 17 36 32 25
5 Standard Liège Sub 21 Standard 14 27 23 20
6 Genk Sub 21 Genk Sub 21 15 26 21 20
7 OH Leuven Sub 21 Leuven 16 29 31 20
8 Sint-Truiden Sub 21 Sint-Truiden 16 17 61 4
TEMPORADA 2017/2018
LIGA BELGA SUB 21 GRUPO 2
Equipo PJ GF GC Puntos
1 Anderlecht Sub 21 Anderlecht 14 41 16 30
2 Club Brugge Sub 21 Club Brugge 14 33 29 22
3 KAA Gent Sub 21 Gent 14 36 30 20
4 Genk Sub 21 Genk Sub 21 14 33 28 19
5 Lokeren Sub 21 Lokeren 14 18 26 18
6 Standard Liège Sub 21 Standard 14 26 32 16
7 KV Oostende Sub 21 Oostende 14 19 30 15
8 Mechelen Sub 21 Mechelen 14 24 39 14
TEMPORADA 2016/2017
LIGA BELGA SUB 21
Equipo PJ GF GC Puntos
1 KAA Gent Sub 21 Gent 15 40 18 34
2 Anderlecht Sub 21 Anderlecht 15 33 14 30
3 Genk Sub 21 Genk Sub 21 15 25 15 29
4 Club Brugge Sub 21 Club Brugge 15 35 26 27
5 Sint-Truiden Sub 21 Sint-Truiden 15 41 34 25
6 Standard Liège Sub 21 Standard 15 32 22 24
7 Lokeren Sub 21 Lokeren 15 24 21 23
8 Mechelen Sub 21 Mechelen 15 21 28 20
9 Jong Essevee Jong Essevee 15 22 29 19
10 Sporting Charleroi Sub 21 Sporting 15 15 19 19
11 Kortrijk Sub 21 Kortrijk 15 27 27 17
12 SK Beveren Sub 21 Beveren 15 14 23 16
13 KV Oostende Sub 21 Oostende 15 21 26 15
14 Mouscron-Péruwelz Sub 21 Mouscron-Pé 15 15 27 13
15 KAS Eupen Sub 21 Eupen 15 19 27 12
16 Westerlo Sub 21 Westerlo 15 9 37 9
TEMPORADA 2015/2016
LIGA BELGA SUB 21 GRUPO 1
Equipo PJ GF GC Puntos
1 Standard Liège Sub 21 Standard 14 55 21 39
2 KV Oostende Sub 21 Oostende 15 36 21 28
3 Genk Sub 21 Genk Sub 21 15 32 20 28
4 Sint-Truiden Sub 21 Sint-Truiden 15 35 26 27
5 Anderlecht Sub 21 Anderlecht 15 28 20 27
6 SK Beveren Sub 21 Beveren 15 27 26 25
7 Mechelen Sub 21 Mechelen 15 29 21 23
8 Lokeren Sub 21 Lokeren 15 27 23 22
9 Club Brugge Sub 21 Club Brugge 15 27 28 22
10 Mouscron-Péruwelz Sub 21 Mouscron-Pé 15 35 31 18
11 OH Leuven Sub 21 Leuven 15 20 28 17
12 Sporting Charleroi Sub 21 Sporting 15 19 33 16
13 KAA Gent Sub 21 Gent 14 19 30 13
14 Kortrijk Sub 21 Kortrijk 15 23 46 13
15 Westerlo Sub 21 Westerlo 15 16 33 11
16 Jong Essevee Jong Essevee 15 27 48 10
TEMPORADA 2014/2015
LIGA BELGA SUB 21 GRUPO 1
Equipo PJ GF GC Puntos
1 Lokeren Sub 21 Lokeren 15 37 14 37
2 Club Brugge Sub 21 Club Brugge 15 48 20 31
3 Kortrijk Sub 21 Kortrijk 15 35 28 29
4 Standard Liège Sub 21 Standard 15 32 24 28
5 Genk Sub 21 Genk Sub 21 15 39 21 27
6 Anderlecht Sub 21 Anderlecht 15 34 20 26
7 Jong Essevee Jong Essevee 15 27 25 22
8 KAA Gent Sub 21 Gent 15 26 24 21
9 Lierse SK Sub 21 Lierse 15 26 27 21
10 Mechelen Sub 21 Mechelen 15 29 40 19
11 Sporting Charleroi Sub 21 Sporting 15 29 33 18
12 Cercle Brugge Sub 21 Cercle 15 17 33 12
13 Westerlo Sub 21 Westerlo 15 21 40 12
14 KV Oostende Sub 21 Oostende 15 17 33 11
15 Mouscron-Péruwelz Sub 21 Mouscron-Pé 15 21 38 8
16 SK Beveren Sub 21 Beveren 15 15 33 8

  USO DE MEMORIA  
5,753,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1083
Total Execution Time  0.1097
  CADENA URL  
/historico/Mechelen-Reservas
  GET DATOS  
$_GET['/historico/Mechelen-Reservas']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0028  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Mechelen-Reservas' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=61033 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=61033 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=61033 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 72696
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61033 AND type_rel = 2
0.0024  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '61033' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '61033' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '61033' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 72696 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=61033 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (72696,71432) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72696 AND teamId = 61033
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 61033
0.0023  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 = 72696 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '61033' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61033' and rp.type = 4
0.0020  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '61033' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031  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 = 72696 WHERE rp.league_id = 72696 AND rp.teamId = 61033 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.0029  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 = 72696 WHERE rp.league_id = 72696 AND rp.teamId = 61033 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 72696 WHERE rp.league_id = 72696 AND rp.teamId = 61033 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 61033 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 = 72696 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 68500 AND t.round = 34 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 `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 = 64067 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 `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 = 57045 AND t.round = 21 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 = 50983 AND t.round = 17 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 `tables2018` 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 = 38941 AND t.round = 15 ORDER BY team.conference 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 `tables2018` 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 = 42248 AND t.round = 14 ORDER BY team.conference 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 `tables2017` 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 = 34015 AND t.round = 15 ORDER BY team.conference 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 `tables2016` 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 = 15955 AND t.round = 15 ORDER BY team.conference 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 `tables2015` 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 = 9369 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2015` 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 = 15791 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72696 ORDER BY nameShow LIMIT 100