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

Silvolde

Temporada 2022/2023

TEMPORADA 2022/2023

HOOFDKLASSE ZONDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Meerssen	30	61	26	69
2	Kampong	30	56	27	54
3	Juliana 31	30	64	44	50
4	Hoogland	30	55	49	48
5	LONGA '30	30	49	35	47
6	Venray	30	64	58	46
7	Halsteren	30	50	40	45
8	RKSV Nuenen	30	40	36	45
9	HVCH	30	47	50	44
10	AWC	29	51	55	44
11	SV Orion	29	49	52	43
12	Unitas 30	30	50	57	39
13	EVV	30	38	40	37
14	Silvolde	30	31	50	26
15	Moerse Boys	30	47	72	24
16	RKZVC	30	24	85	10

TEMPORADA 2021/2022

HOOFDKLASSE ZONDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Baronie	26	53	21	60
2	Rosmalen	26	60	33	54
3	UDI '19	26	41	29	49
4	SV Orion	26	51	35	47
5	Halsteren	26	48	39	44
6	Juliana 31	26	45	38	41
7	RKSV Nuenen	26	36	31	37
8	AWC	26	49	50	33
9	Meerssen	26	40	45	33
10	Silvolde	26	38	30	32
11	RKZVC	26	25	44	27
12	Moerse Boys	26	29	53	22
13	LONGA '30	26	33	59	19
14	RKSV Minor	26	27	68	14
15	Hoensbroek	0	0	0	0

TEMPORADA 2020/2021

HOOFDKLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	RKVV Velsen	6	11	3	11
2	Hoogeveen	6	12	7	10
3	Noordwijk	6	11	7	10
4	RKZVC	6	11	12	10
5	De Zouaven	6	10	11	10
6	Alphense	5	10	7	8
7	HBS	6	10	7	8
8	LONGA '30	5	7	11	8
9	Silvolde	5	11	9	7
10	Quick 1887	5	8	7	7
11	Alcides	5	6	9	6
12	TAC'90	5	9	12	5
13	SDO Bussum	6	9	13	5
14	Purmersteijn	4	4	7	4
15	RKAVV	3	4	6	3
16	VV Emmen	5	8	13	3

TEMPORADA 2019/2020

HOOFDKLASSE ZONDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	GVV Unitas	20	35	12	47
2	Halsteren	20	42	18	41
3	IFC	20	46	25	35
4	Baronie	20	38	19	35
5	RKZVC	20	40	25	34
6	Juliana 31	20	48	33	31
7	Rosmalen	20	36	33	30
8	UDI '19	19	28	22	29
9	AWC	19	21	32	25
10	LONGA '30	19	32	35	24
11	Meerssen	19	20	29	22
12	Silvolde	19	19	28	20
13	RKSV Minor	19	21	46	19
14	Moerse Boys	20	29	38	18
15	Hoensbroek	20	23	49	16
16	RKSV Nuenen	20	10	44	10

TEMPORADA 2018/2019

HOOFDKLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	RKVV DEM	30	60	31	60
2	Hoogeveen	30	71	45	57
3	SDO Bussum	30	69	48	57
4	RKZVC	30	59	53	53
5	Hoogland	30	53	43	49
6	Alcides	30	51	51	44
7	Silvolde	30	54	46	42
8	Hollandia	30	43	49	42
9	Purmersteijn	30	48	37	41
10	MSC	30	53	58	39
11	AWC	30	52	69	39
12	Quick 1887	30	52	51	37
13	De Bataven	30	51	60	37
14	Fortuna	30	39	52	31
15	Achilles	30	47	59	30
16	RKHVV	30	30	80	14

TEMPORADA 2017/2018

HOOFDKLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Noordwijk	30	75	37	62
2	Achilles	30	73	34	56
3	Silvolde	30	69	35	55
4	Leonidas	30	65	53	51
5	Purmersteijn	30	57	47	48
6	Hollandia	30	65	48	47
7	Alphense	30	54	49	47
8	SDO Bussum	30	60	50	44
9	RKAVV	30	55	51	41
10	MSC	30	60	77	41
11	De Bataven	30	42	48	35
12	RKHVV	30	50	63	35
13	SWZ	30	37	49	33
14	DHC Delft	30	47	73	30
15	Heerenveen	30	34	72	24
16	Achilles	30	45	102	17

TEMPORADA 2016/2017

HOOFDKLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	ADO 20	30	82	41	64
2	Woezik	30	57	32	55
3	Noordwijk	30	64	39	53
4	Hollandia	30	51	33	53
5	Silvolde	30	54	51	49
6	De Meern	30	70	55	45
7	SWZ	30	65	52	41
8	SDO Bussum	30	42	45	40
9	Heerenveen	30	49	52	38
10	De Bataven	30	45	60	38
11	MSC	30	53	55	37
12	RKHVV	30	42	52	37
13	Alverna	30	50	45	36
14	Watergraafsm	30	51	55	36
15	Hoogland	30	42	56	33
16	Dieze West	30	28	122	6

TEMPORADA 2015/2016

HOOFDKLASSE ZONDAG GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Juliana 31	26	67	30	65
2	Quick 1887	26	69	26	55
3	Quick '20	26	68	29	54
4	Silvolde	26	43	30	48
5	De Bataven	26	55	44	46
6	Dieze West	26	41	51	36
7	MSC	26	50	52	34
8	Hollandia	26	38	32	33
9	Alverna	26	35	31	33
10	RKHVV	26	45	53	33
11	ROHDA Raalte	26	44	54	32
12	Achilles	26	39	73	21
13	Rigtersbleek	26	26	74	13
14	Alcides	26	27	68	10

TEMPORADA 2014/2015

EERSTE KLASSE ZONDAG GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Alverna	26	63	20	59
2	Hoogland	26	49	21	56
3	Silvolde	26	47	23	45
4	Rigtersbleek	26	49	37	45
5	LONGA '30	26	60	46	43
6	TVC '28	26	40	34	38
7	Bemmel	26	50	56	38
8	Heino	26	36	40	34
9	De Zweef	26	42	49	34
10	Rood	26	33	53	29
11	Concordia	26	43	59	26
12	Grol	26	32	44	24
13	Rheden	26	44	61	18
14	Luctor	26	21	66	12

TEMPORADA 2013/2014

EERSTE KLASSE ZONDAG GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	AFC Arhem	24	69	18	58
2	Hoogland	24	50	27	46
3	Germania	24	36	22	43
4	AWC	24	40	32	40
5	Silvolde	24	47	33	37
6	Rheden	24	48	37	37
7	Grol	24	49	48	35
8	Rigtersbleek	24	43	39	32
9	Bemmel	24	42	35	31
10	Luctor	24	34	48	31
11	Babberich	24	41	52	25
12	Achilles	24	26	51	19
13	DVV Duiven	24	13	96	1
14	Glanerbrug	0	0	0	0

TEMPORADA 2012/2013

EERSTE KLASSE ZONDAG GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Alverna	26	67	37	54
2	Silvolde	26	57	33	51
3	Germania	26	56	38	47
4	AWC	26	53	41	44
5	AFC Arnhem	26	62	46	43
6	Babberich	26	44	39	42
7	TVC '28	26	51	53	37
8	Glanerbrug	26	62	65	37
9	Rheden	26	44	56	33
10	Achilles	26	31	39	32
11	Bemmel	26	51	57	29
12	SDOUC	26	46	67	29
13	Stevo	26	34	58	28
14	SC Enschede	26	25	54	15

Competiciones que juega

Grupo 2

Hoofdklasse Zondag Grupo 2

Pos	Equipos		Pts
1		Meerssen	69
2		Kampong	54
3		Juliana 31	50
4		Hoogland	48
5		LONGA '30	47
6		Venray	46
7		Halsteren	45
8		RKSV Nuenen	45
9		HVCH	44
10		AWC	44
11		SV Orion	43
12		Unitas 30	39
13		EVV	37
14		Silvolde	26
15		Moerse Boys	24
16		RKZVC	10

	Ascenso : Meerssen
	Playoff Descenso : EVV, Silvolde
	Descenso : Moerse Boys, RKZVC

RIVALES EN Hoofdklasse - Pl.

RIVALES EN Hoofdklasse Zond.

USO DE MEMORIA

6,054,168 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1495
Total Execution Time	0.1507

CADENA URL

/historico/Silvolde

GET DATOS

$_GET['/historico/Silvolde']

POST DATOS

No hay datos POST existentes

CONSULTAS (54)

0.0023	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 = 'Silvolde' 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.0033	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 = 'Silvolde' 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=11275 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=11275 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=11275 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=11275 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=11275 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=11275 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=11275 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=11275 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=11275 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=11275 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=11275 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=11275 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=11275 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=11275 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=11275 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=11275 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=11275 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	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 = 70057
0.0022	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 = 71884
0.0017	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11275 AND type_rel = 2
0.0017	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=227 AND type_rel = 3
0.0024	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 227 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0019	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 (711277) 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 = '11275' ORDER BY l.year DESC,cat.coefficient 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 = '11275' 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 = '11275' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019	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 = 71884 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 70057 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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=11275 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0018	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 (71884,70057) 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.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 70057 AND teamId = 11275
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71884 AND teamId = 11275
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 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 = 70057 AND t.round = 30 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 = '11275' 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 = '11275' and rp.type = 4
0.0022	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 = '11275' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019	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 = 70057 WHERE rp.league_id = 70057 AND rp.teamId = 11275 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.0019	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 = 70057 WHERE rp.league_id = 70057 AND rp.teamId = 11275 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019	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 = 70057 WHERE rp.league_id = 70057 AND rp.teamId = 11275 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 11275 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 70057 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* `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 = 63265 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.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* `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 = 58336 AND t.round = 6 ORDER BY team.conference ASC,t.position 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* `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 = 50985 AND t.round = 21 ORDER BY team.conference ASC,t.position 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* `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 = 44702 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* `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 = 39750 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* `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 = 33960 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* `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 = 15941 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* `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 = 9403 AND t.round = 26 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* `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 = 9420 AND t.round = 26 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* `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 = 2223 AND t.round = 26 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 = 70057 ORDER BY nameShow LIMIT 100

Silvolde

Silvolde

Selecciona un equipo

Competiciones que juega

Hoofdklasse Zondag Grupo 2

RIVALES EN Hoofdklasse - Pl.

RIVALES EN Hoofdklasse Zond.