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

IJsselmeervogels

Entrenador: G. Karsten

Temporada 2023/2024
TEMPORADA 2023/2024
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 RKAV Volendam RKAV 30 80 48 57
2 Genemuiden Genemuiden 30 64 33 55
3 IJsselmeervogels IJsselmeervo 30 61 38 54
4 Sparta Nijkerk Sparta 30 74 54 53
5 USV Hercules Hercules 30 54 39 51
6 Harkemase Boys Harkemase 30 56 43 47
7 DOVO DOVO 30 52 37 46
8 HSC 21 HSC 21 30 53 47 45
9 Rijnvogels Rijnvogels 30 53 55 44
10 Eemdijk Eemdijk 30 47 51 42
11 Urk Urk 30 51 58 42
12 RKVV DEM RKVV DEM 30 43 51 40
13 DVS'33 DVS'33 30 46 39 38
14 VVSB VVSB 30 54 61 38
15 Staphorst Staphorst 30 49 61 36
16 Hoogeveen Hoogeveen 30 40 75 33
17 Kampong Kampong 30 40 59 21
18 ODIN '59 ODIN '59 30 25 93 13
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
TWEEDE DIVISIE
Equipo PJ GF GC Puntos
1 Amsterdamsche FC Amsterdamsch 34 85 43 71
2 Excelsior Maassluis Excelsior 34 69 38 63
3 IJsselmeervogels IJsselmeervo 34 70 52 63
4 Koninklijke HFC Koninklijke 33 62 37 60
5 Katwijk Katwijk 34 51 39 55
6 HHC Hardenberg Hardenberg 34 68 54 54
7 Kozakken Boys Kozakken 34 59 49 54
8 Vitesse Sub 23 Vitesse 34 62 46 53
9 Spakenburg Spakenburg 34 55 52 52
10 GVVV GVVV 34 61 64 49
11 Jong Sparta Jong Sparta 34 59 54 47
12 De Treffers De Treffers 33 47 48 47
13 Rijnsburgse Boys Rijnsburgse 34 77 79 47
14 Scheveningen Scheveningen 34 59 65 43
15 VVSB VVSB 34 57 82 30
16 Jong Almere City Jong Almere 34 46 69 28
17 Lienden Lienden 34 42 95 26
18 BVV Barendrecht Barendrecht 34 29 92 19
TEMPORADA 2017/2018
TWEEDE DIVISIE
Equipo PJ GF GC Puntos
1 Katwijk Katwijk 34 67 33 72
2 Kozakken Boys Kozakken 34 74 34 70
3 HHC Hardenberg Hardenberg 34 77 56 59
4 BVV Barendrecht Barendrecht 34 64 57 59
5 Rijnsburgse Boys Rijnsburgse 34 60 63 56
6 GVVV GVVV 34 54 44 54
7 Excelsior Maassluis Excelsior 34 43 30 51
8 VVSB VVSB 34 47 54 51
9 IJsselmeervogels IJsselmeervo 34 59 45 49
10 Koninklijke HFC Koninklijke 34 55 46 48
11 Jong Sparta Jong Sparta 34 72 64 43
12 Amsterdamsche FC Amsterdamsch 34 45 56 43
13 De Treffers De Treffers 34 51 55 41
14 Lienden Lienden 34 52 67 41
15 Lisse Lisse 34 48 57 40
16 SV TEC Tiel SV TEC Tiel 34 53 66 38
17 De Dijk De Dijk 34 50 85 30
18 Achilles 29 Achilles 29 34 41 100 12
TEMPORADA 2016/2017
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 34 74 36 70
2 Lisse Lisse 34 55 38 65
3 Rijnsburgse Boys Rijnsburgse 34 84 62 61
4 ASWH ASWH 34 64 53 58
5 Scheveningen Scheveningen 34 54 48 56
6 Jong Volendam Jong 34 60 56 56
7 DVS'33 DVS'33 34 54 49 48
8 Harkemase Boys Harkemase 34 55 60 46
9 Groningen Sub 21 Groningen 34 48 46 45
10 VVOG VVOG 34 49 55 44
11 Quick Boys Quick Boys 34 47 54 43
12 Capelle Capelle 34 42 52 41
13 ONS Sneek ONS Sneek 34 51 60 40
14 Jong Almere City Jong Almere 34 63 61 38
15 ODIN '59 ODIN '59 34 58 63 36
16 SteDoCo SteDoCo 34 46 69 35
17 Huizen Huizen 34 38 57 33
18 Rijnvogels Rijnvogels 34 55 78 33
TEMPORADA 2015/2016
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 Excelsior Maassluis Excelsior 30 46 31 59
2 HHC Hardenberg Hardenberg 30 54 38 58
3 Katwijk Katwijk 30 62 36 57
4 Kozakken Boys Kozakken 30 57 39 54
5 BVV Barendrecht Barendrecht 30 68 48 53
6 Spakenburg Spakenburg 30 67 52 47
7 GVVV GVVV 30 51 42 46
8 Rijnsburgse Boys Rijnsburgse 30 51 52 43
9 DVS'33 DVS'33 30 57 53 39
10 ONS Sneek ONS Sneek 30 43 63 34
11 Capelle Capelle 30 36 47 31
12 IJsselmeervogels IJsselmeervo 30 34 50 31
13 Scheveningen Scheveningen 30 42 47 30
14 SteDoCo SteDoCo 30 41 72 30
15 Lisse Lisse 30 43 54 29
16 RVVH RVVH 30 32 60 22
TEMPORADA 2014/2015
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 Kozakken Boys Kozakken 30 70 41 59
2 Spakenburg Spakenburg 30 65 37 56
3 HHC Hardenberg Hardenberg 30 57 31 53
4 BVV Barendrecht Barendrecht 30 44 31 51
5 IJsselmeervogels IJsselmeervo 30 48 40 48
6 GVVV GVVV 30 56 46 46
7 Rijnsburgse Boys Rijnsburgse 30 41 41 46
8 Capelle Capelle 30 41 37 44
9 Scheveningen Scheveningen 30 54 51 39
10 Excelsior Maassluis Excelsior 30 37 48 39
11 Lisse Lisse 30 36 47 36
12 ONS Sneek ONS Sneek 30 44 64 34
13 Hoek Hoek 30 39 51 32
14 Ajax Amateurs Ajax 30 38 57 28
15 Sparta Nijkerk Sparta 30 41 64 28
16 Genemuiden Genemuiden 30 51 76 24
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
DERDE DIVISIE GRUPO 1
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 30 68 39 62
2 Spakenburg Spakenburg 30 83 41 60
3 Rijnsburgse Boys Rijnsburgse 30 69 46 51
4 Katwijk Katwijk 30 47 38 49
5 Excelsior .31 Excelsior 30 48 45 45
6 Capelle Capelle 30 46 36 44
7 Genemuiden Genemuiden 30 51 63 43
8 HHC Hardenberg Hardenberg 30 48 37 42
9 BVV Barendrecht Barendrecht 30 35 36 42
10 Harkemase Boys Harkemase 30 53 52 41
11 Lisse Lisse 30 52 51 41
12 ARC Alphense Alphense 30 42 61 33
13 Apeldoorn CSV Apeldoorn 30 47 70 32
14 Flevo Boys Flevo Boys 30 40 68 29
15 Sparta Nijkerk Sparta 30 35 58 28
16 Hoek Hoek 30 27 50 24
TEMPORADA 2009/2010
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 26 64 18 60
2 Sparta Nijkerk Sparta 26 69 35 58
3 Spakenburg Spakenburg 26 62 36 50
4 Hoek Hoek 26 38 29 45
5 Zwaluwen .30 Zwaluwen 26 50 49 38
6 GVVV GVVV 26 46 43 37
7 SDC Putten SDC Putten 26 43 45 35
8 Kozakken Boys Kozakken 26 46 47 33
9 ODIN '59 ODIN '59 26 46 51 31
10 Jodan Boys Jodan Boys 26 40 54 31
11 LRC LRC 26 43 51 30
12 RKAV Volendam RKAV 26 45 60 26
13 DOVO DOVO 26 33 66 20
14 Bennekom Bennekom 26 32 73 13
TEMPORADA 2008/2009
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 26 59 22 54
2 Hoek Hoek 26 47 31 44
3 Spakenburg Spakenburg 26 52 39 42
4 GVVV GVVV 26 45 37 41
5 Bennekom Bennekom 26 37 34 41
6 SDC Putten SDC Putten 26 36 40 38
7 Sparta Nijkerk Sparta 26 40 44 37
8 RKAV Volendam RKAV 26 44 40 36
9 Jodan Boys Jodan Boys 26 47 36 34
10 Zwaluwen .30 Zwaluwen 26 45 43 33
11 Kozakken Boys Kozakken 26 39 40 31
12 DOVO DOVO 26 33 48 31
13 Ajax Amateurs Ajax 26 22 46 22
14 SV Geinoord SV Geinoord 26 35 81 15
TEMPORADA 2007/2008
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 Spakenburg Spakenburg 26 73 25 56
2 Sparta Nijkerk Sparta 26 44 16 53
3 GVVV GVVV 25 49 24 47
4 Kozakken Boys Kozakken 26 44 35 44
5 Hoek Hoek 26 35 28 40
6 IJsselmeervogels IJsselmeervo 26 50 48 40
7 DOVO DOVO 26 36 36 38
8 SV Geinoord SV Geinoord 26 28 36 35
9 Bennekom Bennekom 26 33 50 32
10 Ajax Amateurs Ajax 26 29 44 29
11 LRC LRC 26 33 43 26
12 Nunspeet Nunspeet 26 30 44 23
13 Nivo Sparta Nivo Sparta 26 27 51 18
14 Kloetinge Kloetinge 25 14 45 15
TEMPORADA 2006/2007
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 26 65 29 59
2 Sparta Nijkerk Sparta 25 59 34 49
3 Quick Boys Quick Boys 25 56 32 48
4 Nunspeet Nunspeet 26 49 37 44
5 Spakenburg Spakenburg 26 47 35 42
6 GVVV GVVV 26 48 35 40
7 Hoek Hoek 26 57 48 39
8 Ajax Amateurs Ajax 26 34 41 31
9 Bennekom Bennekom 26 43 51 30
10 Kloetinge Kloetinge 26 29 42 29
11 SV Geinoord SV Geinoord 26 31 49 29
12 Huizen Huizen 26 26 41 23
13 VVOG VVOG 26 27 50 23
14 GOES GOES 26 21 68 5
TEMPORADA 2005/2006
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 26 58 25 57
2 ASWH ASWH 26 45 23 45
3 Sparta Nijkerk Sparta 26 48 37 44
4 GVVV GVVV 26 41 35 43
5 Spakenburg Spakenburg 26 51 42 42
6 Bennekom Bennekom 26 48 41 41
7 VVOG VVOG 26 42 38 37
8 SHO SHO 26 43 54 34
9 Kozakken Boys Kozakken 26 37 38 32
10 SV Geinoord SV Geinoord 25 40 43 32
11 Heerjansdam Heerjansdam 26 32 52 32
12 DOVO DOVO 26 39 46 28
13 Deltasport Deltasport 26 34 57 27
14 SDC Putten SDC Putten 25 27 54 14
TEMPORADA 2004/2005
HOOFDKLASSE ZATERDAG GRUPO 2
Equipo PJ GF GC Puntos
1 IJsselmeervogels IJsselmeervo 26 46 31 52
2 Capelle Capelle 26 45 35 48
3 Quick Boys Quick Boys 26 60 45 47
4 Rijnsburgse Boys Rijnsburgse 26 53 36 42
5 Spakenburg Spakenburg 26 52 42 40
6 SHO SHO 26 39 36 37
7 Sparta Nijkerk Sparta 26 40 41 37
8 Scheveningen Scheveningen 26 41 42 36
9 Excelsior Maassluis Excelsior 26 42 45 32
10 Deltasport Deltasport 26 38 33 31
11 Katwijk Katwijk 26 39 46 31
12 TOGR TOGR 26 34 55 25
13 Huizen Huizen 26 37 48 24
14 Voorschoten .97 Voorschoten 26 25 56 15

  USO DE MEMORIA  
7,807,256 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1894
Total Execution Time  0.1907
  CADENA URL  
/historico/Ijsselmeervogels
  GET DATOS  
$_GET['/historico/Ijsselmeervogels']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (46)  
0.0036  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 = 'Ijsselmeervogels' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=7123 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=7123 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=7123 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=7123 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 72699
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7123 AND type_rel = 2
0.0035  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 = '7123' ORDER BY l.year DESC,cat.coefficient DESC
0.0030  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 = '7123' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0033  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 = '7123' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0028  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 = 72637 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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 = 72699 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0049  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=7123 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (72699,72637,71876,71432,68065) 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.0033  SELECT count(id) as num_players from rel_players WHERE league_id = 68065 AND teamId = 7123
0.0038  SELECT count(id) as num_players from rel_players WHERE league_id = 72699 AND teamId = 7123
0.0075  SELECT count(id) as num_players from rel_players WHERE league_id = 72637 AND teamId = 7123
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 71876 AND teamId = 7123
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7123
0.0019  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 = '7123' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7123' and rp.type = 4
0.0020  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 = '7123' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0048  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 = 72699 WHERE rp.league_id = 72699 AND rp.teamId = 7123 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.0045  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 = 72699 WHERE rp.league_id = 72699 AND rp.teamId = 7123 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72699 WHERE rp.league_id = 72699 AND rp.teamId = 7123 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0040  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 = 7123 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0030  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 72699 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.0032  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.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 `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.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 = 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.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 `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.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 = 44341 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 `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 = 38921 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 `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 = 33929 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 `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 = 15931 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 4005 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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.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 `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.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 `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.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 `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 = 10820 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 `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 = 20379 AND t.round = 26 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 `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 = 20382 AND t.round = 26 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 `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 = 20387 AND t.round = 26 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 `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 = 20390 AND t.round = 26 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 `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 = 20393 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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 = 20396 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC