4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Mons
TEMPORADA 2014/2015
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 Sint-Truidense V.V. Sint-Truiden 34 62 28 79
2 Lommel SK Lommel SK 34 65 27 70
3 KAS Eupen KAS Eupen 34 63 30 67
4 RFC Seraing RFC Seraing 34 69 39 61
5 OH Leuven OH Leuven 34 66 39 61
6 Excelsior Virton Excelsior 34 58 35 59
7 Mons Mons 34 52 30 55
8 Tubize Tubize 34 43 40 50
9 Eendracht Aalst Eendracht 34 48 45 46
10 Antwerp Antwerp 34 41 41 42
11 KSV Roeselare Roeselare 34 44 45 42
12 WS Bruxelles Bruxelles 34 43 48 40
13 Geel-Meerhout Geel-Meerhou 34 42 62 39
14 Heist Heist 34 41 61 36
15 Dessel Sport Dessel Sport 34 36 58 31
16 Patro Eisden Patro Eisden 34 38 68 26
17 Racing Mechelen Racing 34 23 87 19
18 Woluwe Woluwe 34 30 81 15
TEMPORADA 2013/2014
LIGA BELGA GRUPO 6
Equipo PJ GF GC Puntos
1 OH Leuven OH Leuven 3 5 1 10
2 Mons Mons 3 1 5 1
TEMPORADA 2012/2013
LIGA BELGA GRUPO 3
Equipo PJ GF GC Puntos
1 KAA Gent KAA Gent 6 9 3 14
2 Mons Mons 6 7 8 10
3 Lierse SK Lierse SK 6 5 8 4
4 Kortrijk Kortrijk 6 4 6 2
TEMPORADA 2011/2012
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 30 61 26 67
2 Club Brugge Club Brugge 30 51 32 61
3 KAA Gent KAA Gent 30 63 35 56
4 Standard de Liège Standard 30 43 33 51
5 Genk Genk 30 60 44 46
6 Kortrijk Kortrijk 30 39 36 46
7 Cercle Brugge Cercle 30 36 37 46
8 Lokeren Lokeren 30 48 40 44
9 KV Mechelen KV Mechelen 30 40 50 37
10 Mons Mons 30 50 55 36
11 Beerschot Beerschot 30 45 51 36
12 Lierse SK Lierse SK 30 24 36 31
13 Zulte-Waregem Zulte-Warege 30 32 38 30
14 OH Leuven OH Leuven 30 38 58 29
15 KVC Westerlo Westerlo 30 29 59 20
16 Sint-Truidense V.V. Sint-Truiden 30 32 61 19
TEMPORADA 2010/2011
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 OH Leuven OH Leuven 34 75 38 73
2 Lommel SK Lommel SK 34 73 44 65
3 Mons Mons 34 63 38 59
4 SK Beveren SK Beveren 34 51 35 56
5 Visé Visé 34 52 48 51
6 Antwerp Antwerp 34 54 53 50
7 FCV Dender FCV Dender 34 54 54 49
8 Tubize Tubize 34 46 55 47
9 KV Oostende KV Oostende 34 41 48 45
10 Heist Heist 34 57 67 43
11 Brussels Brussels 34 50 51 42
12 Standaard Wetteren Standaard 34 42 51 42
13 RBD Borinage Borinage 34 48 52 41
14 KSV Roeselare Roeselare 34 38 42 41
15 Tienen Tienen 34 35 47 41
16 KFC Turnhout Turnhout 34 48 59 40
17 Rupel Boom Rupel Boom 34 36 56 37
18 Tournai Tournai 34 38 63 24
TEMPORADA 2009/2010
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 Lierse SK Lierse SK 36 75 32 75
2 KVSK United KVSK United 36 55 27 70
3 Mons Mons 36 56 32 66
4 KAS Eupen KAS Eupen 36 56 37 60
5 RBD Borinage Borinage 36 46 43 53
6 Red Star Waasland Star 36 46 49 52
7 KV Oostende KV Oostende 36 49 45 51
8 Antwerp Antwerp 36 55 53 47
9 OH Leuven OH Leuven 36 50 66 45
10 Tournai Tournai 36 50 51 44
11 Standaard Wetteren Standaard 36 48 59 44
12 FCV Dender FCV Dender 36 45 49 43
13 Tienen Tienen 36 44 58 43
14 Tubize Tubize 36 41 41 42
15 Brussels Brussels 36 47 53 42
16 KFC Turnhout Turnhout 36 50 57 41
17 Ronse Ronse 36 51 57 39
18 KSK Beveren KSK Beveren 36 37 55 36
19 RFC Liège RFC Liège 36 23 60 23
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
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
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
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 KV Mechelen KV Mechelen 34 64 24 71
2 Ingelmunster Ingelmunster 34 53 32 67
3 Mons Mons 34 56 37 62
4 Beringen Heusden Beringen 34 52 34 56
5 Harelbeke Harelbeke 34 41 42 55
6 Cercle Brugge Cercle 34 40 28 52
7 Dessel Sport Dessel Sport 34 57 44 47
8 Visé Visé 34 41 50 45
9 Strombeek Strombeek 34 42 51 42
10 RFC Liège RFC Liège 34 35 42 41
11 Excelsior Virton Excelsior 34 41 47 39
12 Verbroedering Geel Verbroederin 34 39 48 38
13 Denderleeuw Denderleeuw 34 31 41 38
14 KSV Roeselare Roeselare 34 41 44 37
15 Ronse Ronse 34 37 52 37
16 Deinze Deinze 34 40 50 36
17 Tienen Tienen 34 36 51 35
18 Patro Eisden Patro Eisden 34 33 62 30
TEMPORADA 2000/2001
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 KFC Lommel KFC Lommel 34 79 27 78
2 KFC Turnhout Turnhout 34 88 44 69
3 RWD Molenbeek Molenbeek 34 62 29 61
4 Verbroedering Geel Verbroederin 34 58 36 60
5 Mons Mons 34 50 26 58
6 Ingelmunster Ingelmunster 34 61 49 55
7 Cercle Brugge Cercle 33 49 48 46
8 KSV Roeselare Roeselare 34 49 51 46
9 Denderleeuw Denderleeuw 34 42 47 41
10 Strombeek Strombeek 34 47 51 39
11 Beringen Heusden Beringen 34 39 53 38
12 Dessel Sport Dessel Sport 33 44 59 38
13 Tienen Tienen 34 42 53 37
14 Patro Eisden Patro Eisden 34 38 60 37
15 Deinze Deinze 34 34 56 36
16 RFC Liège RFC Liège 34 40 68 36
17 Eendracht Hekelgem Eendracht 34 37 69 24
18 KV Oostende KV Oostende 34 35 68 23

  USO DE MEMORIA  
7,036,104 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  1.1567
Total Execution Time  1.1579
  CADENA URL  
/historico/Mons
  GET DATOS  
$_GET['/historico/Mons']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (79)  
0.0133  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 = 'Mons' 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.0287  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 = 'Mons' 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.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=9779 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=9779 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=9779 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=9779 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=9779 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=9779 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=9779 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=9779 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124  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=9779 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124  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=9779 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=9779 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=9779 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=9779 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=9779 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=9779 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=9779 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=9779 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=9779 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=9779 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=9779 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=9779 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=9779 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=9779 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=9779 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=9779 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=9779 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=9779 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=9779 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=9779 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=9779 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=9779 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=9779 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=9779 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=9779 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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=9779 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=9779 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=9779 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0137  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 = 3908
0.0136  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 = 4514
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9779 AND type_rel = 2
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 240 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 (1302659,1262868,1251887,1203596,1182036) ORDER BY n.cover_points DESC, update_date DESC
0.0131  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 = '9779' AND l.year = 2015 ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '9779' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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 = '9779' 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,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 = 4514 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 = 3908 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  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=9779 AND l.year in (2014,2015,2016) 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 (10121,4514,3908,3804) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 10121 AND teamId = 9779
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 3908 AND teamId = 9779
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 4514 AND teamId = 9779
0.0178  SELECT count(id) as num_players from rel_players WHERE league_id = 3804 AND teamId = 9779
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 FROM `tables2015` 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 = 3908 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0175  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 events2015 e ON e.player_id = p.id AND e.league_id = 3908 WHERE rp.league_id = 3908 AND rp.teamId = 9779 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.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 events2015 e ON e.player_id = p.id AND e.league_id = 3908 WHERE rp.league_id = 3908 AND rp.teamId = 9779 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 events2015 e ON e.player_id = p.id AND e.league_id = 3908 WHERE rp.league_id = 3908 AND rp.teamId = 9779 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 9779 AND l.year <= 2015 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2015` 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 = 3908 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 `tables2014` 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 = 2409 AND t.round = 30 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 `tables2014` 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 = 10121 AND t.round = 3 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 `tables2013` 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 = 2015 AND t.round = 30 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 `tables2013` 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 = 10123 AND t.round = 6 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 `tables2012` 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 = 10141 AND t.round = 6 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 `tables2012` 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 = 1356 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 `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 = 10154 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 `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 = 10158 AND t.round = 38 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 `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.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 `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 = 68 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 `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.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 `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.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 `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.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 `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.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 `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.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 `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 = 13508 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 `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 = 13507 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 3908 ORDER BY nameShow LIMIT 100