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

CD Móstoles

Entrenador: Víctor González

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA FEDERACIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Real Madrid	32	58	16	73
2	Móstoles	32	55	29	62
3	Leganés B	32	44	32	54
4	Las Rozas	32	46	36	46
5	RSD Alcalá	32	50	44	45
6	Tres Cantos	32	41	44	45
7	Colonia	32	44	46	44
8	Torrejón	32	38	35	41
9	Alcorcón B	32	32	31	41
10	Galapagar	32	42	48	41
11	Paracuellos	32	39	46	39
12	Trival	32	32	39	38
13	AD Parla	32	37	45	38
14	CD Canillas	32	32	44	37
15	Villalba	32	39	44	35
16	Villanueva	32	26	35	35
17	Rayo	32	38	55	33
18	CF Pozuelo	32	25	49	27

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	CD Ursaria	30	62	22	68
2	Real Madrid	30	73	27	67
3	Getafe B	30	49	24	54
4	Paracuellos	30	48	40	48
5	Móstoles	30	38	32	47
6	RSD Alcalá	30	31	28	46
7	Las Rozas	30	37	38	45
8	Trival	30	38	44	37
9	CF Pozuelo	30	37	47	37
10	Torrejón	30	31	42	35
11	Galapagar	30	38	44	35
12	Villalba	30	30	45	34
13	CD Canillas	30	34	46	34
14	Rayo	30	42	45	33
15	Madrid 2021	30	31	52	32
16	Real	30	21	64	16

TEMPORADA 2021/2022

SEGUNDA FEDERACIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Pontevedra	34	66	35	65
2	Unión	34	54	39	61
3	Navalcarnero	34	41	32	57
4	Coruxo	34	46	32	52
5	Palencia	34	51	41	52
6	Bergantiños	34	36	37	49
7	Leganés B	34	44	34	48
8	Compostela	34	47	38	47
9	Real Avilés	34	43	37	47
10	Arenteiro	34	35	35	45
11	Langreo	34	40	41	44
12	Marino	34	38	38	43
13	Gimnástica	34	37	42	42
14	Móstoles	34	37	44	41
15	Salamanca	34	26	29	41
16	UD Llanera	34	39	55	40
17	Arosa	34	32	48	39
18	UC Ceares	34	23	78	18

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Unión	22	41	17	44
2	Moratalaz	22	36	20	40
3	Rayo	22	35	27	38
4	CF Pozuelo	22	33	20	38
5	Madrid 2021	22	19	18	33
6	Torrejón	22	32	17	32
7	Complutense	22	22	22	30
8	RSD Alcalá	22	20	16	28
9	Paracuellos	22	18	27	26
10	Villanueva	22	14	28	19
11	Fernando	22	18	36	18
12	Santa	22	11	51	10
13	Leganés B	20	34	12	50
14	Móstoles	20	28	11	44
15	Alcorcón B	20	32	15	34
16	AD Parla	20	20	20	28
17	Carabanchel	20	18	20	24
18	Atlético	20	20	30	24
19	Trival	20	15	21	23
20	Villaverde	20	18	29	21
21	El Álamo	20	24	33	16
22	Móstoles	20	15	26	15
23	Real	20	19	32	15

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Navalcarnero	28	44	22	53
2	Unión	28	43	35	47
3	Alcorcón B	28	40	26	47
4	RSD Alcalá	28	41	32	45
5	Trival	28	30	27	43
6	Leganés B	28	49	41	42
7	Móstoles	28	42	36	42
8	CF Pozuelo	28	36	38	40
9	Rayo	28	47	44	39
10	Madrid 2021	28	36	34	39
11	Santa	28	42	46	38
12	Carabanchel	28	32	32	36
13	Atlético	28	40	38	35
14	Torrejón	28	27	32	35
15	El Álamo	28	36	42	34
16	Moratalaz	28	29	37	34
17	Fernando	28	38	42	33
18	Paracuellos	28	35	38	33
19	AD Parla	28	30	50	22
20	Villaverde	28	16	41	19

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Getafe B	38	58	24	83
2	Las Rozas	38	69	34	79
3	Paracuellos	38	49	29	72
4	Móstoles	38	41	25	71
5	Villaverde	38	40	31	63
6	Trival	38	41	32	59
7	Rayo	38	58	47	59
8	Fernando	38	44	37	58
9	Leganés B	38	51	39	55
10	Atlético	38	41	51	51
11	Santa	38	51	48	47
12	Alcorcón B	38	26	35	44
13	RSD Alcalá	38	25	31	44
14	Carabanchel	38	29	37	44
15	AD Parla	38	39	49	43
16	CF Pozuelo	38	38	52	40
17	CD Canillas	38	34	52	39
18	Vicálvaro	38	37	58	34
19	Agustín	38	37	61	29
20	Tres Cantos	38	19	55	27

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Internaciona	38	62	21	79
2	Getafe B	38	67	31	78
3	Rayo	38	63	31	74
4	RSD Alcalá	38	63	32	72
5	CF Pozuelo	38	46	37	65
6	Fernando	38	58	41	63
7	Paracuellos	38	59	38	63
8	Móstoles	38	56	41	61
9	Alcorcón B	38	65	43	57
10	Trival	38	46	41	52
11	Villaverde	38	34	32	49
12	Leganés B	38	61	67	49
13	Atlético	38	34	43	47
14	Agustín	38	43	54	45
15	Santa	38	40	52	43
16	Tres Cantos	38	37	65	43
17	Yébenes-San	38	26	63	33
18	El Álamo	38	31	55	32
19	Colmenar	38	45	72	30
20	Parla	38	16	93	4

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Atlético B	38	63	40	73
2	Unión	38	55	41	66
3	Paracuellos	38	49	28	63
4	Móstoles	38	62	41	62
5	Leganés B	38	57	45	62
6	Getafe B	38	54	35	60
7	Atlético	38	36	30	58
8	RSD Alcalá	38	36	28	57
9	Internaciona	38	52	40	56
10	Santa	38	43	54	53
11	Villaverde	38	41	52	49
12	Fernando	38	44	43	49
13	Alcorcón B	38	40	46	48
14	CF Pozuelo	38	40	35	48
15	Rayo	38	57	49	47
16	Trival	38	44	48	46
17	Alcobendas	38	29	37	44
18	Aravaca	38	36	64	38
19	Villanueva	38	21	57	31
20	AD Parla	38	21	67	19

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	UD Sanse	38	68	26	81
2	Navalcarnero	38	76	42	72
3	CF Pozuelo	38	52	34	69
4	Atlético B	38	48	29	64
5	Fernando	38	58	45	60
6	Unión	38	55	38	59
7	Atlético	38	42	36	57
8	RSD Alcalá	38	53	49	57
9	Trival	38	44	35	57
10	Alcorcón B	38	57	53	55
11	Móstoles	38	48	40	52
12	Paracuellos	38	47	40	50
13	Aravaca	38	43	48	47
14	AD Parla	38	41	50	47
15	Rayo	38	44	42	46
16	Internaciona	38	33	43	43
17	Colonia	38	36	55	34
18	Puerta	38	40	56	33
19	Lugo	38	31	57	32
20	Villalba	38	19	117	2

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Rayo	38	67	38	71
2	Paracuellos	38	59	39	64
3	Navalcarnero	38	43	37	64
4	Alcorcón B	38	57	41	63
5	Unión	38	40	31	63
6	UD Sanse	38	47	32	62
7	Internaciona	38	48	42	60
8	RSD Alcalá	38	41	29	56
9	Real Madrid	38	50	40	55
10	CF Pozuelo	38	46	45	54
11	AD Parla	38	47	39	53
12	Atlético	38	44	42	52
13	Atlético	38	53	66	49
14	Puerta	38	42	44	47
15	Móstoles	38	44	46	46
16	Fernando	38	35	42	44
17	Villanueva	38	37	51	43
18	Alcobendas	38	35	49	36
19	Colmenar	38	35	65	35
20	Torrejón	38	22	74	20

TEMPORADA 2013/2014

PREFERENTE MADRID GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Móstoles	34	62	21	76
2	Navalcarnero	34	56	35	65
3	Villaverde	34	60	36	57
4	Montijo-San	34	51	36	56
5	Colonia	34	50	42	54
6	Villaviciosa	34	43	34	52
7	Lugo	34	44	30	52
8	CD Griñón	34	41	34	51
9	CD Fortuna	34	55	58	46
10	Leganés B	34	48	40	42
11	Arganda	34	42	45	40
12	Alhóndiga	34	39	54	40
13	Atlético	34	52	65	39
14	Nuevo	34	40	52	39
15	Colmenar	34	41	52	36
16	Arroyomolino	34	40	65	33
17	Santa	34	40	75	32
18	Adpi Rivas	34	46	76	25

TEMPORADA 2012/2013

PREFERENTE MADRID GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Yébenes-San	34	60	33	66
2	Vicálvaro	34	49	32	66
3	Móstoles	34	61	45	57
4	Villaverde	34	53	42	57
5	Adpi Rivas	34	69	47	55
6	Navalcarnero	34	60	36	53
7	Colmenar	34	48	41	49
8	Atlético	34	59	40	47
9	CD Fortuna	34	55	63	47
10	Santa	34	44	55	47
11	Leganés B	34	57	56	46
12	Lugo	34	37	40	45
13	Arroyomolino	34	44	48	45
14	Atlético	34	44	46	43
15	Vallecas	34	49	63	38
16	Carabanchel	34	34	58	31
17	Betis Isidro	34	33	61	30
18	Águilas	34	24	74	21

Competiciones que juega

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.

USO DE MEMORIA

6,928,328 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1388
Total Execution Time	0.1400

CADENA URL

/historico/Cd-Mostoles-Urjc

GET DATOS

$_GET['/historico/Cd-Mostoles-Urjc']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0030	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 = 'Cd-Mostoles-Urjc' 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.0019	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=11995 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=11995 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=11995 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	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=11995 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=11995 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0028	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 = 75982
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11995 AND type_rel = 2
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 11995 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023	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 (127173,127962,188505,225942,241811) ORDER BY n.cover_points DESC, update_date DESC
0.0031	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 = '11995' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0032	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 = '11995' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022	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 = 75982 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027	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=11995 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (75982,72569,72266,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.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 72266 AND teamId = 11995
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 75982 AND teamId = 11995
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 72569 AND teamId = 11995
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 11995
0.0022	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 = 75982 WHERE rp.league_id = 75982 AND rp.teamId = 11995 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.0022	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 = 75982 WHERE rp.league_id = 75982 AND rp.teamId = 11995 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022	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 = 75982 WHERE rp.league_id = 75982 AND rp.teamId = 11995 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036	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 = 11995 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 67981 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.0034	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 = 62380 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.0034	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 = 58585 AND t.round = 22 ORDER BY team.conference ASC,t.position 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* `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 = 50275 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.0034	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 = 44395 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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 = 39031 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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 = 33357 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 15448 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0049	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 = 3917 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035	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 = 2680 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038	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 = 1989 AND t.round = 34 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

CD Móstoles

CD Móstoles

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.

RIVALES EN Tercera Federaci.