4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
DIVISIÓN BELGA 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Belisia Bilzen Belisia 32 66 34 65
2 Sporting Hasselt Sporting 32 62 33 64
3 Lyra-Lierse Lyra-Lierse 32 60 46 58
4 Rupel Boom Rupel Boom 32 57 55 54
5 Bocholter Bocholter 33 58 45 53
6 KFC Houtvenne Houtvenne 32 47 42 53
7 Racing Mechelen Racing 32 59 44 52
8 Tongeren Tongeren 32 49 46 47
9 Diegem Sport Diegem Sport 32 56 56 44
10 Mechelen Sub 21 Mechelen 32 51 44 43
11 FC Lebbeke FC Lebbeke 32 48 53 43
12 Wezel Wezel 33 58 66 42
13 Berchem Sport Berchem 32 41 41 42
14 Hades Hades 32 50 54 41
15 KFC Lille KFC Lille 32 46 57 39
16 Tempo Overijse Tempo 32 28 51 28
17 Londerzeel Londerzeel 32 32 54 25
18 KSC City Pirates City Pirates 32 37 84 19
TEMPORADA 2022/2023
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Cappellen Cappellen 34 61 37 66
2 Hades Hades 34 51 32 62
3 Sporting Hasselt Sporting 34 52 42 58
4 Belisia Bilzen Belisia 34 55 37 56
5 Tongeren Tongeren 34 61 56 56
6 Lyra-Lierse Lyra-Lierse 34 64 45 55
7 Mechelen Sub 21 Mechelen 34 60 48 54
8 Diegem Sport Diegem Sport 34 56 51 52
9 Bocholt Bocholt 34 54 46 49
10 Racing Mechelen Racing 34 45 36 47
11 KFC Lille KFC Lille 34 55 59 46
12 KSC City Pirates City Pirates 34 56 75 44
13 Londerzeel Londerzeel 34 51 48 41
14 Berchem Sport Berchem 34 45 61 38
15 FC Lebbeke FC Lebbeke 34 47 64 38
16 KFC Turnhout Turnhout 34 68 81 34
17 Pepingen-Halle Pepingen-Hal 34 36 66 28
18 Beerschot-Wilrijk Sub 21 Beerschot-Wi 34 40 73 27
TEMPORADA 2021/2022
DIVISIÓN BELGA 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Hoogstraten Hoogstraten 30 72 22 70
2 Eendracht Aalst Eendracht 30 61 35 57
3 Lyra-Lierse Lyra-Lierse 30 52 29 57
4 Cappellen Cappellen 30 53 40 53
5 Belisia Bilzen Belisia 30 44 32 52
6 Bocholt Bocholt 30 47 38 51
7 KSC City Pirates City Pirates 30 44 56 43
8 Londerzeel Londerzeel 30 36 37 38
9 Diegem Sport Diegem Sport 30 36 45 35
10 Sporting Hasselt Sporting 30 38 50 34
11 Berchem Sport Berchem 30 36 45 33
12 Hades Hades 30 34 45 32
13 Heur Tongeren Heur 30 37 49 32
14 Pepingen-Halle Pepingen-Hal 30 34 51 28
15 KFC Houtvenne Houtvenne 30 30 52 26
16 Olympia Wijgmaal Olympia 30 30 58 25
TEMPORADA 2020/2021
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Bocholt Bocholt 4 11 5 10
2 Hoogstraten Hoogstraten 4 9 4 7
3 Lyra-Lierse Lyra-Lierse 4 7 4 7
4 Sporting Hasselt Sporting 3 6 3 7
5 Diegem Sport Diegem Sport 4 8 7 7
6 Londerzeel Londerzeel 4 7 9 7
7 Hades Hades 3 9 3 6
8 Pepingen-Halle Pepingen-Hal 3 5 3 6
9 Berchem Sport Berchem 3 4 3 5
10 KFC Houtvenne Houtvenne 4 4 7 4
11 Cappellen Cappellen 3 6 6 3
12 Belisia Bilzen Belisia 3 5 8 3
13 Heur Tongeren Heur 3 1 7 1
14 Eendracht Aalst Eendracht 2 1 3 0
15 KSC City Pirates City Pirates 2 3 7 0
16 Olympia Wijgmaal Olympia 3 2 9 0
TEMPORADA 2019/2020
DIVISIÓN BELGA 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Tienen Tienen 24 43 30 47
2 Eendracht Aalst Eendracht 24 43 27 44
3 Bocholt Bocholt 24 40 26 43
4 Cappellen Cappellen 24 36 28 37
5 Sporting Hasselt Sporting 24 31 31 37
6 Hades Hades 23 33 30 34
7 Diegem Sport Diegem Sport 23 29 27 34
8 Vosselaar Vosselaar 23 35 33 32
9 Berchem Sport Berchem 24 35 38 31
10 Londerzeel Londerzeel 24 32 39 28
11 Geel-Meerhout Geel-Meerhou 24 29 35 27
12 Olympia Wijgmaal Olympia 24 38 40 26
13 Pepingen-Halle Pepingen-Hal 24 24 32 25
14 KFC Duffel KFC Duffel 19 32 32 24
15 Hoogstraten Hoogstraten 23 27 31 24
16 Belisia Bilzen Belisia 23 23 51 21
TEMPORADA 2018/2019
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Patro Eisden Patro Eisden 30 59 26 66
2 Sporting Hasselt Sporting 30 53 29 60
3 Bocholt Bocholt 31 56 39 52
4 Temse Temse 30 60 48 51
5 Hades Hades 30 50 40 43
6 Berchem Sport Berchem 31 55 51 43
7 KFC Duffel KFC Duffel 30 47 40 41
8 Cappellen Cappellen 30 41 41 41
9 Sint-Niklaas Sint-Niklaas 30 48 47 40
10 Vosselaar Vosselaar 30 45 59 38
11 Hoogstraten Hoogstraten 30 30 33 37
12 VW Hamme VW Hamme 30 44 48 36
13 Belisia Bilzen Belisia 30 48 56 35
14 KSC City Pirates City Pirates 30 35 42 34
15 KFC Turnhout Turnhout 30 38 58 29
16 Heur Tongeren Heur 30 30 82 14
TEMPORADA 2017/2018
DIVISIÓN NACIONAL BELGA 1
Equipo PJ GF GC Puntos
1 Lommel SK Lommel SK 30 69 20 71
2 Knokke Knokke 30 69 32 61
3 Dessel Sport Dessel Sport 30 53 29 60
4 Deinze Deinze 30 44 30 50
5 RFC Seraing RFC Seraing 30 50 34 48
6 Heist Heist 30 47 45 47
7 Oudenaarde Oudenaarde 30 50 36 45
8 Eendracht Aalst Eendracht 30 48 46 44
9 Geel-Meerhout Geel-Meerhou 30 47 53 39
10 Excelsior Virton Excelsior 30 40 45 37
11 FCV Dender FCV Dender 30 39 52 36
12 Oosterwijk Oosterwijk 30 39 47 34
13 Châtelet Châtelet 30 34 53 29
14 VW Hamme VW Hamme 30 32 59 28
15 Berchem Sport Berchem 30 34 53 25
16 Patro Eisden Patro Eisden 30 18 79 14
TEMPORADA 2016/2017
DIVISIÓN BELGA 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Berchem Sport Berchem 30 65 24 68
2 Thes Sport Thes Sport 30 61 38 66
3 Rupel Boom Rupel Boom 30 55 38 52
4 Belisia Bilzen Belisia 30 54 58 47
5 Olympia Wijgmaal Olympia 30 45 42 44
6 Bocholt Bocholt 30 44 39 41
7 Zwarte Leeuw Zwarte Leeuw 30 39 56 40
8 Londerzeel Londerzeel 30 46 39 38
9 Hoogstraten Hoogstraten 30 51 60 37
10 Hades Hades 30 45 60 37
11 Cappellen Cappellen 30 41 42 36
12 Tempo Overijse Tempo 30 53 59 36
13 KFC Duffel KFC Duffel 30 53 58 32
14 Grimbergen Grimbergen 30 37 46 32
15 Woluwe Woluwe 30 48 62 32
16 Tienen Tienen 30 29 45 30
TEMPORADA 2015/2016
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Oosterwijk Oosterwijk 36 68 38 71
2 Beerschot VA Beerschot 36 64 39 71
3 Bocholt Bocholt 36 52 41 64
4 Sporting Hasselt Sporting 36 64 41 60
5 Ciney Ciney 36 57 42 57
6 Sprimont-Comblain Sprimont-Com 36 56 43 56
7 RFC Liège RFC Liège 36 58 56 53
8 Hamoir Hamoir 36 70 74 52
9 Rupel Boom Rupel Boom 36 65 55 51
10 Berchem Sport Berchem 36 51 55 50
11 Cappellen Cappellen 36 51 56 49
12 Hoogstraten Hoogstraten 36 60 60 48
13 Walhain Walhain 36 48 57 47
14 Tempo Overijse Tempo 36 47 56 45
15 Tienen Tienen 36 52 56 40
16 La Calamine La Calamine 37 44 61 40
17 Grimbergen Grimbergen 36 38 55 34
18 Diegem Sport Diegem Sport 37 35 68 34
19 Woluwe Woluwe 36 34 61 33
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
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Woluwe Woluwe 35 71 31 73
2 Verviers Verviers 34 66 28 69
3 Patro Eisden Patro Eisden 36 62 47 64
4 KFC Turnhout Turnhout 36 54 50 56
5 La Louvière Centre Louvière 36 55 47 54
6 Bocholt Bocholt 36 51 52 52
7 La Calamine La Calamine 36 73 62 51
8 Union Saint-Gilloise Union 35 42 36 49
9 Sporting Hasselt Sporting 34 30 41 45
10 Cappellen Cappellen 36 49 67 45
11 Ciney Ciney 35 51 48 44
12 Sprimont-Comblain Sprimont-Com 34 57 66 44
13 Diegem Sport Diegem Sport 35 46 65 41
14 Berchem Sport Berchem 35 48 56 40
15 Grimbergen Grimbergen 35 49 62 40
16 Oosterwijk Oosterwijk 34 45 69 39
17 Huy Huy 35 40 42 38
18 Charleroi Fleurus Charleroi 35 46 66 36
TEMPORADA 2012/2013
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Hoogstraten Hoogstraten 34 73 31 74
2 Racing Mechelen Racing 34 55 37 64
3 Geel-Meerhout Geel-Meerhou 34 65 37 61
4 Rupel Boom Rupel Boom 34 56 45 56
5 Berchem Sport Berchem 34 50 46 52
6 Cappellen Cappellen 34 57 38 51
7 Torhout Torhout 34 42 37 51
8 VW Hamme VW Hamme 34 49 44 48
9 Coxyde Coxyde 34 54 42 46
10 Bornem Bornem 34 51 53 45
11 Temse Temse 34 39 51 43
12 Standaard Wetteren Standaard 34 46 56 42
13 Deinze Deinze 34 51 60 39
14 Olsa Brakel Olsa Brakel 34 44 56 39
15 KFC Turnhout Turnhout 34 53 66 34
16 Izegem Izegem 34 49 67 34
17 Ronse Ronse 34 47 73 31
18 Racing Waregem Racing 34 42 84 28
TEMPORADA 2011/2012
PROMOCIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Berchem Sport Berchem 30 64 26 68
2 Tempo Overijse Tempo 30 58 23 64
3 Charleroi Fleurus Charleroi 30 61 34 57
4 VC Groot Dilbeek Groot 30 61 54 49
5 Ternat Ternat 30 51 47 47
6 Ganshoren Ganshoren 30 46 39 45
7 Londerzeel Londerzeel 30 47 42 45
8 Acren Lessines Acren 30 42 44 44
9 KFC Duffel KFC Duffel 30 56 59 38
10 Léopold Uccle-Woluwé Léopold 30 42 50 34
11 Lyra Lyra 30 42 44 33
12 SG-Tertre-Hautrage SG-Tertre-Ha 30 42 59 33
13 Kampenhout Kampenhout 30 33 53 33
14 Katelijne-Waver Katelijne-Wa 30 33 60 31
15 Mariekerke Mariekerke 30 33 55 26
16 Sint-Gillis Waas Sint-Gillis 30 29 51 23
TEMPORADA 2010/2011
PROMOCIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Racing Mechelen Racing 30 62 20 68
2 Londerzeel Londerzeel 30 66 30 58
3 Olympia Wijgmaal Olympia 30 61 42 54
4 TK Meldert TK Meldert 30 62 37 51
5 Lyra Lyra 30 40 35 46
6 Katelijne-Waver Katelijne-Wa 30 55 53 41
7 KFC Duffel KFC Duffel 30 60 57 40
8 Berchem Sport Berchem 30 35 32 40
9 VC Groot Dilbeek Groot 30 46 44 40
10 Tempo Overijse Tempo 30 37 39 40
11 Sint-Gillis Waas Sint-Gillis 30 48 46 39
12 Averbode Okselaar Averbode 30 40 42 39
13 Berlare Berlare 30 47 43 38
14 Eendracht Zele Eendracht 30 33 44 32
15 Opwijk Opwijk 30 40 76 23
16 Willebroek-Meerhof Willebroek-M 30 21 113 6
TEMPORADA 2009/2010
PROMOCIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Bornem Bornem 30 60 32 60
2 Grimbergen Grimbergen 30 57 31 52
3 Oosterwijk Oosterwijk 30 39 30 49
4 TK Meldert TK Meldert 30 48 34 48
5 Olympia Wijgmaal Olympia 30 46 44 48
6 KFC Duffel KFC Duffel 30 44 38 46
7 Sint-Gillis Waas Sint-Gillis 30 51 39 44
8 Lyra Lyra 30 33 32 41
9 Tempo Overijse Tempo 30 35 36 38
10 VC Groot Dilbeek Groot 30 42 45 38
11 Londerzeel Londerzeel 30 37 40 37
12 Berchem Sport Berchem 30 44 47 36
13 Opwijk Opwijk 30 44 53 35
14 Vilvoorde Vilvoorde 30 44 55 34
15 Beerschot VA Beerschot 30 41 60 31
16 Vrasene Vrasene 30 24 73 18
TEMPORADA 2008/2009
PROMOCIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Temse Temse 30 63 37 59
2 Bornem Bornem 30 49 25 56
3 VC Groot Dilbeek Groot 30 56 31 55
4 TK Meldert TK Meldert 30 56 37 51
5 Ternat Ternat 30 64 48 49
6 Opwijk Opwijk 30 42 31 49
7 KFC Duffel KFC Duffel 30 48 38 49
8 Berchem Sport Berchem 30 43 37 44
9 Grimbergen Grimbergen 30 57 44 42
10 Beerschot VA Beerschot 30 55 52 42
11 Berlare Berlare 30 48 38 40
12 Eendracht Zele Eendracht 30 42 60 33
13 Londerzeel Londerzeel 30 41 44 32
14 Eendracht Buggenhout Eendracht 30 29 65 23
15 Tubantia Borgerhout Tubantia 30 24 65 20
16 Schoten Schoten 30 18 83 10
TEMPORADA 2007/2008
PROMOCIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Woluwe Woluwe 30 60 21 66
2 KRC Gent KRC Gent 29 60 26 66
3 Rupel Boom Rupel Boom 30 66 34 64
4 Temse Temse 30 67 31 62
5 Schoten Schoten 30 51 40 47
6 Heist Heist 30 56 45 46
7 Lyra Lyra 30 42 45 42
8 Bornem Bornem 30 51 54 41
9 Tubantia Borgerhout Tubantia 30 37 58 38
10 Eendracht Zele Eendracht 29 36 43 32
11 Berchem Sport Berchem 30 34 43 32
12 Grimbergen Grimbergen 30 43 58 32
13 Olympia Wijgmaal Olympia 30 37 52 32
14 Léopold Uccle-Woluwé Léopold 30 30 59 29
15 Evergem-Center Evergem-Cent 30 34 62 22
16 Tempo Overijse Tempo 30 31 64 21
TEMPORADA 2003/2004
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Kortrijk Kortrijk 30 48 20 63
2 KFC Turnhout Turnhout 30 70 32 62
3 SK Beveren SK Beveren 29 57 28 61
4 Sint-Niklaas Sint-Niklaas 30 65 35 55
5 KV Mechelen KV Mechelen 29 45 23 50
6 Cappellen Cappellen 29 65 33 49
7 Torhout Torhout 30 53 43 47
8 Standaard Wetteren Standaard 30 40 41 44
9 Racing Mechelen Racing 30 36 37 39
10 Lyra Lyra 30 48 53 35
11 Wevelgem City Wevelgem 29 41 44 34
12 Maldegem Maldegem 30 40 58 33
13 Bornem Bornem 30 43 57 31
14 TK Meldert TK Meldert 30 41 81 19
15 Olen Olen 30 26 85 18
16 Berchem Sport Berchem 30 18 66 14
TEMPORADA 2002/2003
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Berchem Sport Berchem 26 45 23 51
2 KV Oostende KV Oostende 26 51 27 47
3 Eendracht Aalst Eendracht 25 39 37 45
4 Wevelgem City Wevelgem 26 54 33 42
5 Kortrijk Kortrijk 27 38 30 39
6 TK Meldert TK Meldert 26 40 46 36
7 Tournai Tournai 26 37 32 34
8 Cappellen Cappellen 26 32 38 34
9 Maldegem Maldegem 26 42 49 34
10 SK Beveren SK Beveren 26 44 38 33
11 Sint-Niklaas Sint-Niklaas 26 29 37 29
12 Denderhoutem Denderhoutem 26 36 46 29
13 Francs Borains Francs 26 27 38 26
14 Torhout Torhout 26 24 43 24
15 KRC Gent KRC Gent 26 20 41 21
TEMPORADA 1986/1987
LIGA BELGA
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 34 82 25 82
2 KV Mechelen KV Mechelen 34 57 18 79
3 Club Brugge Club Brugge 34 70 34 64
4 Lokeren Lokeren 34 59 41 62
5 KSK Beveren KSK Beveren 34 44 24 59
6 RFC Liège RFC Liège 34 44 38 52
7 Charleroi Charleroi 34 49 52 48
8 KSV Waregem KSV Waregem 34 45 43 47
9 K Beerschot VAC Beerschot 34 35 39 44
10 Standard de Liège Standard 34 40 38 41
11 Cercle Brugge Cercle 34 37 40 39
12 Racing Jet Wavre Racing Wavre 34 34 47 39
13 RWD Molenbeek Molenbeek 34 37 53 36
14 Antwerp Antwerp 34 43 49 34
15 Kortrijk Kortrijk 34 37 52 32
16 KAA Gent KAA Gent 34 25 50 30
17 RFC Seraing RFC Seraing 34 30 63 25
18 Berchem Sport Berchem 34 20 82 19

  USO DE MEMORIA  
7,910,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6950
Total Execution Time  0.6961
  CADENA URL  
/historico/Berchem-Sport
  GET DATOS  
$_GET['/historico/Berchem-Sport']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0160  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 = 'Berchem-Sport' 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.0145  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=9787 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=9787 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=9787 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=9787 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9787 AND type_rel = 2
0.0159  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 = '9787' ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '9787' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0152  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 = '9787' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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=9787 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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,72696,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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 72696 AND teamId = 9787
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 9787
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9787
0.0154  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 = 72696 WHERE rp.league_id = 72696 AND rp.teamId = 9787 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.0153  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 = 72696 WHERE rp.league_id = 72696 AND rp.teamId = 9787 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 72696 WHERE rp.league_id = 72696 AND rp.teamId = 9787 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0159  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 = 9787 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0150  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 = 72696 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.0151  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 = 68500 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.0148  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 = 63434 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.0149  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 = 57813 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 50976 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.0148  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 = 45033 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 38873 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 33883 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 15756 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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.0151  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 = 2738 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 2018 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 27960 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 27970 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 27976 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 27981 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 27985 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 24311 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 24308 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables1987` 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 = 25366 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC