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

Tournai

Temporada 2023/2024

TEMPORADA 2023/2024

DIVISIÓN BELGA 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	RAEC Mons	32	68	22	79
2	Union	32	62	37	65
3	Tubize	31	57	32	57
4	Tournai	31	50	32	56
5	Binche	31	42	42	47
6	Warnant	31	43	36	45
7	Louvière	32	46	42	44
8	Stockay-Warf	31	54	47	44
9	Meux	32	43	43	44
10	La Calamine	32	50	52	41
11	Union	32	49	52	40
12	Verviers	32	53	59	38
13	Verlaine	31	46	52	36
14	Jette	32	32	52	35
15	Ganshoren	31	39	53	34
16	Acren	31	46	64	30
17	Hamoir	31	29	63	23
18	Rebecq	31	37	66	22

TEMPORADA 2022/2023

PROMOCIÓN BÉLGICA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	RAEC Mons	29	56	18	64
2	Onhaye	29	54	32	57
3	Rapid	29	44	37	52
4	Tournai	29	45	33	46
5	Ostiches	29	39	32	46
6	Crossing	29	41	32	45
7	Aische	29	57	42	44
8	Entité	29	38	40	41
9	RAS Monceau	29	43	43	39
10	Jeunesse	29	32	34	36
11	Brainois	29	39	43	32
12	Jodoigne	29	41	51	31
13	Couvin-Marie	29	35	45	31
14	SG-Tertre-Ha	29	41	59	30
15	Léopold	29	23	54	23
16	Gosselies	29	29	62	20

TEMPORADA 2021/2022

PROMOCIÓN BÉLGICA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Union Namur	28	58	21	65
2	Entité	28	61	32	49
3	Crossing	28	53	40	49
4	Aische	28	61	41	48
5	Tournai	28	38	34	45
6	Binche	28	41	36	42
7	Rapid	28	40	35	41
8	RAEC Mons	28	55	39	40
9	Jeunesse	28	32	34	40
10	Ostiches	28	41	39	37
11	SG-Tertre-Ha	28	39	51	36
12	Braine	28	47	57	31
13	Gosselies	28	21	50	22
14	PAC Buzet	28	20	49	18
15	Stockel	28	32	81	10

TEMPORADA 2020/2021

PROMOCIÓN BÉLGICA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	PAC Buzet	0	0	0	0
2	Ostiches	0	0	0	0
3	Stockel	0	0	0	0
4	Entité	0	0	0	0
5	Crossing	0	0	0	0
6	Tournai	0	0	0	0
7	Rapid	0	0	0	0
8	Aische	0	0	0	0
9	SG-Tertre-Ha	0	0	0	0
10	Gosselies	0	0	0	0
11	Binche	0	0	0	0
12	RAEC Mons	0	0	0	0
13	Braine	0	0	0	0
14	Union Namur	0	0	0	0
15	Jeunesse	0	0	0	0
16	Stade	0	0	0	0

TEMPORADA 2019/2020

PROMOCIÓN BÉLGICA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ganshoren	24	56	27	53
2	Jette	24	45	27	48
3	RAEC Mons	24	53	27	43
4	Rapid	24	35	27	40
5	Walhain	24	42	37	40
6	Braine	24	40	38	38
7	Tournai	24	35	25	37
8	SG-Tertre-Ha	24	47	41	36
9	Stade	24	35	36	34
10	Entité	24	33	41	31
11	Gosselies	24	35	44	31
12	Ostiches	24	38	45	29
13	PAC Buzet	24	28	42	28
14	Kosova	24	36	55	24
15	Léopold	24	29	44	18
16	Wavre	24	17	48	13

TEMPORADA 2018/2019

PROMOCIÓN BÉLGICA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Union Namur	30	68	29	60
2	Braine	30	58	31	60
3	Aische	30	59	47	54
4	Tournai	30	46	25	52
5	Léopold	30	53	36	48
6	Entité	30	50	38	47
7	Ostiches	30	55	47	47
8	RAEC Mons	30	45	45	44
9	Rapid	30	50	50	43
10	Stade	30	37	36	39
11	Jette	30	48	56	34
12	Racing Wavre	30	42	63	32
13	Ganshoren	30	44	61	31
14	Jeunesse	30	45	65	29
15	Stockel	30	38	69	23
16	Binche	30	33	73	20

TEMPORADA 2017/2018

PROMOCIÓN BÉLGICA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	RAAL	30	74	24	69
2	Francs	30	78	32	66
3	Onhaye	30	66	47	56
4	Tournai	30	45	27	55
5	Couvin-Marie	30	62	41	54
6	Racing Wavre	30	58	47	52
7	Binche	30	56	53	52
8	Entité	30	52	50	41
9	RAEC Mons	30	44	40	39
10	Jeunesse	30	46	56	37
11	Ganshoren	30	40	54	36
12	Léopold	30	47	50	32
13	Stade	30	35	52	29
14	Spy	30	39	83	22
15	Solre-sur-Sa	30	35	67	20
16	Waterloo	30	34	88	14

TEMPORADA 2016/2017

PROMOCIÓN BÉLGICA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Molenbeek	26	72	31	61
2	Rebecq	26	58	24	61
3	Francs	26	60	21	58
4	RAEC Mons	26	54	28	47
5	Tournai	26	55	46	40
6	Onhaye	26	34	44	37
7	Léopold	26	44	29	35
8	Entité	26	34	35	35
9	Racing Wavre	26	40	33	31
10	Solre-sur-Sa	26	32	59	27
11	Waterloo	26	30	49	26
12	Ganshoren	26	36	65	23
13	Jeunesse	26	29	51	20
14	Profondevill	26	18	81	2

TEMPORADA 2015/2016

PROMOCIÓN BÉLGICA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Olympic	27	52	23	62
2	KFC Duffel	28	59	34	52
3	Châtelet	28	47	40	50
4	Sterrebeek	28	50	39	49
5	Charleroi	28	47	45	48
6	Rebecq	28	44	35	43
7	Halle	28	46	28	42
8	Molenbeek	28	43	34	39
9	Léopold	28	46	52	39
10	Wolvertem	28	44	49	35
11	Betekom	28	42	39	34
12	Francs	27	41	52	30
13	Ganshoren	28	34	59	24
14	Tournai	28	32	57	24
15	Waterloo	28	22	63	14
16	Géants	0	0	0	0

TEMPORADA 2014/2015

DIVISIÓN BELGA 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Coxyde	34	75	42	71
2	Deinze	34	72	29	65
3	Temse	34	64	33	61
4	Olsa Brakel	34	52	44	55
5	Oudenaarde	34	54	42	54
6	Rupel Boom	34	55	51	54
7	Winkel Sport	34	57	53	52
8	VW Hamme	34	55	50	50
9	FCV Dender	34	46	39	49
10	KRC Gent	34	41	48	47
11	Londerzeel	34	46	43	44
12	Gullegem	34	35	34	43
13	Bornem	34	46	53	42
14	Torhout	34	33	42	40
15	Izegem	34	45	57	40
16	Géants	34	39	68	35
17	Eendracht	34	43	65	30
18	Tournai	34	27	92	14

TEMPORADA 2013/2014

DIVISIÓN BELGA 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Racing	35	77	37	75
2	Oudenaarde	35	64	39	67
3	Deinze	35	55	39	60
4	Londerzeel	34	55	41	57
5	Coxyde	34	66	46	56
6	Géants	35	49	39	53
7	Olsa Brakel	35	60	59	51
8	KRC Gent	35	53	48	49
9	Tournai	35	54	56	47
10	VW Hamme	35	62	67	41
11	Torhout	34	39	55	41
12	FCV Dender	34	45	59	40
13	Izegem	35	46	60	39
14	Rupel Boom	34	41	63	39
15	Temse	34	46	56	37
16	Bornem	35	55	62	36
17	Sint-Niklaas	34	40	50	33
18	Standaard	34	35	66	32

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 1
Equipo		PJ	GF	GC	Puntos
1	Mouscron	32	72	17	79
2	Oudenaarde	32	69	25	65
3	Louvière	32	65	25	65
4	Excelsior	32	53	24	55
5	Torhout	32	55	51	50
6	Deinze	32	50	55	46
7	Ronse	32	57	49	45
8	Olsa Brakel	32	48	42	45
9	Heppignies	32	47	38	44
10	Racing	32	41	42	43
11	Géants	32	41	34	41
12	Bleid-Gaume	32	46	48	37
13	Huy	32	42	42	36
14	Verviers	32	42	57	32
15	Bertrix	32	48	54	31
16	Coxyde	30	29	102	22
17	Tournai	30	12	112	16
18	Olympic	0	0	0	0

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

SEGUNDA DIVISIÓN BÉLGICA
Equipo		PJ	GF	GC	Puntos
1	Sint-Truiden	36	72	29	80
2	Lierse SK	36	75	40	75
3	Antwerp	36	55	32	61
4	Star	36	56	48	55
5	Tournai	36	53	41	54
6	Tienen	36	58	49	53
7	KV Oostende	36	54	51	53
8	Ronse	36	54	52	52
9	KVSK United	36	48	38	51
10	Brussels	36	50	37	49
11	RFC Liège	36	49	48	48
12	OH Leuven	36	46	48	46
13	KSK Beveren	36	47	57	45
14	KAS Eupen	36	47	63	43
15	Excelsior	36	46	58	39
16	Olympic	36	48	65	39
17	VW Hamme	36	48	64	36
18	Deinze	36	46	65	36
19	Union Namur	36	22	89	13

TEMPORADA 2007/2008

SEGUNDA DIVISIÓN BÉLGICA
Equipo		PJ	GF	GC	Puntos
1	Kortrijk	36	73	35	76
2	Tubize	36	49	29	66
3	OH Leuven	36	61	42	61
4	KVSK United	36	51	36	60
5	Antwerp	36	64	38	59
6	Excelsior	36	56	44	56
7	Lierse SK	36	47	36	53
8	VW Hamme	36	54	45	49
9	Tienen	36	49	51	48
10	KSK Beveren	36	48	56	48
11	Tournai	36	34	37	46
12	Olympic	36	40	53	46
13	KAS Eupen	36	45	49	45
14	Star	36	46	47	43
15	Deinze	36	44	58	43
16	Union Namur	36	51	63	42
17	KV Oostende	36	44	59	42
18	Union	36	48	61	40
19	Verbroederin	36	33	98	16

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 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 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

Grupo 1

División Belga 2 Grupo 1

Pos	Equipos		Pts
1		RAEC Mons	79
2		Union Rochefortoise	65
3		Tubize	57
4		Tournai	56
5		Binche	47
6		Warnant	45
7		La Louvière Centre	44
8		Stockay-Warfusée	44
9		Meux	44
10		La Calamine	41
11		Union Saint-Gilloise II	40
12		Verviers	38
13		Verlaine	36
14		Jette	35
15		Ganshoren	34
16		Acren Lessines	30
17		Hamoir	23
18		Rebecq	22

	Ascenso : RAEC Mons
	Playoff Ascenso : Union Rochefortoise, Tubize, Tournai, Binche
	Playoff Descenso : Acren Lessines
	Descenso : Hamoir, Rebecq

RIVALES EN División Belga 2

RIVALES EN Copa Belga

USO DE MEMORIA

7,822,264 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1625
Total Execution Time	0.1639

CADENA URL

/historico/Tournai

GET DATOS

$_GET['/historico/Tournai']

POST DATOS

No hay datos POST existentes

CONSULTAS (46)

0.0037	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 = 'Tournai' 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.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=7531 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=7531 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=7531 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042	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 = 73206
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7531 AND type_rel = 2
0.0020	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=241 AND type_rel = 3
0.0032	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 241 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023	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 (900137,520396,273795,255821,104680) ORDER BY n.cover_points DESC, update_date DESC
0.0025	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 = '7531' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0029	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 = '7531' 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 = 72463 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0037	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 = 73206 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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=7531 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0023	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,72463,68883) 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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 72463 AND teamId = 7531
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 68883 AND teamId = 7531
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 7531
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* `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 = 72463 AND t.round = 32 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 = '7531' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7531' and rp.type = 4
0.0020	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 = '7531' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032	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 = 72463 WHERE rp.league_id = 72463 AND rp.teamId = 7531 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.0035	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 = 72463 WHERE rp.league_id = 72463 AND rp.teamId = 7531 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 72463 WHERE rp.league_id = 72463 AND rp.teamId = 7531 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 7531 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72463 AND t.round = 32 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* `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 = 68883 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.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 = 63439 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.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* `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 = 58724 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.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 = 51109 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.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* `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 = 44694 AND t.round = 30 ORDER BY team.conference 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* `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 = 38981 AND t.round = 30 ORDER BY team.conference 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* `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 = 34028 AND t.round = 26 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* `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 = 15780 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* `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 = 4221 AND t.round = 34 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* `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 = 2737 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* `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.0030	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 = 1742 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* `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.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 = 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.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* `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 = 10159 AND t.round = 38 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* `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 = 10160 AND t.round = 38 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* `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.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* `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.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


	¿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

Tournai

Tournai

Selecciona un equipo

Competiciones que juega

División Belga 2 Grupo 1

RIVALES EN División Belga 2

RIVALES EN Copa Belga