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

Antwerp

Entrenador: Mark van Bommel

Temporada 2008/2009
TEMPORADA 2008/2009
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 Sint-Truidense V.V. Sint-Truiden 36 72 29 80
2 Lierse SK Lierse SK 36 75 40 75
3 Antwerp Antwerp 36 55 32 61
4 Red Star Waasland Star 36 56 48 55
5 Tournai Tournai 36 53 41 54
6 Tienen Tienen 36 58 49 53
7 KV Oostende KV Oostende 36 54 51 53
8 Ronse Ronse 36 54 52 52
9 KVSK United KVSK United 36 48 38 51
10 Brussels Brussels 36 50 37 49
11 RFC Liège RFC Liège 36 49 48 48
12 OH Leuven OH Leuven 36 46 48 46
13 KSK Beveren KSK Beveren 36 47 57 45
14 KAS Eupen KAS Eupen 36 47 63 43
15 Excelsior Virton Excelsior 36 46 58 39
16 Olympic Charleroi Olympic 36 48 65 39
17 VW Hamme VW Hamme 36 48 64 36
18 Deinze Deinze 36 46 65 36
19 Union Namur Union Namur 36 22 89 13
TEMPORADA 2007/2008
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 Kortrijk Kortrijk 36 73 35 76
2 Tubize Tubize 36 49 29 66
3 OH Leuven OH Leuven 36 61 42 61
4 KVSK United KVSK United 36 51 36 60
5 Antwerp Antwerp 36 64 38 59
6 Excelsior Virton Excelsior 36 56 44 56
7 Lierse SK Lierse SK 36 47 36 53
8 VW Hamme VW Hamme 36 54 45 49
9 Tienen Tienen 36 49 51 48
10 KSK Beveren KSK Beveren 36 48 56 48
11 Tournai Tournai 36 34 37 46
12 Olympic Charleroi Olympic 36 40 53 46
13 KAS Eupen KAS Eupen 36 45 49 45
14 Red Star Waasland Star 36 46 47 43
15 Deinze Deinze 36 44 58 43
16 Union Namur Union Namur 36 51 63 42
17 KV Oostende KV Oostende 36 44 59 42
18 Union Saint-Gilloise Union 36 48 61 40
19 Verbroedering Geel Verbroederin 36 33 98 16
TEMPORADA 2006/2007
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 FCV Dender FCV Dender 34 73 27 79
2 KV Mechelen KV Mechelen 34 64 36 70
3 Kortrijk Kortrijk 34 69 35 67
4 Antwerp Antwerp 34 63 36 60
5 OH Leuven OH Leuven 34 53 49 56
6 KAS Eupen KAS Eupen 34 50 46 50
7 Deinze Deinze 34 50 54 50
8 Tubize Tubize 34 36 32 48
9 Union Saint-Gilloise Union 34 47 44 45
10 Tienen Tienen 34 50 57 45
11 KV Oostende KV Oostende 34 51 58 40
12 VW Hamme VW Hamme 34 38 43 39
13 Excelsior Virton Excelsior 34 37 55 39
14 Lommel SK Lommel SK 34 39 49 36
15 SK Beveren SK Beveren 34 41 56 36
16 Dessel Sport Dessel Sport 34 45 58 34
17 Racing Waregem Racing 34 32 58 27
18 Ronse Ronse 34 26 71 20
TEMPORADA 2005/2006
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 Mons Mons 34 64 30 69
2 Lommel SK Lommel SK 34 62 38 63
3 Kortrijk Kortrijk 34 57 41 58
4 Verbroedering Geel Verbroederin 34 49 34 57
5 SK Beveren SK Beveren 34 58 46 57
6 OH Leuven OH Leuven 34 53 37 54
7 Antwerp Antwerp 34 58 50 53
8 VW Hamme VW Hamme 34 58 47 49
9 KAS Eupen KAS Eupen 34 51 47 48
10 KV Oostende KV Oostende 34 51 47 47
11 Ronse Ronse 34 52 62 42
12 Tubize Tubize 34 47 50 41
13 KV Mechelen KV Mechelen 34 44 46 39
14 Union Saint-Gilloise Union 34 42 53 37
15 Excelsior Virton Excelsior 34 28 41 37
16 Dessel Sport Dessel Sport 34 38 50 34
17 Deinze Deinze 34 39 65 29
18 Beringen Heusden Beringen 34 24 91 26
TEMPORADA 2004/2005
SEGUNDA DIVISIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 Zulte-Waregem Zulte-Warege 34 71 35 73
2 KSV Roeselare Roeselare 34 51 31 60
3 Verbroedering Geel Verbroederin 34 49 36 56
4 Antwerp Antwerp 34 48 40 50
5 SK Beveren SK Beveren 34 51 55 50
6 Kortrijk Kortrijk 34 56 48 48
7 Tubize Tubize 34 54 49 48
8 Ronse Ronse 34 42 51 48
9 Beringen Heusden Beringen 34 41 41 47
10 Deinze Deinze 34 47 59 43
11 KAS Eupen KAS Eupen 34 52 46 41
12 VW Hamme VW Hamme 34 50 47 41
13 Excelsior Virton Excelsior 34 43 54 41
14 Union Saint-Gilloise Union 34 41 53 39
15 Dessel Sport Dessel Sport 34 31 46 39
16 Visé Visé 34 52 54 37
17 Patro Eisden Patro Eisden 34 35 53 37
18 Eendracht Aalst Eendracht 34 41 57 34
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 Lierse SK Lierse SK 34 33 40 39
11 Lokeren Lokeren 34 45 54 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
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 KFC Lommel KFC Lommel 34 54 66 39
13 Charleroi Charleroi 34 40 63 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
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 Antwerp Antwerp 34 84 29 80
2 KV Oostende KV Oostende 34 53 30 63
3 RAAL La Louviere RAAL 34 58 29 60
4 KFC Turnhout Turnhout 34 64 46 56
5 RWD Molenbeek Molenbeek 34 51 38 55
6 Cercle Brugge Cercle 34 54 35 54
7 Dessel Sport Dessel Sport 34 43 48 54
8 Ingelmunster Ingelmunster 33 62 47 51
9 Denderleeuw Denderleeuw 34 42 41 51
10 Patro Eisden Patro Eisden 34 53 58 49
11 Deinze Deinze 34 46 42 43
12 Tienen Tienen 34 35 52 40
13 Eendracht Hekelgem Eendracht 34 36 60 40
14 KSV Roeselare Roeselare 34 50 58 39
15 RFC Liège RFC Liège 34 43 54 39
16 Kortrijk Kortrijk 34 52 79 38
17 Visé Visé 34 46 73 22
18 Cappellen Cappellen 33 22 75 12
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 1995/1996
LIGA BELGA
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 34 83 30 81
2 Anderlecht Anderlecht 34 83 37 71
3 Germinal Beerschot Germinal 34 53 37 53
4 RWD Molenbeek Molenbeek 34 39 29 53
5 Lierse SK Lierse SK 34 53 43 52
6 Standard de Liège Standard 34 51 46 51
7 Charleroi Charleroi 34 59 53 50
8 Cercle Brugge Cercle 34 51 47 49
9 KFC Lommel KFC Lommel 34 40 45 48
10 Eendracht Aalst Eendracht 34 55 50 46
11 KV Mechelen KV Mechelen 34 40 46 44
12 Harelbeke Harelbeke 34 38 47 43
13 Antwerp Antwerp 34 38 46 42
14 KAA Gent KAA Gent 34 39 49 41
15 Sint-Truidense V.V. Sint-Truiden 34 42 60 40
16 RFC Seraing RFC Seraing 34 35 75 29
17 KSK Beveren KSK Beveren 34 38 57 27
18 KSV Waregem KSV Waregem 34 30 70 21
TEMPORADA 1994/1995
LIGA BELGA
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 34 80 31 75
2 Standard de Liège Standard 34 52 23 72
3 Club Brugge Club Brugge 34 68 31 70
4 Eendracht Aalst Eendracht 34 62 56 53
5 Lierse SK Lierse SK 34 52 52 51
6 Beerschot Beerschot 34 57 39 49
7 KFC Lommel KFC Lommel 34 44 41 48
8 RFC Seraing RFC Seraing 34 53 45 46
9 Sint-Truidense V.V. Sint-Truiden 34 34 35 46
10 KV Mechelen KV Mechelen 34 40 45 42
11 KSK Beveren KSK Beveren 34 40 46 42
12 RWD Molenbeek Molenbeek 34 34 41 41
13 Charleroi Charleroi 34 33 43 41
14 KAA Gent KAA Gent 34 41 53 41
15 Cercle Brugge Cercle 34 43 52 37
16 Antwerp Antwerp 34 40 56 32
17 KV Oostende KV Oostende 34 34 81 24
18 RFC Liège RFC Liège 34 35 72 22
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 1989/1990
LIGA BELGA
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 34 76 19 82
2 Anderlecht Anderlecht 34 76 21 77
3 KV Mechelen KV Mechelen 34 65 14 69
4 Antwerp Antwerp 34 63 32 58
5 Standard de Liège Standard 34 54 33 58
6 KAA Gent KAA Gent 34 46 38 48
7 Kortrijk Kortrijk 34 39 46 46
8 Cercle Brugge Cercle 34 46 47 43
9 K Beerschot VAC Beerschot 34 34 47 43
10 Lierse SK Lierse SK 34 42 66 39
11 Beerschot Beerschot 34 38 52 37
12 Lokeren Lokeren 34 34 66 37
13 RFC Liège RFC Liège 34 35 45 36
14 Charleroi Charleroi 34 41 56 36
15 Sint-Truidense V.V. Sint-Truiden 34 25 45 35
16 KSV Waregem KSV Waregem 34 35 64 33
17 KSK Beveren KSK Beveren 34 31 57 32
18 Racing Mechelen Racing 34 29 61 26
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  
7,956,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.2456
Total Execution Time  0.2474
  CADENA URL  
/historico/Antwerp/2009
  GET DATOS  
$_GET['/historico/Antwerp/2009']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0056  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 = 'Antwerp' AND l.year = 2009 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.0020  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=7512 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=7512 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=7512 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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 = 10159
0.0028  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 = 44808
0.0023  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7512 AND type_rel = 2
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7512 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0080  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 (147178,260603,261210,266750,278273) ORDER BY n.cover_points DESC, update_date DESC
0.0037  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 = '7512' AND l.year = 2009 ORDER BY l.year DESC,cat.coefficient DESC
0.0031  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 = '7512' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = 10159 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  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=7512 AND l.year in (2008,2009,2010) ORDER BY l.id DESC, l.year DESC ;
0.0022  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 (44808,20649,10160) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 10160 AND teamId = 7512
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 20649 AND teamId = 7512
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 44808 AND teamId = 7512
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 10159 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0027  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 = '7512' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7512' and rp.type = 4
0.0024  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 = '7512' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0038  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 events2009 e ON e.player_id = p.id AND e.league_id = 10159 WHERE rp.league_id = 10159 AND rp.teamId = 7512 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.0049  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 events2009 e ON e.player_id = p.id AND e.league_id = 10159 WHERE rp.league_id = 10159 AND rp.teamId = 7512 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 events2009 e ON e.player_id = p.id AND e.league_id = 10159 WHERE rp.league_id = 10159 AND rp.teamId = 7512 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 = 7512 AND l.year <= 2009 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  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 = 10159 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2008` 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 = 10160 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 13513 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 13512 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 13511 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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.0025  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.0062  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.0026  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 = 13506 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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.0023  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.0023  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 `tables1996` 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 = 366 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables1995` 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 = 25341 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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.0118  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.0041  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.0021  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 = 10159 ORDER BY nameShow LIMIT 100