4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sint-Niklaas
TEMPORADA 2022/2023
PROVINCIAL BÉLGICA GRUPO 10
Equipo PJ GF GC Puntos
1 Toekomst Borsbeke Toekomst 30 57 25 62
2 Sint-Denijs Sport Sint-Denijs 30 52 30 60
3 Munkzwalm Munkzwalm 30 74 38 52
4 KSK Beveren KSK Beveren 30 57 40 51
5 Svelta Melsele Svelta 30 69 49 48
6 Sottegem Sottegem 30 61 42 47
7 Ardennen Ardennen 30 52 41 47
8 Maldegem Maldegem 29 45 44 45
9 Berlare Berlare 30 55 56 43
10 Denderhoutem Denderhoutem 30 38 42 43
11 Haasdonk Haasdonk 29 42 40 41
12 Eendracht Zele Eendracht 30 57 58 39
13 Excelsior Mariakerke Excelsior 27 35 46 31
14 Heikant Zele Heikant Zele 30 45 60 26
15 Grembergen Grembergen 30 29 47 24
16 Sint-Niklaas Sint-Niklaas 29 17 127 0
TEMPORADA 2021/2022
PROMOCIÓN BÉLGICA GRUPO 3
Equipo PJ GF GC Puntos
1 Oostkamp Oostkamp 30 83 37 74
2 FC Lebbeke FC Lebbeke 30 60 30 63
3 Tempo Overijse Tempo 30 55 37 54
4 Torhout Torhout 30 52 45 54
5 Lochristi Lochristi 30 60 47 48
6 Erpe-Mere United Erpe-Mere 30 45 39 44
7 VW Hamme VW Hamme 30 49 45 44
8 Avanti Avanti 30 48 38 42
9 Wolvertem Merchtem Wolvertem 30 42 39 36
10 Voorde Appelterre Voorde 30 47 52 36
11 Anzegem Anzegem 30 47 60 35
12 Jong Lede Jong Lede 30 47 61 34
13 Eppegem Eppegem 30 36 39 32
14 Svelta Melsele Svelta 30 47 75 27
15 Sint-Niklaas Sint-Niklaas 30 32 66 25
16 Rhodienne-De Hoek Rhodienne-De 30 26 66 23
TEMPORADA 2020/2021
PROMOCIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 Avanti Avanti 4 7 2 10
2 FC Lebbeke FC Lebbeke 4 9 5 8
3 Tempo Overijse Tempo 3 7 3 7
4 Oostkamp Oostkamp 4 10 8 7
5 Lochristi Lochristi 3 8 6 6
6 Bambrugge Bambrugge 4 3 4 6
7 Torhout Torhout 4 8 8 4
8 VW Hamme VW Hamme 3 4 4 4
9 Anzegem Anzegem 4 3 5 4
10 Wolvertem Merchtem Wolvertem 4 6 9 4
11 Voorde Appelterre Voorde 3 5 5 3
12 Sint-Niklaas Sint-Niklaas 2 3 5 3
13 Eppegem Eppegem 2 3 3 2
14 Jong Lede Jong Lede 3 1 2 2
15 Rhodienne-De Hoek Rhodienne-De 3 4 6 1
16 Svelta Melsele Svelta 4 4 10 1
TEMPORADA 2019/2020
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Knokke Knokke 24 57 15 63
2 Mandel United Mandel 24 51 31 45
3 Ronse Ronse 24 42 26 45
4 Oudenaarde Oudenaarde 24 54 46 42
5 KRC Gent KRC Gent 24 36 29 41
6 Sparta Petegem Sparta 24 51 39 39
7 Gullegem Gullegem 24 36 32 39
8 Voorwaarts Zwevezele Voorwaarts 24 41 28 38
9 Racing Club Harelbeke Racing Club 24 30 35 35
10 Dikkelvenne Dikkelvenne 24 35 37 31
11 Westhoek Westhoek 24 29 48 28
12 Temse Temse 24 22 38 24
13 KSCT Menen KSCT Menen 24 28 47 20
14 Merelbeke Merelbeke 24 25 41 19
15 Sint-Niklaas Sint-Niklaas 24 22 49 16
16 VW Hamme VW Hamme 24 34 52 15
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 BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Rupel Boom Rupel Boom 30 74 49 61
2 Izegem Izegem 30 59 33 57
3 KVC Winkel Sport Winkel Sport 30 60 41 55
4 Sparta Petegem Sparta 30 64 40 53
5 Westhoek Westhoek 30 61 56 51
6 Sint-Niklaas Sint-Niklaas 30 55 43 50
7 Temse Temse 30 51 42 48
8 Racing Club Harelbeke Racing Club 30 45 42 43
9 Olsa Brakel Olsa Brakel 30 41 49 41
10 Gullegem Gullegem 30 51 52 40
11 KRC Gent KRC Gent 30 47 59 37
12 Londerzeel Londerzeel 30 55 51 36
13 Ronse Ronse 30 33 44 33
14 Pepingen-Halle Pepingen-Hal 30 30 56 28
15 Torhout Torhout 30 36 67 26
16 Bornem Bornem 30 28 66 17
TEMPORADA 2016/2017
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Knokke Knokke 30 73 25 72
2 Sparta Petegem Sparta 30 60 44 58
3 Eendracht Aalst Eendracht 30 55 37 56
4 KVC Winkel Sport Winkel Sport 30 55 30 53
5 Izegem Izegem 30 53 42 53
6 Olsa Brakel Olsa Brakel 30 59 51 43
7 Temse Temse 30 38 45 42
8 KRC Gent KRC Gent 30 46 43 41
9 Torhout Torhout 30 36 45 39
10 Gullegem Gullegem 30 46 52 37
11 Sint-Niklaas Sint-Niklaas 30 45 49 35
12 Bornem Bornem 30 31 39 34
13 Racing Club Harelbeke Racing Club 30 36 45 34
14 Westhoek Westhoek 30 40 56 34
15 Halle Halle 30 27 55 23
16 KSCT Menen KSCT Menen 30 35 77 16
TEMPORADA 2015/2016
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 VW Hamme VW Hamme 34 66 31 68
2 KVC Winkel Sport Winkel Sport 34 61 43 63
3 Oudenaarde Oudenaarde 34 70 45 60
4 FCV Dender FCV Dender 34 69 43 59
5 Londerzeel Londerzeel 34 58 37 59
6 Sparta Petegem Sparta 34 66 54 56
7 Eendracht Aalst Eendracht 34 66 55 54
8 Temse Temse 34 60 48 53
9 La Louvière Centre Louvière 34 54 44 50
10 Olsa Brakel Olsa Brakel 34 56 46 46
11 Gullegem Gullegem 34 50 45 45
12 KRC Gent KRC Gent 34 50 56 43
13 Sint-Niklaas Sint-Niklaas 34 51 57 42
14 Bornem Bornem 34 54 56 38
15 Izegem Izegem 34 51 73 28
16 Torhout Torhout 34 29 75 28
17 Acren Lessines Acren 34 37 91 23
18 Racing Mechelen Racing 34 33 82 22
TEMPORADA 2014/2015
PROMOCIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 Sparta Petegem Sparta 30 67 30 66
2 Sint-Niklaas Sint-Niklaas 30 64 33 63
3 Racing Club Harelbeke Racing Club 30 67 34 58
4 OMS Ingelmunster Ingelmunster 30 73 38 56
5 Westhoek Westhoek 30 74 53 53
6 Ronse Ronse 30 55 47 48
7 Knokke Knokke 30 53 46 46
8 KSCT Menen KSCT Menen 30 44 42 41
9 Standaard Wetteren Standaard 30 45 42 40
10 Sint-Gillis Waas Sint-Gillis 30 41 60 36
11 Berlare Berlare 30 52 59 34
12 Eernegem Eernegem 30 33 51 33
13 Wetteren-Kwatrecht Wetteren-Kwa 30 41 63 33
14 Jong Lede Jong Lede 30 29 43 31
15 Racing Waregem Racing 30 37 81 18
16 Sassport Boezinge Sassport 30 32 85 10
TEMPORADA 2013/2014
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Mechelen Racing 35 77 37 75
2 Oudenaarde Oudenaarde 35 64 39 67
3 Deinze Deinze 35 55 39 60
4 Londerzeel Londerzeel 34 55 41 57
5 Coxyde Coxyde 34 66 46 56
6 Géants Athois Géants 35 49 39 53
7 Olsa Brakel Olsa Brakel 35 60 59 51
8 KRC Gent KRC Gent 35 53 48 49
9 Tournai Tournai 35 54 56 47
10 VW Hamme VW Hamme 35 62 67 41
11 Torhout Torhout 34 39 55 41
12 FCV Dender FCV Dender 34 45 59 40
13 Izegem Izegem 35 46 60 39
14 Rupel Boom Rupel Boom 34 41 63 39
15 Temse Temse 34 46 56 37
16 Bornem Bornem 35 55 62 36
17 Sint-Niklaas Sint-Niklaas 34 40 50 33
18 Standaard Wetteren Standaard 34 35 66 32
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
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Eendracht Aalst Eendracht 34 71 29 74
2 Hoogstraten Hoogstraten 34 74 39 62
3 Deinze Deinze 34 62 54 59
4 Coxyde Coxyde 34 70 54 58
5 Dessel Sport Dessel Sport 34 56 38 57
6 Oudenaarde Oudenaarde 34 57 49 55
7 Sint-Niklaas Sint-Niklaas 34 47 36 54
8 Geel-Meerhout Geel-Meerhou 34 51 45 53
9 Ronse Ronse 34 42 39 45
10 VW Hamme VW Hamme 34 40 49 43
11 Torhout Torhout 34 43 57 42
12 Temse Temse 34 45 61 42
13 Olsa Brakel Olsa Brakel 34 53 64 38
14 Racing Waregem Racing 34 31 50 38
15 Bornem Bornem 34 44 48 37
16 Cappellen Cappellen 34 45 51 35
17 Izegem Izegem 34 44 57 34
18 Wielsbeke Wielsbeke 34 31 86 18
TEMPORADA 2009/2010
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Heist Heist 36 73 34 76
2 Rupel Boom Rupel Boom 36 82 46 72
3 Eendracht Aalst Eendracht 36 82 44 67
4 Deinze Deinze 36 50 38 60
5 Temse Temse 36 61 61 56
6 Coxyde Coxyde 36 67 43 55
7 VW Hamme VW Hamme 36 59 51 55
8 Hoogstraten Hoogstraten 36 59 55 50
9 Sint-Niklaas Sint-Niklaas 36 62 55 49
10 Oudenaarde Oudenaarde 36 62 62 48
11 Racing Waregem Racing 36 43 51 48
12 Torhout Torhout 36 49 51 45
13 Wielsbeke Wielsbeke 36 50 62 45
14 Ternat Ternat 36 53 72 41
15 Cappellen Cappellen 36 40 62 39
16 Sottegem Sottegem 36 32 65 38
17 Westhoek Westhoek 36 53 70 37
18 Racing Mechelen Racing 36 52 71 37
19 Willebroek-Meerhof Willebroek-M 36 40 76 30
TEMPORADA 2008/2009
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Standaard Wetteren Standaard 30 68 30 64
2 Woluwe Woluwe 30 46 22 60
3 Francs Borains Francs 30 62 31 55
4 Diegem Sport Diegem Sport 30 43 27 54
5 La Louvière Centre Louvière 30 56 45 45
6 Sottegem Sottegem 30 35 30 45
7 Oudenaarde Oudenaarde 30 43 40 45
8 Racing Waregem Racing 30 40 37 45
9 Sint-Niklaas Sint-Niklaas 30 55 44 43
10 WS Bruxelles Bruxelles 30 44 45 39
11 Eendracht Aalst Eendracht 30 38 50 38
12 Union Saint-Gilloise Union 30 39 43 33
13 RAAL La Louviere RAAL 30 36 61 28
14 Wielsbeke Wielsbeke 30 40 58 27
15 Mouscron Mouscron 30 27 83 27
16 KRC Gent KRC Gent 30 39 65 22
TEMPORADA 2007/2008
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Ronse Ronse 30 49 23 57
2 RAAL La Louviere RAAL 30 41 23 54
3 Mouscron Mouscron 30 49 37 54
4 Racing Waregem Racing 30 42 30 51
5 Racing Mechelen Racing 30 34 28 50
6 Sottegem Sottegem 30 37 34 48
7 Eendracht Aalst Eendracht 30 50 32 46
8 Willebroek-Meerhof Willebroek-M 30 45 39 43
9 Sint-Niklaas Sint-Niklaas 30 46 37 40
10 Francs Borains Francs 30 38 40 39
11 Diegem Sport Diegem Sport 30 31 39 39
12 Oudenaarde Oudenaarde 30 39 43 34
13 Standaard Wetteren Standaard 30 34 51 33
14 Londerzeel Londerzeel 30 34 40 30
15 Torhout Torhout 30 39 70 24
16 Charleroi Fleurus Charleroi 30 29 71 19
TEMPORADA 2006/2007
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Verbroedering Geel Verbroederin 30 66 25 65
2 Tournai Tournai 30 47 24 61
3 Diegem Sport Diegem Sport 30 47 19 59
4 Mouscron Mouscron 30 43 33 51
5 KFC Turnhout Turnhout 30 56 41 49
6 Cappellen Cappellen 30 32 23 45
7 Standaard Wetteren Standaard 30 41 40 45
8 Sint-Niklaas Sint-Niklaas 30 51 42 44
9 Londerzeel Londerzeel 30 35 34 38
10 Torhout Torhout 30 39 48 38
11 Oudenaarde Oudenaarde 30 37 42 37
12 Racing Mechelen Racing 30 35 39 34
13 Willebroek-Meerhof Willebroek-M 30 38 52 32
14 Racing Club Harelbeke Racing Club 30 28 53 22
15 Geel-Meerhout Geel-Meerhou 30 21 58 20
16 Maldegem Maldegem 30 32 75 18
TEMPORADA 2005/2006
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 FCV Dender FCV Dender 30 66 36 65
2 Cappellen Cappellen 30 67 33 59
3 Standaard Wetteren Standaard 30 54 41 52
4 Sint-Niklaas Sint-Niklaas 30 55 30 48
5 Racing Club Harelbeke Racing Club 30 48 39 48
6 Racing Waregem Racing 30 44 37 48
7 KFC Turnhout Turnhout 30 52 40 44
8 Diegem Sport Diegem Sport 30 36 44 44
9 WS Bruxelles Bruxelles 30 44 46 42
10 Torhout Torhout 30 51 47 41
11 Willebroek-Meerhof Willebroek-M 30 42 48 37
12 Racing Mechelen Racing 30 37 44 35
13 Maldegem Maldegem 29 39 56 28
14 Eendracht Aalst Eendracht 29 28 66 22
15 Rupel Boom Rupel Boom 30 29 59 19
16 Bornem Bornem 30 22 48 18
TEMPORADA 2004/2005
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 KV Mechelen KV Mechelen 30 76 35 59
2 Cappellen Cappellen 30 58 29 58
3 Torhout Torhout 30 69 44 54
4 Sint-Niklaas Sint-Niklaas 30 60 37 54
5 Denderhoutem Denderhoutem 30 61 41 54
6 KFC Turnhout Turnhout 30 51 40 47
7 Standaard Wetteren Standaard 30 43 44 45
8 Denderleeuw Denderleeuw 30 51 46 44
9 Maldegem Maldegem 29 43 46 44
10 Racing Club Harelbeke Racing Club 30 44 41 42
11 Racing Waregem Racing 29 51 61 36
12 Racing Mechelen Racing 30 43 41 34
13 Bornem Bornem 30 48 75 27
14 Wevelgem City Wevelgem 29 34 64 26
15 Lyra Lyra 30 41 76 22
16 Evergem-Center Evergem-Cent 29 30 83 12
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

  USO DE MEMORIA  
7,587,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1393
Total Execution Time  0.1406
  CADENA URL  
/historico/Sint-Niklaas
  GET DATOS  
$_GET['/historico/Sint-Niklaas']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0123  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 = 'Sint-Niklaas' 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.0021  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=7504 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=7504 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0057  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 = 73206
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7504 AND type_rel = 2
0.0034  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 = '7504' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0032  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 = '7504' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0029  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=7504 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,68719) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 68719 AND teamId = 7504
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 7504
0.0022  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 = 73206 WHERE rp.league_id = 73206 AND rp.teamId = 7504 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.0023  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 = 73206 WHERE rp.league_id = 73206 AND rp.teamId = 7504 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 73206 WHERE rp.league_id = 73206 AND rp.teamId = 7504 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 7504 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68719 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.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 = 63441 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.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 `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 = 58299 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.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 `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 = 50975 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.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 `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.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 `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 = 39090 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 `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 = 33882 AND t.round = 30 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 `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 = 15755 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 = 13373 AND t.round = 30 ORDER BY team.conference 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 `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 = 2737 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 `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.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 `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 = 24294 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 `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 = 24297 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 24299 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 = 24303 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2007` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 24306 AND t.round = 30 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 `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 = 24319 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 `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 = 24312 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 `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