4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sint-Truiden Sub 21
TEMPORADA 2023/2024
LIGA BELGA SUB 21
Equipo PJ GF GC Puntos
1 Westerlo Sub 21 Westerlo 26 81 41 57
2 KAS Eupen Sub 21 Eupen 26 65 37 53
3 Kortrijk Sub 21 Kortrijk 26 52 32 52
4 KV Oostende Sub 21 Oostende 25 66 22 50
5 RWD Molenbeek Sub 21 Molenbeek 26 53 44 45
6 Sint-Truiden Sub 21 Sint-Truiden 26 43 33 36
7 SK Beveren Sub 21 Beveren 26 42 39 36
8 RFC Liège Sub 21 Liège 26 42 45 35
9 Deinze Sub 21 Deinze 26 41 49 34
10 Lommel SK Sub 21 Lommel 25 55 50 32
11 FCV Dender Sub 21 Dender 26 31 70 23
12 Lierse Kempenzonen Sub 21 Lierse 26 43 73 22
13 Patro Eisden Sub 21 Patro Eisden 26 39 71 15
14 Francs Borains Sub 21 Francs 26 29 76 15
TEMPORADA 2022/2023
LIGA BELGA SUB 21
Equipo PJ GF GC Puntos
1 KV Oostende Sub 21 Oostende 22 71 29 53
2 KAS Eupen Sub 21 Eupen 22 50 24 51
3 Sint-Truiden Sub 21 Sint-Truiden 22 47 16 46
4 Kortrijk Sub 21 Kortrijk 22 38 27 35
5 Westerlo Sub 21 Westerlo 22 50 49 30
6 SK Beveren Sub 21 Beveren 22 29 29 27
7 RWD Molenbeek Sub 21 Molenbeek 22 41 48 24
8 Lommel SK Sub 21 Lommel 22 47 60 24
9 FCV Dender Sub 21 Dender 22 32 56 24
10 Excelsior Virton Sub 21 Excelsior 22 46 58 23
11 Lierse Kempenzonen Sub 21 Lierse 22 34 52 20
12 Deinze Sub 21 Deinze 22 21 58 14
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
SEGUNDA BELGA SUB 21
Equipo PJ GF GC Puntos
1 Sporting Charleroi Sub 21 Sporting 8 18 7 18
2 Sint-Truiden Sub 21 Sint-Truiden 7 21 6 16
3 Cercle Brugge Sub 21 Cercle 8 19 14 15
4 Kortrijk Sub 21 Kortrijk 6 13 6 14
5 Saint-Gilloise Sub 21 Saint-Gilloi 8 16 10 14
6 KV Oostende Sub 21 Oostende 9 12 13 14
7 Antwerp Sub 21 Antwerp 7 12 10 13
8 Westerlo Sub 21 Westerlo 8 16 14 12
9 Deinze Sub 21 Deinze 6 11 12 10
10 Jong Essevee Jong Essevee 7 8 8 9
11 Lierse Kempenzonen Sub 21 Lierse 7 8 12 7
12 Excel Mouscron Sub 21 Excel 4 6 6 5
13 Beerschot-Wilrijk Sub 21 Beerschot-Wi 6 4 9 4
14 Lommel SK Sub 21 Lommel 8 6 16 4
15 RFC Seraing Sub 21 Seraing 7 9 22 1
16 RWD Molenbeek Sub 21 Molenbeek 6 4 18 0
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 2018/2019
LIGA BELGA SUB 21 GRUPO 3
Equipo PJ GF GC Puntos
1 Sporting Charleroi Sub 21 Sporting 13 31 10 32
2 Jong Essevee Jong Essevee 14 31 20 25
3 Sint-Truiden Sub 21 Sint-Truiden 13 28 25 20
4 Kortrijk Sub 21 Kortrijk 13 18 21 20
5 KV Oostende Sub 21 Oostende 13 14 22 17
6 KAS Eupen Sub 21 Eupen 12 28 25 15
7 SK Beveren Sub 21 Beveren 14 18 32 10
8 Excel Mouscron Sub 21 Excel 12 14 27 9
TEMPORADA 2017/2018
LIGA BELGA SUB 21 GRUPO 3
Equipo PJ GF GC Puntos
1 Sint-Truiden Sub 21 Sint-Truiden 14 47 17 36
2 Sporting Charleroi Sub 21 Sporting 14 29 23 21
3 Kortrijk Sub 21 Kortrijk 14 36 42 20
4 KAS Eupen Sub 21 Eupen 14 32 27 19
5 Antwerp Sub 21 Antwerp 13 28 32 18
6 Jong Essevee Jong Essevee 13 22 32 15
7 SK Beveren Sub 21 Beveren 14 25 34 14
8 Mouscron-Péruwelz Sub 21 Mouscron-Pé 14 20 32 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

  USO DE MEMORIA  
5,456,960 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6517
Total Execution Time  0.6529
  CADENA URL  
/historico/Sint-Truiden-Reservas
  GET DATOS  
$_GET['/historico/Sint-Truiden-Reservas']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0172  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 = 'Sint-Truiden-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.0150  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=65739 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=65739 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0302  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 = 73579
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65739 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1600 AND type_rel = 3
0.0149  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1600 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0156  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (452402,398461) ORDER BY n.cover_points DESC, update_date DESC
0.0160  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 = '65739' ORDER BY l.year DESC,cat.coefficient DESC
0.0166  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 = '65739' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0152  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 = '65739' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = 73579 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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=65739 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (73579) 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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 73579 AND teamId = 65739
0.0150  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 = 73579 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '65739' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65739' and rp.type = 4
0.0146  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 = '65739' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  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 = 73579 WHERE rp.league_id = 73579 AND rp.teamId = 65739 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.0154  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 = 73579 WHERE rp.league_id = 73579 AND rp.teamId = 65739 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152  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 = 73579 WHERE rp.league_id = 73579 AND rp.teamId = 65739 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 65739 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0152  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 = 73579 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.0151  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 = 68686 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.0152  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.0154  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 = 57046 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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.0148  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 = 44433 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 48926 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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.0147  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 = 42249 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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.0149  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.0146  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 = 73579 ORDER BY nameShow LIMIT 100