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

EMD Santillana

Temporada 2023/2024

TEMPORADA 2023/2024

PREFERENTE CANTABRIA
Equipo		PJ	GF	GC	Puntos
1	SD Gama	7	6	1	17
2	Barreda	7	18	7	16
3	Textil	7	10	4	13
4	CD Monte	6	9	6	13
5	Peña	7	7	4	11
6	Martín	7	5	6	11
7	Cayón B	7	10	10	10
8	Barquereño	7	11	7	9
9	Santillana	7	11	9	9
10	Solares	7	8	7	9
11	Ribamontán	7	6	4	8
12	FC Miengo	6	9	11	8
13	CD Naval B	7	7	10	6
14	Rayo Santa.	7	8	12	6
15	Noja	7	7	11	6
16	Arenas	7	3	8	6
17	Selaya	7	6	11	4
18	Estrella	7	5	18	3

TEMPORADA 2022/2023

PREFERENTE CANTABRIA
Equipo		PJ	GF	GC	Puntos
1	Atlético	34	77	31	78
2	Velarde CF	34	64	29	72
3	CD Bezana	34	80	48	68
4	Colindres	34	70	38	64
5	Barreda	34	65	45	62
6	Barquereño	34	64	39	59
7	Selaya	34	49	32	58
8	Ribamontán	34	51	47	48
9	CD Monte	34	55	49	47
10	Rayo Santa.	34	50	50	45
11	Noja	34	50	51	44
12	Arenas	34	38	58	35
13	Martín	34	38	72	34
14	Santillana	34	39	50	32
15	Estrella	34	38	69	32
16	Vimenor B	34	31	53	29
17	CD Ramales	34	35	76	29
18	Nueva	34	26	83	20

TEMPORADA 2021/2022

1ª REGIONAL CANTABRIA
Equipo		PJ	GF	GC	Puntos
1	Santillana	33	67	38	69
2	Rayo Santa.	34	77	30	66
3	Estrella	33	76	47	62
4	Vimenor B	33	52	34	62
5	Marina	33	57	47	51
6	Peña	33	52	51	48
7	Atlético	33	52	40	47
8	Valle	33	48	58	45
9	Escobedo B	33	50	53	44
10	Atco.	33	57	56	43
11	Cayón B	33	60	65	43
12	Minerva Fc	33	42	61	43
13	Solares	33	49	58	42
14	Montañas	33	49	58	41
15	Atco. Deva	32	53	49	36
16	EMF Meruelo	33	49	61	36
17	Villaescusa	34	34	57	30
18	Textil	20	18	79	5

TEMPORADA 2020/2021

PREFERENTE CANTABRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Naval	16	51	7	43
2	Atlético	16	35	15	34
3	Velarde CF	16	30	16	27
4	Arenas	16	21	20	26
5	FC Miengo	16	21	21	21
6	CD Los Rios	16	24	27	21
7	Santillana	16	26	29	19
8	EMF Meruelo	16	11	36	5
9	Atco. Deva	16	5	53	4

TEMPORADA 2019/2020

PREFERENTE CANTABRIA
Equipo		PJ	GF	GC	Puntos
1	Revilla	25	51	17	53
2	Castro	25	48	21	51
3	Rinconeda	25	46	21	51
4	FC Miengo	24	39	26	46
5	Nueva	25	55	39	40
6	Atlético	24	38	29	39
7	Noja	25	32	30	36
8	Colindres	25	31	25	35
9	Velarde CF	25	39	35	35
10	CD Naval	25	34	39	33
11	SD Gama	25	28	31	30
12	Villaescusa	25	27	38	29
13	Valle	25	33	50	28
14	EMF Meruelo	25	31	45	27
15	Santillana	25	30	34	24
16	Atco. Deva	25	28	45	22
17	CD Ramales	25	19	58	17
18	CD Los Rios	25	23	49	15

TEMPORADA 2018/2019

PREFERENTE CANTABRIA
Equipo		PJ	GF	GC	Puntos
1	Barquereño	34	47	21	67
2	UC Cartes	34	46	25	65
3	Selaya	34	54	32	64
4	Colindres	34	76	42	64
5	Castro	34	63	34	62
6	Atlético	34	61	41	56
7	SD Gama	34	62	48	55
8	Santillana	34	41	52	47
9	Nueva	34	49	65	41
10	CD Ramales	34	58	64	41
11	CD Los Rios	34	46	55	40
12	Valle	34	44	58	39
13	EMF Meruelo	34	41	59	38
14	Noja	34	39	48	37
15	Ayrón Club	34	46	69	37
16	Peña	34	45	56	36
17	CD Monte	34	42	60	36
18	Cayón B	34	38	69	26

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

PREFERENTE CANTABRIA
Equipo		PJ	GF	GC	Puntos
1	Barreda	36	76	21	85
2	EMF Meruelo	36	66	31	76
3	Velarde CF	36	68	40	68
4	SD Solares	36	43	30	63
5	Santillana	36	66	38	61
6	Nueva	36	58	39	57
7	Atlético	36	59	43	52
8	Noja	36	52	62	50
9	Rinconeda	36	58	49	47
10	Internaciona	35	49	52	44
11	CD Pontejos	36	49	59	44
12	Arenas	36	47	64	44
13	Cayón B	36	50	71	43
14	Santoña CF	36	48	58	43
15	Minerva Fc	36	59	67	42
16	CD Los Rios	35	43	47	42
17	Barquereño	36	41	67	35
18	Ribamontán	36	35	65	29
19	Buelna	36	25	89	15

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

TERCERA DIVISIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Tropezón	38	87	32	83
2	Deportivo	38	76	27	83
3	Cayón	38	49	21	73
4	CD Laredo	38	54	30	68
5	Castro	38	52	33	68
6	CF Vimenor	38	52	42	61
7	Santoña CF	38	53	51	58
8	Barreda	38	49	44	58
9	Siete Villas	38	48	49	53
10	CD Guarnizo	38	45	41	52
11	UM Escobedo	38	67	54	51
12	CD Pontejos	38	43	52	48
13	SD Gama	38	32	40	48
14	Atlético	38	49	49	48
15	CD Bezana	38	42	47	47
16	Ribamontán	38	42	51	45
17	Santillana	38	43	65	36
18	Textil	38	35	69	30
19	EMF Meruelo	38	32	84	22
20	Martín	38	14	83	12

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 2010/2011

PREFERENTE CANTABRIA
Equipo		PJ	GF	GC	Puntos
1	Barreda	34	54	22	70
2	Martín	34	68	39	67
3	Barquereño	34	52	30	62
4	Santillana	34	60	41	61
5	SD Gama	34	47	29	61
6	Textil	34	50	33	57
7	Ayrón Club	34	43	31	55
8	Navalmoral	34	46	40	52
9	EMF Meruelo	34	46	47	48
10	CD Comillas	34	52	50	45
11	Atco. Deva	34	49	56	45
12	Selaya	34	45	42	42
13	Revilla	34	38	47	38
14	Velarde CF	34	40	61	37
15	Colindres	34	48	62	36
16	Union club	34	29	61	28
17	Sd Noja B	34	32	65	23
18	UC Cartes	34	35	78	18

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

Competiciones que juega

Preferente Cantabria

Pos	Equipos		Pts
1		SD Gama	17
2		SD Barreda Balompié	16
3		SD Textil Escudo	13
4		CD Monte	13
5		Peña Revilla SD	11
6		SD San Martín Arena	11
7		Cayón B	10
8		Barquereño	9
9		EMD Santillana	9
10		SD Solares B	9
11		Ribamontán al Mar	8
12		FC Miengo	8
13		CD Naval B	6
14		Rayo Santa Cruz	6
15		Noja	6
16		Arenas de Frajanas	6
17		Selaya	4
18		Estrella Roja	3

	Ascenso : SD Gama, SD Barreda Balompié, SD Textil Escudo, CD Monte
	Descenso : Arenas de Frajanas, Selaya, Estrella Roja

RIVALES EN Preferente Canta.

USO DE MEMORIA

7,103,184 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.1317
Total Execution Time	0.1337

CADENA URL

/historico/Santillana

GET DATOS

$_GET['/historico/Santillana']

POST DATOS

No hay datos POST existentes

CONSULTAS (30)

0.0024	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2266 AND type_rel = 2
0.0031	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2266 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024	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.0039	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 = '2266' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0044	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=2266 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0024	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 (73447,71432) 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.0032	SELECT count(id) as num_players from rel_players WHERE league_id = 73447 AND teamId = 2266
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2266
0.0024	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 = '2266' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2266' and rp.type = 4
0.0023	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 = '2266' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0053	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 = 73447 WHERE rp.league_id = 73447 AND rp.teamId = 2266 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.0034	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 = 73447 WHERE rp.league_id = 73447 AND rp.teamId = 2266 AND (e.action = 4 or e.action = 5) 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 = 73447 WHERE rp.league_id = 73447 AND rp.teamId = 2266 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 = 2266 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0042	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 = 68550 AND t.round = 34 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* `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 = 63669 AND t.round = 34 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 = 58850 AND t.round = 18 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* `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 = 51274 AND t.round = 25 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* `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 = 44658 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* `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.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* `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.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* `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 = 16698 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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.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* `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.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* `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 = 1944 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* `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.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* `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 = 1148 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* `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.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* `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

EMD Santillana

EMD Santillana

Selecciona un equipo

Competiciones que juega

Preferente Cantabria

RIVALES EN Preferente Canta.