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

Resultados de Fútbol

PEC Zwolle

Entrenador: Johnny Jansen

Temporada 2023/2024

TEMPORADA 2023/2024

EREDIVISIE
Equipo		PJ	GF	GC	Puntos
1	PSV	30	95	17	81
2	Feyenoord	30	77	23	72
3	Twente	30	56	30	60
4	AZ Alkmaar	30	59	35	55
5	Ajax	30	63	56	48
6	Nijmegen	30	59	44	47
7	Utrecht	30	43	41	45
8	Ahead Eagles	30	44	39	42
9	Sparta	30	45	43	40
10	Heerenveen	30	50	56	36
11	Fortuna	30	34	52	35
12	Almere City	30	30	48	33
13	PEC Zwolle	30	40	58	32
14	Heracles	30	40	62	32
15	Excelsior	30	44	64	25
16	Waalwijk	30	29	50	24
17	FC Volendam	30	30	74	19
18	Vitesse	30	22	68	-1

TEMPORADA 2022/2023

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Heracles	38	103	42	85
2	PEC Zwolle	38	99	43	85
3	Almere City	38	58	41	70
4	Willem II	38	68	40	68
5	Maastricht	38	65	65	59
6	NAC Breda	38	64	64	59
7	VVV Venlo	38	56	51	58
8	Eindhoven	38	58	54	58
9	SC Telstar	38	39	52	53
10	Graafschap	38	64	54	52
11	Jong AZ	38	60	58	51
12	Haag	38	51	57	51
13	Jong Ajax	38	69	72	46
14	Jong PSV	38	59	63	45
15	Roda JC	38	49	59	43
16	Helmond	38	39	57	43
17	TOP Oss	38	45	76	37
18	Dordrecht	38	41	68	35
19	Den Bosch	38	46	85	35
20	Jong Utrecht	38	33	65	28

TEMPORADA 2021/2022

EREDIVISIE
Equipo		PJ	GF	GC	Puntos
1	Ajax	34	98	19	83
2	PSV	34	86	42	81
3	Feyenoord	34	76	34	71
4	Twente	34	55	37	68
5	AZ Alkmaar	34	64	44	61
6	Vitesse	34	42	51	51
7	Utrecht	34	51	46	47
8	Heerenveen	34	37	50	41
9	Cambuur	34	53	70	39
10	Waalwijk	34	40	51	38
11	Nijmegen	34	38	52	38
12	Groningen	34	41	55	36
13	Ahead Eagles	34	37	51	36
14	Sparta	34	30	48	35
15	Fortuna	34	36	67	35
16	Heracles	34	33	49	34
17	Willem II	34	32	57	33
18	PEC Zwolle	34	26	52	27

TEMPORADA 2020/2021

EREDIVISIE
Equipo		PJ	GF	GC	Puntos
1	Ajax	34	102	23	88
2	PSV	34	74	35	72
3	AZ Alkmaar	34	75	41	71
4	Vitesse	34	52	38	61
5	Feyenoord	34	64	36	59
6	Utrecht	34	52	41	53
7	Groningen	34	40	37	50
8	Sparta	34	49	48	47
9	Heracles	34	42	53	44
10	Twente	34	48	50	41
11	Fortuna	34	50	58	41
12	Heerenveen	34	43	49	39
13	PEC Zwolle	34	44	53	38
14	Willem II	34	40	68	31
15	Waalwijk	34	33	55	30
16	Emmen	34	40	68	30
17	VVV Venlo	34	43	91	23
18	Haag	34	29	76	22

TEMPORADA 2019/2020

EREDIVISIE
Equipo		PJ	GF	GC	Puntos
1	Ajax	25	68	23	56
2	AZ Alkmaar	25	54	17	56
3	Feyenoord	25	50	35	50
4	PSV	26	54	28	49
5	Willem II	26	37	34	44
6	Utrecht	25	50	34	41
7	Vitesse	26	45	35	41
8	Heracles	26	40	34	36
9	Groningen	26	27	26	35
10	Heerenveen	26	41	41	33
11	Sparta	26	41	45	33
12	Emmen	26	32	45	32
13	VVV Venlo	26	24	51	28
14	Twente	26	34	46	27
15	PEC Zwolle	26	37	55	26
16	Fortuna	26	29	52	26
17	Haag	26	25	54	19
18	Waalwijk	26	27	60	15

TEMPORADA 2018/2019

EREDIVISIE
Equipo		PJ	GF	GC	Puntos
1	Ajax	34	119	32	86
2	PSV	34	98	26	83
3	Feyenoord	34	75	41	65
4	AZ Alkmaar	34	64	43	58
5	Vitesse	34	70	51	53
6	Utrecht	34	60	51	53
7	Heracles	34	61	68	48
8	Groningen	34	39	41	45
9	Haag	34	58	63	45
10	Willem II	34	58	72	44
11	Heerenveen	34	64	73	41
12	VVV Venlo	34	47	63	41
13	PEC Zwolle	34	44	57	39
14	Emmen	34	41	72	38
15	Fortuna	34	50	80	34
16	Excelsior	34	46	79	33
17	Graafschap	34	38	75	29
18	NAC Breda	34	29	74	23

TEMPORADA 2017/2018

EREDIVISIE
Equipo		PJ	GF	GC	Puntos
1	PSV	34	87	39	83
2	Ajax	34	89	33	79
3	AZ Alkmaar	34	72	38	71
4	Feyenoord	34	76	39	66
5	Utrecht	34	58	53	54
6	Vitesse	34	63	47	49
7	Haag	34	45	53	47
8	Heerenveen	34	48	53	46
9	PEC Zwolle	34	42	54	44
10	Heracles	34	50	64	42
11	Excelsior	34	41	56	40
12	Groningen	34	50	50	38
13	Willem II	34	50	63	37
14	NAC Breda	34	41	57	34
15	VVV Venlo	34	35	54	34
16	Roda JC	34	42	69	30
17	Sparta	34	34	75	27
18	Twente	34	37	63	24

TEMPORADA 2016/2017

EREDIVISIE
Equipo		PJ	GF	GC	Puntos
1	Feyenoord	34	86	25	82
2	Ajax	34	79	23	81
3	PSV	34	68	23	76
4	Utrecht	34	54	38	62
5	Vitesse	34	51	40	51
6	AZ Alkmaar	34	56	52	49
7	Twente	34	48	50	45
8	Groningen	34	55	51	43
9	Heerenveen	34	54	53	43
10	Heracles	34	53	55	43
11	Haag	34	37	59	38
12	Excelsior	34	43	60	37
13	Willem II	34	29	44	36
14	PEC Zwolle	34	39	67	35
15	Sparta	34	42	61	34
16	Nijmegen	34	32	59	34
17	Roda JC	34	26	51	33
18	Ahead Eagles	34	32	73	23

TEMPORADA 2015/2016

EREDIVISIE
Equipo		PJ	GF	GC	Puntos
1	PSV	34	88	32	84
2	Ajax	34	81	21	82
3	Feyenoord	34	62	40	63
4	AZ Alkmaar	34	70	53	59
5	Utrecht	34	57	48	53
6	Heracles	34	47	49	51
7	Groningen	34	41	48	50
8	PEC Zwolle	34	56	54	48
9	Vitesse	34	55	38	46
10	Nijmegen	34	37	42	46
11	Haag	34	48	49	43
12	Twente	34	49	64	43
13	Heerenveen	34	46	61	42
14	Roda JC	34	34	55	34
15	Excelsior	34	34	60	30
16	Willem II	34	35	53	29
17	Graafschap	34	39	66	23
18	Cambuur	34	33	79	18

TEMPORADA 2014/2015

EREDIVISIE
Equipo		PJ	GF	GC	Puntos
1	PSV	34	92	31	88
2	Ajax	34	69	29	71
3	AZ Alkmaar	34	63	56	62
4	Feyenoord	34	56	39	59
5	Vitesse	34	66	43	58
6	PEC Zwolle	34	59	43	53
7	Heerenveen	34	53	46	50
8	Twente	34	56	51	46
9	Groningen	34	49	53	46
10	Willem II	34	46	50	46
11	Utrecht	34	60	62	41
12	Cambuur	34	46	56	41
13	Haag	34	44	53	37
14	Heracles	34	47	64	37
15	Excelsior	34	47	63	32
16	NAC Breda	34	36	68	28
17	Ahead Eagles	34	29	59	27
18	Dordrecht	34	24	76	20

TEMPORADA 2013/2014

EREDIVISIE
Equipo		PJ	GF	GC	Puntos
1	Ajax	34	69	28	71
2	Feyenoord	34	76	40	67
3	Twente	34	72	37	63
4	PSV	34	60	45	59
5	Heerenveen	34	72	51	57
6	Vitesse	34	65	49	55
7	Groningen	34	57	53	51
8	AZ Alkmaar	34	54	50	47
9	Haag	34	45	64	43
10	Utrecht	34	46	65	41
11	PEC Zwolle	34	47	49	40
12	Cambuur	34	40	50	39
13	Ahead Eagles	34	45	69	38
14	Heracles	34	45	59	37
15	NAC Breda	34	43	54	35
16	Waalwijk	34	44	64	32
17	Nijmegen	34	54	82	30
18	Roda JC	34	44	69	29

TEMPORADA 2012/2013

EREDIVISIE
Equipo		PJ	GF	GC	Puntos
1	Ajax	34	83	31	76
2	PSV	34	103	43	69
3	Feyenoord	34	64	38	69
4	Vitesse	34	68	42	64
5	Utrecht	34	55	41	63
6	Twente	34	60	33	62
7	Groningen	34	36	53	43
8	Heerenveen	34	50	63	42
9	Haag	34	49	63	40
10	AZ Alkmaar	34	56	54	39
11	PEC Zwolle	34	42	55	39
12	Heracles	34	58	71	38
13	NAC Breda	34	40	56	38
14	Waalwijk	34	39	48	37
15	Nijmegen	34	44	66	37
16	Roda JC	34	51	69	33
17	VVV Venlo	34	33	62	28
18	Willem II	34	33	76	23

TEMPORADA 2011/2012

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	PEC Zwolle	34	68	34	72
2	Sparta	34	59	32	65
3	Eindhoven	34	52	33	63
4	Helmond	34	62	50	62
5	Willem II	34	67	41	58
6	Den Bosch	34	57	32	57
7	Cambuur	34	68	44	56
8	Maastricht	34	59	55	51
9	Ahead Eagles	34	65	56	50
10	Dordrecht	34	56	62	50
11	Fortuna	34	62	51	48
12	FC Volendam	34	57	55	48
13	Almere City	34	52	62	40
14	TOP Oss	34	56	76	35
15	SC Telstar	34	45	70	32
16	Emmen	34	24	73	23
17	SC Veendam	34	42	67	22
18	AGOVV	34	36	94	19

TEMPORADA 2010/2011

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Waalwijk	34	85	40	73
2	PEC Zwolle	34	69	27	70
3	Helmond	34	61	43	59
4	SC Veendam	34	54	44	57
5	Cambuur	34	64	52	54
6	FC Volendam	34	56	50	51
7	Ahead Eagles	34	58	43	50
8	Maastricht	34	44	50	50
9	Den Bosch	34	56	47	47
10	Dordrecht	34	52	56	45
11	Sparta	34	71	65	43
12	Eindhoven	34	41	49	40
13	AGOVV	34	54	77	40
14	Emmen	34	48	64	35
15	SC Telstar	34	43	54	34
16	Almere City	34	45	84	31
17	Roosendaal	34	38	66	29
18	Fortuna	34	42	70	28

TEMPORADA 2009/2010

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Graafschap	37	89	35	84
2	Cambuur	38	86	49	77
3	Excelsior	37	78	49	68
4	PEC Zwolle	37	61	38	68
5	Ahead Eagles	37	56	35	66
6	AGOVV	37	65	53	60
7	Helmond	37	67	54	57
8	SC Veendam	37	63	49	56
9	Den Bosch	37	67	58	54
10	Maastricht	37	59	67	50
11	Roosendaal	37	49	55	47
12	Dordrecht	37	57	59	46
13	Eindhoven	37	64	83	46
14	Omniworld	37	44	67	43
15	FC Volendam	38	68	82	41
16	Emmen	37	51	83	38
17	Fortuna	37	36	58	33
18	TOP Oss	38	44	80	33
19	SC Telstar	37	47	67	30
20	Haarlem	22	27	57	13

TEMPORADA 2008/2009

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	VVV Venlo	38	86	38	80
2	Waalwijk	38	68	31	71
3	Cambuur	38	68	49	69
4	PEC Zwolle	38	58	49	63
5	Excelsior	38	53	43	61
6	Maastricht	38	60	42	60
7	Ahead Eagles	38	41	41	56
8	Dordrecht	38	51	39	55
9	Den Bosch	38	59	51	53
10	Helmond	38	50	48	53
11	AGOVV	38	60	67	52
12	Haarlem	38	43	56	50
13	Emmen	38	48	68	47
14	TOP Oss	38	50	63	42
15	Fortuna	38	42	59	42
16	Eindhoven	38	59	80	41
17	Roosendaal	38	43	55	40
18	SC Telstar	38	42	56	39
19	SC Veendam	38	46	67	39
20	Omniworld	38	40	65	30

TEMPORADA 2007/2008

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	FC Volendam	38	90	46	77
2	Waalwijk	38	84	44	77
3	Den Bosch	38	61	37	70
4	PEC Zwolle	38	70	42	67
5	Maastricht	38	66	50	60
6	Haag	38	58	50	58
7	Helmond	38	53	52	58
8	TOP Oss	38	58	61	55
9	Emmen	38	61	74	53
10	Ahead Eagles	38	60	64	51
11	Roosendaal	38	46	49	49
12	Dordrecht	38	59	52	47
13	Omniworld	38	56	55	47
14	SC Veendam	38	57	67	47
15	SC Telstar	38	41	51	46
16	AGOVV	38	66	98	41
17	Fortuna	38	48	69	40
18	Cambuur	38	50	68	39
19	Eindhoven	38	49	83	32
20	Haarlem	38	39	60	29

TEMPORADA 2006/2007

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Graafschap	38	88	41	83
2	VVV Venlo	38	64	44	71
3	Roosendaal	38	82	44	70
4	FC Volendam	38	65	40	68
5	Den Bosch	38	65	43	68
6	Dordrecht	38	76	49	67
7	Ahead Eagles	38	56	51	57
8	SC Veendam	38	57	50	55
9	PEC Zwolle	38	66	51	53
10	SC Telstar	38	61	61	48
11	Emmen	38	59	65	48
12	Cambuur	38	44	57	47
13	Maastricht	38	49	51	46
14	Haarlem	38	43	57	43
15	Fortuna	38	38	57	43
16	Omniworld	38	55	82	41
17	TOP Oss	38	59	78	40
18	Helmond	38	40	76	36
19	Eindhoven	38	47	80	33
20	AGOVV	38	42	79	29

TEMPORADA 2005/2006

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Excelsior	38	68	25	75
2	VVV Venlo	38	53	34	68
3	FC Volendam	38	59	43	66
4	Helmond	38	62	55	64
5	Graafschap	38	63	51	62
6	Emmen	38	68	56	60
7	Den Bosch	38	62	51	59
8	Haarlem	38	57	51	59
9	Dordrecht	38	61	45	56
10	AGOVV	38	64	62	56
11	TOP Oss	38	51	53	55
12	PEC Zwolle	38	57	52	54
13	Maastricht	38	53	52	51
14	SC Veendam	38	54	60	51
15	Cambuur	38	48	50	50
16	SC Telstar	38	37	53	40
17	Eindhoven	38	53	65	39
18	Ahead Eagles	38	45	70	35
19	Omniworld	38	50	87	29
20	Fortuna	38	35	85	17

TEMPORADA 2004/2005

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Heracles	36	67	34	75
2	Sparta	36	93	39	74
3	VVV Venlo	36	56	36	62
4	PEC Zwolle	36	66	50	61
5	FC Volendam	36	52	38	61
6	Helmond	36	61	44	57
7	SC Telstar	36	58	46	56
8	Dordrecht	36	46	51	53
9	Cambuur	36	44	54	47
10	AGOVV	36	55	60	46
11	SC Veendam	36	47	56	45
12	Excelsior	36	56	59	44
13	Haarlem	36	47	56	42
14	Maastricht	36	40	46	39
15	Eindhoven	36	60	80	39
16	TOP Oss	36	41	66	39
17	Ahead Eagles	36	40	60	38
18	Fortuna	36	46	67	34
19	Emmen	36	38	71	30

Competiciones que juega

Eredivisie

Pos	Equipos		Pts
1		PSV	81
2		Feyenoord	72
3		Twente	60
4		AZ Alkmaar	55
5		Ajax	48
6		NEC Nijmegen	47
7		Utrecht	45
8		Go Ahead Eagles	42
9		Sparta Rotterdam	40
10		Heerenveen	36
11		Fortuna Sittard	35
12		Almere City	33
13		PEC Zwolle	32
14		Heracles	32
15		Excelsior	25
16		RKC Waalwijk	24
17		FC Volendam	19
18		Vitesse	-1

	Campeón : PSV
	Champions League : Feyenoord
	Previa de Champions : Twente
	Previa de Europa League : AZ Alkmaar
	Siguiente Ronda : Ajax, NEC Nijmegen, Utrecht, Go Ahead Eagles
	Playoff Descenso : RKC Waalwijk
	Descenso : FC Volendam, Vitesse

RIVALES EN Eredivisie

RIVALES EN KNVB Beker

USO DE MEMORIA

8,354,656 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1663
Total Execution Time	0.1675

CADENA URL

/historico/Fc-Zwolle

GET DATOS

$_GET['/historico/Fc-Zwolle']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0033	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 = 'Fc-Zwolle' 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.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=1127 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=1127 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=1127 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=1127 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=1127 AND type_rel = 2
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1127 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	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 (3705,3773,9063,9678,17243) ORDER BY n.cover_points DESC, update_date 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 = '1127' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0031	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 = '1127' 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 = 72048 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030	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=1127 AND l.year in (2023,2024,2025) 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 (72637,72048,71432,68172,67927) 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.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 72048 AND teamId = 1127
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 67927 AND teamId = 1127
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 72637 AND teamId = 1127
0.0029	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1127
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 68172 AND teamId = 1127
0.0033	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 = 72048 WHERE rp.league_id = 72048 AND rp.teamId = 1127 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.0030	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 = 72048 WHERE rp.league_id = 72048 AND rp.teamId = 1127 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 events2024 e ON e.player_id = p.id AND e.league_id = 72048 WHERE rp.league_id = 72048 AND rp.teamId = 1127 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033	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 = 1127 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0038	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 = 62749 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 = 56828 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.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* `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 = 49848 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.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 = 43582 AND t.round = 34 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* `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 = 38711 AND t.round = 34 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* `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 = 30786 AND t.round = 34 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* `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 = 15117 AND t.round = 34 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* `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 = 3796 AND t.round = 34 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* `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 = 2450 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* `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 = 1911 AND t.round = 34 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* `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 = 1330 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* `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 = 1091 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* `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 = 884 AND t.round = 38 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 = 883 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048	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 = 562 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0054	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 = 563 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 564 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 565 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

PEC Zwolle

PEC Zwolle

Selecciona un equipo

Competiciones que juega

Eredivisie

RIVALES EN Eredivisie

RIVALES EN KNVB Beker