4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA BELGA GRUPO 4
Equipo PJ GF GC Puntos
1 Charleroi Charleroi 34 31 50 39
2 RWD Molenbeek Molenbeek 33 38 70 30
3 KAS Eupen KAS Eupen 34 27 65 25
4 Kortrijk Kortrijk 33 26 64 25
TEMPORADA 2022/2023
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Genk Genk 34 78 37 75
2 Union Saint-Gilloise Union 34 70 41 75
3 Antwerp Antwerp 34 59 26 72
4 Club Brugge Club Brugge 34 61 36 59
5 KAA Gent KAA Gent 34 64 38 56
6 Standard de Liège Standard 34 58 45 55
7 KVC Westerlo Westerlo 34 61 53 51
8 Cercle Brugge Cercle 34 50 46 50
9 Charleroi Charleroi 34 45 52 48
10 OH Leuven OH Leuven 34 56 48 48
11 Anderlecht Anderlecht 34 49 46 46
12 Sint-Truidense V.V. Sint-Truiden 34 37 40 42
13 KV Mechelen KV Mechelen 34 49 63 40
14 Kortrijk Kortrijk 34 37 61 31
15 KAS Eupen KAS Eupen 34 40 75 28
16 KV Oostende KV Oostende 34 37 76 27
17 Zulte-Waregem Zulte-Warege 34 50 78 27
18 RFC Seraing RFC Seraing 34 28 68 20
TEMPORADA 2021/2022
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Union Saint-Gilloise Union 34 78 27 77
2 Club Brugge Club Brugge 34 72 37 72
3 Anderlecht Anderlecht 34 72 36 64
4 Antwerp Antwerp 34 55 38 63
5 KAA Gent KAA Gent 34 56 30 62
6 Charleroi Charleroi 34 55 46 54
7 KV Mechelen KV Mechelen 34 57 61 52
8 Genk Genk 34 66 47 51
9 Sint-Truidense V.V. Sint-Truiden 34 42 40 51
10 Cercle Brugge Cercle 34 49 46 45
11 OH Leuven OH Leuven 34 47 58 41
12 KV Oostende KV Oostende 34 34 61 37
13 Kortrijk Kortrijk 34 43 48 37
14 Standard de Liège Standard 34 32 51 36
15 KAS Eupen KAS Eupen 34 37 61 32
16 Zulte-Waregem Zulte-Warege 34 42 69 32
17 RFC Seraing RFC Seraing 34 30 68 28
18 Beerschot VA Beerschot 34 33 76 16
TEMPORADA 2020/2021
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 34 73 26 76
2 Antwerp Antwerp 34 57 48 60
3 Anderlecht Anderlecht 34 51 34 58
4 Genk Genk 34 67 48 56
5 KV Oostende KV Oostende 34 49 41 53
6 Standard de Liège Standard 34 52 41 50
7 KAA Gent KAA Gent 34 55 42 49
8 KV Mechelen KV Mechelen 34 54 54 48
9 Beerschot VA Beerschot 34 58 64 47
10 Zulte-Waregem Zulte-Warege 34 53 69 46
11 OH Leuven OH Leuven 34 54 59 45
12 KAS Eupen KAS Eupen 34 44 55 43
13 Charleroi Charleroi 34 46 49 42
14 Kortrijk Kortrijk 34 44 57 39
15 Sint-Truidense V.V. Sint-Truiden 34 41 52 38
16 Cercle Brugge Cercle 34 40 51 36
17 SK Beveren SK Beveren 34 44 70 31
18 Mouscron Mouscron 34 32 54 31
TEMPORADA 2019/2020
LIGA BELGA
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 29 58 14 70
2 KAA Gent KAA Gent 29 59 34 55
3 Charleroi Charleroi 29 49 23 54
4 Antwerp Antwerp 29 49 32 53
5 Standard de Liège Standard 29 47 32 49
6 KV Mechelen KV Mechelen 29 46 43 44
7 Genk Genk 29 45 42 44
8 Anderlecht Anderlecht 29 45 29 43
9 Zulte-Waregem Zulte-Warege 29 41 49 36
10 Mouscron Mouscron 29 38 40 36
11 Kortrijk Kortrijk 29 40 44 33
12 Sint-Truidense V.V. Sint-Truiden 29 33 50 33
13 KAS Eupen KAS Eupen 29 28 51 30
14 Cercle Brugge Cercle 29 27 54 23
15 KV Oostende KV Oostende 29 29 58 22
16 SK Beveren SK Beveren 29 21 60 20
TEMPORADA 2018/2019
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Genk Genk 30 63 31 63
2 Club Brugge Club Brugge 30 64 32 56
3 Standard de Liège Standard 30 49 35 53
4 Anderlecht Anderlecht 30 49 34 51
5 KAA Gent KAA Gent 30 53 45 50
6 Antwerp Antwerp 30 39 34 49
7 Sint-Truidense V.V. Sint-Truiden 30 47 36 47
8 Kortrijk Kortrijk 30 44 42 43
9 Charleroi Charleroi 30 43 43 42
10 Mouscron Mouscron 30 33 33 40
11 Zulte-Waregem Zulte-Warege 30 49 60 33
12 KAS Eupen KAS Eupen 30 34 57 32
13 Cercle Brugge Cercle 30 35 59 28
14 KV Oostende KV Oostende 30 29 52 27
15 SK Beveren SK Beveren 30 37 50 27
16 Lokeren Lokeren 30 28 53 20
TEMPORADA 2017/2018
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 30 68 33 67
2 Anderlecht Anderlecht 30 49 42 55
3 Charleroi Charleroi 30 46 30 51
4 KAA Gent KAA Gent 30 45 27 50
5 Genk Genk 30 44 36 44
6 Standard de Liège Standard 30 43 41 44
7 Kortrijk Kortrijk 30 42 39 42
8 Antwerp Antwerp 30 38 40 41
9 Zulte-Waregem Zulte-Warege 30 47 52 37
10 Sint-Truidense V.V. Sint-Truiden 30 29 41 37
11 KV Oostende KV Oostende 30 42 41 36
12 SK Beveren SK Beveren 30 50 51 35
13 Lokeren Lokeren 30 33 49 31
14 Mouscron Mouscron 30 40 59 30
15 KAS Eupen KAS Eupen 30 40 57 27
16 KV Mechelen KV Mechelen 30 31 49 27
TEMPORADA 2016/2017
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 30 67 30 61
2 Club Brugge Club Brugge 30 56 24 59
3 Zulte-Waregem Zulte-Warege 30 49 38 54
4 KAA Gent KAA Gent 30 45 29 50
5 KV Oostende KV Oostende 30 52 37 50
6 Charleroi Charleroi 30 34 29 49
7 KV Mechelen KV Mechelen 30 41 36 48
8 Genk Genk 30 40 35 48
9 Standard de Liège Standard 30 47 38 39
10 Kortrijk Kortrijk 30 38 55 31
11 Lokeren Lokeren 30 24 34 31
12 Sint-Truidense V.V. Sint-Truiden 30 35 48 30
13 KAS Eupen KAS Eupen 30 40 64 30
14 SK Beveren SK Beveren 30 28 43 30
15 Mouscron Mouscron 30 29 53 24
16 KVC Westerlo Westerlo 30 33 65 23
TEMPORADA 2015/2016
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 White Star Woluwé White Star. 32 53 28 63
2 KAS Eupen KAS Eupen 32 69 34 62
3 Antwerp Antwerp 32 52 20 62
4 Tubize Tubize 32 51 34 57
5 Cercle Brugge Cercle 32 56 35 54
6 Union Saint-Gilloise Union 32 50 34 51
7 Lierse SK Lierse SK 32 53 41 51
8 Lommel SK Lommel SK 32 43 29 50
9 KSV Roeselare Roeselare 32 46 47 50
10 Dessel Sport Dessel Sport 32 38 40 48
11 RFC Seraing RFC Seraing 32 45 50 44
12 Excelsior Virton Excelsior 32 40 55 34
13 Geel-Meerhout Geel-Meerhou 32 40 56 31
14 Deinze Deinze 32 36 58 29
15 Patro Eisden Patro Eisden 32 33 63 24
16 Heist Heist 32 39 82 19
17 Coxyde Coxyde 32 29 67 16
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
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 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
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

  USO DE MEMORIA  
7,695,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1417
Total Execution Time  0.1429
  CADENA URL  
/historico/As-Eupen
  GET DATOS  
$_GET['/historico/As-Eupen']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0053  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 = 'As-Eupen' 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.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=7508 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=7508 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=7508 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=7508 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=7508 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0028  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 = '7508' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0034  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 = '7508' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 75664 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  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=7508 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0033  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 (75664,73206,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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 75664 AND teamId = 7508
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 7508
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7508
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 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 = 75664 AND t.round = 4 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0034  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 = 75664 WHERE rp.league_id = 75664 AND rp.teamId = 7508 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 = 75664 WHERE rp.league_id = 75664 AND rp.teamId = 7508 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 75664 WHERE rp.league_id = 75664 AND rp.teamId = 7508 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 = 7508 AND l.year <= 2024 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 `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 = 67769 AND t.round = 34 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 `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 = 56829 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `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 = 49865 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.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 `tables2018` 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 = 38639 AND t.round = 30 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 `tables2017` 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 = 33313 AND t.round = 30 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 `tables2016` 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 = 15406 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 `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.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 `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.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 `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.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 `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.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 = 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.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 `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.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 `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.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 `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