4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del VV Noordwijk

VV Noordwijk

Entrenador: Kees Zethof

Temporada 2023/2024
TEMPORADA 2023/2024
TWEEDE DIVISIE
Equipo PJ GF GC Puntos
1 Spakenburg Spakenburg 30 75 34 70
2 De Treffers De Treffers 30 60 36 65
3 Quick Boys Quick Boys 30 61 38 57
4 Katwijk Katwijk 30 55 41 53
5 GVVV GVVV 30 48 44 50
6 Amsterdamsche FC Amsterdamsch 30 53 44 48
7 Jong Almere City Jong Almere 30 55 48 45
8 Jong Sparta Jong Sparta 30 49 44 43
9 ACV Assen ACV Assen 30 46 48 43
10 HHC Hardenberg Hardenberg 30 43 36 42
11 Koninklijke HFC Koninklijke 30 48 43 42
12 ADO 20 ADO 20 30 38 48 37
13 Rijnsburgse Boys Rijnsburgse 30 41 50 36
14 VV Noordwijk Noordwijk 30 35 46 31
15 Scheveningen Scheveningen 30 38 56 28
16 Excelsior Maassluis Excelsior 30 35 57 25
17 Kozakken Boys Kozakken 30 32 55 20
18 Lisse Lisse 30 32 76 15
TEMPORADA 2022/2023
TWEEDE DIVISIE
Equipo PJ GF GC Puntos
1 Katwijk Katwijk 34 74 36 71
2 Rijnsburgse Boys Rijnsburgse 34 73 42 69
3 Amsterdamsche FC Amsterdamsch 34 60 31 69
4 HHC Hardenberg Hardenberg 34 75 48 60
5 De Treffers De Treffers 34 66 45 60
6 Quick Boys Quick Boys 34 72 48 56
7 Koninklijke HFC Koninklijke 34 52 41 55
8 Scheveningen Scheveningen 34 38 46 45
9 VV Noordwijk Noordwijk 34 45 45 43
10 Jong Sparta Jong Sparta 34 58 61 43
11 Spakenburg Spakenburg 34 50 55 43
12 Lisse Lisse 34 45 51 42
13 Kozakken Boys Kozakken 34 50 58 40
14 Excelsior Maassluis Excelsior 34 50 69 39
15 SV TEC Tiel SV TEC Tiel 34 41 60 39
16 IJsselmeervogels IJsselmeervo 34 51 71 33
17 Jong Volendam Jong 34 45 82 26
18 OFC Oostzaan Oostzaan 34 33 89 20
TEMPORADA 2021/2022
TWEEDE DIVISIE
Equipo PJ GF GC Puntos
1 Katwijk Katwijk 34 73 34 71
2 HHC Hardenberg Hardenberg 34 58 43 62
3 Koninklijke HFC Koninklijke 34 54 39 57
4 Rijnsburgse Boys Rijnsburgse 34 63 43 55
5 Jong Sparta Jong Sparta 34 57 49 55
6 Amsterdamsche FC Amsterdamsch 34 61 49 54
7 VV Noordwijk Noordwijk 34 53 46 54
8 Scheveningen Scheveningen 34 43 44 50
9 Spakenburg Spakenburg 34 64 62 49
10 Excelsior Maassluis Excelsior 34 50 55 47
11 Jong Volendam Jong 34 66 65 45
12 Quick Boys Quick Boys 34 43 53 44
13 IJsselmeervogels IJsselmeervo 34 44 48 42
14 SV TEC Tiel SV TEC Tiel 34 44 63 42
15 De Treffers De Treffers 34 38 51 41
16 Kozakken Boys Kozakken 34 46 62 35
17 GVVV GVVV 34 45 54 34
18 ASWH ASWH 34 38 80 21
TEMPORADA 2020/2021
TWEEDE DIVISIE
Equipo PJ GF GC Puntos
1 Amsterdamsche FC Amsterdamsch 5 15 5 13
2 ASWH ASWH 6 12 7 12
3 Spakenburg Spakenburg 6 11 6 12
4 Quick Boys Quick Boys 6 7 8 12
5 IJsselmeervogels IJsselmeervo 5 9 10 9
6 Rijnsburgse Boys Rijnsburgse 5 10 6 8
7 Kozakken Boys Kozakken 5 12 10 8
8 Katwijk Katwijk 5 9 7 8
9 HHC Hardenberg Hardenberg 6 7 7 8
10 Koninklijke HFC Koninklijke 4 6 5 6
11 Jong Volendam Jong 6 9 13 5
12 GVVV GVVV 6 6 11 5
13 SV TEC Tiel SV TEC Tiel 4 6 6 4
14 Excelsior Maassluis Excelsior 5 6 10 4
15 Jong Sparta Jong Sparta 6 6 9 4
16 Scheveningen Scheveningen 4 3 4 3
17 VV Noordwijk Noordwijk 5 7 10 3
18 De Treffers De Treffers 5 2 9 2
TEMPORADA 2019/2020
TWEEDE DIVISIE
Equipo PJ GF GC Puntos
1 Katwijk Katwijk 24 48 26 49
2 HHC Hardenberg Hardenberg 24 54 27 46
3 Amsterdamsche FC Amsterdamsch 24 50 33 45
4 Rijnsburgse Boys Rijnsburgse 24 55 42 45
5 IJsselmeervogels IJsselmeervo 24 57 37 44
6 Kozakken Boys Kozakken 24 38 29 42
7 Spakenburg Spakenburg 24 37 44 37
8 Koninklijke HFC Koninklijke 23 43 36 35
9 De Treffers De Treffers 24 42 36 35
10 VV Noordwijk Noordwijk 24 47 44 32
11 Jong Sparta Jong Sparta 24 43 42 31
12 Excelsior Maassluis Excelsior 24 36 47 31
13 GVVV GVVV 24 38 48 30
14 Quick Boys Quick Boys 24 25 32 27
15 Scheveningen Scheveningen 23 24 36 25
16 SV TEC Tiel SV TEC Tiel 24 17 40 16
17 Jong Volendam Jong 24 40 61 14
18 ASWH ASWH 24 26 60 14
TEMPORADA 2018/2019
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 VV Noordwijk Noordwijk 34 94 41 80
2 Quick Boys Quick Boys 34 84 41 72
3 DVS'33 DVS'33 34 102 47 68
4 Hoek Hoek 34 82 55 64
5 Groningen Sub 21 Groningen 34 66 39 58
6 Harkemase Boys Harkemase 34 68 59 57
7 ASWH ASWH 34 75 54 55
8 SteDoCo SteDoCo 34 65 56 55
9 ODIN '59 ODIN '59 34 71 66 54
10 Lisse Lisse 34 62 64 51
11 DOVO DOVO 34 76 66 48
12 Ajax Amateurs Ajax 34 52 61 41
13 ONS Sneek ONS Sneek 34 57 58 39
14 VVOG VVOG 34 41 72 35
15 Eemdijk Eemdijk 34 51 87 29
16 SJC Noordwijk Noordwijk 34 50 105 26
17 Achilles 29 Achilles 29 34 44 107 20
18 De Dijk De Dijk 34 49 111 19
TEMPORADA 2017/2018
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 VV Noordwijk Noordwijk 30 89 33 69
2 Ter Leede Ter Leede 30 70 43 62
3 SteDoCo SteDoCo 30 61 32 60
4 Hoek Hoek 30 63 41 55
5 Achilles Veen Achilles 30 48 34 54
6 Rijnvogels Rijnvogels 30 47 41 44
7 S Gravenzande SV Gravenzande 30 69 61 43
8 Jodan Boys Jodan Boys 30 53 46 42
9 Zwaluwen Zwaluwen 30 49 54 40
10 Swift Swift 30 40 54 37
11 Smitshoek Smitshoek 30 47 59 34
12 Nootdorp Nootdorp 30 35 67 32
13 AFC II AFC II 30 56 69 30
14 Rijsoord Rijsoord 30 33 57 29
15 RVVH RVVH 30 24 55 24
16 SV Argon SV Argon 30 32 70 17
TEMPORADA 2016/2017
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Spijkenisse Spijkenisse 28 62 35 56
2 Ter Leede Ter Leede 28 55 38 56
3 VV Noordwijk Noordwijk 28 66 42 53
4 Achilles Veen Achilles 28 52 36 53
5 Swift Swift 28 56 34 49
6 Ajax Amateurs Ajax 28 50 47 45
7 Jodan Boys Jodan Boys 28 52 39 41
8 Hoek Hoek 28 41 43 38
9 Door Fusie Sterk Door Fusie. 28 40 51 38
10 SV Argon SV Argon 28 44 46 36
11 RVVH RVVH 28 45 50 33
12 Zwaluwen Zwaluwen 28 43 56 30
13 Sliedrecht Sliedrecht 28 49 72 24
14 Smitshoek Smitshoek 28 35 62 24
15 Breukelen Breukelen 28 29 68 12
16 Haaglandia Haaglandia 0 0 0 0
TEMPORADA 2015/2016
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Quick Boys Quick Boys 26 58 16 64
2 VV Noordwijk Noordwijk 26 63 19 62
3 ASWH ASWH 26 53 25 48
4 Rijnvogels Rijnvogels 26 41 32 45
5 Spijkenisse Spijkenisse 26 48 41 45
6 Jodan Boys Jodan Boys 26 40 28 42
7 Ter Leede Ter Leede 26 36 40 40
8 Hoek Hoek 26 29 37 34
9 Zwaluwen Zwaluwen 26 37 51 30
10 Haaglandia Zaterdag Haaglandia 26 35 49 30
11 Xerxes DZB Xerxes DZB 26 32 43 24
12 Heinenoord Heinenoord 26 21 52 20
13 Sportlust 46 Sportlust 26 27 56 18
14 Deltasport Deltasport 26 29 60 14
TEMPORADA 2014/2015
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Katwijk Katwijk 26 69 26 64
2 Quick Boys Quick Boys 26 49 28 48
3 RVVH RVVH 26 40 30 43
4 ASWH ASWH 26 53 31 41
5 Zwaluwen Zwaluwen 26 42 41 41
6 Spijkenisse Spijkenisse 26 43 36 40
7 VV Noordwijk Noordwijk 26 42 39 38
8 Rijnvogels Rijnvogels 26 47 47 36
9 Ter Leede Ter Leede 26 41 42 35
10 Xerxes Xerxes 26 41 56 29
11 Smitshoek Smitshoek 26 37 52 28
12 Kloetinge Kloetinge 26 34 50 28
13 SHO SHO 26 37 70 23
14 S Gravenzande SV Gravenzande 26 29 56 16
TEMPORADA 2013/2014
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 GVVV GVVV 30 73 44 54
2 Spakenburg Spakenburg 30 57 38 54
3 HHC Hardenberg Hardenberg 30 67 43 51
4 IJsselmeervogels IJsselmeervo 30 62 43 50
5 Rijnsburgse Boys Rijnsburgse 30 72 41 49
6 Excelsior Maassluis Excelsior 30 49 51 48
7 Kozakken Boys Kozakken 30 57 49 47
8 Lisse Lisse 30 48 42 47
9 Scheveningen Scheveningen 30 43 49 43
10 ONS Sneek ONS Sneek 30 52 66 42
11 BVV Barendrecht Barendrecht 30 53 57 39
12 Capelle Capelle 30 37 45 38
13 VV Noordwijk Noordwijk 30 40 56 36
14 Katwijk Katwijk 30 52 69 30
15 Excelsior .31 Excelsior 30 52 83 28
16 Ter Leede Ter Leede 30 32 70 22
TEMPORADA 2012/2013
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 Katwijk Katwijk 30 77 47 56
2 BVV Barendrecht Barendrecht 30 51 34 54
3 GVVV GVVV 30 54 41 52
4 HHC Hardenberg Hardenberg 30 62 49 51
5 Rijnsburgse Boys Rijnsburgse 30 60 42 50
6 Lisse Lisse 30 52 42 50
7 Capelle Capelle 30 54 41 49
8 Kozakken Boys Kozakken 30 61 59 47
9 VV Noordwijk Noordwijk 30 51 48 44
10 Excelsior .31 Excelsior 30 49 58 40
11 Scheveningen Scheveningen 30 45 46 39
12 IJsselmeervogels IJsselmeervo 30 44 48 39
13 Spakenburg Spakenburg 30 47 54 35
14 Genemuiden Genemuiden 30 63 74 32
15 Jodan Boys Jodan Boys 30 38 58 32
16 DETO Twenterand DETO 30 18 85 7
TEMPORADA 2011/2012
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 Spakenburg Spakenburg 30 84 44 65
2 Rijnsburgse Boys Rijnsburgse 30 76 36 64
3 Katwijk Katwijk 30 78 41 55
4 VV Noordwijk Noordwijk 30 66 43 55
5 GVVV GVVV 30 70 56 53
6 IJsselmeervogels IJsselmeervo 30 67 50 48
7 Genemuiden Genemuiden 30 60 55 47
8 Excelsior .31 Excelsior 30 39 47 45
9 HHC Hardenberg Hardenberg 30 48 59 45
10 Capelle Capelle 30 47 46 42
11 Lisse Lisse 30 48 56 38
12 BVV Barendrecht Barendrecht 30 39 40 36
13 Harkemase Boys Harkemase 30 39 61 25
14 SVZW SVZW 30 36 72 25
15 Montfoort Montfoort 30 34 73 20
16 ARC Alphense Alphense 30 36 88 10
TEMPORADA 2010/2011
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Quick Boys Quick Boys 26 64 25 58
2 VV Noordwijk Noordwijk 26 57 24 58
3 Young Boys Young Boys 26 58 34 51
4 Scheveningen Scheveningen 26 47 28 46
5 Excelsior Maassluis Excelsior 26 51 39 45
6 ODIN '59 ODIN '59 26 40 29 44
7 RKAV Volendam RKAV 26 52 54 34
8 Voorschoten .97 Voorschoten 26 32 49 32
9 Ter Leede Ter Leede 26 28 51 30
10 Jodan Boys Jodan Boys 26 35 45 29
11 Zwaluwen .30 Zwaluwen 26 36 45 27
12 Huizen Huizen 26 38 54 23
13 Vitesse Delft Vitesse 26 28 53 18
14 Swift Swift 26 28 64 17
TEMPORADA 2009/2010
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 BVV Barendrecht Barendrecht 26 66 21 61
2 Capelle Capelle 26 57 34 54
3 Rijnsburgse Boys Rijnsburgse 26 48 25 49
4 Lisse Lisse 26 49 36 41
5 Katwijk Katwijk 26 45 43 39
6 ARC Alphense Alphense 26 41 43 39
7 VV Noordwijk Noordwijk 26 45 37 38
8 ASWH ASWH 26 47 43 38
9 Ter Leede Ter Leede 26 50 46 34
10 Scheveningen Scheveningen 26 44 52 31
11 Quick Boys Quick Boys 26 39 48 30
12 RVVH RVVH 26 31 45 30
13 DOTO DOTO 26 21 66 15
14 TOGR TOGR 26 24 68 8
TEMPORADA 2008/2009
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Rijnsburgse Boys Rijnsburgse 26 63 22 65
2 Capelle Capelle 26 54 32 51
3 BVV Barendrecht Barendrecht 26 50 24 49
4 ASWH ASWH 26 48 34 47
5 Ter Leede Ter Leede 26 52 45 42
6 Quick Boys Quick Boys 26 56 47 41
7 Katwijk Katwijk 26 39 33 41
8 Lisse Lisse 26 48 51 37
9 VV Noordwijk Noordwijk 26 42 49 28
10 Scheveningen Scheveningen 26 36 54 28
11 DOTO DOTO 26 25 54 26
12 Excelsior Maassluis Excelsior 26 31 48 24
13 ARC Alphense Alphense 26 27 47 24
14 Heerjansdam Heerjansdam 26 27 58 15
TEMPORADA 2007/2008
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Lisse Lisse 26 54 27 56
2 Rijnsburgse Boys Rijnsburgse 26 55 28 47
3 Quick Boys Quick Boys 26 53 38 46
4 Capelle Capelle 26 39 30 40
5 DOTO DOTO 26 39 44 36
6 Katwijk Katwijk 26 35 38 35
7 VV Noordwijk Noordwijk 26 42 33 34
8 BVV Barendrecht Barendrecht 26 36 33 33
9 ASWH ASWH 26 42 45 33
10 Ter Leede Ter Leede 26 25 32 31
11 Zwaluwen .30 Zwaluwen 26 47 64 31
12 Excelsior Maassluis Excelsior 26 35 46 30
13 SHO SHO 26 34 49 21
14 TOGR TOGR 26 31 60 19
TEMPORADA 2006/2007
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Rijnsburgse Boys Rijnsburgse 25 62 30 55
2 Lisse Lisse 26 51 28 53
3 VV Noordwijk Noordwijk 26 42 34 46
4 Kozakken Boys Kozakken 26 44 43 40
5 ASWH ASWH 25 50 43 39
6 DOTO DOTO 26 52 48 39
7 Katwijk Katwijk 26 45 43 37
8 Ter Leede Ter Leede 25 47 43 36
9 SHO SHO 26 46 52 31
10 TOGR TOGR 26 34 48 29
11 Capelle Capelle 26 38 45 28
12 Excelsior Maassluis Excelsior 26 34 47 27
13 Vitesse Delft Vitesse 26 47 70 26
14 Heerjansdam Heerjansdam 25 39 57 23
TEMPORADA 2005/2006
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Rijnsburgse Boys Rijnsburgse 27 44 23 51
2 Lisse Lisse 26 54 36 49
3 DOTO DOTO 26 48 35 49
4 Katwijk Katwijk 26 47 35 41
5 Ter Leede Ter Leede 27 33 33 41
6 Quick Boys Quick Boys 25 39 32 37
7 VV Noordwijk Noordwijk 25 43 42 35
8 Excelsior Maassluis Excelsior 26 43 45 35
9 Capelle Capelle 26 36 39 33
10 Ajax Amateurs Ajax 26 26 34 30
11 Kloetinge Kloetinge 26 30 47 30
12 Hoek Hoek 26 44 52 28
13 ARC Alphense Alphense 26 35 47 21
14 Scheveningen Scheveningen 26 22 44 17
TEMPORADA 2004/2005
HOOFDKLASSE ZATERDAG GRUPO 1
Equipo PJ GF GC Puntos
1 ASWH ASWH 26 53 23 58
2 Hoek Hoek 26 57 35 46
3 Kozakken Boys Kozakken 26 42 21 46
4 Ter Leede Ter Leede 26 45 25 46
5 Lisse Lisse 26 62 43 46
6 Bennekom Bennekom 26 44 31 45
7 VV Noordwijk Noordwijk 26 42 42 38
8 DOVO DOVO 26 40 37 37
9 Heerjansdam Heerjansdam 26 37 46 33
10 ARC Alphense Alphense 26 28 37 32
11 Ajax Amateurs Ajax 26 25 37 31
12 BVV Barendrecht Barendrecht 26 27 53 21
13 Marken Marken 26 27 53 20
14 RKAV Volendam RKAV 26 18 64 11

  USO DE MEMORIA  
7,614,752 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.7092
Total Execution Time  0.7113
  CADENA URL  
/historico/Noordwijk
  GET DATOS  
$_GET['/historico/Noordwijk']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0149  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 = 'Noordwijk' 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.0127  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=7130 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=7130 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=7130 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133  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=7130 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0262  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 = 72649
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7130 AND type_rel = 2
0.0136  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7130 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0138  SELECT /*35 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 (49516,50354) ORDER BY n.cover_points DESC, update_date DESC
0.0156  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 = '7130' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '7130' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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=7130 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0133  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 (72649,72637,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.0143  SELECT count(id) as num_players from rel_players WHERE league_id = 72649 AND teamId = 7130
0.0159  SELECT count(id) as num_players from rel_players WHERE league_id = 72637 AND teamId = 7130
0.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7130
0.0136  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 = '7130' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7130' and rp.type = 4
0.0135  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 = '7130' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0176  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 = 72649 WHERE rp.league_id = 72649 AND rp.teamId = 7130 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.0190  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 = 72649 WHERE rp.league_id = 72649 AND rp.teamId = 7130 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 72649 WHERE rp.league_id = 72649 AND rp.teamId = 7130 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 7130 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 68065 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.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 63256 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.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 57795 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.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 50350 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.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 44605 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 39746 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 33955 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 15936 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 9388 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 2461 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 2184 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2012` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1711 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 20374 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 20378 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 20381 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 20386 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 20389 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 20392 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 20395 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC