4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Visé
TEMPORADA 2023/2024
DIVISIÓN NACIONAL BELGA 1
Equipo PJ GF GC Puntos
1 RAAL La Louviere RAAL 33 75 19 80
2 Lokeren-Temse Lokeren-Tems 33 56 29 70
3 Knokke Knokke 33 54 39 53
4 Charleroi II Charleroi 33 54 42 52
5 Hoogstraten Hoogstraten 33 44 49 49
6 Thes Sport Thes Sport 33 53 59 48
7 Heist Heist 33 54 52 48
8 Gent II Gent II 33 57 39 48
9 Olympic Charleroi Olympic 33 55 50 47
10 KVC Winkel Sport Winkel Sport 33 41 44 46
11 Excelsior Virton Excelsior 33 46 53 45
12 Tienen Tienen 33 44 39 44
13 Dessel Sport Dessel Sport 33 53 58 41
14 Union Namur Union Namur 33 39 58 39
15 Antwerp II Antwerp II 33 38 54 37
16 Leuven II Leuven II 33 41 64 29
17 Visé Visé 33 39 58 28
18 Cappellen Cappellen 33 34 71 26
TEMPORADA 2022/2023
DIVISIÓN NACIONAL BELGA 1
Equipo PJ GF GC Puntos
1 Patro Eisden Patro Eisden 38 84 23 86
2 RFC Liège RFC Liège 38 99 29 86
3 Francs Borains Francs 38 79 46 77
4 RAAL La Louviere RAAL 38 72 39 73
5 Gent II Gent II 38 59 43 67
6 Heist Heist 38 69 59 61
7 Olympic Charleroi Olympic 38 71 52 60
8 Knokke Knokke 38 65 58 60
9 Visé Visé 38 66 52 56
10 Thes Sport Thes Sport 38 58 52 53
11 Leuven II Leuven II 38 61 68 50
12 Tienen Tienen 38 50 60 46
13 Charleroi II Charleroi 38 41 58 44
14 Dessel Sport Dessel Sport 38 45 65 43
15 KVC Winkel Sport Winkel Sport 38 44 58 42
16 Hoogstraten Hoogstraten 38 46 60 41
17 Antwerp II Antwerp II 38 33 58 39
18 Ninove Ninove 38 39 75 35
19 Rupel Boom Rupel Boom 38 29 83 24
20 Mandel United Mandel 38 16 88 14
TEMPORADA 2021/2022
DIVISIÓN NACIONAL BELGA 1 GRUPO 1
Equipo PJ GF GC Puntos
1 RFC Liège RFC Liège 28 57 23 50
2 Knokke Knokke 28 48 33 48
3 Dessel Sport Dessel Sport 28 47 35 48
4 FCV Dender FCV Dender 28 41 30 46
5 Olympic Charleroi Olympic 28 41 31 46
6 Patro Eisden Patro Eisden 28 28 21 46
7 KVC Winkel Sport Winkel Sport 28 40 36 44
8 Visé Visé 28 45 34 39
9 Heist Heist 28 41 34 39
10 Thes Sport Thes Sport 28 35 35 39
11 Tienen Tienen 28 28 34 35
12 Rupel Boom Rupel Boom 28 26 39 33
13 Francs Borains Francs 28 26 29 32
14 Mandel United Mandel 28 26 50 19
15 La Louvière Centre Louvière 28 13 78 9
TEMPORADA 2020/2021
DIVISIÓN NACIONAL BELGA 1
Equipo PJ GF GC Puntos
1 Thes Sport Thes Sport 3 7 3 9
2 Tienen Tienen 4 5 5 6
3 Heist Heist 2 3 2 4
4 Mandel United Mandel 3 6 4 3
5 KVC Winkel Sport Winkel Sport 2 4 2 3
6 Francs Borains Francs 1 2 1 3
7 Knokke Knokke 2 2 1 3
8 Visé Visé 2 3 3 3
9 Olympic Charleroi Olympic 2 1 1 3
10 Patro Eisden Patro Eisden 1 2 2 1
11 RFC Liège RFC Liège 1 0 0 1
12 Rupel Boom Rupel Boom 2 0 2 1
13 FCV Dender FCV Dender 0 0 0 0
14 Dessel Sport Dessel Sport 0 0 0 0
15 La Louvière Centre Louvière 2 1 5 0
16 KSV Roeselare Roeselare 1 0 5 0
TEMPORADA 2019/2020
DIVISIÓN NACIONAL BELGA 1
Equipo PJ GF GC Puntos
1 Deinze Deinze 24 52 16 62
2 Thes Sport Thes Sport 24 32 23 42
3 RFC Seraing RFC Seraing 23 42 27 40
4 Heist Heist 24 28 23 38
5 Patro Eisden Patro Eisden 24 25 23 36
6 RWD Molenbeek Molenbeek 24 26 25 34
7 FCV Dender FCV Dender 24 36 34 31
8 Dessel Sport Dessel Sport 24 29 29 31
9 Rupel Boom Rupel Boom 24 35 32 31
10 Olympic Charleroi Olympic 24 29 33 30
11 Visé Visé 24 32 36 30
12 RFC Liège RFC Liège 23 30 37 27
13 Lierse Kempenzonen Lierse 24 27 30 26
14 La Louvière Centre Louvière 24 36 49 26
15 Tubize Tubize 24 19 40 23
16 KVC Winkel Sport Winkel Sport 24 21 42 13
TEMPORADA 2018/2019
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 La Louvière Centre Louvière 30 83 19 77
2 Visé Visé 30 68 36 61
3 Hamoir Hamoir 30 56 34 59
4 Francs Borains Francs 30 59 42 52
5 Rebecq Rebecq 30 60 44 51
6 RFC Tilleur RFC Tilleur 30 54 45 47
7 RAAL La Louviere RAAL 30 42 30 46
8 Meux Meux 30 51 51 39
9 RES Durbuy RES Durbuy 30 37 50 39
10 Couvin-Mariembourg Couvin-Marie 30 50 51 38
11 Waremme Waremme 30 46 53 35
12 Solières Sport Solières 30 38 56 31
13 Acren Lessines Acren 30 42 53 29
14 Walhain Walhain 30 33 52 28
15 Olympic Charleroi Olympic 30 32 61 24
16 Ciney Ciney 30 22 96 9
TEMPORADA 2014/2015
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Cappellen Cappellen 34 105 40 73
2 Sprimont-Comblain Sprimont-Com 34 69 34 68
3 Union Saint-Gilloise Union 34 53 32 67
4 Ciney Ciney 34 73 42 65
5 Bocholt Bocholt 34 77 37 64
6 Walhain Walhain 34 58 40 57
7 Sporting Hasselt Sporting 34 59 43 56
8 Oosterwijk Oosterwijk 34 69 48 51
9 Hoogstraten Hoogstraten 34 58 54 51
10 La Calamine La Calamine 34 54 57 47
11 La Louvière Centre Louvière 34 56 66 47
12 Berchem Sport Berchem 34 57 72 45
13 Tienen Tienen 34 48 57 35
14 Grimbergen Grimbergen 34 34 46 35
15 Diegem Sport Diegem Sport 34 40 61 35
16 Visé Visé 34 40 83 28
17 Verviers Verviers 34 43 95 25
18 KFC Turnhout Turnhout 34 23 109 7
TEMPORADA 2013/2014
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 KVC Westerlo Westerlo 34 67 23 78
2 KAS Eupen KAS Eupen 34 75 27 74
3 Sint-Truidense V.V. Sint-Truiden 34 47 31 67
4 Mouscron Mouscron 34 53 27 66
5 Lommel SK Lommel SK 34 56 34 59
6 Tubize Tubize 34 59 45 54
7 Antwerp Antwerp 33 44 31 46
8 RWD Molenbeek Molenbeek 34 38 41 45
9 RBD Borinage Borinage 34 45 51 45
10 Geel-Meerhout Geel-Meerhou 34 45 49 43
11 Eendracht Aalst Eendracht 34 37 49 42
12 WS Bruxelles Bruxelles 34 37 38 40
13 Excelsior Virton Excelsior 33 47 45 38
14 Dessel Sport Dessel Sport 34 37 60 35
15 KSV Roeselare Roeselare 34 41 62 35
16 Heist Heist 34 38 74 31
17 Hoogstraten Hoogstraten 34 33 61 28
18 Visé Visé 34 26 77 13
TEMPORADA 2012/2013
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 KV Oostende KV Oostende 34 61 27 75
2 Mouscron Mouscron 34 58 29 67
3 KVC Westerlo Westerlo 34 54 29 63
4 Sint-Truidense V.V. Sint-Truiden 34 54 36 57
5 RBD Borinage Borinage 34 44 34 55
6 White Star Woluwé White Star. 34 44 39 53
7 Lommel SK Lommel SK 34 50 48 50
8 KAS Eupen KAS Eupen 34 44 37 49
9 Tubize Tubize 34 43 42 46
10 Antwerp Antwerp 34 42 44 45
11 KSV Roeselare Roeselare 34 44 47 42
12 Dessel Sport Dessel Sport 34 35 42 41
13 Eendracht Aalst Eendracht 34 38 52 41
14 Visé Visé 34 47 57 33
15 Brussels Brussels 34 32 49 33
16 Heist Heist 34 39 57 30
17 Sint-Niklaas Sint-Niklaas 34 34 64 30
18 Oudenaarde Oudenaarde 34 31 61 30
TEMPORADA 2011/2012
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 Charleroi Charleroi 34 64 34 74
2 KAS Eupen KAS Eupen 34 61 34 68
3 SK Beveren SK Beveren 34 61 34 68
4 KV Oostende KV Oostende 34 61 29 66
5 Lommel SK Lommel SK 34 48 42 52
6 White Star Woluwé White Star. 34 48 43 51
7 Heist Heist 34 46 46 46
8 Eendracht Aalst Eendracht 34 46 52 46
9 Visé Visé 34 44 41 44
10 Antwerp Antwerp 34 39 42 43
11 RBD Borinage Borinage 34 44 54 42
12 Tubize Tubize 34 36 55 41
13 KSV Roeselare Roeselare 34 46 51 40
14 Brussels Brussels 34 44 46 38
15 Sint-Niklaas Sint-Niklaas 34 41 54 34
16 FCV Dender FCV Dender 34 33 43 33
17 Tienen Tienen 34 34 61 33
18 Standaard Wetteren Standaard 34 19 54 21
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
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Visé Visé 34 68 30 71
2 Olympic Charleroi Olympic 34 59 34 62
3 Dessel Sport Dessel Sport 34 80 49 58
4 Woluwe Woluwe 34 62 52 56
5 La Louvière Centre Louvière 34 53 45 53
6 Diegem Sport Diegem Sport 34 50 48 52
7 Verviers Verviers 34 38 47 48
8 Bocholt Bocholt 34 64 50 47
9 Wezel Wezel 34 39 37 45
10 Sporting Hasselt Sporting 34 45 55 45
11 Union Namur Union Namur 34 48 43 43
12 WS Bruxelles Bruxelles 34 47 48 43
13 Union Saint-Gilloise Union 34 53 41 42
14 Excelsior Virton Excelsior 34 37 44 42
15 BX Brussels BX Brussels 34 47 57 40
16 Tongeren Tongeren 34 44 47 39
17 Veldwezelt Veldwezelt 34 34 60 26
18 Mouscron Mouscron 34 29 110 21
TEMPORADA 2008/2009
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 KFC Turnhout Turnhout 30 50 18 67
2 Visé Visé 30 61 34 59
3 Racing Mechelen Racing 30 55 44 51
4 Wuustwezel Wuustwezel 30 51 50 51
5 Rupel Boom Rupel Boom 30 57 37 49
6 Willebroek-Meerhof Willebroek-M 30 47 34 49
7 Bocholt Bocholt 30 52 39 45
8 Hoogstraten Hoogstraten 30 49 49 41
9 Veldwezelt Veldwezelt 30 45 46 38
10 Verviers Verviers 29 33 37 34
11 Tongeren Tongeren 29 36 50 33
12 Cappellen Cappellen 30 33 43 32
13 Hamoir Hamoir 30 46 55 30
14 Dessel Sport Dessel Sport 30 37 57 30
15 RFC Seraing RFC Seraing 30 22 45 26
16 La Calamine La Calamine 30 26 62 19
TEMPORADA 2007/2008
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 RFC Liège RFC Liège 28 47 21 66
2 KFC Turnhout Turnhout 28 45 19 59
3 WS Bruxelles Bruxelles 28 49 30 57
4 Cappellen Cappellen 28 54 25 56
5 Visé Visé 27 59 28 51
6 Wezel Wezel 27 42 41 43
7 Hamoir Hamoir 28 37 47 39
8 Bocholt Bocholt 28 32 40 36
9 Dessel Sport Dessel Sport 28 39 45 29
10 Tongeren Tongeren 28 27 45 29
11 RFC Seraing RFC Seraing 28 30 47 28
12 Veldwezelt Veldwezelt 28 26 42 26
13 Verviers Verviers 28 34 39 25
14 La Calamine La Calamine 28 28 54 22
15 Sprimont-Comblain Sprimont-Com 28 21 47 18
TEMPORADA 2006/2007
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Olympic Charleroi Olympic 30 49 29 57
2 Sprimont-Comblain Sprimont-Com 30 34 31 50
3 Union Namur Union Namur 29 55 35 49
4 WS Bruxelles Bruxelles 30 52 42 47
5 Charleroi Fleurus Charleroi 29 37 30 45
6 Tongeren Tongeren 30 50 45 44
7 Bocholt Bocholt 30 47 35 42
8 RFC Seraing RFC Seraing 30 48 40 41
9 Visé Visé 30 38 39 41
10 Verviers Verviers 30 39 41 38
11 RFC Liège RFC Liège 30 22 27 36
12 Francs Borains Francs 30 37 50 36
13 RAAL La Louviere RAAL 30 31 41 35
14 La Calamine La Calamine 30 27 44 35
15 Sporting Hasselt Sporting 30 41 59 31
16 Walhain Walhain 30 34 53 25
TEMPORADA 2005/2006
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Tienen Tienen 29 53 24 59
2 Francs Borains Francs 29 44 29 50
3 La Calamine La Calamine 30 43 48 49
4 Olympic Charleroi Olympic 30 51 32 47
5 Visé Visé 30 40 39 46
6 Sporting Hasselt Sporting 30 43 38 44
7 Union Namur Union Namur 30 43 34 42
8 Sprimont-Comblain Sprimont-Com 30 35 38 40
9 Tongeren Tongeren 30 38 42 39
10 Tournai Tournai 30 38 35 38
11 Verviers Verviers 30 33 43 37
12 Charleroi Fleurus Charleroi 30 37 51 35
13 Bocholt Bocholt 30 34 43 32
14 Leopoldsburg Leopoldsburg 30 34 46 32
15 Walhain Walhain 30 27 39 32
16 R.R.F.C. Montegnée R.R.F.C. 30 42 54 27
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
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 RWD Molenbeek Molenbeek 34 79 29 70
2 KV Oostende KV Oostende 34 69 43 65
3 KSV Roeselare Roeselare 34 59 38 63
4 Tubize Tubize 34 60 33 58
5 Zulte-Waregem Zulte-Warege 34 58 45 52
6 Excelsior Virton Excelsior 34 38 33 51
7 Deinze Deinze 34 45 46 50
8 Patro Eisden Patro Eisden 34 47 50 49
9 Dessel Sport Dessel Sport 34 41 42 48
10 Verbroedering Geel Verbroederin 34 38 41 47
11 VW Hamme VW Hamme 34 43 44 46
12 Eendracht Aalst Eendracht 34 54 59 45
13 Visé Visé 34 48 59 44
14 KAS Eupen KAS Eupen 34 32 41 37
15 Ronse Ronse 34 27 46 32
16 Racing Club Harelbeke Racing Club 34 41 61 31
17 Tienen Tienen 34 30 64 25
18 Denderleeuw Denderleeuw 34 32 67 22
TEMPORADA 2002/2003
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 Cercle Brugge Cercle 34 65 36 69
2 KAS Eupen KAS Eupen 34 54 32 64
3 Beringen Heusden Beringen 34 52 33 57
4 Zulte-Waregem Zulte-Warege 34 51 40 55
5 Denderleeuw Denderleeuw 34 56 40 53
6 Visé Visé 34 48 41 52
7 RFC Liège RFC Liège 34 46 47 48
8 Strombeek Strombeek 34 57 47 47
9 Verbroedering Geel Verbroederin 34 35 33 47
10 Excelsior Virton Excelsior 34 43 37 42
11 Ronse Ronse 34 38 42 42
12 VW Hamme VW Hamme 34 50 63 42
13 Deinze Deinze 34 37 52 40
14 Ingelmunster Ingelmunster 34 50 58 39
15 Tienen Tienen 34 37 60 39
16 Dessel Sport Dessel Sport 34 48 63 38
17 KSV Roeselare Roeselare 34 40 51 31
18 Patro Eisden Patro Eisden 34 31 63 24
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

  USO DE MEMORIA  
7,975,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1664
Total Execution Time  0.1676
  CADENA URL  
/historico/Vise
  GET DATOS  
$_GET['/historico/Vise']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (46)  
0.0028  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 = 'Vise' 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.0018  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=7509 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=7509 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=7509 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=7509 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7509 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1894 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1894 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1293576,1264941,900137,769348,500257) ORDER BY n.cover_points DESC, update_date DESC
0.0026  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 = '7509' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '7509' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 72259 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=7509 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (73206,72259,71432) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72259 AND teamId = 7509
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 7509
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7509
0.0039  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72259 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '7509' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0023  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7509' and rp.type = 4
0.0021  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 = '7509' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0035  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72259 WHERE rp.league_id = 72259 AND rp.teamId = 7509 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.0031  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72259 WHERE rp.league_id = 72259 AND rp.teamId = 7509 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72259 WHERE rp.league_id = 72259 AND rp.teamId = 7509 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 7509 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72259 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 68256 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 63431 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 58503 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 50973 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 44609 AND t.round = 30 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 `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 = 4001 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 `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 = 2473 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 2016 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 1741 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 `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.0033  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 = 24298 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 `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 = 24301 AND t.round = 30 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 `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 = 24304 AND t.round = 30 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 `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 = 24307 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 24320 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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.0029  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 = 13510 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 `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 = 13509 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 `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.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 = 72259 ORDER BY nameShow LIMIT 100