Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Resultados de Fútbol

TSK Roces

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA RFFPA
Equipo		PJ	GF	GC	Puntos
1	Real	31	54	14	69
2	Martín	31	45	14	68
3	Astur	31	46	22	58
4	Mosconia	30	55	24	57
5	TSK Roces	31	51	40	53
6	Club Siero	31	49	34	49
7	Vallobin CD	30	43	31	49
8	Navarro	31	35	34	43
9	U.Comercial	31	46	44	41
10	Muros	31	36	39	41
11	Universidad	31	37	41	39
12	Llaranes CF	31	32	36	37
13	Andés	31	30	42	37
14	Candás CF	31	36	48	35
15	Valdesoto	31	25	36	33
16	Fresneda	31	22	42	32
17	Berrón	31	24	42	28
18	Club	31	30	60	27
19	Atlético	31	38	59	26
20	Colloto	31	22	54	18

TEMPORADA 2022/2023

PRIMERA RFFPA
Equipo		PJ	GF	GC	Puntos
1	Urraca CF	38	61	25	74
2	Gijón	38	58	27	73
3	Lenense	38	53	30	70
4	Barcia CF	38	46	33	62
5	Atlético	38	51	30	62
6	TSK Roces	38	36	28	62
7	Llaranes CF	38	48	43	61
8	Astur	38	38	35	54
9	Candás CF	38	48	49	53
10	Navarro	38	44	47	52
11	Berrón	38	43	43	51
12	Andés	38	47	42	48
13	Martín	38	37	40	45
14	Mosconia	38	30	36	44
15	Colloto	38	38	51	44
16	Vallobin CD	38	41	45	44
17	Universidad	38	45	57	41
18	Tineo	38	31	48	36
19	Langreo	38	41	88	30
20	Lealtad	38	15	54	21

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real Oviedo	38	75	39	75
2	Sporting	38	71	25	74
3	Lealtad	38	55	27	71
4	Llanes	38	50	36	64
5	Caudal	38	55	37	64
6	CD Colunga	38	51	32	61
7	L´Entregu	38	48	39	57
8	CD Praviano	38	51	44	56
9	CD Tuilla	38	53	59	53
10	Covadonga	38	48	44	51
11	Luarca CF	38	36	52	49
12	Real	38	43	44	48
13	Gijón	38	43	52	47
14	Urraca CF	38	31	35	47
15	Martín	38	44	48	47
16	Lenense	38	39	48	46
17	TSK Roces	38	40	62	36
18	Navarro	38	29	55	33
19	Langreo	38	36	80	26
20	Mosconia	38	30	70	24

TEMPORADA 2020/2021

PRIMERA RFFPA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	TSK Roces	10	12	4	21
2	Gozón	10	8	8	13
3	Guía Norte	10	15	12	12
4	Colloto	10	9	13	12
5	Berrón	10	10	14	11
6	Ribadesella	10	7	10	11

TEMPORADA 2019/2020

PRIMERA RFFPA
Equipo		PJ	GF	GC	Puntos
1	Real	28	55	20	69
2	Avilés	28	28	12	53
3	Valdesoto	28	39	24	51
4	TSK Roces	28	50	26	50
5	Claudio	28	44	28	49
6	Podes CF	28	41	34	49
7	Astur	28	34	21	44
8	Atlético	28	40	31	41
9	Candás CF	28	30	32	36
10	Club	28	43	35	34
11	Unión	28	35	37	34
12	Berrón	28	28	45	34
13	Colloto	28	33	41	33
14	Universidad	28	34	34	32
15	Guía Norte	28	34	41	30
16	Llaranes CF	28	33	48	29
17	Tineo	28	22	36	26
18	Nalón CF	28	28	48	26
19	CD Turón	28	30	53	26
20	Madalena	28	28	63	18

TEMPORADA 2018/2019

PRIMERA RFFPA
Equipo		PJ	GF	GC	Puntos
1	Urraca CF	38	58	28	74
2	Vallobin CD	38	59	33	74
3	Navarro	38	61	27	73
4	Lenense	38	65	36	72
5	Avilés	38	52	27	71
6	Real	38	43	28	67
7	Tineo	38	63	59	56
8	TSK Roces	38	58	46	54
9	Club	38	59	61	52
10	Atlético	38	41	43	48
11	Astur	38	45	49	47
12	Candás CF	38	47	53	44
13	Colloto	38	47	59	43
14	Valdesoto	38	47	65	43
15	Berrón	38	37	59	42
16	CD Turón	38	45	65	41
17	Nalón CF	38	46	67	41
18	Andés	38	43	57	39
19	Ribadesella	38	39	62	32
20	Ribadedeva	38	33	64	31

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Real Oviedo	38	73	19	82
2	Langreo	38	89	23	78
3	Marino	38	70	21	76
4	Llanes	38	65	48	75
5	Covadonga	38	83	46	72
6	UC Ceares	38	46	30	60
7	CD Tuilla	38	60	41	59
8	CD Praviano	38	45	37	58
9	L´Entregu	38	53	50	53
10	Martín	38	41	50	51
11	Mosconia	38	39	57	50
12	Gijón	38	52	55	47
13	Condal	38	39	67	44
14	CD Colunga	38	44	60	42
15	UD Llanera	38	48	65	39
16	Club Siero	38	34	70	36
17	Real Avilés	38	35	64	32
18	Valdesoto	38	27	55	30
19	Atlético	38	22	68	28
20	TSK Roces	38	29	68	24

TEMPORADA 2016/2017

PRIMERA RFFPA
Equipo		PJ	GF	GC	Puntos
1	TSK Roces	38	58	25	72
2	Gijón	38	65	33	71
3	Martín	38	63	34	70
4	Valdesoto	38	61	31	69
5	Nalón CF	38	67	37	67
6	Rayo	38	46	31	64
7	Claudio	38	58	56	57
8	Ribadesella	38	76	76	55
9	Unión	38	50	51	55
10	Andés	38	57	61	48
11	Navarro	38	44	54	48
12	Astur	38	42	48	47
13	Universidad	38	50	66	47
14	Madalena	38	59	62	45
15	Ribadedeva	38	44	51	44
16	Candás CF	38	42	61	40
17	CD Turón	38	45	69	38
18	Muros	38	45	82	36
19	Luarca CF	38	44	65	33
20	Berrón	38	46	69	33

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Caudal	38	86	12	98
2	Langreo	38	96	25	90
3	Real Avilés	38	77	18	89
4	Marino	38	55	23	68
5	CD Tuilla	38	66	39	67
6	CD Colunga	38	60	54	66
7	Real Oviedo	38	63	42	62
8	Condal	38	50	47	60
9	Llanes	38	54	47	57
10	UC Ceares	38	42	60	45
11	Covadonga	38	35	51	45
12	Atlético	38	33	55	41
13	Mosconia	38	36	57	40
14	CD Praviano	38	39	65	40
15	Tineo	38	40	63	39
16	Club Siero	38	37	63	38
17	Urraca CF	38	34	47	36
18	Gijón	38	34	68	31
19	Astur	38	34	92	24
20	TSK Roces	38	19	62	22

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Condal	38	67	20	86
2	Caudal	38	68	18	84
3	Real Oviedo	38	82	34	78
4	CD Tuilla	38	67	31	77
5	Covadonga	38	63	39	70
6	UC Ceares	38	51	41	63
7	Llanes	38	61	51	61
8	CD Praviano	38	47	46	51
9	Urraca CF	38	50	47	50
10	Atlético	38	45	49	49
11	Mosconia	38	37	45	47
12	Real Avilés	38	46	53	46
13	Astur	38	39	52	46
14	Gijón	38	42	50	46
15	TSK Roces	38	37	43	45
16	Andés	38	44	60	43
17	L´Entregu	38	34	54	38
18	Lenense	38	38	72	30
19	Universidad	38	30	78	23
20	Cudillero	38	10	75	0

TEMPORADA 2013/2014

PRIMERA RFFPA
Equipo		PJ	GF	GC	Puntos
1	TSK Roces	38	75	32	77
2	Llanes	38	86	41	76
3	Astur	38	71	38	76
4	Mosconia	38	78	38	70
5	CD Colunga	38	68	44	66
6	Rayo	38	67	50	61
7	Navarro	38	47	35	61
8	Valdesoto	38	59	46	55
9	Atlético	38	56	53	52
10	Llano 2000	38	46	44	52
11	Tineo	38	38	47	51
12	UD Llanera	38	58	56	50
13	Muros	38	56	54	50
14	U.Comercial	38	50	52	49
15	CD Turón	38	68	69	47
16	Boal CF	38	51	59	46
17	Campomanes	38	54	65	45
18	Nalón CF	38	34	54	39
19	Pumarín CF	38	53	65	31
20	Navia CF	38	21	194	3

TEMPORADA 2012/2013

PRIMERA RFFPA
Equipo		PJ	GF	GC	Puntos
1	Real Avilés	37	69	32	73
2	Lenense	37	69	53	71
3	Andés	37	69	43	70
4	Astur	37	60	32	69
5	Muros	38	83	37	68
6	Pumarín Cf	38	57	36	65
7	Valdesoto	38	53	48	60
8	TSK Roces	38	53	37	59
9	Tineo	38	60	45	59
10	Llano 2000	38	64	41	57
11	Mosconia	38	48	44	55
12	Atlético	38	51	42	51
13	Campomanes	38	53	49	48
14	Unión	38	54	60	48
15	CD Colunga	38	48	64	46
16	CD Turón	38	60	74	45
17	Nalón CF	37	55	63	43
18	Sd Colloto	37	32	49	43
19	Narcea	38	31	106	11
20	La Caridad	38	27	141	11

TEMPORADA 2011/2012

PRIMERA RFFPA
Equipo		PJ	GF	GC	Puntos
1	CD Praviano	38	61	35	75
2	Atlético	38	58	25	71
3	L´Entregu	38	71	45	70
4	Urraca CF	38	83	58	69
5	Real Tapia	38	58	43	66
6	Club Siero	38	69	45	62
7	Lenense	38	51	55	56
8	Tineo	38	58	51	53
9	TSK Roces	38	54	46	52
10	Universidad	38	57	55	51
11	Valdesoto	38	51	46	50
12	U.Comercial	38	60	54	49
13	Real Avilés	38	57	58	48
14	La Caridad	38	43	52	48
15	Andés	38	44	61	48
16	Campomanes	38	54	66	42
17	Narcea	38	35	52	42
18	Ribadesella	38	52	71	41
19	Deportiva	38	37	75	30
20	San Martín	38	28	88	25

Competiciones que juega

Primera RFFPA

Pos	Equipos		Pts
1		Real Sporting C	69
2		EI San Martín	68
3		Astur	58
4		Mosconia	57
5		TSK Roces	53
6		Club Siero	49
7		Vallobin CD	49
8		Navarro	43
9		U.Comercial	41
10		Muros Balompié	41
11		Universidad Oviedo	39
12		Llaranes CF	37
13		Andés	37
14		Candás CF	35
15		Valdesoto	33
16		La Fresneda	32
17		Berrón	28
18		Club Asturias de Blimea	27
19		Atlético de Lugones	26
20		Colloto	18

	Ascenso : Real Sporting C, EI San Martín, Astur
	Descenso : Club Asturias de Blimea, Atlético de Lugones, Colloto

RIVALES EN Primera RFFPA

USO DE MEMORIA

6,815,592 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.6363
Total Execution Time	0.6376

CADENA URL

/historico/Club-Roces

GET DATOS

$_GET['/historico/Club-Roces']

POST DATOS

No hay datos POST existentes

CONSULTAS (32)

0.0154	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 = 'Club-Roces' 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.0144	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=6071 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=6071 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6071 AND type_rel = 2
0.0152	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6071 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0145	SELECT /35 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 (427710) ORDER BY n.cover_points DESC, update_date DESC
0.0147	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 = '6071' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147	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 = '6071' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147	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 = 73524 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147	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=6071 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146	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 (73524) 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.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 73524 AND teamId = 6071
0.0297	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 = 73524 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0148	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 = '6071' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6071' and rp.type = 4
0.0149	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 = '6071' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0162	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 = 73524 WHERE rp.league_id = 73524 AND rp.teamId = 6071 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.0197	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 = 73524 WHERE rp.league_id = 73524 AND rp.teamId = 6071 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0193	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 = 73524 WHERE rp.league_id = 73524 AND rp.teamId = 6071 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0163	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 = 6071 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0173	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 = 68760 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0201	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 = 62386 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 61954 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 51182 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154	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 = 44673 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 39026 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 34175 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 15443 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154	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 = 3912 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 2589 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 1978 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 1453 AND t.round = 38 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

TSK Roces

TSK Roces

Selecciona un equipo

Competiciones que juega

Primera RFFPA

RIVALES EN Primera RFFPA