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 2010/2011
TEMPORADA 2010/2011
LIGA BELGA GRUPO 2
Equipo PJ GF GC Puntos
1 Genk Genk 10 16 12 51
2 Standard de Liège Standard 10 18 6 51
3 Anderlecht Anderlecht 10 14 16 44
4 Club Brugge Club Brugge 10 13 6 43
5 KAA Gent KAA Gent 10 9 22 33
6 Lokeren Lokeren 10 9 17 31
TEMPORADA 2009/2010
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 28 62 20 69
2 Club Brugge Club Brugge 28 52 33 57
3 KAA Gent KAA Gent 28 49 30 49
4 Kortrijk Kortrijk 28 39 30 45
5 Sint-Truidense V.V. Sint-Truiden 28 35 35 42
6 Zulte-Waregem Zulte-Warege 28 39 32 41
7 KV Mechelen KV Mechelen 28 36 46 39
8 Standard de Liège Standard 28 38 34 39
9 Cercle Brugge Cercle 28 45 40 38
10 KVC Westerlo Westerlo 29 29 34 35
11 Germinal Beerschot Germinal 28 30 43 35
12 Genk Genk 28 33 31 34
13 Charleroi Charleroi 28 28 45 23
14 Lokeren Lokeren 28 22 54 18
15 KSV Roeselare Roeselare 28 29 58 18
16 Excelsior Mouscron Excelsior 1 0 1 0
TEMPORADA 2008/2009
LIGA BELGA
Equipo PJ GF GC Puntos
1 Standard de Liège Standard 34 66 26 77
2 Anderlecht Anderlecht 34 75 30 77
3 Club Brugge Club Brugge 34 59 50 59
4 KAA Gent KAA Gent 34 67 42 59
5 Zulte-Waregem Zulte-Warege 34 55 36 55
6 KVC Westerlo Westerlo 34 42 38 52
7 Lokeren Lokeren 34 40 32 51
8 Genk Genk 34 48 51 50
9 Cercle Brugge Cercle 34 48 53 47
10 KV Mechelen KV Mechelen 34 46 52 46
11 Excelsior Mouscron Excelsior 34 42 49 44
12 Charleroi Charleroi 34 43 48 43
13 Germinal Beerschot Germinal 34 44 42 42
14 Kortrijk Kortrijk 34 37 55 38
15 FCV Dender FCV Dender 34 44 58 35
16 KSV Roeselare Roeselare 34 33 59 30
17 Tubize Tubize 34 35 77 27
18 Mons Mons 34 31 57 19
TEMPORADA 2007/2008
LIGA BELGA
Equipo PJ GF GC Puntos
1 Standard de Liège Standard 34 61 19 77
2 Anderlecht Anderlecht 34 59 31 70
3 Club Brugge Club Brugge 34 45 30 67
4 Cercle Brugge Cercle 34 62 33 60
5 Germinal Beerschot Germinal 34 46 34 55
6 KAA Gent KAA Gent 34 57 46 52
7 Zulte-Waregem Zulte-Warege 34 47 54 47
8 Charleroi Charleroi 34 41 45 46
9 KVC Westerlo Westerlo 34 43 37 45
10 Genk Genk 34 54 55 45
11 Excelsior Mouscron Excelsior 34 38 43 42
12 Lokeren Lokeren 34 32 33 42
13 KV Mechelen KV Mechelen 34 45 52 40
14 KSV Roeselare Roeselare 34 36 55 38
15 FCV Dender FCV Dender 34 33 59 33
16 Mons Mons 34 37 45 33
17 Sint-Truidense V.V. Sint-Truiden 34 32 58 27
18 RWD Molenbeek Molenbeek 34 27 66 19
TEMPORADA 2006/2007
LIGA BELGA
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 34 75 30 77
2 Genk Genk 34 71 37 72
3 Standard de Liège Standard 34 62 38 64
4 KAA Gent KAA Gent 34 56 40 60
5 Charleroi Charleroi 34 51 40 60
6 Club Brugge Club Brugge 34 58 40 51
7 Germinal Beerschot Germinal 34 52 46 51
8 KVC Westerlo Westerlo 34 41 44 46
9 Mons Mons 34 41 41 44
10 Excelsior Mouscron Excelsior 34 51 55 42
11 KSV Roeselare Roeselare 34 50 72 39
12 Cercle Brugge Cercle 34 31 36 38
13 RWD Molenbeek Molenbeek 34 39 50 38
14 Zulte-Waregem Zulte-Warege 34 40 54 37
15 Sint-Truidense V.V. Sint-Truiden 34 39 52 35
16 Lokeren Lokeren 34 32 48 30
17 Lierse SK Lierse SK 34 33 66 26
18 KSK Beveren KSK Beveren 34 31 64 25
TEMPORADA 2005/2006
LIGA BELGA
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 34 72 27 70
2 Standard de Liège Standard 34 51 28 65
3 Club Brugge Club Brugge 34 51 33 64
4 KAA Gent KAA Gent 34 48 34 61
5 Genk Genk 34 48 38 57
6 Zulte-Waregem Zulte-Warege 34 51 49 49
7 Germinal Beerschot Germinal 34 45 45 47
8 Lokeren Lokeren 34 48 49 47
9 KVC Westerlo Westerlo 34 42 48 46
10 RWD Molenbeek Molenbeek 34 30 30 46
11 Charleroi Charleroi 34 39 39 45
12 KSV Roeselare Roeselare 34 44 42 41
13 Cercle Brugge Cercle 34 38 56 38
14 Excelsior Mouscron Excelsior 34 43 43 37
15 Sint-Truidense V.V. Sint-Truiden 34 36 49 34
16 KSK Beveren KSK Beveren 34 35 55 33
17 Lierse SK Lierse SK 34 22 52 32
18 RAA Louvieroise Louvieroise 34 26 52 26
TEMPORADA 2004/2005
LIGA BELGA
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 34 83 25 79
2 Anderlecht Anderlecht 34 75 34 76
3 Genk Genk 34 59 37 70
4 Standard de Liège Standard 34 64 30 70
5 Charleroi Charleroi 34 47 34 64
6 KAA Gent KAA Gent 34 46 36 59
7 RAA Louvieroise Louvieroise 34 43 43 44
8 Lokeren Lokeren 34 36 38 44
9 Germinal Beerschot Germinal 34 36 45 42
10 Lierse SK Lierse SK 34 57 60 41
11 Cercle Brugge Cercle 34 45 74 41
12 KVC Westerlo Westerlo 34 34 54 39
13 Excelsior Mouscron Excelsior 34 40 43 36
14 Sint-Truidense V.V. Sint-Truiden 34 40 58 36
15 RWD Molenbeek Molenbeek 34 32 60 33
16 KSK Beveren KSK Beveren 34 43 59 32
17 KV Oostende KV Oostende 34 31 62 27
18 Mons Mons 34 39 58 26
TEMPORADA 2003/2004
LIGA BELGA
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 34 77 27 81
2 Club Brugge Club Brugge 34 77 31 72
3 Standard de Liège Standard 34 68 31 65
4 Excelsior Mouscron Excelsior 34 64 42 59
5 Genk Genk 34 58 40 59
6 KVC Westerlo Westerlo 34 51 45 52
7 RAA Louvieroise Louvieroise 34 45 46 44
8 Germinal Beerschot Germinal 34 34 40 44
9 KAA Gent KAA Gent 34 33 34 40
10 Lokeren Lokeren 34 45 54 39
11 Lierse SK Lierse SK 34 33 40 39
12 KSK Beveren KSK Beveren 34 45 58 38
13 Sint-Truidense V.V. Sint-Truiden 34 36 50 38
14 Cercle Brugge Cercle 34 28 52 35
15 Charleroi Charleroi 34 35 47 33
16 Mons Mons 34 29 52 33
17 Beringen Heusden Beringen 34 36 68 28
18 Antwerp Antwerp 34 30 67 27
TEMPORADA 2002/2003
LIGA BELGA
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 32 96 34 79
2 Anderlecht Anderlecht 32 72 31 71
3 Lokeren Lokeren 32 69 51 60
4 Sint-Truidense V.V. Sint-Truiden 32 63 44 56
5 Lierse SK Lierse SK 32 48 41 56
6 Genk Genk 32 73 52 55
7 Standard de Liège Standard 32 53 39 50
8 KAA Gent KAA Gent 32 49 55 47
9 Mons Mons 32 42 48 40
10 KVC Westerlo Westerlo 32 39 46 40
11 KSK Beveren KSK Beveren 32 50 66 38
12 Excelsior Mouscron Excelsior 32 46 69 35
13 Antwerp Antwerp 32 44 55 34
14 Beerschot Beerschot 32 49 57 31
15 RAA Louvieroise Louvieroise 32 34 44 30
16 Charleroi Charleroi 32 39 66 27
17 KV Mechelen KV Mechelen 32 18 86 18
TEMPORADA 2001/2002
LIGA BELGA
Equipo PJ GF GC Puntos
1 Genk Genk 34 85 43 72
2 Club Brugge Club Brugge 34 74 41 70
3 Anderlecht Anderlecht 34 71 37 66
4 KAA Gent KAA Gent 34 62 51 58
5 Standard de Liège Standard 34 57 38 57
6 Lokeren Lokeren 34 43 33 55
7 Excelsior Mouscron Excelsior 34 63 41 53
8 Sint-Truidense V.V. Sint-Truiden 34 52 47 53
9 Beerschot Beerschot 34 68 51 49
10 RWD Molenbeek Molenbeek 34 50 59 44
11 RAA Louvieroise Louvieroise 34 41 52 44
12 Charleroi Charleroi 34 40 63 39
13 KFC Lommel KFC Lommel 34 54 66 39
14 KVC Westerlo Westerlo 34 49 61 36
15 Lierse SK Lierse SK 34 55 65 35
16 Antwerp Antwerp 34 47 67 31
17 Eendracht Aalst Eendracht 34 33 68 24
18 KSK Beveren KSK Beveren 34 30 91 14
TEMPORADA 2000/2001
LIGA BELGA
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 34 88 25 83
2 Club Brugge Club Brugge 34 84 23 78
3 Standard de Liège Standard 34 72 42 60
4 Lokeren Lokeren 34 55 43 57
5 KAA Gent KAA Gent 34 59 49 57
6 Beerschot Beerschot 34 62 53 54
7 Excelsior Mouscron Excelsior 34 63 49 53
8 KVC Westerlo Westerlo 34 61 53 53
9 Charleroi Charleroi 34 51 65 47
10 Lierse SK Lierse SK 34 44 51 43
11 Genk Genk 34 45 51 42
12 Antwerp Antwerp 34 38 45 40
13 Sint-Truidense V.V. Sint-Truiden 34 44 54 35
14 KSK Beveren KSK Beveren 34 30 62 35
15 RAA Louvieroise Louvieroise 34 32 56 30
16 Eendracht Aalst Eendracht 34 33 65 29
17 Harelbeke Harelbeke 34 36 79 28
18 KV Mechelen KV Mechelen 34 40 72 22
TEMPORADA 1999/2000
LIGA BELGA
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 34 86 36 75
2 Club Brugge Club Brugge 34 70 32 67
3 KAA Gent KAA Gent 34 78 54 63
4 Excelsior Mouscron Excelsior 34 67 45 57
5 Standard de Liège Standard 34 66 52 56
6 KVC Westerlo Westerlo 34 73 66 56
7 Beerschot Beerschot 34 56 45 55
8 Genk Genk 34 63 59 54
9 Lierse SK Lierse SK 34 65 47 52
10 Lokeren Lokeren 34 56 58 47
11 KV Mechelen KV Mechelen 34 47 77 41
12 Harelbeke Harelbeke 34 62 70 38
13 Eendracht Aalst Eendracht 34 53 72 37
14 Sint-Truidense V.V. Sint-Truiden 34 41 65 37
15 KSK Beveren KSK Beveren 34 49 75 32
16 Charleroi Charleroi 34 42 62 31
17 Verbroedering Geel Verbroederin 34 32 60 28
18 KFC Lommel KFC Lommel 34 35 66 27
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

  USO DE MEMORIA  
8,095,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.8564
Total Execution Time  0.8576
  CADENA URL  
/historico/Genk/2011
  GET DATOS  
$_GET['/historico/Genk/2011']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (56)  
0.0151  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 = 2011 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.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.0126  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.0126  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.0126  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.0126  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.0126  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.0126  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 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 = 10144
0.0131  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 = 42044
0.0131  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 = 20650
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9785 AND type_rel = 2
0.0132  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.0132  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.0179  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' ORDER BY l.year DESC,cat.coefficient DESC
0.0133  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 = 2011 ORDER BY l.year DESC,cat.coefficient DESC
0.0137  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.0128  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 = 20650 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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 = 42044 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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 = 10144 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0171  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 (2010,2011,2012) ORDER BY l.id DESC, l.year DESC ;
0.0135  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 (42906,42844,20651,11662,10152,1439,1098,894) 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.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 10152 AND teamId = 9785
0.0141  SELECT count(id) as num_players from rel_players WHERE league_id = 1439 AND teamId = 9785
0.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 894 AND teamId = 9785
0.0140  SELECT count(id) as num_players from rel_players WHERE league_id = 42844 AND teamId = 9785
0.0136  SELECT count(id) as num_players from rel_players WHERE league_id = 42906 AND teamId = 9785
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 20651 AND teamId = 9785
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 11662 AND teamId = 9785
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 1098 AND teamId = 9785
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 FROM `tables2011` 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 = 1077 AND t.round = 30 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 = '9785' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0124  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9785' and rp.type = 4
0.0126  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 = '9785' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139  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 events2011 e ON e.player_id = p.id AND e.league_id = 1077 WHERE rp.league_id = 1077 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.0137  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 events2011 e ON e.player_id = p.id AND e.league_id = 1077 WHERE rp.league_id = 1077 AND rp.teamId = 9785 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 events2011 e ON e.player_id = p.id AND e.league_id = 1077 WHERE rp.league_id = 1077 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 <= 2011 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,team.teamId FROM `tables2011` 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 = 10144 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables2010` 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 = 10151 AND t.round = 6 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 `tables2010` 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 = 864 AND t.round = 30 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 `tables2009` 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 = 320 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 `tables2007` 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 = 355 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 `tables2006` 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 = 356 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 `tables2005` 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 = 357 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 `tables2004` 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 = 358 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 `tables2003` 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 = 359 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 `tables2002` 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 = 360 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 `tables2001` 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 = 361 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 `tables2000` 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 = 362 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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.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 `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.0128  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.0136  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.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 `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.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 `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