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

Rayo Vallecano Sub 19 C

Temporada 2023/2024

TEMPORADA 2023/2024

1ª AUTO. MADRID JUVENIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Leganés	30	69	32	64
2	Parla	30	62	32	64
3	Sebastian	29	59	22	63
4	Getafe	30	53	27	61
5	Yebenes-San	30	70	46	58
6	Rayo	30	58	35	54
7	Moratalaz	30	53	42	46
8	Móstoles	30	50	48	41
9	Periso	30	44	52	40
10	Trival	29	53	53	37
11	Usera	30	46	60	33
12	Colonia	30	51	68	33
13	Aluche	30	34	61	33
14	Real	30	46	50	31
15	Fortuna	30	33	64	30
16	Rivas	30	35	67	25
17	Villaverde	30	29	47	22
18	Fuenlabrada	30	28	67	11

TEMPORADA 2022/2023

1ª AUTO. MADRID JUVENIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Rayo	33	99	29	79
2	Leganés	33	75	45	71
3	Alcorcón	33	76	40	67
4	Rayo	33	79	46	64
5	Getafe	33	65	39	59
6	Trival	33	78	59	58
7	Fuenlabrada	33	66	51	57
8	Móstoles	33	58	49	51
9	Fernando	33	53	63	43
10	Rivas	33	53	67	42
11	Atlético	33	57	66	40
12	Aluche	33	45	53	38
13	Usera	33	51	69	37
14	Villaviciosa	33	47	68	36
15	Unión	33	56	89	32
16	Canillas B	33	56	87	26
17	Navalcarnero	33	48	83	24
18	Las Rozas C	33	37	96	7

TEMPORADA 2021/2022

1ª AUTO. MADRID JUVENIL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Real Madrid	34	129	20	93
2	Moratalaz	34	75	38	65
3	Complutense	34	72	45	62
4	Fundacion	34	63	53	58
5	Rayo Mjdh.	34	64	51	55
6	Rayo	34	71	59	53
7	Santa	34	61	65	51
8	Villaviciosa	34	71	77	50
9	Chopera	34	61	49	48
10	Fernando	34	59	56	48
11	Villanueva	34	52	59	46
12	Nuevo	34	70	72	43
13	Canillas	34	57	80	38
14	Sanse	34	50	81	38
15	Móstoles	34	53	72	36
16	Unión	34	38	71	31
17	Alcobendas	34	30	67	24
18	Aluche B	34	40	101	23

TEMPORADA 2020/2021

1ª AUTO. MADRID JUVENIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Rayo	19	61	16	50
2	Alcorcón	19	62	25	39
3	Leganés	19	53	25	38
4	Atlético	19	36	20	36
5	Getafe	19	59	19	35
6	Aluche	19	46	25	33
7	Fuenlabrada	19	39	27	33
8	Unión	19	41	34	29
9	Casarrubuelo	19	36	29	29
10	Móstoles	19	29	23	28
11	Sitio	19	32	27	28
12	Navalcarnero	19	40	39	28
13	Villaviciosa	19	44	43	27
14	Carabanchel	19	38	35	24
15	Parla	19	40	36	23
16	Ciudad	19	21	48	17
17	Complutense	19	31	48	14
18	Puerta	19	23	44	14
19	Humanes A	19	22	42	12
20	Bercial	19	5	153	1

TEMPORADA 2019/2020

1ª AUTO. MADRID JUVENIL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Real Madrid	23	108	15	64
2	Rayo	23	82	26	61
3	Rozas	23	51	36	40
4	Alcalá B	23	44	38	39
5	Fuenlabrada	23	40	23	36
6	Nuevo	23	47	40	36
7	Aravaca B	23	38	56	33
8	Canillas B	23	37	38	32
9	Unión	23	33	45	32
10	Siete Picos	23	33	42	29
11	Villanueva	23	35	41	28
12	Sanse	23	42	52	27
13	Santa	23	46	60	26
14	Union Zona.	23	38	58	24
15	Pozuelo	23	31	56	24
16	Complutense	23	31	40	19
17	Chopera	23	30	57	17
18	Collado	23	28	71	11

TEMPORADA 2018/2019

1ª AUTO. MADRID JUVENIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Moratalaz	34	100	40	79
2	Boadilla	34	81	46	67
3	Getafe	34	71	48	66
4	Ciudad	34	70	45	63
5	Leganés	34	72	46	57
6	Humanes A	34	61	55	55
7	Rayo	34	69	63	51
8	Parla	34	75	58	49
9	Alcorcón	34	48	55	43
10	Pozuelo	34	52	60	43
11	Carabanchel	34	51	62	43
12	Aluche	34	55	66	42
13	Fuenlabrada	34	52	66	41
14	Móstoles	34	47	56	40
15	Sitio	34	53	58	38
16	Trival	34	40	73	31
17	Yébenes	34	45	98	26
18	Atlético	34	59	106	21

TEMPORADA 2017/2018

1ª AUTO. MADRID JUVENIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Yebenes-San	34	98	52	71
2	Móstoles	34	74	41	71
3	Rayo	34	89	40	66
4	Alcorcón	34	80	48	66
5	Moratalaz	34	80	50	66
6	Rozas	34	81	41	61
7	Fuenlabrada	34	65	54	56
8	Getafe	34	69	52	53
9	Leganés	34	61	57	53
10	Ciudad	34	53	64	42
11	Trival	34	48	57	41
12	Parla	34	54	68	38
13	Atlético	34	43	61	36
14	Boadilla	34	67	95	35
15	Lugo	34	46	85	32
16	Vicalvaro A	34	33	57	31
17	Pozuelo	34	39	69	28
18	Alcalá C	34	24	113	8

TEMPORADA 2016/2017

1ª AUTO. MADRID JUVENIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Rayo	34	112	22	89
2	Leganés	34	63	41	62
3	Fuenlabrada	34	79	52	60
4	Atlético	34	56	35	60
5	Atlético	34	77	41	59
6	Parla	34	82	66	57
7	Móstoles	34	72	56	57
8	Trival	34	59	53	56
9	Boadilla	34	63	61	54
10	Ciudad	34	59	58	47
11	Moratalaz	34	71	67	46
12	Lugo	34	61	83	41
13	Getafe	34	60	57	39
14	Juventud	34	48	63	39
15	Unión	34	47	109	27
16	Villaviciosa	34	57	104	23
17	San Blas C	34	35	87	23
18	Vicalvaro B	34	35	81	20

TEMPORADA 2015/2016

1ª AUTO. MADRID JUVENIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Rayo	34	123	29	85
2	Fuenlabrada	34	104	36	85
3	Carabanchel	34	95	33	71
4	Fernando	34	71	43	66
5	Getafe	34	74	43	58
6	Atlético	34	61	64	53
7	Leganés	34	68	54	52
8	Ciudad	34	61	56	50
9	Atlético	34	54	60	49
10	Alcorcon C	34	59	53	48
11	Lugo	34	48	50	45
12	Juventud	34	64	88	41
13	Parla	34	65	68	39
14	Villaviciosa	34	56	76	37
15	Vallecas A	34	50	62	35
16	Pinto	34	64	70	32
17	Sitio	34	35	96	16
18	Villarejo	34	28	199	1

TEMPORADA 2014/2015

1ª AUTO. MADRID JUVENIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Getafe	34	96	21	82
2	Casarrubuelo	34	88	28	82
3	Rayo	34	100	38	77
4	Leganés	34	81	40	70
5	Atlético	34	70	40	59
6	Lugo	34	72	57	58
7	Alcorcon C	34	69	64	47
8	Villaviciosa	34	61	70	46
9	Juventud	34	52	68	46
10	Vicalvaro A	34	61	71	44
11	Villarejo	34	45	75	42
12	Vallecas A	34	54	70	41
13	Aluche	34	59	67	40
14	Sitio	34	52	78	40
15	Ciudad	34	55	63	38
16	Real	34	36	63	27
17	Fernando	34	42	103	20
18	Atlético	34	40	117	13

Competiciones que juega

Grupo 2

RIVALES EN 1ª Auto. Madrid.

USO DE MEMORIA

6,008,280 bytes

BENCHMARKS

Loading Time Base Classes	0.0016
Controller Execution Time ( Home / Category )	0.4946
Total Execution Time	0.4962

CADENA URL

/historico/Rayo-Vallecano-De-Madrid-C-Juvenil

GET DATOS

$_GET['/historico/Rayo-Vallecano-De-Madrid-C-Juvenil']

POST DATOS

No hay datos POST existentes

CONSULTAS (29)

0.0135	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 = 'Rayo-Vallecano-De-Madrid-C-Juvenil' 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.0126	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=90819 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=90819 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0262	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 = 74254
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=90819 AND type_rel = 2
0.0127	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=731 AND type_rel = 3
0.0142	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 731 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0134	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 (1067892,914706,889402,860480,829183) ORDER BY n.cover_points DESC, update_date DESC
0.0135	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 = '90819' ORDER BY l.year DESC,cat.coefficient DESC
0.0130	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 = '90819' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128	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 = '90819' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129	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 = 74254 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130	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=90819 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (74254) 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.0127	SELECT count(id) as num_players from rel_players_base WHERE league_id = 74254 AND teamId = 90819
0.0128	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 = '90819' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '90819' and rp.type = 4
0.0126	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 = '90819' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127	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 = 90819 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129	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_base` 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 = 74254 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.0131	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_base` 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 = 68911 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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_base` 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 = 64789 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.0128	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_base` 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 = 61289 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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_base` 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 = 51855 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.0132	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_base` 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 = 45013 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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_base` 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 = 39235 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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_base` 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 = 34181 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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_base` 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 = 16968 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 4617 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

Rayo Vallecano Sub 19 C

Rayo Vallecano Sub 19 C

Selecciona un equipo

Competiciones que juega

RIVALES EN 1ª Auto. Madrid.