4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Genk

Genk

Entrenador: Wouter Vrancken

Temporada 1998/1999
TEMPORADA 1998/1999
LIGA BELGA
Equipo PJ GF GC Puntos
1 Genk Genk 34 74 38 73
2 Club Brugge Club Brugge 34 65 38 71
3 Anderlecht Anderlecht 34 76 39 70
4 Excelsior Mouscron Excelsior 34 76 47 66
5 Lokeren Lokeren 34 69 61 57
6 Lierse SK Lierse SK 34 73 44 54
7 Standard de Liège Standard 34 55 47 54
8 KAA Gent KAA Gent 34 55 59 52
9 Sint-Truidense V.V. Sint-Truiden 34 52 46 51
10 Harelbeke Harelbeke 34 44 46 41
11 KVC Westerlo Westerlo 34 56 62 40
12 Eendracht Aalst Eendracht 34 48 66 35
13 Charleroi Charleroi 34 37 55 32
14 Ekeren Ekeren 20 35 30 31
15 KSK Beveren KSK Beveren 34 33 60 30
16 KFC Lommel KFC Lommel 34 33 56 28
17 Kortrijk Kortrijk 34 49 81 25
18 KV Oostende KV Oostende 34 27 79 22
19 Germinal Beerschot Germinal 14 13 16 18
TEMPORADA 1997/1998
LIGA BELGA
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 34 78 29 84
2 Genk Genk 34 65 40 66
3 Germinal Beerschot Germinal 34 60 48 58
4 Anderlecht Anderlecht 34 53 37 57
5 Harelbeke Harelbeke 34 50 31 55
6 Lokeren Lokeren 34 65 69 52
7 Lierse SK Lierse SK 34 54 45 50
8 KAA Gent KAA Gent 34 50 44 47
9 Standard de Liège Standard 34 53 50 43
10 KVC Westerlo Westerlo 34 52 56 41
11 KFC Lommel KFC Lommel 34 46 50 41
12 Excelsior Mouscron Excelsior 34 39 45 41
13 Charleroi Charleroi 34 46 57 39
14 Sint-Truidense V.V. Sint-Truiden 34 32 45 37
15 Eendracht Aalst Eendracht 34 51 66 36
16 KSK Beveren KSK Beveren 34 30 48 32
17 RWD Molenbeek Molenbeek 34 39 74 31
18 Antwerp Antwerp 34 39 68 25
TEMPORADA 1996/1997
LIGA BELGA
Equipo PJ GF GC Puntos
1 Lierse SK Lierse SK 34 70 38 73
2 Club Brugge Club Brugge 34 69 34 71
3 Excelsior Mouscron Excelsior 34 60 38 61
4 Anderlecht Anderlecht 34 59 36 58
5 KFC Lommel KFC Lommel 34 50 48 57
6 Antwerp Antwerp 34 51 49 53
7 Standard de Liège Standard 34 55 55 50
8 Genk Genk 34 49 43 48
9 Harelbeke Harelbeke 34 50 42 47
10 Germinal Beerschot Germinal 34 56 57 46
11 Sint-Truidense V.V. Sint-Truiden 34 46 56 39
12 Lokeren Lokeren 34 41 57 38
13 Charleroi Charleroi 34 44 58 37
14 Eendracht Aalst Eendracht 34 44 55 36
15 KAA Gent KAA Gent 34 44 58 36
16 RWD Molenbeek Molenbeek 34 32 43 35
17 KV Mechelen KV Mechelen 34 33 55 31
18 Cercle Brugge Cercle 34 36 67 27
TEMPORADA 1993/1994
LIGA BELGA
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 34 79 31 79
2 Club Brugge Club Brugge 34 54 19 73
3 Charleroi Charleroi 34 61 49 59
4 RFC Seraing RFC Seraing 34 50 27 58
5 Antwerp Antwerp 34 44 38 55
6 Standard de Liège Standard 34 43 22 51
7 KV Oostende KV Oostende 34 45 41 46
8 KV Mechelen KV Mechelen 34 40 40 45
9 KSK Beveren KSK Beveren 34 42 40 44
10 Beerschot Beerschot 34 49 48 43
11 KFC Lommel KFC Lommel 34 42 50 40
12 Cercle Brugge Cercle 34 52 63 38
13 RFC Liège RFC Liège 34 40 59 38
14 Lierse SK Lierse SK 34 30 42 35
15 KAA Gent KAA Gent 34 43 57 34
16 RWD Molenbeek Molenbeek 34 32 49 32
17 KSV Waregem KSV Waregem 34 32 62 25
18 Genk Genk 34 38 79 22
TEMPORADA 1992/1993
LIGA BELGA
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 35 81 24 87
2 Standard de Liège Standard 34 69 43 63
3 KV Mechelen KV Mechelen 34 53 33 60
4 KSV Waregem KSV Waregem 34 78 45 59
5 Antwerp Antwerp 34 61 42 58
6 Club Brugge Club Brugge 34 49 32 56
7 Charleroi Charleroi 34 58 46 56
8 KSK Beveren KSK Beveren 34 47 42 52
9 KAA Gent KAA Gent 34 51 51 46
10 Lierse SK Lierse SK 34 41 51 43
11 RWD Molenbeek Molenbeek 34 39 45 41
12 RFC Liège RFC Liège 34 48 71 38
13 Cercle Brugge Cercle 34 65 73 37
14 Beerschot Beerschot 34 57 67 37
15 Genk Genk 35 37 51 35
16 KFC Lommel KFC Lommel 34 42 79 31
17 Rupel Boom Rupel Boom 34 40 95 25
18 Lokeren Lokeren 34 32 58 24
TEMPORADA 1991/1992
LIGA BELGA
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 34 68 29 74
2 Anderlecht Anderlecht 34 65 26 70
3 Standard de Liège Standard 34 59 28 62
4 Antwerp Antwerp 34 47 39 59
5 KV Mechelen KV Mechelen 34 47 23 58
6 KAA Gent KAA Gent 34 54 44 57
7 Lierse SK Lierse SK 34 53 50 51
8 Beerschot Beerschot 34 55 45 50
9 Cercle Brugge Cercle 34 57 57 44
10 KSV Waregem KSV Waregem 34 47 55 41
11 RWD Molenbeek Molenbeek 34 37 48 40
12 KSK Beveren KSK Beveren 34 42 52 38
13 Charleroi Charleroi 34 32 43 36
14 Lokeren Lokeren 34 38 51 35
15 Genk Genk 34 32 44 34
16 RFC Liège RFC Liège 34 33 47 34
17 Kortrijk Kortrijk 34 31 72 25
18 Eendracht Aalst Eendracht 34 18 62 20
TEMPORADA 1990/1991
LIGA BELGA
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 34 74 22 76
2 KV Mechelen KV Mechelen 34 59 24 70
3 KAA Gent KAA Gent 34 67 37 67
4 Club Brugge Club Brugge 34 61 27 65
5 K Beerschot VAC Beerschot 34 55 41 59
6 Standard de Liège Standard 34 51 42 58
7 Antwerp Antwerp 34 54 45 47
8 RFC Liège RFC Liège 35 44 45 46
9 Lokeren Lokeren 34 41 45 44
10 Charleroi Charleroi 34 36 36 42
11 RWD Molenbeek Molenbeek 34 40 45 38
12 Lierse SK Lierse SK 34 26 41 38
13 KSV Waregem KSV Waregem 34 33 45 36
14 Kortrijk Kortrijk 35 41 59 35
15 Genk Genk 34 31 66 35
16 Cercle Brugge Cercle 34 40 73 34
17 Sint-Truidense V.V. Sint-Truiden 34 30 51 28
18 Beerschot Beerschot 34 33 72 20
TEMPORADA 1988/1989
LIGA BELGA
Equipo PJ GF GC Puntos
1 KV Mechelen KV Mechelen 34 64 20 82
2 Anderlecht Anderlecht 34 83 36 75
3 RFC Liège RFC Liège 34 64 22 63
4 Club Brugge Club Brugge 34 67 44 60
5 Antwerp Antwerp 34 62 39 58
6 Standard de Liège Standard 34 46 43 50
7 Sint-Truidense V.V. Sint-Truiden 34 39 44 47
8 Kortrijk Kortrijk 34 53 44 44
9 KSV Waregem KSV Waregem 34 48 52 41
10 Lierse SK Lierse SK 34 29 46 39
11 KSK Beveren KSK Beveren 34 40 51 38
12 Racing Mechelen Racing 34 37 55 38
13 Lokeren Lokeren 34 44 57 37
14 Cercle Brugge Cercle 34 41 54 37
15 Charleroi Charleroi 34 31 49 35
16 RWD Molenbeek Molenbeek 34 36 59 35
17 K Beerschot VAC Beerschot 34 41 63 34
18 Genk Genk 34 20 67 17

  USO DE MEMORIA  
6,480,984 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5556
Total Execution Time  0.5576
  CADENA URL  
/historico/Genk/1999
  GET DATOS  
$_GET['/historico/Genk/1999']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0150  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 = 'Genk' AND l.year = 1999 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.0127  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=9785 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=9785 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=9785 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=9785 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133  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=9785 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9785 AND type_rel = 2
0.0153  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9785 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148  SELECT /*35 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 (41287,366,4400,4705,9529) ORDER BY n.cover_points DESC, update_date DESC
0.0145  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 = '9785' AND l.year = 1999 ORDER BY l.year DESC,cat.coefficient DESC
0.0140  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 = '9785' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0138  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=9785 AND l.year in (1998,1999,2000) 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 (42335,25284,23359,12040,10980,364) 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.0136  SELECT count(id) as num_players from rel_players WHERE league_id = 364 AND teamId = 9785
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 42335 AND teamId = 9785
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 23359 AND teamId = 9785
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 25284 AND teamId = 9785
0.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 10980 AND teamId = 9785
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 12040 AND teamId = 9785
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 FROM `tables1999` 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 = 363 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0144  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 events1999 e ON e.player_id = p.id AND e.league_id = 363 WHERE rp.league_id = 363 AND rp.teamId = 9785 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.0136  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 events1999 e ON e.player_id = p.id AND e.league_id = 363 WHERE rp.league_id = 363 AND rp.teamId = 9785 AND (e.action = 4 or e.action = 5) 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 events1999 e ON e.player_id = p.id AND e.league_id = 363 WHERE rp.league_id = 363 AND rp.teamId = 9785 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 9785 AND l.year <= 1999 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 `tables1999` 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 = 363 AND t.round = 34 ORDER BY team.conference 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 `tables1998` 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 = 364 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables1997` 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 = 365 AND t.round = 34 ORDER BY team.conference 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 `tables1994` 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 = 25344 AND t.round = 34 ORDER BY team.conference 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 `tables1993` 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 = 25357 AND t.round = 34 ORDER BY team.conference 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 `tables1992` 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 = 25361 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables1991` 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 = 25362 AND t.round = 34 ORDER BY team.conference 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 `tables1989` 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 = 25364 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 363 ORDER BY nameShow LIMIT 100