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

Bocholt

Temporada 2022/2023

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

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

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 2
Equipo		PJ	GF	GC	Puntos
1	Bocholt	35	72	31	74
2	Excelsior	34	73	27	73
3	Patro Eisden	34	55	35	61
4	Louvière	34	66	33	59
5	Grimbergen	34	57	48	52
6	FCV Dender	34	55	44	50
7	Tienen	34	48	40	50
8	La Calamine	34	57	48	48
9	Huy	34	48	42	48
10	Woluwe	34	49	49	47
11	Charleroi	34	48	50	47
12	Ciney	34	45	54	47
13	Diegem Sport	34	58	52	45
14	Tournai	34	44	46	43
15	Géants	34	50	54	40
16	Union	35	45	52	37
17	Verviers	34	39	53	35
18	Bertrix	34	35	74	21
19	BX Brussels	34	14	126	8

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 2
Equipo		PJ	GF	GC	Puntos
1	Bruxelles	34	78	20	77
2	Excelsior	34	68	31	69
3	Woluwe	34	58	40	64
4	Bertrix	34	60	43	62
5	Union	34	60	32	61
6	Bocholt	34	52	28	60
7	Louvière	34	60	42	58
8	Olympic	34	57	37	55
9	Sporting	34	60	32	53
10	Diegem Sport	34	51	47	49
11	Huy	34	42	50	39
12	Charleroi	34	38	50	39
13	BX Brussels	34	34	66	35
14	Verviers	34	35	55	33
15	Grimbergen	34	40	53	31
16	Ternat	34	51	77	31
17	RFC Liège	34	33	79	17
18	Union Namur	34	18	113	15

TEMPORADA 2009/2010

DIVISIÓN BELGA 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Visé	34	68	30	71
2	Olympic	34	59	34	62
3	Dessel Sport	34	80	49	58
4	Woluwe	34	62	52	56
5	Louvière	34	53	45	53
6	Diegem Sport	34	50	48	52
7	Verviers	34	38	47	48
8	Bocholt	34	64	50	47
9	Wezel	34	39	37	45
10	Sporting	34	45	55	45
11	Union Namur	34	48	43	43
12	Bruxelles	34	47	48	43
13	Union	34	53	41	42
14	Excelsior	34	37	44	42
15	BX Brussels	34	47	57	40
16	Tongeren	34	44	47	39
17	Veldwezelt	34	34	60	26
18	Mouscron	34	29	110	21

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 2
Equipo		PJ	GF	GC	Puntos
1	Olympic	30	49	29	57
2	Sprimont-Com	30	34	31	50
3	Union Namur	29	55	35	49
4	Bruxelles	30	52	42	47
5	Charleroi	29	37	30	45
6	Tongeren	30	50	45	44
7	Bocholt	30	47	35	42
8	RFC Seraing	30	48	40	41
9	Visé	30	38	39	41
10	Verviers	30	39	41	38
11	RFC Liège	30	22	27	36
12	Francs	30	37	50	36
13	RAAL	30	31	41	35
14	La Calamine	30	27	44	35
15	Sporting	30	41	59	31
16	Walhain	30	34	53	25

TEMPORADA 2005/2006

DIVISIÓN BELGA 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Tienen	29	53	24	59
2	Francs	29	44	29	50
3	La Calamine	30	43	48	49
4	Olympic	30	51	32	47
5	Visé	30	40	39	46
6	Sporting	30	43	38	44
7	Union Namur	30	43	34	42
8	Sprimont-Com	30	35	38	40
9	Tongeren	30	38	42	39
10	Tournai	30	38	35	38
11	Verviers	30	33	43	37
12	Charleroi	30	37	51	35
13	Bocholt	30	34	43	32
14	Leopoldsburg	30	34	46	32
15	Walhain	30	27	39	32
16	R.R.F.C.	30	42	54	27

TEMPORADA 2004/2005

DIVISIÓN BELGA 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Lommel SK	30	77	22	78
2	OH Leuven	30	62	27	62
3	Tongeren	30	51	33	52
4	Sprimont-Com	30	46	43	49
5	Bruxelles	30	44	38	44
6	Walhain	30	51	52	43
7	Bocholt	30	36	35	42
8	Tienen	30	35	35	39
9	Olympic	30	39	36	37
10	Diegem Sport	30	52	44	36
11	La Calamine	30	37	59	34
12	Francs	30	23	45	33
13	Sporting	30	41	52	31
14	Union Namur	30	33	61	30
15	Veldwezelt	30	32	56	25
16	RFC Seraing	30	33	54	22

TEMPORADA 2003/2004

DIVISIÓN BELGA 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Union	30	56	24	60
2	Lommel SK	30	55	33	55
3	OH Leuven	30	43	23	53
4	Bocholt	30	48	35	51
5	Veldwezelt	29	41	38	46
6	Walhain	30	51	45	44
7	Union Namur	30	38	45	37
8	Olympic	30	43	47	36
9	Tongeren	30	32	37	36
10	RFC Liège	30	43	43	35
11	Francs	30	33	38	35
12	Diegem Sport	29	43	50	35
13	Sprimont-Com	30	39	45	34
14	RFC Seraing	30	31	49	33
15	Tournai	30	30	49	31
16	Royal Spa	30	29	54	27

Competiciones que juega

División Belga 2 Grupo 2

Pos	Equipos		Pts
1		Cappellen	66
2		Hades	62
3		Sporting Hasselt	58
4		Belisia Bilzen	56
5		Tongeren	56
6		Lyra-Lierse	55
7		Mechelen Sub 21	54
8		Diegem Sport	52
9		Bocholt	49
10		Racing Mechelen	47
11		KFC Lille	46
12		KSC City Pirates	44
13		Londerzeel	41
14		Berchem Sport	38
15		FC Lebbeke	38
16		KFC Turnhout	34
17		Pepingen-Halle	28
18		Beerschot-Wilrijk Sub 21	27

	Ascenso : Cappellen
	Playoff Ascenso : Hades
	Posible siguiente ronda : Sporting Hasselt, Belisia Bilzen, Tongeren
	Playoff Descenso : KFC Turnhout
	Descenso : Pepingen-Halle, Beerschot-Wilrijk Sub 21

RIVALES EN División Belga 2

USO DE MEMORIA

7,545,664 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.2373
Total Execution Time	0.2393

CADENA URL

/historico/Bocholt

GET DATOS

$_GET['/historico/Bocholt']

POST DATOS

No hay datos POST existentes

CONSULTAS (80)

0.0026	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 = 'Bocholt' 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.0065	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 = 'Bocholt' ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 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=7550 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=7550 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=7550 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023	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 = 68500
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7550 AND type_rel = 2
0.0024	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 = '7550' ORDER BY l.year DESC,cat.coefficient DESC
0.0022	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 = '7550' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0021	SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '7550' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '7550' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 68500 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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=7550 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0019	SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (68500,63346) 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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 68500 AND teamId = 7550
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 63346 AND teamId = 7550
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021	SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '7550' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7550' and rp.type = 4
0.0021	SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '7550' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 68500 WHERE rp.league_id = 68500 AND rp.teamId = 7550 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.0026	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 68500 WHERE rp.league_id = 68500 AND rp.teamId = 7550 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 68500 WHERE rp.league_id = 68500 AND rp.teamId = 7550 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 7550 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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* `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.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 = 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.0021	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.0026	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.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 = 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.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* `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.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15756 AND t.round = 38 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* `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.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 = 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.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 = 42549 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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.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* `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 = 24298 AND t.round = 34 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 = 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.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* `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.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* `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 = 24307 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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 = 24320 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0067	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 = 24315 AND t.round = 30 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* `tables2004` 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 = 24310 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 68500 ORDER BY nameShow LIMIT 100

Bocholt

Bocholt

Selecciona un equipo

Competiciones que juega

División Belga 2 Grupo 2

RIVALES EN División Belga 2