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

Hoogstraten

Temporada 2023/2024

TEMPORADA 2023/2024

DIVISIÓN NACIONAL BELGA 1
Equipo		PJ	GF	GC	Puntos
1	RAAL	33	75	19	80
2	Lokeren-Tems	33	56	29	70
3	Knokke	33	54	39	53
4	Charleroi	33	54	42	52
5	Hoogstraten	33	44	49	49
6	Thes Sport	33	53	59	48
7	Heist	33	54	52	48
8	Gent II	33	57	39	48
9	Olympic	33	55	50	47
10	Winkel Sport	33	41	44	46
11	Excelsior	33	46	53	45
12	Tienen	33	44	39	44
13	Dessel Sport	33	53	58	41
14	Union Namur	33	39	58	39
15	Antwerp II	33	38	54	37
16	Leuven II	33	41	64	29
17	Visé	33	39	58	28
18	Cappellen	33	34	71	26

TEMPORADA 2022/2023

DIVISIÓN NACIONAL BELGA 1
Equipo		PJ	GF	GC	Puntos
1	Patro Eisden	38	84	23	86
2	RFC Liège	38	99	29	86
3	Francs	38	79	46	77
4	RAAL	38	72	39	73
5	Gent II	38	59	43	67
6	Heist	38	69	59	61
7	Olympic	38	71	52	60
8	Knokke	38	65	58	60
9	Visé	38	66	52	56
10	Thes Sport	38	58	52	53
11	Leuven II	38	61	68	50
12	Tienen	38	50	60	46
13	Charleroi	38	41	58	44
14	Dessel Sport	38	45	65	43
15	Winkel Sport	38	44	58	42
16	Hoogstraten	38	46	60	41
17	Antwerp II	38	33	58	39
18	Ninove	38	39	75	35
19	Rupel Boom	38	29	83	24
20	Mandel	38	16	88	14

TEMPORADA 2021/2022

DIVISIÓN BELGA 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hoogstraten	30	72	22	70
2	Eendracht	30	61	35	57
3	Lyra-Lierse	30	52	29	57
4	Cappellen	30	53	40	53
5	Belisia	30	44	32	52
6	Bocholt	30	47	38	51
7	City Pirates	30	44	56	43
8	Londerzeel	30	36	37	38
9	Diegem Sport	30	36	45	35
10	Sporting	30	38	50	34
11	Berchem	30	36	45	33
12	Hades	30	34	45	32
13	Heur	30	37	49	32
14	Pepingen-Hal	30	34	51	28
15	Houtvenne	30	30	52	26
16	Olympia	30	30	58	25

TEMPORADA 2020/2021

DIVISIÓN BELGA 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Bocholt	4	11	5	10
2	Hoogstraten	4	9	4	7
3	Lyra-Lierse	4	7	4	7
4	Sporting	3	6	3	7
5	Diegem Sport	4	8	7	7
6	Londerzeel	4	7	9	7
7	Hades	3	9	3	6
8	Pepingen-Hal	3	5	3	6
9	Berchem	3	4	3	5
10	Houtvenne	4	4	7	4
11	Cappellen	3	6	6	3
12	Belisia	3	5	8	3
13	Heur	3	1	7	1
14	Eendracht	2	1	3	0
15	City Pirates	2	3	7	0
16	Olympia	3	2	9	0

TEMPORADA 2019/2020

DIVISIÓN BELGA 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Tienen	24	43	30	47
2	Eendracht	24	43	27	44
3	Bocholt	24	40	26	43
4	Cappellen	24	36	28	37
5	Sporting	24	31	31	37
6	Hades	23	33	30	34
7	Diegem Sport	23	29	27	34
8	Vosselaar	23	35	33	32
9	Berchem	24	35	38	31
10	Londerzeel	24	32	39	28
11	Geel-Meerhou	24	29	35	27
12	Olympia	24	38	40	26
13	Pepingen-Hal	24	24	32	25
14	KFC Duffel	19	32	32	24
15	Hoogstraten	23	27	31	24
16	Belisia	23	23	51	21

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

DIVISIÓN BELGA 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Berchem	30	65	24	68
2	Thes Sport	30	61	38	66
3	Rupel Boom	30	55	38	52
4	Belisia	30	54	58	47
5	Olympia	30	45	42	44
6	Bocholt	30	44	39	41
7	Zwarte Leeuw	30	39	56	40
8	Londerzeel	30	46	39	38
9	Hoogstraten	30	51	60	37
10	Hades	30	45	60	37
11	Cappellen	30	41	42	36
12	Tempo	30	53	59	36
13	KFC Duffel	30	53	58	32
14	Grimbergen	30	37	46	32
15	Woluwe	30	48	62	32
16	Tienen	30	29	45	30

TEMPORADA 2015/2016

DIVISIÓN BELGA 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Oosterwijk	36	68	38	71
2	Beerschot	36	64	39	71
3	Bocholt	36	52	41	64
4	Sporting	36	64	41	60
5	Ciney	36	57	42	57
6	Sprimont-Com	36	56	43	56
7	RFC Liège	36	58	56	53
8	Hamoir	36	70	74	52
9	Rupel Boom	36	65	55	51
10	Berchem	36	51	55	50
11	Cappellen	36	51	56	49
12	Hoogstraten	36	60	60	48
13	Walhain	36	48	57	47
14	Tempo	36	47	56	45
15	Tienen	36	52	56	40
16	La Calamine	37	44	61	40
17	Grimbergen	36	38	55	34
18	Diegem Sport	37	35	68	34
19	Woluwe	36	34	61	33

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

SEGUNDA DIVISIÓN BÉLGICA
Equipo		PJ	GF	GC	Puntos
1	Westerlo	34	67	23	78
2	KAS Eupen	34	75	27	74
3	Sint-Truiden	34	47	31	67
4	Mouscron	34	53	27	66
5	Lommel SK	34	56	34	59
6	Tubize	34	59	45	54
7	Antwerp	33	44	31	46
8	Molenbeek	34	38	41	45
9	Borinage	34	45	51	45
10	Geel-Meerhou	34	45	49	43
11	Eendracht	34	37	49	42
12	Bruxelles	34	37	38	40
13	Excelsior	33	47	45	38
14	Dessel Sport	34	37	60	35
15	Roeselare	34	41	62	35
16	Heist	34	38	74	31
17	Hoogstraten	34	33	61	28
18	Visé	34	26	77	13

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

DIVISIÓN BELGA 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Eendracht	34	71	29	74
2	Hoogstraten	34	74	39	62
3	Deinze	34	62	54	59
4	Coxyde	34	70	54	58
5	Dessel Sport	34	56	38	57
6	Oudenaarde	34	57	49	55
7	Sint-Niklaas	34	47	36	54
8	Geel-Meerhou	34	51	45	53
9	Ronse	34	42	39	45
10	VW Hamme	34	40	49	43
11	Torhout	34	43	57	42
12	Temse	34	45	61	42
13	Olsa Brakel	34	53	64	38
14	Racing	34	31	50	38
15	Bornem	34	44	48	37
16	Cappellen	34	45	51	35
17	Izegem	34	44	57	34
18	Wielsbeke	34	31	86	18

TEMPORADA 2009/2010

DIVISIÓN BELGA 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Heist	36	73	34	76
2	Rupel Boom	36	82	46	72
3	Eendracht	36	82	44	67
4	Deinze	36	50	38	60
5	Temse	36	61	61	56
6	Coxyde	36	67	43	55
7	VW Hamme	36	59	51	55
8	Hoogstraten	36	59	55	50
9	Sint-Niklaas	36	62	55	49
10	Oudenaarde	36	62	62	48
11	Racing	36	43	51	48
12	Torhout	36	49	51	45
13	Wielsbeke	36	50	62	45
14	Ternat	36	53	72	41
15	Cappellen	36	40	62	39
16	Sottegem	36	32	65	38
17	Westhoek	36	53	70	37
18	Racing	36	52	71	37
19	Willebroek-M	36	40	76	30

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

PROMOCIÓN BÉLGICA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hoogstraten	30	70	32	65
2	Patro Eisden	29	56	33	52
3	Sporting	30	57	49	52
4	Witgoor	30	42	35	52
5	Sint-Lenaart	30	49	34	51
6	KFC Lille	30	54	37	48
7	Belisia	30	36	34	44
8	Geel-Meerhou	30	51	51	39
9	Thes Sport	30	40	52	39
10	Huy	30	49	47	38
11	Leopoldsburg	30	35	43	38
12	Hannutois	29	43	49	36
13	Heusden-Zold	30	35	44	35
14	Overpelt	30	39	51	31
15	Wanze	30	38	52	28
16	Grivegnée	30	37	88	19

TEMPORADA 2001/2002

DIVISIÓN BELGA 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Zulte-Warege	30	69	40	60
2	VW Hamme	30	55	32	59
3	KV Oostende	30	50	35	54
4	Turnhout	30	58	53	52
5	Wevelgem	30	62	39	49
6	Haasdonk	30	53	42	46
7	Denderhoutem	30	56	39	45
8	Maldegem	30	47	47	44
9	Torhout	30	43	38	41
10	Kortrijk	30	46	50	40
11	KRC Gent	30	41	42	38
12	Schoten	30	43	51	37
13	Cappellen	30	30	45	28
14	Olen	30	38	61	23
15	Gullegem	30	29	62	21
16	Hoogstraten	30	34	78	16

Competiciones que juega

División Nacional Belga 1

Pos	Equipos		Pts
1		RAAL La Louviere	80
2		Lokeren-Temse	70
3		Knokke	53
4		Charleroi II	52
5		Hoogstraten	49
6		Thes Sport	48
7		Heist	48
8		Gent II	48
9		Olympic Charleroi	47
10		KVC Winkel Sport	46
11		Excelsior Virton	45
12		Tienen	44
13		Dessel Sport	41
14		Union Namur	39
15		Antwerp II	37
16		Leuven II	29
17		Visé	28
18		Cappellen	26

	Ascenso : RAAL La Louviere, Lokeren-Temse, Knokke
	Playoff Descenso : Visé
	Descenso : Cappellen

RIVALES EN División Naciona.

RIVALES EN Copa Belga

USO DE MEMORIA

7,637,256 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6179
Total Execution Time	0.6191

CADENA URL

/historico/Hoogstraten

GET DATOS

$_GET['/historico/Hoogstraten']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0183	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 = 'Hoogstraten' 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.0126	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=7545 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=7545 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=7545 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=7545 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0264	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 = 72259
0.0126	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7545 AND type_rel = 2
0.0135	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 = '7545' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient 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 = '7545' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127	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 = 72259 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134	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=7545 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,72259,71432) 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.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 72259 AND teamId = 7545
0.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 7545
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7545
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 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 = 72259 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0139	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 = 72259 WHERE rp.league_id = 72259 AND rp.teamId = 7545 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.0134	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 = 72259 WHERE rp.league_id = 72259 AND rp.teamId = 7545 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136	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 = 72259 WHERE rp.league_id = 72259 AND rp.teamId = 7545 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136	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 = 7545 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0133	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 = 72259 AND t.round = 33 ORDER BY team.conference ASC,t.position 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* `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 = 68256 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144	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 = 63434 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.0153	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 = 57813 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.0144	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 = 50976 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.0133	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.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* `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.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* `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 = 33883 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	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.0145	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.0157	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.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* `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 = 24294 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 = 24297 AND t.round = 38 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* `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.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* `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 = 27986 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* `tables2002` 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 = 24296 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Hoogstraten

Hoogstraten

Selecciona un equipo

Competiciones que juega

División Nacional Belga 1

RIVALES EN División Naciona.

RIVALES EN Copa Belga