4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Uitgeest
TEMPORADA 2022/2023
EERSTE KLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 HBC HBC 26 63 19 61
2 AFC '34 AFC '34 26 61 31 50
3 Kolping Boys Kolping Boys 26 70 40 49
4 Hoofddorp Hoofddorp 26 71 46 49
5 Vitesse '22 Vitesse '22 26 49 29 49
6 AGB AGB 25 64 40 47
7 IVV Landsmeer Landsmeer 26 44 39 41
8 Fortuna Wormerveer Fortuna 26 49 55 37
9 Hillegom Hillegom 26 55 55 33
10 LSVV LSVV 26 34 61 26
11 SDZ SDZ 25 39 62 22
12 Assendelft Assendelft 26 27 55 22
13 Uitgeest Uitgeest 26 30 71 14
14 De Meer De Meer 26 19 72 9
TEMPORADA 2021/2022
EERSTE KLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Kampong Kampong 26 68 18 62
2 AGB AGB 26 77 28 60
3 AFC '34 AFC '34 26 73 36 51
4 Fortuna Wormerveer Fortuna 26 63 39 47
5 Assendelft Assendelft 26 56 56 39
6 Hoofddorp Hoofddorp 26 43 45 39
7 LSVV LSVV 26 49 44 36
8 Kolping Boys Kolping Boys 26 37 35 34
9 Uitgeest Uitgeest 26 32 37 33
10 Hillegom Hillegom 26 53 63 32
11 SDZ SDZ 26 40 74 31
12 DSOV DSOV 26 32 67 24
13 Legmeervogels Legmeervogel 26 26 70 13
14 ROAC ROAC 26 15 52 11
TEMPORADA 2020/2021
EERSTE KLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Kampong Kampong 4 10 4 12
2 Kolping Boys Kolping Boys 4 13 6 9
3 Hillegom Hillegom 4 10 11 9
4 Hoofddorp Hoofddorp 4 6 5 7
5 AFC '34 AFC '34 4 12 9 6
6 Fortuna Wormerveer Fortuna 4 10 7 6
7 Uitgeest Uitgeest 4 11 9 6
8 SDZ SDZ 3 3 0 5
9 ROAC ROAC 2 1 0 4
10 Legmeervogels Legmeervogel 4 4 4 4
11 AGB AGB 3 3 5 1
12 Assendelft Assendelft 3 1 9 1
13 DSOV DSOV 4 3 12 1
14 LSVV LSVV 3 3 9 0
TEMPORADA 2019/2020
EERSTE KLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 De Zouaven De Zouaven 15 27 11 35
2 SDZ SDZ 16 46 19 30
3 AFC '34 AFC '34 16 45 27 27
4 AGB AGB 16 37 30 24
5 LSVV LSVV 16 27 27 24
6 ZVV Zaanlandia Zaanlandia 16 26 26 24
7 Uitgeest Uitgeest 16 20 21 23
8 Hoofddorp Hoofddorp 16 26 29 22
9 Legmeervogels Legmeervogel 16 29 25 20
10 DSOV DSOV 16 21 28 20
11 Kolping Boys Kolping Boys 16 21 29 18
12 Fortuna Wormerveer Fortuna 15 22 30 15
13 Magreb 90 Magreb 90 6 10 27 3
14 De Meern De Meern 12 11 39 3
TEMPORADA 2018/2019
EERSTE KLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 RKVV Velsen RKVV Velsen 26 56 17 58
2 JOS Watergraafsmeer Watergraafsm 26 63 33 56
3 FC Boshuizen Boshuizen 26 45 33 46
4 Uitgeest Uitgeest 26 49 44 39
5 AFC '34 AFC '34 26 39 40 38
6 ZVV Zaanlandia Zaanlandia 26 48 47 37
7 LSVV LSVV 26 39 51 37
8 AGB AGB 26 44 43 35
9 Legmeervogels Legmeervogel 26 47 53 33
10 DSOV DSOV 26 52 59 30
11 Hoofddorp Hoofddorp 26 38 49 29
12 Zeeburgia Zeeburgia 26 49 64 25
13 Hillegom Hillegom 26 50 57 24
14 NVC NVC 26 34 63 23
TEMPORADA 2017/2018
EERSTE KLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Fortuna Wormerveer Fortuna 26 65 30 58
2 RKVV DEM RKVV DEM 26 55 34 53
3 Legmeervogels Legmeervogel 26 53 42 48
4 JOS Watergraafsmeer Watergraafsm 26 67 42 46
5 AFC '34 AFC '34 26 63 46 46
6 Uitgeest Uitgeest 26 41 41 42
7 Hoofddorp Hoofddorp 26 54 59 35
8 LSVV LSVV 26 41 52 32
9 Zeeburgia Zeeburgia 26 42 53 30
10 AGB AGB 26 40 46 29
11 RKVV Velsen RKVV Velsen 26 26 46 28
12 Hillegom Hillegom 26 31 47 23
13 Assendelft Assendelft 26 29 51 19
14 EDO HFC EDO HFC 26 37 55 17
TEMPORADA 2013/2014
EERSTE KLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 JOS Watergraafsmeer Watergraafsm 26 75 28 63
2 AFC '34 AFC '34 26 66 38 51
3 OFC Oostzaan Oostzaan 26 74 33 50
4 De Meern De Meern 26 54 22 49
5 Elinkwijk Elinkwijk 26 68 61 41
6 SDO Bussum SDO Bussum 26 47 59 38
7 Stormvogels Stormvogels 26 69 72 34
8 De Kennemers Kennemers 26 41 49 33
9 Foresters Foresters 26 41 60 32
10 RKVV DEM RKVV DEM 26 48 65 30
11 NVC NVC 26 43 60 28
12 Pancratius Pancratius 26 36 58 27
13 Uitgeest Uitgeest 26 42 73 27
14 Zeeburgia Zeeburgia 26 39 65 18
TEMPORADA 2012/2013
EERSTE KLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 De Dijk De Dijk 26 75 24 62
2 Zeeburgia Zeeburgia 26 56 31 58
3 JOS Watergraafsmeer Watergraafsm 26 68 26 53
4 USV Hercules Hercules 26 59 40 49
5 Hoogland Hoogland 26 46 37 41
6 AFC '34 AFC '34 26 57 45 35
7 Stormvogels Stormvogels 26 54 71 34
8 Uitgeest Uitgeest 26 42 53 33
9 Pancratius Pancratius 26 35 43 30
10 RKVV DEM RKVV DEM 26 44 64 28
11 DWV DWV 26 27 42 23
12 VVIJ VVIJ 26 32 64 23
13 Purmersteijn Purmersteijn 26 38 60 22
14 FC Blauw Wit Amsterdam Blauw 26 34 67 20

  USO DE MEMORIA  
5,450,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1052
Total Execution Time  0.1065
  CADENA URL  
/historico/Uitgeest
  GET DATOS  
$_GET['/historico/Uitgeest']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0022  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 = 'Uitgeest' 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.0032  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 = 'Uitgeest' 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=11261 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=11261 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=11261 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=11261 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=11261 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=11261 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=11261 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=11261 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=11261 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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 = 70700
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11261 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=229 AND type_rel = 3
0.0025  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 = '11261' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '11261' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '11261' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 70700 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=11261 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (70700) 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 = 70700 AND teamId = 11261
0.0020  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 = '11261' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '11261' 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 = '11261' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 events2023 e ON e.player_id = p.id AND e.league_id = 70700 WHERE rp.league_id = 70700 AND rp.teamId = 11261 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.0019  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 events2023 e ON e.player_id = p.id AND e.league_id = 70700 WHERE rp.league_id = 70700 AND rp.teamId = 11261 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 events2023 e ON e.player_id = p.id AND e.league_id = 70700 WHERE rp.league_id = 70700 AND rp.teamId = 11261 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 11261 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 70700 AND t.round = 26 ORDER BY team.conference ASC,t.position 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 `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 = 64432 AND t.round = 26 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 = 59819 AND t.round = 4 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 `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 = 51225 AND t.round = 17 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 = 45035 AND t.round = 26 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 = 39757 AND t.round = 26 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 `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 = 9416 AND t.round = 26 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 `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 = 2219 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC