4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Etterbeek
TEMPORADA 2022/2023
PROVINCIAL BÉLGICA GRUPO 4
Equipo PJ GF GC Puntos
1 Perwez Perwez 30 61 25 66
2 Genappe Genappe 30 68 32 58
3 Union Lasne-Ohain Union 30 62 36 56
4 Kosova Schaerbeek Kosova 30 56 55 56
5 Sporting Bruxelles Sporting 30 61 46 50
6 Grez-Doiceau Grez-Doiceau 30 62 41 47
7 Stade Everois Stade 30 43 46 43
8 Saint-Josse Saint-Josse 30 40 47 41
9 BX Brussels BX Brussels 30 52 59 39
10 Saint-Michel Saint-Michel 30 41 41 38
11 Tubize II Tubize II 30 63 64 38
12 NSeth Berchem NSeth 30 46 65 38
13 Ixelles Ixelles 30 36 54 33
14 AFC Evere AFC Evere 30 50 72 30
15 Etterbeek Etterbeek 30 32 64 29
16 Stockel Stockel 30 46 72 19
TEMPORADA 2021/2022
PROVINCIAL BÉLGICA GRUPO 9
Equipo PJ GF GC Puntos
1 Léopold Uccle-Woluwé Léopold 30 76 32 70
2 Grez-Doiceau Grez-Doiceau 30 82 27 65
3 NSeth Berchem NSeth 30 73 46 64
4 Sporting Bruxelles Sporting 30 71 31 60
5 Saint-Josse Saint-Josse 30 69 33 60
6 Genappe Genappe 30 69 45 56
7 Kosova Schaerbeek Kosova 30 55 42 52
8 Union Lasne-Ohain Union 30 60 39 50
9 Tubize II Tubize II 30 53 55 43
10 Stade Everois Stade 30 49 48 34
11 Ixelles Ixelles 30 44 55 30
12 Etterbeek Etterbeek 30 61 70 26
13 BX Brussels BX Brussels 30 36 72 21
14 Schaerbeek Schaerbeek 30 34 73 17
15 Nivellois Nivellois 30 28 141 15
16 Brainoise Brainoise 30 34 85 8
TEMPORADA 2020/2021
PROVINCIAL BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 NSeth Berchem NSeth 5 13 4 12
2 Grez-Doiceau Grez-Doiceau 4 17 4 9
3 Kosova Schaerbeek Kosova 4 8 3 9
4 Stade Everois Stade 4 5 2 9
5 Brainoise Brainoise 5 7 5 9
6 Union Lasne-Ohain Union 3 4 0 7
7 Genappe Genappe 4 12 7 6
8 BX Brussels BX Brussels 4 8 5 6
9 Saint-Josse Saint-Josse 5 5 7 6
10 Sporting Bruxelles Sporting 3 6 7 4
11 Léopold Uccle-Woluwé Léopold 3 4 5 4
12 Ixelles Ixelles 5 4 9 4
13 Nivellois Nivellois 2 5 5 3
14 Etterbeek Etterbeek 4 0 5 1
15 Schaerbeek Schaerbeek 3 3 10 1
16 Walhain Walhain 4 2 25 0
TEMPORADA 2019/2020
PROVINCIAL BÉLGICA GRUPO 5
Equipo PJ GF GC Puntos
1 Crossing Schaerbeek Crossing 22 46 16 50
2 Stockel Stockel 22 57 28 46
3 Saint-Josse Saint-Josse 22 36 15 42
4 BX Brussels BX Brussels 22 39 18 40
5 Union Lasne-Ohain Union 22 42 27 38
6 Ixelles Ixelles 23 38 30 34
7 Stade Everois Stade 23 34 41 34
8 Nivellois Nivellois 22 29 23 31
9 Sporting Bruxelles Sporting 22 37 37 31
10 Genappe Genappe 22 29 35 28
11 Etterbeek Etterbeek 22 31 41 26
12 Football Club Schaerbeek Football 22 32 48 24
13 US d'Ophain US d'Ophain 22 24 35 22
14 Waterloo Waterloo 22 16 40 15
15 Boitsfort Boitsfort 22 24 46 14
16 Villers-La-Ville Villers-La-V 22 21 55 12
17 Diest Diest 24 55 24 49
18 Rhodienne-De Hoek Rhodienne-De 24 34 26 48
19 Kampenhout Kampenhout 24 43 22 46
20 Grimbergen Grimbergen 24 55 36 44
21 Bertem-Leefdaal Bertem-Leefd 24 51 41 40
22 Stade Bierbeek Stade 24 42 28 37
23 SC Aarschot SC Aarschot 24 38 30 36
24 Liedekerke Liedekerke 24 32 35 35
25 KV Tervuren-Duisburg Tervuren-Dui 24 39 41 32
26 Hoegaarden-Outgaarden Hoegaarden-O 24 41 42 30
27 Melsbroek Melsbroek 24 31 36 30
28 Borght Borght 24 34 40 29
29 Huldenberg Huldenberg 24 31 41 26
30 Kester-Gooik Kester-Gooik 24 30 46 25
31 Meise Meise 24 18 43 14
32 Woluwe Woluwe 24 26 69 12
TEMPORADA 2018/2019
PROVINCIAL BÉLGICA GRUPO 7
Equipo PJ GF GC Puntos
1 Jodoigne Jodoigne 30 80 45 57
2 Kosova Schaerbeek Kosova 30 71 47 56
3 Etterbeek Etterbeek 30 67 41 55
4 BX Brussels BX Brussels 30 51 32 52
5 Villers-La-Ville Villers-La-V 30 44 38 52
6 Schaerbeek-Evere Schaerbeek-E 30 66 38 50
7 Ixelles Ixelles 30 36 26 48
8 Waterloo Waterloo 30 51 53 43
9 Saint-Josse Saint-Josse 30 49 38 42
10 Union Lasne-Ohain Union 30 52 51 40
11 Boitsfort Boitsfort 30 41 46 36
12 Stade Everois Stade 30 49 75 35
13 Sporting Bruxelles Sporting 30 44 57 28
14 Genappe Genappe 30 32 57 23
15 Saint-Michel Saint-Michel 30 35 70 20
16 Renaissance Forestoise Renaissance 30 41 95 18
17 Linden Linden 30 52 23 65
18 Diest Diest 30 57 34 60
19 Liedekerke Liedekerke 30 60 30 58
20 Stade Bierbeek Stade 30 62 29 56
21 Melsbroek Melsbroek 30 43 44 49
22 KV Tervuren-Duisburg Tervuren-Dui 30 58 50 47
23 Grimbergen Grimbergen 30 57 52 42
24 Bertem-Leefdaal Bertem-Leefd 30 54 42 40
25 SC Aarschot SC Aarschot 30 46 38 40
26 Borght Borght 30 48 47 39
27 Huldenberg Huldenberg 30 34 43 37
28 Rhodienne-De Hoek Rhodienne-De 30 42 46 36
29 Veltem Veltem 30 50 58 33
30 Herent Herent 30 52 65 33
31 Hoeilaart Hoeilaart 30 42 73 26
32 Sterrebeek Sterrebeek 30 23 106 12

  USO DE MEMORIA  
5,612,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4888
Total Execution Time  0.4900
  CADENA URL  
/historico/Rrc-Detterbeek
  GET DATOS  
$_GET['/historico/Rrc-Detterbeek']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0166  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 = 'Rrc-Detterbeek' 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.0125  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=89302 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=89302 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0257  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 = 73206
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=89302 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=651 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 651 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0129  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 (1299022,1298998,1128382,1083492,984548) ORDER BY n.cover_points DESC, update_date DESC
0.0129  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 = '89302' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '89302' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '89302' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 73206 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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=89302 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (73206,68713) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 68713 AND teamId = 89302
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 89302
0.0127  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 = 73206 AND t.round = 11 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '89302' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '89302' and rp.type = 4
0.0128  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 = '89302' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128  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 = 73206 WHERE rp.league_id = 73206 AND rp.teamId = 89302 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.0127  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 = 73206 WHERE rp.league_id = 73206 AND rp.teamId = 89302 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  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 = 73206 WHERE rp.league_id = 73206 AND rp.teamId = 89302 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 89302 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130  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 = 68713 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 63513 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 58302 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 51059 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 44844 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC