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

Maravillas S.D.

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Deportivo	0	0	0	0
2	Cd Calasanz	0	0	0	0
3	CD Ciudad	0	0	0	0
4	Coruña	0	0	0	0
5	Eiris SD	0	0	0	0
6	Galicia	0	0	0	0
7	Imperator	0	0	0	0
8	Liceo	0	0	0	0
9	Maravillas	0	0	0	0
10	S.D. Santa.	0	0	0	0
11	Sada	0	0	0	0
12	Ciudad	0	0	0	0
13	Sin Querer	0	0	0	0
14	Sporting	0	0	0	0
15	Unión	0	0	0	0
16	Vioño CF	0	0	0	0

TEMPORADA 2022/2023

TERCERA GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sporting	30	114	22	73
2	Marte CD	30	87	29	73
3	Imperator	30	107	36	65
4	Liceo	30	96	42	63
5	Atletico	30	94	43	62
6	Maravillas	30	104	47	60
7	Coruña	30	66	39	58
8	Ciudad	30	85	57	43
9	Sin Querer	29	51	59	36
10	CD Ciudad	30	56	56	35
11	Eiris SD	30	59	62	35
12	S.D. Santa.	30	72	83	33
13	Vioño CF	29	34	96	19
14	Unión	30	44	99	17
15	Galicia	30	25	157	8
16	Deportivo	30	31	198	6

TEMPORADA 2021/2022

TERCERA GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sin Querer	24	59	31	55
2	Sada	24	62	41	49
3	CD Ciudad	24	64	27	47
4	Eiris SD	24	56	27	45
5	Maravillas	24	55	36	42
6	Liceo	24	52	29	41
7	S.D. Santa.	24	50	36	40
8	Ciudad	24	43	31	33
9	Coruña	24	51	54	32
10	Unión	24	50	69	26
11	Deportivo	24	48	68	22
12	Vioño CF	24	28	74	8
13	Galicia	24	24	119	4

TEMPORADA 2019/2020

TERCERA GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Marte CD	20	46	15	45
2	Atlético	19	58	31	42
3	Sin Querer	19	62	14	41
4	Cd Calasanz	20	44	29	38
5	Unión	20	47	36	36
6	Galicia	20	46	31	32
7	CD Ciudad	20	51	30	31
8	Ciudad	20	41	44	29
9	Maravillas	20	30	52	23
10	S.D. Santa.	20	24	56	21
11	Liceo	19	22	44	16
12	Vioño CF	20	29	52	15
13	Eiris SD	19	22	57	13
14	Deportivo	20	23	54	11

TEMPORADA 2018/2019

TERCERA GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Juvenil S.D.	28	89	23	74
2	Marte CD	28	79	30	66
3	Sin Querer	28	94	40	64
4	Ciudad	28	84	40	54
5	Galicia	28	79	35	54
6	Atlético	28	80	47	50
7	Cd Calasanz	28	71	60	42
8	Maravillas	28	58	71	40
9	Liceo	28	54	65	38
10	Unión	28	51	65	35
11	Deportivo	28	45	59	31
12	S.D. Santa.	28	54	79	26
13	Vioño CF	28	39	91	15
14	Eiris SD	28	40	85	14
15	Deportivo	28	26	153	3

TEMPORADA 2017/2018

TERCERA GALICIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	CD Obrero	25	92	29	62
2	CD Ciudad	26	89	28	59
3	Xuventude	26	84	28	59
4	Juvenil S.D.	26	67	34	51
5	Suevos CF	26	75	46	46
6	Orzán Sd	26	66	59	40
7	Aranga	26	68	64	37
8	Ozacesuras	26	72	61	36
9	Maravillas	26	49	50	36
10	Brexo Lema	26	69	73	30
11	Sobrado	25	36	85	19
12	Unión	26	40	106	17
13	Sigras CD	26	38	63	15
14	Vizoño B	26	27	146	9
15	Miguel	0	0	0	0
16	UD America	0	0	0	0

TEMPORADA 2016/2017

SEGUNDA GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Orillamar	34	105	29	81
2	Atletico	34	79	34	76
3	Sporting	34	67	27	70
4	Vizoño	34	80	54	60
5	Torre SD	34	59	54	52
6	Santa Cruz.	34	66	62	52
7	Carnoedo	34	56	54	50
8	Sporting	34	56	69	50
9	Ciudad	34	62	49	49
10	Visantoña	34	64	55	47
11	Imperator	34	52	50	44
12	Mesia CD	34	47	56	41
13	Sin Querer	34	48	64	41
14	Sporting	34	50	78	37
15	Martiño	34	38	51	35
16	Xuventude	34	50	83	33
17	Maravillas	34	41	83	26
18	Vioño CF	34	47	115	11

TEMPORADA 2015/2016

PRIMERA GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Betanzos CF	34	79	34	73
2	AD Miño	34	71	32	67
3	Eume	34	70	49	59
4	Olimpico CF	34	72	47	58
5	Boimorto CF	34	65	54	56
6	Marino CF	34	65	55	55
7	Victoria CF	34	61	54	54
8	Brexo Lema	34	65	55	53
9	Club Caion	34	37	39	47
10	Tirso	34	63	66	47
11	Ud Carral	34	63	65	46
12	SE Abella	34	52	47	45
13	Cedeira SD	34	51	49	44
14	Sporting	34	59	69	40
15	Maravillas	34	38	59	34
16	Orillamar	34	51	77	31
17	Rapido Neda	34	45	87	25
18	Imperator	34	37	106	14

TEMPORADA 2014/2015

SEGUNDA GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Maravillas	33	85	33	81
2	Sporting	33	86	25	80
3	Español	34	96	26	79
4	Cd Calasanz	34	88	46	67
5	Ciudad	34	75	44	57
6	Cristóbal	34	74	48	54
7	Torre SD	34	73	52	54
8	Universidade	34	58	44	50
9	Galicia	34	77	65	49
10	Orzán Sd	34	49	49	44
11	Cocteleira	33	77	68	43
12	Relámpago	33	46	60	42
13	Juvenil S.D.	34	49	53	41
14	Atlético	34	47	64	38
15	C.D.	34	61	95	36
16	Liceo	34	54	92	28
17	Unión	33	29	176	8
18	S.D. Santa.	33	35	119	7

TEMPORADA 1987/1988

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Galáctico	38	82	28	58
2	Colonia	38	79	42	54
3	Móstoles	38	58	26	53
4	Colmenar	38	67	50	49
5	Rayo	38	58	51	44
6	Fuenlabrada	38	65	50	43
7	Pelayo AD	38	57	48	43
8	Fernando	38	52	40	42
9	Carabanchel	38	56	48	41
10	Real Madrid	38	50	46	40
11	Paracuellos	38	45	55	35
12	Navalcarnero	38	58	67	34
13	Vicálvaro	38	42	55	34
14	Real	38	51	59	32
15	Valdemoro	38	49	54	32
16	CF Pozuelo	38	40	71	28
17	Maravillas	38	38	56	28
18	Coslada	38	42	72	28
19	Alcorcón	38	33	61	25
20	Rayo Velilla	38	32	75	17

TEMPORADA 1986/1987

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	AD Parla	38	82	27	59
2	Galáctico	38	79	37	57
3	Leganés	38	71	33	52
4	RSD Alcalá	38	53	33	50
5	Conquense	38	66	38	49
6	Getafe	38	63	45	44
7	UD Sanse	38	44	35	43
8	Real Madrid	38	59	46	41
9	Valdemoro	38	64	62	40
10	Villarrobled	38	40	44	37
11	Daimiel	38	42	40	37
12	Puertollano	38	45	49	35
13	CD Manchego	38	44	56	35
14	Valdepeñas	38	32	38	34
15	Talavera CF	38	33	52	32
16	Maravillas	38	36	66	28
17	Alcorcón	38	33	58	27
18	Fuenlabrada	38	37	55	25
19	La Roda CF	38	39	71	21
20	Guadalajara	38	31	108	14

Competiciones que juega

Grupo 1

Tercera Galicia Grupo 1

Pos	Equipos		Pts
1		C Deportivo Cristal	0
2		Cd Calasanz	0
3		CD Ciudad	0
4		Coruña Arboco Club de Fútb.	0
5		Eiris SD	0
6		Galicia Gaiteira	0
7		Imperator OAR	0
8		Liceo de Monelos	0
9		Maravillas S.D.	0
10		S.D. Santa Margarita	0
11		Sada Atlético Club Futbol	0
12		SCD Ciudad Jardín	0
13		Sin Querer	0
14		Sporting Coruñés	0
15		Unión Sportiva	0
16		Vioño CF	0

	Ascenso : C Deportivo Cristal, Cd Calasanz, CD Ciudad, Coruña Arboco Club de Fútbo

RIVALES EN Tercera Galicia

USO DE MEMORIA

6,098,896 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.2109
Total Execution Time	0.2123

CADENA URL

/historico/Maravillas

GET DATOS

$_GET['/historico/Maravillas']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0029	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 = 'Maravillas' 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.0028	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=19876 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=19876 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0079	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 = 73754
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19876 AND type_rel = 2
0.0020	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=715 AND type_rel = 3
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 715 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0045	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 (792499,697535,370510,219172,57995) ORDER BY n.cover_points DESC, update_date DESC
0.0027	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 = '19876' ORDER BY l.year DESC,cat.coefficient DESC
0.0046	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 = '19876' 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 = '19876' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024	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 = 73754 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025	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=19876 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 (73754) 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.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 73754 AND teamId = 19876
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 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 = 73754 AND t.round = 27 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 = '19876' 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 = '19876' 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 = '19876' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021	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 = 73754 WHERE rp.league_id = 73754 AND rp.teamId = 19876 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 events2024 e ON e.player_id = p.id AND e.league_id = 73754 WHERE rp.league_id = 73754 AND rp.teamId = 19876 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021	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 = 73754 WHERE rp.league_id = 73754 AND rp.teamId = 19876 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 19876 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73754 AND t.round = 27 ORDER BY team.conference ASC,t.position 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* `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 = 69299 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 = 65415 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0077	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 = 51549 AND t.round = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0082	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 = 45269 AND t.round = 30 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* `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 = 39852 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037	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 = 34932 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 = 16765 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* `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 = 4343 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0073	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 = 21782 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0055	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* `tables1987` 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 = 21763 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 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 = 73754 ORDER BY nameShow LIMIT 100

Maravillas S.D.

Maravillas S.D.

Selecciona un equipo

Competiciones que juega

Tercera Galicia Grupo 1

RIVALES EN Tercera Galicia