Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

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

OFC Oostzaan

Temporada 2022/2023

TEMPORADA 2022/2023

TWEEDE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Katwijk	34	74	36	71
2	Rijnsburgse	34	73	42	69
3	Amsterdamsch	34	60	31	69
4	Hardenberg	34	75	48	60
5	De Treffers	34	66	45	60
6	Quick Boys	34	72	48	56
7	Koninklijke	34	52	41	55
8	Scheveningen	34	38	46	45
9	Noordwijk	34	45	45	43
10	Jong Sparta	34	58	61	43
11	Spakenburg	34	50	55	43
12	Lisse	34	45	51	42
13	Kozakken	34	50	58	40
14	Excelsior	34	50	69	39
15	SV TEC Tiel	34	41	60	39
16	IJsselmeervo	34	51	71	33
17	Jong	34	45	82	26
18	Oostzaan	34	33	89	20

TEMPORADA 2021/2022

DERDE DIVISIE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Oostzaan	34	66	47	61
2	Hercules	34	74	46	59
3	ADO 20	34	64	46	58
4	Gemert	34	75	57	57
5	OSS '20	34	62	46	55
6	Groene Ster	34	48	50	51
7	Dongen	34	56	47	50
8	UNA	34	60	58	50
9	HSC 21	34	63	52	49
10	Quick	34	47	44	47
11	Blauw Geel	34	55	56	45
12	RKVV DEM	34	37	50	45
13	GVV Unitas	34	41	59	42
14	Watergraafsm	34	59	69	40
15	Hoogland	34	42	64	39
16	EVV	34	36	59	37
17	Hollandia	34	38	55	35
18	Westlandia	34	43	61	32

TEMPORADA 2020/2021

DERDE DIVISIE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hercules	5	12	2	13
2	Blauw Geel	6	17	8	13
3	Oostzaan	5	10	7	10
4	Groene Ster	5	9	6	10
5	OSS '20	6	10	11	10
6	UNA	6	15	9	8
7	GVV Unitas	6	13	8	8
8	Hollandia	5	6	7	7
9	Westlandia	6	10	11	7
10	Gemert	6	6	10	7
11	Watergraafsm	6	4	9	7
12	Quick	5	9	7	6
13	EVV	5	2	6	6
14	ADO 20	6	9	8	6
15	Dongen	6	5	9	6
16	Hoogland	5	8	11	5
17	RKVV DEM	5	6	13	5
18	HSC 21	6	5	14	2

TEMPORADA 2019/2020

DERDE DIVISIE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	OSS '20	22	55	24	53
2	Haag	22	47	36	39
3	Oostzaan	22	38	27	36
4	Gemert	22	42	42	35
5	Dongen	20	34	19	34
6	UNA	22	35	39	32
7	EVV	22	30	27	31
8	Blauw Geel	22	38	38	29
9	HSC 21	22	34	39	29
10	Hercules	21	35	38	27
11	RKVV DEM	22	31	31	27
12	Groene Ster	22	28	33	27
13	Quick	21	29	26	26
14	Westlandia	22	31	40	24
15	ADO 20	21	29	35	21
16	Lienden	21	17	39	18
17	Hoogland	22	31	51	17

TEMPORADA 2018/2019

DERDE DIVISIE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Jong	34	97	44	71
2	SV TEC Tiel	34	63	38	70
3	Oostzaan	34	79	43	62
4	GOES	34	80	55	61
5	UNA	34	68	55	56
6	OSS '20	34	70	53	54
7	Quick	34	67	66	50
8	ADO 20	34	59	57	47
9	Westlandia	34	59	73	46
10	Dongen	34	51	70	45
11	EVV	34	40	43	44
12	Hercules	34	55	63	44
13	HSC 21	34	51	73	44
14	Blauw Geel	34	62	65	43
15	JVC Cuijk	34	43	77	39
16	Rosmalen	34	49	61	35
17	Quick '20	34	53	84	31
18	HBS	34	37	63	27

TEMPORADA 2017/2018

DERDE DIVISIE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Vitesse	34	96	36	75
2	UNA	34	74	38	71
3	Quick	34	74	58	63
4	Dongen	34	61	65	55
5	Westlandia	34	77	74	54
6	Oostzaan	34	64	47	52
7	ADO 20	34	76	70	52
8	JVC Cuijk	34	60	58	50
9	Hercules	34	63	59	49
10	Blauw Geel	34	60	62	47
11	Rosmalen	34	52	61	47
12	HBS	34	43	43	40
13	EVV	34	32	48	39
14	HSC 21	34	44	57	38
15	Quick '20	34	52	67	38
16	Quick 1887	34	61	85	33
17	Graafschap	34	48	61	32
18	De Meern	34	28	76	25

TEMPORADA 2016/2017

DERDE DIVISIE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	De Dijk	34	91	42	83
2	Westlandia	34	101	47	75
3	Dongen	34	65	46	66
4	Hercules	34	64	48	61
5	Quick '20	34	67	57	55
6	Quick 1887	34	74	61	54
7	EVV	34	57	49	48
8	HSC 21	34	73	69	48
9	HBS	34	55	62	47
10	Oostzaan	34	53	62	44
11	JVC Cuijk	34	48	58	44
12	Rosmalen	34	47	69	41
13	Magreb 90	34	53	78	39
14	Graafschap	34	66	79	36
15	Juliana 31	34	56	68	35
16	UDI '19	34	45	80	31
17	Bosch	34	45	61	30
18	Achilles	34	58	82	28

TEMPORADA 2015/2016

HOOFDKLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Westlandia	26	75	39	65
2	De Dijk	26	68	37	55
3	DHC Delft	26	52	26	55
4	Oostzaan	26	55	35	52
5	Quick	26	51	38	48
6	ADO 20	26	54	34	42
7	De Meern	26	45	48	30
8	RKAVV	26	36	41	30
9	Watergraafsm	26	34	39	30
10	SDO Bussum	26	28	29	29
11	EDO HFC	26	35	52	24
12	Nieuwerkerk	26	33	62	23
13	Leonidas	26	31	79	12
14	Nieuw	26	21	59	11

TEMPORADA 2014/2015

HOOFDKLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Magreb 90	24	61	32	52
2	De Dijk	24	51	32	50
3	Vlissingen	24	47	41	43
4	Oostzaan	24	54	38	38
5	Quick	24	50	51	36
6	Westlandia	23	43	35	35
7	Chabab	23	47	48	34
8	Watergraafsm	24	44	50	33
9	DHC Delft	24	48	55	30
10	Hollandia	24	37	38	27
11	VOC	24	41	57	24
12	De Zouaven	24	31	52	21
13	AFC '34	24	33	58	17
14	Haaglandia	0	0	0	0

TEMPORADA 2013/2014

EERSTE KLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Watergraafsm	26	75	28	63
2	AFC '34	26	66	38	51
3	Oostzaan	26	74	33	50
4	De Meern	26	54	22	49
5	Elinkwijk	26	68	61	41
6	SDO Bussum	26	47	59	38
7	Stormvogels	26	69	72	34
8	Kennemers	26	41	49	33
9	Foresters	26	41	60	32
10	RKVV DEM	26	48	65	30
11	NVC	26	43	60	28
12	Pancratius	26	36	58	27
13	Uitgeest	26	42	73	27
14	Zeeburgia	26	39	65	18

Competiciones que juega

Tweede Divisie

Pos	Equipos		Pts
1		Katwijk	71
2		Rijnsburgse Boys	69
3		Amsterdamsche FC	69
4		HHC Hardenberg	60
5		De Treffers	60
6		Quick Boys	56
7		Koninklijke HFC	55
8		Scheveningen	45
9		VV Noordwijk	43
10		Jong Sparta	43
11		Spakenburg	43
12		Lisse	42
13		Kozakken Boys	40
14		Excelsior Maassluis	39
15		SV TEC Tiel	39
16		IJsselmeervogels	33
17		Jong Volendam	26
18		OFC Oostzaan	20

	Campeón : Katwijk
	Playoff Descenso : SV TEC Tiel, IJsselmeervogels
	Descenso : Jong Volendam, OFC Oostzaan

RIVALES EN KNVB Beker

RIVALES EN Tweede Divisie

USO DE MEMORIA

6,290,848 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1585
Total Execution Time	0.1597

CADENA URL

/historico/Ofc-Oostzaan

GET DATOS

$_GET['/historico/Ofc-Oostzaan']

POST DATOS

No hay datos POST existentes

CONSULTAS (54)

0.0028	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 = 'Ofc-Oostzaan' 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.0051	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 = 'Ofc-Oostzaan' 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=61231 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=61231 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=61231 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=61231 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=61231 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=61231 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=61231 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=61231 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=61231 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=61231 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=61231 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=61231 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=61231 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=61231 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=61231 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=61231 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=61231 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=61231 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=61231 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=61231 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=61231 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=61231 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61231 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1892 AND type_rel = 3
0.0023	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1892 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0028	SELECT /53 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 (1220698,1207759,1075606,936469,924655) ORDER BY n.cover_points DESC, update_date DESC
0.0032	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 = '61231' ORDER BY l.year DESC,cat.coefficient DESC
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 = '61231' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0022	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 = '61231' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '61231' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023	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=61231 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (68342,68065,63260) 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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 68065 AND teamId = 61231
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 63260 AND teamId = 61231
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 68342 AND teamId = 61231
0.0021	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 = '61231' 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 = '61231' and rp.type = 4
0.0021	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 = '61231' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036	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 = 68065 WHERE rp.league_id = 68065 AND rp.teamId = 61231 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.0034	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 = 68065 WHERE rp.league_id = 68065 AND rp.teamId = 61231 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 = 68065 WHERE rp.league_id = 68065 AND rp.teamId = 61231 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 61231 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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* `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 = 63260 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.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 = 57890 AND t.round = 6 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 = 50981 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 = 44606 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* `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 = 38964 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* `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 = 33935 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* `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 = 15938 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* `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 = 9389 AND t.round = 26 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* `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

OFC Oostzaan

OFC Oostzaan

Selecciona un equipo

Competiciones que juega

Tweede Divisie

RIVALES EN KNVB Beker

RIVALES EN Tweede Divisie