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

Sámano

Entrenador: Obu

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA FEDERACIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	UM Escobedo	32	55	28	64
2	CD Laredo	32	47	18	61
3	SD Torina	32	45	37	58
4	Atlético	32	52	37	54
5	Tropezón	32	46	36	52
6	CF Vimenor	32	38	32	51
7	CD Bezana	32	45	41	50
8	Castro	32	37	39	48
9	CD Guarnizo	32	32	27	45
10	Siete Villas	32	49	43	42
11	Colindres	32	35	39	42
12	Revilla	32	38	48	41
13	CD Naval	32	36	34	41
14	Sámano	32	39	41	40
15	Atlético	32	33	61	31
16	UC Cartes	32	29	46	30
17	SD Solares	32	28	48	30
18	Velarde CF	32	29	58	19

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Cayón	30	59	26	59
2	CF Vimenor	30	52	36	57
3	Tropezón	30	46	23	52
4	UM Escobedo	30	50	34	52
5	Atlético	30	53	34	52
6	SD Torina	30	34	20	49
7	CD Naval	30	26	27	43
8	Siete Villas	30	34	37	41
9	Sámano	30	39	43	40
10	Revilla	30	37	44	33
11	CD Guarnizo	30	27	35	31
12	UC Cartes	30	26	46	31
13	Castro	30	33	43	30
14	SD Solares	30	34	49	28
15	SD Gama	30	30	58	26
16	Textil	30	26	51	24

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Gimnástica	30	69	17	65
2	CF Vimenor	30	49	27	57
3	UM Escobedo	30	53	27	54
4	CD Naval	30	41	26	48
5	SD Torina	30	34	25	46
6	Sámano	30	35	33	46
7	Atlético	30	38	35	44
8	CD Guarnizo	30	36	30	42
9	Siete Villas	30	41	41	41
10	UC Cartes	30	31	37	37
11	Castro	30	34	43	37
12	Textil	30	24	38	32
13	Noja	30	32	57	27
14	Barreda	30	26	47	25
15	Colindres	30	26	58	21
16	Selaya	30	20	48	19

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Tropezón	20	40	19	43
2	Gimnástica	20	42	20	37
3	UM Escobedo	20	27	17	37
4	CF Vimenor	20	29	20	32
5	UC Cartes	20	23	22	29
6	Selaya	20	24	32	29
7	Castro	20	20	23	27
8	SD Torina	20	21	31	20
9	CD Guarnizo	20	18	30	19
10	Barreda	20	18	33	19
11	SD Solares	20	9	24	10
12	Cayón	20	47	14	51
13	Rayo	20	45	16	46
14	Siete Villas	20	30	15	42
15	Sámano	20	33	20	37
16	Textil	20	27	17	33
17	Atlético	20	27	30	20
18	Rinconeda	20	19	37	19
19	Revilla	20	21	36	17
20	CD Bezana	20	14	40	16
21	Barquereño	20	17	33	15
22	Ribamontán	20	12	34	12

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	CD Laredo	28	60	24	65
2	Gimnástica	28	58	23	60
3	Rayo	28	54	24	57
4	Tropezón	28	55	32	54
5	Cayón	28	54	23	51
6	UM Escobedo	28	48	32	49
7	CD Bezana	28	43	27	47
8	Barreda	28	35	41	44
9	Barquereño	28	35	37	36
10	CD Guarnizo	28	40	45	35
11	Siete Villas	28	32	31	34
12	SD Torina	28	36	42	34
13	Sámano	28	32	49	33
14	Selaya	28	21	41	32
15	Textil	28	31	49	27
16	SD Solares	28	23	41	26
17	Ribamontán	28	27	56	25
18	CF Vimenor	28	30	51	25
19	Atlético	28	33	50	25
20	UC Cartes	28	23	52	21

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	UM Escobedo	38	80	29	86
2	CD Laredo	38	71	26	80
3	Tropezón	38	73	34	76
4	Cayón	38	66	26	74
5	Rayo	38	62	24	68
6	CD Bezana	38	60	50	65
7	Sámano	38	54	46	58
8	CF Vimenor	38	51	56	54
9	SD Torina	38	55	60	53
10	Textil	38	49	43	51
11	Ribamontán	38	36	38	50
12	Barreda	38	48	59	47
13	Siete Villas	38	41	51	43
14	Atlético	38	43	47	42
15	SD Solares	38	33	44	42
16	CD Guarnizo	38	41	54	40
17	Revilla	38	48	83	38
18	Velarde CF	38	35	67	36
19	CD Naval	38	36	95	23
20	Rinconeda	38	37	87	19

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Gimnástica	38	83	21	91
2	UM Escobedo	38	80	30	86
3	CD Laredo	38	63	29	82
4	Tropezón	38	71	26	81
5	Rayo	38	75	39	77
6	Cayón	38	62	35	68
7	Sámano	38	58	62	58
8	Textil	38	51	53	52
9	Barreda	38	49	57	49
10	Atlético	38	47	63	45
11	Deportivo	38	52	59	44
12	Siete Villas	38	46	56	41
13	CD Guarnizo	38	48	60	41
14	Velarde CF	38	29	47	40
15	CF Vimenor	38	37	51	39
16	CD Bezana	38	38	61	38
17	SD Solares	38	37	62	37
18	Selaya	38	30	52	36
19	Santillana	38	30	73	24
20	Castro	38	27	77	22

TEMPORADA 2016/2017

PREFERENTE CANTABRIA
Equipo		PJ	GF	GC	Puntos
1	Santillana	34	73	22	82
2	Sámano	34	71	33	77
3	SD Solares	34	57	30	67
4	Valle	34	68	52	58
5	CD Naval	34	54	42	58
6	Vimenor B	34	52	44	52
7	SD Torina	34	58	63	49
8	Nueva	34	54	56	48
9	Rinconeda	34	80	69	46
10	CD Los Rios	34	66	65	43
11	Santoña CF	34	49	56	40
12	SD Gama	34	41	56	37
13	Internaciona	34	42	77	35
14	Cayón B	34	54	65	34
15	CD Monte	34	44	68	34
16	Arenas	34	47	69	33
17	Noja	34	35	60	31
18	Atlético	34	47	65	30

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	CD Laredo	38	74	29	88
2	Gimnástica	38	86	28	87
3	Rayo	38	90	35	86
4	Cayón	38	65	26	79
5	Deportivo	38	60	49	61
6	Castro	38	46	34	57
7	CF Vimenor	38	54	46	55
8	UM Escobedo	38	56	52	50
9	Tropezón	38	51	44	50
10	Textil	38	62	58	46
11	CD Guarnizo	38	44	55	43
12	Colindres	38	45	68	43
13	Siete Villas	38	44	57	42
14	Revilla	38	34	47	41
15	CD Bezana	38	36	59	40
16	Atlético	38	38	60	39
17	Selaya	38	41	60	39
18	CD Naval	38	29	60	36
19	SD Gama	38	34	82	34
20	Sámano	38	32	72	30

TEMPORADA 2014/2015

PREFERENTE CANTABRIA
Equipo		PJ	GF	GC	Puntos
1	CD Guarnizo	34	63	23	85
2	Sámano	34	69	39	68
3	CD Naval	34	49	28	60
4	Santillana	34	55	39	59
5	Velarde CF	34	61	45	58
6	Barquereño	33	64	40	56
7	EMF Meruelo	34	50	29	56
8	Reocin	32	63	47	50
9	Ribamontán	34	47	53	49
10	Noja	34	40	50	40
11	Rinconeda	33	45	57	38
12	Nueva	34	38	61	35
13	SD Solares	34	27	36	34
14	CD Los Rios	34	52	67	34
15	CD Pontejos	34	29	52	34
16	Minerva Fc	34	35	67	32
17	SD Torina	34	41	65	28
18	Martín	34	36	66	27

TEMPORADA 2013/2014

PREFERENTE CANTABRIA
Equipo		PJ	GF	GC	Puntos
1	Revilla	34	61	33	69
2	Arenas	34	62	38	65
3	Textil	34	60	26	62
4	Velarde CF	34	62	43	62
5	Barquereño	34	55	43	59
6	Sámano	34	60	42	56
7	Nueva	34	59	43	54
8	EMF Meruelo	34	47	38	52
9	Santillana	34	48	41	51
10	SD Torina	34	52	49	50
11	Martín	34	51	57	47
12	Gimnástica	34	46	44	47
13	Rinconeda	34	41	48	38
14	SD Solares	34	45	52	36
15	Minerva Fc	34	43	69	33
16	Cayón B	34	44	71	33
17	UC Cartes	34	34	84	20
18	Valdáliga	34	29	78	13

TEMPORADA 2012/2013

PREFERENTE CANTABRIA
Equipo		PJ	GF	GC	Puntos
1	Colindres	34	64	32	76
2	Selaya	34	59	24	72
3	Buelna	34	70	44	68
4	Sámano	34	72	54	62
5	Gimnástica	34	56	45	56
6	Revilla	34	57	45	53
7	SD Torina	34	54	50	53
8	Nueva	34	45	53	47
9	Velarde CF	34	63	60	46
10	Barquereño	34	40	46	45
11	Arenas	34	63	63	43
12	Cayón B	34	49	52	42
13	Rinconeda	34	43	51	41
14	Minerva Fc	34	49	70	38
15	Ayrón Club	34	29	53	35
16	CD Comillas	34	46	66	32
17	Sd Reocín	34	41	62	32
18	Montañas	34	30	60	18

TEMPORADA 2011/2012

PREFERENTE CANTABRIA
Equipo		PJ	GF	GC	Puntos
1	SD Gama	34	57	31	67
2	Santoña CF	34	56	31	66
3	Santillana	33	57	37	61
4	Textil	33	47	27	58
5	EMF Meruelo	34	45	39	56
6	Sámano	33	60	46	54
7	Gimnástica	34	59	37	52
8	Selaya	34	50	39	48
9	SD Torina	34	49	53	47
10	Colindres	34	35	36	44
11	Revilla	34	40	50	44
12	Velarde CF	34	53	69	38
13	Reocin	34	48	58	37
14	Solares	33	40	66	36
15	CD Comillas	33	46	56	35
16	Ayrón Club	33	39	51	33
17	Atco. Deva	32	38	74	33
18	CD Naval	34	38	57	25

TEMPORADA 2009/2010

PREFERENTE CANTABRIA
Equipo		PJ	GF	GC	Puntos
1	CD Guarnizo	34	55	31	64
2	Santoña CF	34	55	34	64
3	Arenas	34	53	36	63
4	Colindres	34	55	36	62
5	Ayrón	34	46	29	61
6	Barquereño	34	47	34	58
7	Martín	34	50	34	56
8	CD Comillas	34	54	51	56
9	EMF Meruelo	34	45	48	45
10	SD Gama	34	47	56	45
11	Revilla	34	39	44	44
12	Santillana	34	37	44	44
13	Union club	34	30	35	43
14	Velarde CF	34	37	48	42
15	Sámano	34	42	43	40
16	Gimnástica	34	36	51	29
17	Calasanz	34	39	70	25
18	Rinconeda	34	31	74	21

TEMPORADA 2008/2009

PREFERENTE CANTABRIA
Equipo		PJ	GF	GC	Puntos
1	Textil	34	68	28	73
2	Buelna	34	61	35	63
3	Selaya	34	57	35	63
4	CD Pontejos	34	61	41	62
5	Gimnástica	34	70	37	59
6	SD Gama	34	65	42	59
7	Revilla	34	46	43	50
8	Colindres	34	45	45	49
9	Santillana	34	51	56	48
10	Ayrón	34	46	48	47
11	Union club	34	36	49	46
12	EMF Meruelo	34	39	40	45
13	Sámano	34	49	51	43
14	CD Comillas	34	37	51	41
15	Rinconeda	34	37	50	37
16	Villaescusa	34	29	57	33
17	Reocín B	34	27	66	23
18	Atlético	34	23	73	12

TEMPORADA 1988/1989

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	CD Laredo	42	102	27	72
2	Castro	42	89	17	72
3	Deportivo	42	118	21	70
4	Gimnástica	42	80	29	62
5	CF Vimenor	42	60	39	54
6	Unión Club	42	67	45	49
7	CD Guarnizo	42	67	72	43
8	Reocin	42	44	42	43
9	CD Naval	42	63	50	43
10	CD Ramales	42	64	60	42
11	Cayón	42	57	53	42
12	Ayrón Club	42	45	58	41
13	Marina	42	60	67	40
14	Barreda	42	50	58	39
15	CD Pontejos	42	49	67	34
16	SD Gama	42	54	72	34
17	Noja	42	44	68	33
18	Velarde CF	42	39	72	27
19	Ribamontán	41	44	80	24
20	Atlético	42	38	106	23
21	Sámano	41	24	65	19
22	Lope Vega	42	43	133	16

TEMPORADA 1987/1988

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Unión Club	38	81	24	63
2	Santoña CF	38	68	29	54
3	Castro	38	61	31	54
4	CF Vimenor	38	51	34	48
5	Barreda	38	60	41	43
6	Reocin	38	50	38	40
7	CD Naval	38	68	53	40
8	CD Guarnizo	38	55	41	40
9	Marina	38	65	60	40
10	Cayón	38	62	48	40
11	CD Ramales	38	44	49	38
12	Lope Vega	38	44	45	35
13	Noja	38	49	43	35
14	Atlético	38	42	59	34
15	Ayrón Club	38	46	49	33
16	Sámano	38	40	54	33
17	Ribamontán	38	38	53	32
18	Textil	38	45	73	26
19	Barquereño	38	27	93	19
20	Martín	38	17	96	13

Competiciones que juega

Tercera Federación Grupo 3

Pos	Equipos		Pts
1		UM Escobedo	64
2		CD Laredo	61
3		SD Torina	58
4		Atlético Albericia	54
5		Tropezón	52
6		CF Vimenor	51
7		CD Bezana	50
8		Castro	48
9		CD Guarnizo	45
10		Siete Villas	42
11		CD Colindres	42
12		Revilla	41
13		CD Naval	41
14		Sámano	40
15		Atlético Mineros	31
16		UC Cartes	30
17		SD Solares	30
18		Velarde CF	19

	Ascenso : UM Escobedo
	Playoff Ascenso : CD Laredo, SD Torina, Atlético Albericia, Tropezón
	Descenso : UC Cartes, SD Solares, Velarde CF

RIVALES EN Tercera Federaci.

USO DE MEMORIA

7,449,792 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.1323
Total Execution Time	0.1337

CADENA URL

/historico/Samano

GET DATOS

$_GET['/historico/Samano']

POST DATOS

No hay datos POST existentes

CONSULTAS (37)

0.0028	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 = 'Samano' 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=2214 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=2214 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2214 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2214 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	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 (377189,377217,822157,886617,1220822) ORDER BY n.cover_points DESC, update_date DESC
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 = '2214' 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 = '2214' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022	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 = '2214' 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 = 72262 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=2214 AND l.year in (2023,2024,2025) 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 (72262,68195) 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 = 72262 AND teamId = 2214
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 68195 AND teamId = 2214
0.0039	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 = 72262 AND t.round = 33 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 = '2214' 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 = '2214' 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 = '2214' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0033	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 = 72262 WHERE rp.league_id = 72262 AND rp.teamId = 2214 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.0029	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 = 72262 WHERE rp.league_id = 72262 AND rp.teamId = 2214 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 = 72262 WHERE rp.league_id = 72262 AND rp.teamId = 2214 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 = 2214 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 67977 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.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* `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 = 62387 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.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* `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 = 50271 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.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* `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 = 44391 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 39027 AND t.round = 38 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* `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 = 33972 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* `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 = 15444 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 4097 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 2590 AND t.round = 34 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* `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 = 1979 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* `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 = 1454 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* `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 = 848 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* `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 = 288 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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* `tables1989` 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 = 21797 AND t.round = 42 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* `tables1988` 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 = 21778 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Sámano

Sámano

Selecciona un equipo

Competiciones que juega

Tercera Federación Grupo 3

RIVALES EN Tercera Federaci.