Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

KFC Turnhout

Temporada 2023/2024

TEMPORADA 2023/2024

PROMOCIÓN BÉLGICA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Beerschot	0	0	0	0
2	Berg en Dal	0	0	0	0
3	Betekom	0	0	0	0
4	Diest	0	0	0	0
5	Eendracht	0	0	0	0
6	Esperanza	0	0	0	0
7	KFC Eksel	0	0	0	0
8	KFC Nijlen	0	0	0	0
9	Turnhout	0	0	0	0
10	Schoonbeek-B	0	0	0	0
11	Sint-Lenaart	0	0	0	0
12	Verbroederin	0	0	0	0
13	Wellen	0	0	0	0
14	Witgoor	0	0	0	0
15	Zepperen-Bru	0	0	0	0
16	Zwarte Leeuw	0	0	0	0

TEMPORADA 2022/2023

DIVISIÓN BELGA 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Cappellen	34	61	37	66
2	Hades	34	51	32	62
3	Sporting	34	52	42	58
4	Belisia	34	55	37	56
5	Tongeren	34	61	56	56
6	Lyra-Lierse	34	64	45	55
7	Mechelen	34	60	48	54
8	Diegem Sport	34	56	51	52
9	Bocholt	34	54	46	49
10	Racing	34	45	36	47
11	KFC Lille	34	55	59	46
12	City Pirates	34	56	75	44
13	Londerzeel	34	51	48	41
14	Berchem	34	45	61	38
15	FC Lebbeke	34	47	64	38
16	Turnhout	34	68	81	34
17	Pepingen-Hal	34	36	66	28
18	Beerschot-Wi	34	40	73	27

TEMPORADA 2021/2022

PROMOCIÓN BÉLGICA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Racing	30	63	41	59
2	Esperanza	30	64	38	58
3	Diest	30	47	28	56
4	KFC Lille	30	63	55	54
5	Turnhout	30	53	28	49
6	Sint-Lenaart	30	49	41	47
7	Zwarte Leeuw	30	61	38	46
8	Wellen	30	46	41	44
9	Eendracht	30	40	41	42
10	Beringen	30	48	43	41
11	Betekom	30	53	51	41
12	KFC Nijlen	30	52	55	41
13	Witgoor	30	37	43	35
14	De Kempen	30	35	62	22
15	Berlaar-Heik	30	27	70	21
16	Weerstand	30	30	93	11

TEMPORADA 2020/2021

PROMOCIÓN BÉLGICA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Betekom	4	11	6	9
2	KFC Nijlen	4	9	7	9
3	Berlaar-Heik	4	9	6	8
4	KFC Lille	4	13	7	7
5	Eendracht	4	11	8	7
6	Esperanza	3	8	4	6
7	Witgoor	4	7	6	6
8	Sint-Lenaart	4	8	9	6
9	Racing	4	5	9	6
10	Diest	4	6	7	4
11	Zwarte Leeuw	3	5	6	4
12	Wellen	4	5	6	3
13	Turnhout	3	3	7	3
14	De Kempen	4	4	6	2
15	Beringen	4	4	8	2
16	Weerstand	3	4	10	1

TEMPORADA 2019/2020

PROMOCIÓN BÉLGICA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Lyra-Lierse	24	46	23	49
2	Heur	24	48	26	48
3	City Pirates	24	40	29	48
4	Houtvenne	24	47	29	45
5	Sint-Lenaart	24	57	34	38
6	Betekom	24	43	37	37
7	Eendracht	24	41	41	35
8	Wellen	24	36	41	33
9	Esperanza	24	39	42	32
10	Zwarte Leeuw	24	46	38	31
11	Beringen	24	30	38	29
12	Turnhout	24	38	40	28
13	Witgoor	24	31	38	28
14	Bilzerse	24	37	51	20
15	Helson	24	26	51	18
16	Linden	24	17	64	9

TEMPORADA 2018/2019

DIVISIÓN BELGA 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Patro Eisden	30	59	26	66
2	Sporting	30	53	29	60
3	Bocholt	31	56	39	52
4	Temse	30	60	48	51
5	Hades	30	50	40	43
6	Berchem	31	55	51	43
7	KFC Duffel	30	47	40	41
8	Cappellen	30	41	41	41
9	Sint-Niklaas	30	48	47	40
10	Vosselaar	30	45	59	38
11	Hoogstraten	30	30	33	37
12	VW Hamme	30	44	48	36
13	Belisia	30	48	56	35
14	City Pirates	30	35	42	34
15	Turnhout	30	38	58	29
16	Heur	30	30	82	14

TEMPORADA 2017/2018

DIVISIÓN BELGA 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Thes Sport	30	63	30	65
2	Bocholt	30	57	42	57
3	Belisia	30	56	46	52
4	City Pirates	30	52	44	47
5	Olympia	30	53	49	46
6	Vosselaar	30	49	35	44
7	Hades	30	46	42	43
8	Cappellen	30	43	37	41
9	Tempo	30	39	51	41
10	KFC Duffel	30	46	46	40
11	Turnhout	30	30	34	37
12	Hoogstraten	30	39	47	36
13	Sporting	30	34	45	35
14	Zwarte Leeuw	30	43	47	30
15	Tienen	30	39	61	28
16	Sint-Lenaart	30	33	66	22

TEMPORADA 2016/2017

PROMOCIÓN BÉLGICA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Turnhout	30	74	38	63
2	City Pirates	30	80	40	59
3	Sint-Lenaart	30	45	32	54
4	Diegem Sport	30	54	49	50
5	Vosselaar	30	55	51	47
6	Esperanza	30	49	44	45
7	Houtvenne	30	60	54	44
8	Eppegem	30	49	49	43
9	Leopoldsburg	30	38	38	39
10	KFC Nijlen	30	32	36	38
11	Sterrebeek	30	39	40	37
12	Wellen	30	48	42	36
13	Diest	30	46	67	34
14	Helson	30	29	44	32
15	Betekom	30	45	67	32
16	Racing	30	29	81	13

TEMPORADA 2015/2016

PROMOCIÓN BÉLGICA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hades	30	59	34	61
2	Olympia	30	57	43	52
3	Thes Sport	30	61	34	51
4	Zwarte Leeuw	30	60	46	50
5	Sint-Lenaart	30	46	32	46
6	City Pirates	30	62	50	46
7	Belisia	30	45	53	45
8	Esperanza	30	61	48	44
9	Leopoldsburg	30	53	43	44
10	Turnhout	30	53	52	43
11	KFC Nijlen	30	49	57	38
12	Wellen	30	37	50	37
13	Vosselaar	30	52	60	36
14	Bilzerse	30	39	63	24
15	KFC Lille	30	37	64	23
16	Lyra	30	30	72	17

TEMPORADA 2014/2015

DIVISIÓN BELGA 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Cappellen	34	105	40	73
2	Sprimont-Com	34	69	34	68
3	Union	34	53	32	67
4	Ciney	34	73	42	65
5	Bocholt	34	77	37	64
6	Walhain	34	58	40	57
7	Sporting	34	59	43	56
8	Oosterwijk	34	69	48	51
9	Hoogstraten	34	58	54	51
10	La Calamine	34	54	57	47
11	Louvière	34	56	66	47
12	Berchem	34	57	72	45
13	Tienen	34	48	57	35
14	Grimbergen	34	34	46	35
15	Diegem Sport	34	40	61	35
16	Visé	34	40	83	28
17	Verviers	34	43	95	25
18	Turnhout	34	23	109	7

TEMPORADA 2013/2014

DIVISIÓN BELGA 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Woluwe	35	71	31	73
2	Verviers	34	66	28	69
3	Patro Eisden	36	62	47	64
4	Turnhout	36	54	50	56
5	Louvière	36	55	47	54
6	Bocholt	36	51	52	52
7	La Calamine	36	73	62	51
8	Union	35	42	36	49
9	Sporting	34	30	41	45
10	Cappellen	36	49	67	45
11	Ciney	35	51	48	44
12	Sprimont-Com	34	57	66	44
13	Diegem Sport	35	46	65	41
14	Berchem	35	48	56	40
15	Grimbergen	35	49	62	40
16	Oosterwijk	34	45	69	39
17	Huy	35	40	42	38
18	Charleroi	35	46	66	36

TEMPORADA 2012/2013

DIVISIÓN BELGA 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Hoogstraten	34	73	31	74
2	Racing	34	55	37	64
3	Geel-Meerhou	34	65	37	61
4	Rupel Boom	34	56	45	56
5	Berchem	34	50	46	52
6	Cappellen	34	57	38	51
7	Torhout	34	42	37	51
8	VW Hamme	34	49	44	48
9	Coxyde	34	54	42	46
10	Bornem	34	51	53	45
11	Temse	34	39	51	43
12	Standaard	34	46	56	42
13	Deinze	34	51	60	39
14	Olsa Brakel	34	44	56	39
15	Turnhout	34	53	66	34
16	Izegem	34	49	67	34
17	Ronse	34	47	73	31
18	Racing	34	42	84	28

TEMPORADA 2011/2012

DIVISIÓN BELGA 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Dessel Sport	34	61	32	69
2	Hoogstraten	34	77	49	65
3	Bocholt	34	64	43	65
4	Woluwe	34	63	46	59
5	Rupel Boom	34	62	42	58
6	VW Hamme	34	62	52	56
7	Bornem	34	69	59	54
8	Racing	34	60	44	51
9	Geel-Meerhou	34	48	52	48
10	La Calamine	34	47	47	47
11	Turnhout	34	51	55	46
12	Union	34	42	58	42
13	Diegem Sport	34	40	37	41
14	Patro Eisden	34	43	53	35
15	Grimbergen	34	29	51	32
16	Temse	34	39	65	32
17	Olympia	34	37	72	28
18	Sporting	34	29	66	24

TEMPORADA 2010/2011

SEGUNDA DIVISIÓN BÉLGICA
Equipo		PJ	GF	GC	Puntos
1	OH Leuven	34	75	38	73
2	Lommel SK	34	73	44	65
3	Mons	34	63	38	59
4	SK Beveren	34	51	35	56
5	Visé	34	52	48	51
6	Antwerp	34	54	53	50
7	FCV Dender	34	54	54	49
8	Tubize	34	46	55	47
9	KV Oostende	34	41	48	45
10	Heist	34	57	67	43
11	Brussels	34	50	51	42
12	Standaard	34	42	51	42
13	Borinage	34	48	52	41
14	Roeselare	34	38	42	41
15	Tienen	34	35	47	41
16	Turnhout	34	48	59	40
17	Rupel Boom	34	36	56	37
18	Tournai	34	38	63	24

TEMPORADA 2009/2010

SEGUNDA DIVISIÓN BÉLGICA
Equipo		PJ	GF	GC	Puntos
1	Lierse SK	36	75	32	75
2	KVSK United	36	55	27	70
3	Mons	36	56	32	66
4	KAS Eupen	36	56	37	60
5	Borinage	36	46	43	53
6	Star	36	46	49	52
7	KV Oostende	36	49	45	51
8	Antwerp	36	55	53	47
9	OH Leuven	36	50	66	45
10	Tournai	36	50	51	44
11	Standaard	36	48	59	44
12	FCV Dender	36	45	49	43
13	Tienen	36	44	58	43
14	Tubize	36	41	41	42
15	Brussels	36	47	53	42
16	Turnhout	36	50	57	41
17	Ronse	36	51	57	39
18	KSK Beveren	36	37	55	36
19	RFC Liège	36	23	60	23

TEMPORADA 2008/2009

DIVISIÓN BELGA 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Turnhout	30	50	18	67
2	Visé	30	61	34	59
3	Racing	30	55	44	51
4	Wuustwezel	30	51	50	51
5	Rupel Boom	30	57	37	49
6	Willebroek-M	30	47	34	49
7	Bocholt	30	52	39	45
8	Hoogstraten	30	49	49	41
9	Veldwezelt	30	45	46	38
10	Verviers	29	33	37	34
11	Tongeren	29	36	50	33
12	Cappellen	30	33	43	32
13	Hamoir	30	46	55	30
14	Dessel Sport	30	37	57	30
15	RFC Seraing	30	22	45	26
16	La Calamine	30	26	62	19

TEMPORADA 2007/2008

DIVISIÓN BELGA 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	RFC Liège	28	47	21	66
2	Turnhout	28	45	19	59
3	Bruxelles	28	49	30	57
4	Cappellen	28	54	25	56
5	Visé	27	59	28	51
6	Wezel	27	42	41	43
7	Hamoir	28	37	47	39
8	Bocholt	28	32	40	36
9	Dessel Sport	28	39	45	29
10	Tongeren	28	27	45	29
11	RFC Seraing	28	30	47	28
12	Veldwezelt	28	26	42	26
13	Verviers	28	34	39	25
14	La Calamine	28	28	54	22
15	Sprimont-Com	28	21	47	18

TEMPORADA 2006/2007

DIVISIÓN BELGA 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Verbroederin	30	66	25	65
2	Tournai	30	47	24	61
3	Diegem Sport	30	47	19	59
4	Mouscron	30	43	33	51
5	Turnhout	30	56	41	49
6	Cappellen	30	32	23	45
7	Standaard	30	41	40	45
8	Sint-Niklaas	30	51	42	44
9	Londerzeel	30	35	34	38
10	Torhout	30	39	48	38
11	Oudenaarde	30	37	42	37
12	Racing	30	35	39	34
13	Willebroek-M	30	38	52	32
14	Racing Club	30	28	53	22
15	Geel-Meerhou	30	21	58	20
16	Maldegem	30	32	75	18

TEMPORADA 2005/2006

DIVISIÓN BELGA 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	FCV Dender	30	66	36	65
2	Cappellen	30	67	33	59
3	Standaard	30	54	41	52
4	Sint-Niklaas	30	55	30	48
5	Racing Club	30	48	39	48
6	Racing	30	44	37	48
7	Turnhout	30	52	40	44
8	Diegem Sport	30	36	44	44
9	Bruxelles	30	44	46	42
10	Torhout	30	51	47	41
11	Willebroek-M	30	42	48	37
12	Racing	30	37	44	35
13	Maldegem	29	39	56	28
14	Eendracht	29	28	66	22
15	Rupel Boom	30	29	59	19
16	Bornem	30	22	48	18

TEMPORADA 2004/2005

DIVISIÓN BELGA 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	KV Mechelen	30	76	35	59
2	Cappellen	30	58	29	58
3	Torhout	30	69	44	54
4	Sint-Niklaas	30	60	37	54
5	Denderhoutem	30	61	41	54
6	Turnhout	30	51	40	47
7	Standaard	30	43	44	45
8	Denderleeuw	30	51	46	44
9	Maldegem	29	43	46	44
10	Racing Club	30	44	41	42
11	Racing	29	51	61	36
12	Racing	30	43	41	34
13	Bornem	30	48	75	27
14	Wevelgem	29	34	64	26
15	Lyra	30	41	76	22
16	Evergem-Cent	29	30	83	12

Competiciones que juega

Grupo 3

Promoción Bélgica Grupo 3

Pos	Equipos		Pts
1		Beerschot VA B	0
2		Berg en Dal	0
3		Betekom	0
4		Diest	0
5		Eendracht Termien	0
6		Esperanza Pelt	0
7		KFC Eksel	0
8		KFC Nijlen	0
9		KFC Turnhout	0
10		Schoonbeek-Beverst	0
11		Sint-Lenaarts	0
12		Verbroedering Geel	0
13		Wellen	0
14		Witgoor Sport	0
15		Zepperen-Brustem	0
16		Zwarte Leeuw	0

	Ascenso : Beerschot VA B
	Playoff Ascenso : Berg en Dal
	Posible siguiente ronda : Betekom, Diest, Eendracht Termien
	Playoff Descenso : Wellen
	Descenso : Witgoor Sport, Zepperen-Brustem, Zwarte Leeuw

RIVALES EN Promoción Bélgic.

RIVALES EN Copa Belga

USO DE MEMORIA

7,593,336 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6123
Total Execution Time	0.6135

CADENA URL

/historico/Turnhout

GET DATOS

$_GET['/historico/Turnhout']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0254	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 = 72774
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7539 AND type_rel = 2
0.0127	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=569 AND type_rel = 3
0.0126	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 569 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0126	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 (169732) ORDER BY n.cover_points DESC, update_date DESC
0.0131	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 = '7539' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 72774 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130	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=7539 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (73206,72774,71738,71730) 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.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 71738 AND teamId = 7539
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 72774 AND teamId = 7539
0.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 7539
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 71730 AND teamId = 7539
0.0130	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 72774 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127	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 = 72774 WHERE rp.league_id = 72774 AND rp.teamId = 7539 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.0126	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 = 72774 WHERE rp.league_id = 72774 AND rp.teamId = 7539 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126	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 = 72774 WHERE rp.league_id = 72774 AND rp.teamId = 7539 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131	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 = 7539 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128	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 = 72774 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.0130	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 = 68500 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.0129	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 = 63442 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.0128	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 = 58300 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 51112 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.0129	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 = 45033 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 39091 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 34027 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 15781 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 4001 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 2738 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 2018 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 1743 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 10154 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 10158 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 24301 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 24304 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 24306 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 24319 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 24312 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

KFC Turnhout

KFC Turnhout

Selecciona un equipo

Competiciones que juega

Promoción Bélgica Grupo 3

RIVALES EN Promoción Bélgic.

RIVALES EN Copa Belga