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

KV Oostende

Entrenador: Jamath Shoffner

Temporada 2016/2017

TEMPORADA 2016/2017

LIGA BELGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Anderlecht	10	14	6	52
2	Club Brugge	10	16	14	45
3	KAA Gent	10	16	11	41
4	KV Oostende	10	14	17	37
5	Charleroi	10	10	13	35
6	Zulte-Warege	10	12	21	33

TEMPORADA 2015/2016

LIGA BELGA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Club Brugge	10	25	9	54
2	Anderlecht	10	15	16	47
3	KAA Gent	10	10	15	42
4	Genk	10	20	13	40
5	KV Oostende	10	14	19	36
6	Zulte-Warege	10	11	23	27

TEMPORADA 2014/2015

LIGA BELGA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Club Brugge	30	69	28	61
2	KAA Gent	30	52	29	57
3	Anderlecht	30	51	30	57
4	Standard	30	49	39	53
5	Kortrijk	30	54	35	51
6	Charleroi	30	44	31	49
7	Genk	30	38	28	49
8	Lokeren	30	38	32	42
9	KV Mechelen	30	37	39	41
10	KV Oostende	30	40	52	38
11	Westerlo	30	42	63	33
12	Zulte-Warege	30	41	54	31
13	Mouscron	30	32	51	26
14	SK Beveren	30	30	49	26
15	Cercle	30	21	45	24
16	Lierse SK	30	30	63	22

TEMPORADA 2013/2014

LIGA BELGA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	KV Oostende	6	7	1	14
2	KAA Gent	6	11	6	10
3	Lierse SK	6	5	12	6
4	SK Beveren	6	7	11	4

TEMPORADA 2012/2013

SEGUNDA DIVISIÓN BÉLGICA
Equipo		PJ	GF	GC	Puntos
1	KV Oostende	34	61	27	75
2	Mouscron	34	58	29	67
3	Westerlo	34	54	29	63
4	Sint-Truiden	34	54	36	57
5	Borinage	34	44	34	55
6	White Star.	34	44	39	53
7	Lommel SK	34	50	48	50
8	KAS Eupen	34	44	37	49
9	Tubize	34	43	42	46
10	Antwerp	34	42	44	45
11	Roeselare	34	44	47	42
12	Dessel Sport	34	35	42	41
13	Eendracht	34	38	52	41
14	Visé	34	47	57	33
15	Brussels	34	32	49	33
16	Heist	34	39	57	30
17	Sint-Niklaas	34	34	64	30
18	Oudenaarde	34	31	61	30

TEMPORADA 2011/2012

SEGUNDA DIVISIÓN BÉLGICA
Equipo		PJ	GF	GC	Puntos
1	Charleroi	34	64	34	74
2	KAS Eupen	34	61	34	68
3	SK Beveren	34	61	34	68
4	KV Oostende	34	61	29	66
5	Lommel SK	34	48	42	52
6	White Star.	34	48	43	51
7	Heist	34	46	46	46
8	Eendracht	34	46	52	46
9	Visé	34	44	41	44
10	Antwerp	34	39	42	43
11	Borinage	34	44	54	42
12	Tubize	34	36	55	41
13	Roeselare	34	46	51	40
14	Brussels	34	44	46	38
15	Sint-Niklaas	34	41	54	34
16	FCV Dender	34	33	43	33
17	Tienen	34	34	61	33
18	Standaard	34	19	54	21

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

SEGUNDA DIVISIÓN BÉLGICA
Equipo		PJ	GF	GC	Puntos
1	FCV Dender	34	73	27	79
2	KV Mechelen	34	64	36	70
3	Kortrijk	34	69	35	67
4	Antwerp	34	63	36	60
5	OH Leuven	34	53	49	56
6	KAS Eupen	34	50	46	50
7	Deinze	34	50	54	50
8	Tubize	34	36	32	48
9	Union	34	47	44	45
10	Tienen	34	50	57	45
11	KV Oostende	34	51	58	40
12	VW Hamme	34	38	43	39
13	Excelsior	34	37	55	39
14	Lommel SK	34	39	49	36
15	SK Beveren	34	41	56	36
16	Dessel Sport	34	45	58	34
17	Racing	34	32	58	27
18	Ronse	34	26	71	20

TEMPORADA 2005/2006

SEGUNDA DIVISIÓN BÉLGICA
Equipo		PJ	GF	GC	Puntos
1	Mons	34	64	30	69
2	Lommel SK	34	62	38	63
3	Kortrijk	34	57	41	58
4	Verbroederin	34	49	34	57
5	SK Beveren	34	58	46	57
6	OH Leuven	34	53	37	54
7	Antwerp	34	58	50	53
8	VW Hamme	34	58	47	49
9	KAS Eupen	34	51	47	48
10	KV Oostende	34	51	47	47
11	Ronse	34	52	62	42
12	Tubize	34	47	50	41
13	KV Mechelen	34	44	46	39
14	Union	34	42	53	37
15	Excelsior	34	28	41	37
16	Dessel Sport	34	38	50	34
17	Deinze	34	39	65	29
18	Beringen	34	24	91	26

TEMPORADA 2004/2005

LIGA BELGA
Equipo		PJ	GF	GC	Puntos
1	Club Brugge	34	83	25	79
2	Anderlecht	34	75	34	76
3	Standard	34	64	30	70
4	Genk	34	59	37	70
5	Charleroi	34	47	34	64
6	KAA Gent	34	41	37	56
7	Germinal	34	37	40	45
8	Louvieroise	34	43	43	44
9	Lokeren	34	36	38	44
10	Lierse SK	34	57	60	41
11	Cercle	34	45	74	41
12	Westerlo	34	34	54	39
13	Excelsior	34	40	43	36
14	Sint-Truiden	34	40	58	36
15	Molenbeek	34	32	60	33
16	KSK Beveren	34	43	59	32
17	KV Oostende	34	31	62	27
18	Mons	34	39	58	26

TEMPORADA 2003/2004

SEGUNDA DIVISIÓN BÉLGICA
Equipo		PJ	GF	GC	Puntos
1	Molenbeek	34	79	29	70
2	KV Oostende	34	69	43	65
3	Roeselare	34	59	38	63
4	Tubize	34	60	33	58
5	Zulte-Warege	34	58	45	52
6	Excelsior	34	38	33	51
7	Deinze	34	45	46	50
8	Patro Eisden	34	47	50	49
9	Dessel Sport	34	41	42	48
10	Verbroederin	34	38	41	47
11	VW Hamme	34	43	44	46
12	Eendracht	34	54	59	45
13	Visé	34	48	59	44
14	KAS Eupen	34	32	41	37
15	Ronse	34	27	46	32
16	Racing Club	34	41	61	31
17	Tienen	34	30	64	25
18	Denderleeuw	34	32	67	22

TEMPORADA 2002/2003

DIVISIÓN BELGA 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Berchem	26	45	23	51
2	KV Oostende	26	51	27	47
3	Eendracht	25	39	37	45
4	Wevelgem	26	54	33	42
5	Kortrijk	27	38	30	39
6	TK Meldert	26	40	46	36
7	Tournai	26	37	32	34
8	Cappellen	26	32	38	34
9	Maldegem	26	42	49	34
10	SK Beveren	26	44	38	33
11	Sint-Niklaas	26	29	37	29
12	Denderhoutem	26	36	46	29
13	Francs	26	27	38	26
14	Torhout	26	24	43	24
15	KRC Gent	26	20	41	21

Competiciones que juega

Grupo 1

Liga Belga Grupo 1

Pos	Equipos		Pts
1		Anderlecht	61
2		Club Brugge	59
3		Zulte-Waregem	54
4		KAA Gent	50
5		KV Oostende	50
6		Charleroi	49
7		KV Mechelen	48
8		Genk	48
9		Standard de Liège	39
10		Kortrijk	31
11		Lokeren	31
12		Sint-Truidense V.V.	30
13		KAS Eupen	30
14		SK Beveren	30
15		Mouscron	24
16		KVC Westerlo	23

	Playoff Título : Anderlecht, Club Brugge, Zulte-Waregem, KAA Gent, KV Oostende, Charleroi
	Eliminatoria Champions/UEFA : KV Mechelen, Genk, Standard de Liège, Kortrijk, Lokeren, Sint-Truidense V.V., KAS Eupen, SK Beveren, Mouscron
	Descenso : KVC Westerlo

RIVALES EN Copa Belga

RIVALES EN Liga Belga

USO DE MEMORIA

7,201,880 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.6926
Total Execution Time	0.6939

CADENA URL

/historico/Kv-Oostende/2017

GET DATOS

$_GET['/historico/Kv-Oostende/2017']

POST DATOS

No hay datos POST existentes

CONSULTAS (45)

0.0132	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 = 'Kv-Oostende' AND l.year = 2017 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.0111	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=1477 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0113	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=1477 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0114	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=1477 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0114	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=1477 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112	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=1477 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112	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=1477 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133	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 = 33313
0.0133	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 = 38066
0.0133	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 = 38504
0.0135	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 = 33404
0.0141	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 = '1477' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0158	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 = '1477' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0161	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 = 33404 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0114	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 = 38066 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136	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=1477 AND l.year in (2016,2017,2018) ORDER BY l.id DESC, l.year DESC ;
0.0116	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 (43127,38787,38744,38639,38427) 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.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 38639 AND teamId = 1477
0.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 38744 AND teamId = 1477
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 38787 AND teamId = 1477
0.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 43127 AND teamId = 1477
0.0498	SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 1477
0.0112	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 33313 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128	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 events2017 e ON e.player_id = p.id AND e.league_id = 33313 WHERE rp.league_id = 33313 AND rp.teamId = 1477 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.0125	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 events2017 e ON e.player_id = p.id AND e.league_id = 33313 WHERE rp.league_id = 33313 AND rp.teamId = 1477 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0125	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 events2017 e ON e.player_id = p.id AND e.league_id = 33313 WHERE rp.league_id = 33313 AND rp.teamId = 1477 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133	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 = 1477 AND l.year <= 2017 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0123	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 = 33313 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118	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 = 38066 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124	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 = 15156 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0119	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 = 21698 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0121	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 = 11090 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124	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 = 2409 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114	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 = 10120 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 10118 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115	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 = 1741 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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.0112	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.0112	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.0114	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.0115	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 = 13513 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0120	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 = 13512 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123	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 = 357 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 13510 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0122	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* `tables2003` 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 = 24308 AND t.round = 28 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

KV Oostende

KV Oostende

Selecciona un equipo

Competiciones que juega

Liga Belga Grupo 1

RIVALES EN Copa Belga

RIVALES EN Liga Belga