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

Genemuiden

Temporada 2023/2024

TEMPORADA 2023/2024

DERDE DIVISIE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	RKAV	30	80	48	57
2	Genemuiden	30	64	33	55
3	IJsselmeervo	30	61	38	54
4	Sparta	30	74	54	53
5	Hercules	30	54	39	51
6	Harkemase	30	56	43	47
7	DOVO	30	52	37	46
8	HSC 21	30	53	47	45
9	Rijnvogels	30	53	55	44
10	Eemdijk	30	47	51	42
11	Urk	30	51	58	42
12	RKVV DEM	30	43	51	40
13	DVS'33	30	46	39	38
14	VVSB	30	54	61	38
15	Staphorst	30	49	61	36
16	Hoogeveen	30	40	75	33
17	Kampong	30	40	59	21
18	ODIN '59	30	25	93	13

TEMPORADA 2022/2023

HOOFDKLASSE ZATERDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Eemdijk	30	83	39	66
2	Swift	30	58	39	57
3	Genemuiden	30	57	41	54
4	AZSV	30	49	38	48
5	DETO	30	60	45	47
6	Huizen	30	59	45	43
7	DHSC	29	52	53	43
8	Berkum	30	45	37	41
9	Ajax	30	41	37	41
10	WV-HEDW	29	47	54	40
11	Barneveld	30	40	47	37
12	Buitenpost	29	26	52	32
13	Flevo Boys	30	41	59	30
14	Olde Veste	30	39	61	29
15	Apeldoorn	29	34	56	29
16	HZVV	30	31	59	24

TEMPORADA 2021/2022

HOOFDKLASSE ZATERDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Urk	30	65	34	66
2	RKAV	30	74	43	62
3	Eemdijk	30	70	37	58
4	Genemuiden	30	66	35	58
5	DETO	30	61	44	54
6	AZSV	30	45	51	45
7	Flevo Boys	30	48	52	42
8	HZVV	30	45	42	41
9	Berkum	30	40	38	40
10	Swift	30	58	49	39
11	Buitenpost	30	33	44	36
12	De Dijk	30	26	36	34
13	SDC Putten	30	38	44	32
14	ONS Sneek	30	50	83	29
15	NSC	30	26	62	22
16	Noordschesch	30	25	76	16

TEMPORADA 2020/2021

HOOFDKLASSE ZATERDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Berkum	6	17	5	13
2	Swift	4	14	3	12
3	Flevo Boys	5	15	7	12
4	HZVV	5	13	6	12
5	Genemuiden	6	9	6	12
6	Eemdijk	5	13	4	10
7	SDC Putten	5	11	4	10
8	RKAV	5	11	7	10
9	AZSV	6	11	11	10
10	Urk	6	10	12	7
11	NSC	6	10	11	6
12	DETO	5	7	12	4
13	Noordschesch	6	5	19	3
14	Buitenpost	6	4	19	3
15	ONS Sneek	5	5	14	1
16	De Dijk	5	0	15	0

TEMPORADA 2019/2020

HOOFDKLASSE ZATERDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Staphorst	21	62	19	47
2	ACV Assen	21	46	32	42
3	Eemdijk	21	28	15	41
4	Swift	21	39	26	39
5	HZVV	21	41	28	38
6	Genemuiden	21	45	25	37
7	Urk	21	34	25	31
8	Berkum	21	37	31	31
9	NSC	20	39	37	29
10	RKAV	21	43	42	29
11	De Dijk	21	24	40	21
12	SDC Putten	21	22	40	21
13	Flevo Boys	21	27	33	20
14	DETO	21	27	49	18
15	Purmersteijn	21	26	56	14
16	Buitenpost	20	17	59	11

TEMPORADA 2018/2019

HOOFDKLASSE ZATERDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Excelsior	30	63	26	64
2	Staphorst	30	65	33	63
3	Sparta	30	51	29	63
4	AZSV	30	47	30	58
5	ACV Assen	30	49	33	54
6	Urk	30	47	33	53
7	Berkum	30	46	49	41
8	DUNO	30	52	52	40
9	SDC Putten	30	47	40	39
10	Flevo Boys	30	37	43	36
11	Genemuiden	30	42	49	33
12	Buitenpost	30	31	57	29
13	DETO	30	35	54	27
14	Apeldoorn	30	42	66	26
15	WHC	30	44	68	25
16	SVZW	30	39	75	18

TEMPORADA 2017/2018

HOOFDKLASSE ZATERDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Eemdijk	30	63	33	58
2	Berkum	30	52	36	56
3	Genemuiden	30	74	45	54
4	Ajax	30	69	45	54
5	Staphorst	30	55	44	46
6	Urk	30	47	44	43
7	AZSV	30	38	39	42
8	Door Fusie.	30	47	43	41
9	Excelsior	30	40	45	41
10	SDC Putten	30	40	50	41
11	Sparta	30	47	37	40
12	Apeldoorn	30	51	61	36
13	HZVV	30	37	54	32
14	Huizen	30	47	65	26
15	Zuidvogels	30	40	70	26
16	NSC	30	46	82	26

TEMPORADA 2016/2017

HOOFDKLASSE ZATERDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	ACV Assen	30	58	35	65
2	DOVO	30	62	31	60
3	Staphorst	30	68	34	53
4	Apeldoorn	30	61	48	51
5	Excelsior	30	67	56	46
6	Genemuiden	30	60	42	45
7	Sparta	30	53	48	45
8	SDC Putten	30	43	39	45
9	Eemdijk	30	58	61	42
10	AZSV	30	41	37	38
11	Urk	30	41	42	38
12	NSC	30	47	56	37
13	Flevo Boys	30	47	56	35
14	Oranje	30	42	69	32
15	Barneveld	30	33	57	25
16	ASV Dronten	30	27	97	11

TEMPORADA 2015/2016

HOOFDKLASSE ZATERDAG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Harkemase	26	73	27	58
2	Staphorst	26	60	32	56
3	ACV Assen	26	42	38	47
4	VVOG	26	62	40	44
5	AZSV	26	47	41	41
6	Flevo Boys	26	46	43	39
7	Excelsior	26	53	44	38
8	Apeldoorn	26	48	48	37
9	Urk	26	36	37	31
10	Genemuiden	26	38	40	31
11	SVZW	26	44	54	29
12	HZVV	26	31	52	23
13	DOS 37	26	31	71	19
14	Drachtster	26	24	68	10

TEMPORADA 2014/2015

DERDE DIVISIE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Kozakken	30	70	41	59
2	Spakenburg	30	65	37	56
3	Hardenberg	30	57	31	53
4	Barendrecht	30	44	31	51
5	IJsselmeervo	30	48	40	48
6	GVVV	30	56	46	46
7	Rijnsburgse	30	41	41	46
8	Capelle	30	41	37	44
9	Scheveningen	30	54	51	39
10	Excelsior	30	37	48	39
11	Lisse	30	36	47	36
12	ONS Sneek	30	44	64	34
13	Hoek	30	39	51	32
14	Ajax	30	38	57	28
15	Sparta	30	41	64	28
16	Genemuiden	30	51	76	24

TEMPORADA 2013/2014

HOOFDKLASSE ZATERDAG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Genemuiden	26	60	39	51
2	Harkemase	26	56	38	50
3	Staphorst	26	59	35	49
4	Flevo Boys	26	62	45	48
5	ACV Assen	26	46	34	45
6	SVZW	26	45	33	37
7	Apeldoorn	26	39	44	35
8	Drachtster	26	29	35	32
9	AZSV	26	38	45	31
10	VVOG	26	44	52	28
11	WHC	26	39	66	28
12	DETO	26	31	46	26
13	Go Ahead	26	39	60	25
14	Berkum	26	33	48	24

TEMPORADA 2012/2013

DERDE DIVISIE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Katwijk	30	77	47	56
2	Barendrecht	30	51	34	54
3	GVVV	30	54	41	52
4	Hardenberg	30	62	49	51
5	Rijnsburgse	30	60	42	50
6	Lisse	30	52	42	50
7	Capelle	30	54	41	49
8	Kozakken	30	61	59	47
9	Noordwijk	30	51	48	44
10	Excelsior	30	49	58	40
11	Scheveningen	30	45	46	39
12	IJsselmeervo	30	44	48	39
13	Spakenburg	30	47	54	35
14	Genemuiden	30	63	74	32
15	Jodan Boys	30	38	58	32
16	DETO	30	18	85	7

TEMPORADA 2011/2012

DERDE DIVISIE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Spakenburg	30	84	44	65
2	Rijnsburgse	30	76	36	64
3	Katwijk	30	78	41	55
4	Noordwijk	30	66	43	55
5	GVVV	30	70	56	53
6	IJsselmeervo	30	67	50	48
7	Genemuiden	30	60	55	47
8	Excelsior	30	39	47	45
9	Hardenberg	30	48	59	45
10	Capelle	30	47	46	42
11	Lisse	30	48	56	38
12	Barendrecht	30	39	40	36
13	Harkemase	30	39	61	25
14	SVZW	30	36	72	25
15	Montfoort	30	34	73	20
16	Alphense	30	36	88	10

TEMPORADA 2010/2011

DERDE DIVISIE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	IJsselmeervo	30	68	39	62
2	Spakenburg	30	83	41	60
3	Rijnsburgse	30	69	46	51
4	Katwijk	30	47	38	49
5	Excelsior	30	48	45	45
6	Capelle	30	46	36	44
7	Genemuiden	30	51	63	43
8	Hardenberg	30	48	37	42
9	Barendrecht	30	35	36	42
10	Harkemase	30	53	52	41
11	Lisse	30	52	51	41
12	Alphense	30	42	61	33
13	Apeldoorn	30	47	70	32
14	Flevo Boys	30	40	68	29
15	Sparta	30	35	58	28
16	Hoek	30	27	50	24

TEMPORADA 2009/2010

HOOFDKLASSE ZATERDAG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Excelsior	26	46	25	54
2	Harkemase	26	66	31	51
3	Apeldoorn	26	46	35	46
4	Flevo Boys	26	42	36	42
5	Genemuiden	26	45	37	38
6	Hardenberg	26	31	29	35
7	WHC	26	45	48	35
8	ACV Assen	26	34	39	35
9	PKC .83	26	50	52	33
10	Berkum	26	44	46	31
11	Staphorst	26	30	34	31
12	Nunspeet	26	36	53	30
13	Quick	26	39	47	29
14	Go Ahead	26	30	72	15

TEMPORADA 2008/2009

HOOFDKLASSE ZATERDAG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Harkemase	26	52	24	57
2	Hardenberg	26	44	31	46
3	Nunspeet	26	49	31	44
4	Berkum	26	54	41	42
5	WHC	26	34	27	40
6	Flevo Boys	26	52	62	38
7	Quick	26	43	31	37
8	Go Ahead	26	44	42	35
9	Genemuiden	26	38	31	34
10	Excelsior	26	42	43	31
11	Staphorst	26	44	63	29
12	PKC .83	26	39	58	29
13	ONS Sneek	26	26	46	28
14	Oranje	26	34	65	20

TEMPORADA 2007/2008

HOOFDKLASSE ZATERDAG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hardenberg	26	69	30	60
2	Quick	26	51	22	55
3	ONS Sneek	26	42	36	41
4	Excelsior	26	44	41	41
5	Flevo Boys	26	41	34	35
6	Genemuiden	26	44	39	34
7	WHC	26	41	40	34
8	Go Ahead	26	35	38	32
9	Staphorst	26	38	47	32
10	PKC .83	26	46	56	32
11	Oranje	26	30	48	31
12	VVOG	26	32	56	30
13	ACV Assen	26	34	40	26
14	DOS Kampen	26	28	48	23

TEMPORADA 2006/2007

HOOFDKLASSE ZATERDAG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hardenberg	26	65	37	55
2	Quick	26	68	27	51
3	ACV Assen	26	49	31	44
4	ONS Sneek	26	47	35	44
5	WHC	26	34	26	41
6	Excelsior	26	39	35	38
7	Genemuiden	25	46	46	37
8	Flevo Boys	26	36	42	33
9	DOS Kampen	26	28	53	30
10	Go Ahead	25	29	49	27
11	Oranje	26	27	50	27
12	Berkum	25	38	47	25
13	Harkemase	26	29	46	24
14	Urk	25	32	43	20

TEMPORADA 2005/2006

HOOFDKLASSE ZATERDAG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	ONS Sneek	25	54	34	54
2	Genemuiden	25	46	40	43
3	Harkemase	27	45	35	41
4	Excelsior	25	44	38	41
5	Hardenberg	26	52	39	39
6	Go Ahead	27	34	44	37
7	Quick	26	39	43	36
8	WHC	26	46	43	35
9	Flevo Boys	25	43	49	35
10	Urk	27	43	32	34
11	ACV Assen	26	47	50	34
12	DOS Kampen	27	41	46	33
13	SVZW	26	37	54	24
14	Drachtster	26	33	57	24

TEMPORADA 2004/2005

HOOFDKLASSE ZATERDAG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Excelsior	27	64	39	49
2	Harkemase	26	69	44	48
3	Quick	27	61	46	46
4	ACV Assen	27	54	46	44
5	Urk	27	55	49	44
6	WHC	25	51	35	41
7	VVOG	26	47	43	41
8	ONS Sneek	25	55	52	34
9	Genemuiden	25	44	47	33
10	Hardenberg	25	41	51	30
11	SDC Putten	26	34	39	29
12	DOS Kampen	26	35	50	25
13	Nunspeet	26	30	61	23
14	ASV Dronten	26	32	70	21

Competiciones que juega

Derde Divisie Grupo 1

Pos	Equipos		Pts
1		RKAV Volendam	57
2		Genemuiden	55
3		IJsselmeervogels	54
4		Sparta Nijkerk	53
5		USV Hercules	51
6		Harkemase Boys	47
7		DOVO	46
8		HSC 21	45
9		Rijnvogels	44
10		Eemdijk	42
11		Urk	42
12		RKVV DEM	40
13		DVS'33	38
14		VVSB	38
15		Staphorst	36
16		Hoogeveen	33
17		Kampong	21
18		ODIN '59	13

	Ascenso : RKAV Volendam
	Playoff Descenso : Staphorst, Hoogeveen
	Descenso : Kampong, ODIN '59

RIVALES EN KNVB Beker

RIVALES EN Derde Divisie

USO DE MEMORIA

7,499,320 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.7613
Total Execution Time	0.7626

CADENA URL

/historico/Genemuiden

GET DATOS

$_GET['/historico/Genemuiden']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0157	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 = 'Genemuiden' 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.0145	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=7131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=7131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=7131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7131 AND type_rel = 2
0.0152	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 = '7131' ORDER BY l.year DESC,cat.coefficient DESC
0.0150	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 = '7131' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0150	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 = '7131' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0150	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=7131 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146	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,71881,70054) 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.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 72699 AND teamId = 7131
0.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 70054 AND teamId = 7131
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 72637 AND teamId = 7131
0.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 71881 AND teamId = 7131
0.0146	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 = '7131' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0149	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7131' and rp.type = 4
0.0157	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 = '7131' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0203	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 = 7131 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.0166	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 = 7131 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0165	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 = 7131 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0163	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 = 7131 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0167	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 = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164	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 = 70054 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.0162	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 = 63263 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.0163	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 = 58335 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.0151	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 = 50987 AND t.round = 21 ORDER BY team.conference ASC,t.position 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* `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 = 44705 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154	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 = 39747 AND t.round = 30 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* `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 = 33959 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160	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 = 15937 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165	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.0170	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 = 9395 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166	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.0168	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.0164	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.0172	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 = 20380 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161	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 = 20384 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154	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 = 20388 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 20391 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 20394 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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 = 20397 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Genemuiden

Genemuiden

Selecciona un equipo

Competiciones que juega

Derde Divisie Grupo 1

RIVALES EN KNVB Beker

RIVALES EN Derde Divisie