4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Mandel United
TEMPORADA 2023/2024
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Eendracht Aalst Eendracht 33 59 32 64
2 Dikkelvenne Dikkelvenne 33 66 46 56
3 Ninove Ninove 33 55 47 55
4 Merelbeke Merelbeke 33 66 40 54
5 Cercle Brugge Sub 21 Cercle 33 62 50 50
6 Voorde Appelterre Voorde 33 51 54 50
7 Jong Essevee Jong Essevee 33 52 42 48
8 Oudenaarde Oudenaarde 33 42 38 47
9 Oostkamp Oostkamp 33 56 67 46
10 KRC Gent KRC Gent 33 54 51 45
11 Gullegem Gullegem 33 54 63 44
12 Torhout Torhout 33 45 61 44
13 Zelzate Zelzate 33 62 57 42
14 Olsa Brakel Olsa Brakel 33 37 45 39
15 Mandel United Mandel 33 27 43 37
16 Racing Club Harelbeke Racing Club 33 45 55 36
17 Sparta Petegem Sparta 33 51 63 35
18 Wetteren Wetteren 33 48 78 32
TEMPORADA 2022/2023
DIVISIÓN NACIONAL BELGA 1
Equipo PJ GF GC Puntos
1 Patro Eisden Patro Eisden 38 84 23 86
2 RFC Liège RFC Liège 38 99 29 86
3 Francs Borains Francs 38 79 46 77
4 RAAL La Louviere RAAL 38 72 39 73
5 Gent II Gent II 38 59 43 67
6 Heist Heist 38 69 59 61
7 Olympic Charleroi Olympic 38 71 52 60
8 Knokke Knokke 38 65 58 60
9 Visé Visé 38 66 52 56
10 Thes Sport Thes Sport 38 58 52 53
11 Leuven II Leuven II 38 61 68 50
12 Tienen Tienen 38 50 60 46
13 Charleroi II Charleroi 38 41 58 44
14 Dessel Sport Dessel Sport 38 45 65 43
15 KVC Winkel Sport Winkel Sport 38 44 58 42
16 Hoogstraten Hoogstraten 38 46 60 41
17 Antwerp II Antwerp II 38 33 58 39
18 Ninove Ninove 38 39 75 35
19 Rupel Boom Rupel Boom 38 29 83 24
20 Mandel United Mandel 38 16 88 14
TEMPORADA 2021/2022
DIVISIÓN NACIONAL BELGA 1 GRUPO 1
Equipo PJ GF GC Puntos
1 RFC Liège RFC Liège 28 57 23 50
2 Knokke Knokke 28 48 33 48
3 Dessel Sport Dessel Sport 28 47 35 48
4 FCV Dender FCV Dender 28 41 30 46
5 Olympic Charleroi Olympic 28 41 31 46
6 Patro Eisden Patro Eisden 28 28 21 46
7 KVC Winkel Sport Winkel Sport 28 40 36 44
8 Visé Visé 28 45 34 39
9 Heist Heist 28 41 34 39
10 Thes Sport Thes Sport 28 35 35 39
11 Tienen Tienen 28 28 34 35
12 Rupel Boom Rupel Boom 28 26 39 33
13 Francs Borains Francs 28 26 29 32
14 Mandel United Mandel 28 26 50 19
15 La Louvière Centre Louvière 28 13 78 9
TEMPORADA 2020/2021
DIVISIÓN NACIONAL BELGA 1
Equipo PJ GF GC Puntos
1 Thes Sport Thes Sport 3 7 3 9
2 Tienen Tienen 4 5 5 6
3 Heist Heist 2 3 2 4
4 Mandel United Mandel 3 6 4 3
5 KVC Winkel Sport Winkel Sport 2 4 2 3
6 Francs Borains Francs 1 2 1 3
7 Knokke Knokke 2 2 1 3
8 Visé Visé 2 3 3 3
9 Olympic Charleroi Olympic 2 1 1 3
10 Patro Eisden Patro Eisden 1 2 2 1
11 RFC Liège RFC Liège 1 0 0 1
12 Rupel Boom Rupel Boom 2 0 2 1
13 FCV Dender FCV Dender 0 0 0 0
14 Dessel Sport Dessel Sport 0 0 0 0
15 La Louvière Centre Louvière 2 1 5 0
16 KSV Roeselare Roeselare 1 0 5 0
TEMPORADA 2019/2020
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Knokke Knokke 24 57 15 63
2 Mandel United Mandel 24 51 31 45
3 Ronse Ronse 24 42 26 45
4 Oudenaarde Oudenaarde 24 54 46 42
5 KRC Gent KRC Gent 24 36 29 41
6 Sparta Petegem Sparta 24 51 39 39
7 Gullegem Gullegem 24 36 32 39
8 Voorwaarts Zwevezele Voorwaarts 24 41 28 38
9 Racing Club Harelbeke Racing Club 24 30 35 35
10 Dikkelvenne Dikkelvenne 24 35 37 31
11 Westhoek Westhoek 24 29 48 28
12 Temse Temse 24 22 38 24
13 KSCT Menen KSCT Menen 24 28 47 20
14 Merelbeke Merelbeke 24 25 41 19
15 Sint-Niklaas Sint-Niklaas 24 22 49 16
16 VW Hamme VW Hamme 24 34 52 15
TEMPORADA 2018/2019
DIVISIÓN BELGA 2 GRUPO 3
Equipo PJ GF GC Puntos
1 KVC Winkel Sport Winkel Sport 30 60 24 69
2 Mandel United Mandel 30 58 30 60
3 Sparta Petegem Sparta 30 55 44 49
4 KRC Gent KRC Gent 30 56 39 48
5 Olympia Wijgmaal Olympia 30 52 46 47
6 Ronse Ronse 30 41 35 43
7 KSCT Menen KSCT Menen 30 51 56 42
8 Londerzeel Londerzeel 30 37 35 40
9 Diegem Sport Diegem Sport 30 37 51 39
10 Westhoek Westhoek 30 48 56 37
11 Dikkelvenne Dikkelvenne 30 28 42 36
12 Racing Club Harelbeke Racing Club 30 37 38 35
13 Gullegem Gullegem 30 40 52 35
14 Eppegem Eppegem 30 36 66 34
15 Tempo Overijse Tempo 30 36 50 29
16 Olsa Brakel Olsa Brakel 30 39 47 28

  USO DE MEMORIA  
5,751,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4455
Total Execution Time  0.4468
  CADENA URL  
/historico/Mandel-United
  GET DATOS  
$_GET['/historico/Mandel-United']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0169  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 = 'Mandel-United' 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.0130  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=112226 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=112226 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=112226 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=112226 AND type_rel = 2
0.0141  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 = '112226' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0141  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 = '112226' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0141  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=112226 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0134  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,72695,68256) 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.0144  SELECT count(id) as num_players from rel_players WHERE league_id = 68256 AND teamId = 112226
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 72695 AND teamId = 112226
0.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 112226
0.0128  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 = '112226' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '112226' 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 = '112226' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0138  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 = 72695 WHERE rp.league_id = 72695 AND rp.teamId = 112226 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.0141  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 = 72695 WHERE rp.league_id = 72695 AND rp.teamId = 112226 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 72695 WHERE rp.league_id = 72695 AND rp.teamId = 112226 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 112226 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0253  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 = 72695 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 68256 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 63431 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.0131  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 = 58503 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.0133  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 = 50975 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.0139  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 = 45034 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC