¿Eres mayor de edad?

SI NO

Confirma si tienes 18 años

Faldón apuestas
4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Rayo Majadahonda Sub 19 - Las Rozas CF Sub 19
Jornada 7
FINALIZADO
30
20
27 Pts. Elo
13º

22 Pts. Elo
5º

1-1
Sábado, 12 Octubre 2024, 16:00
Casca 41'
1 - 0
1 - 1
 91' L. Simon

Eventos del partido

Goles

CascaGol de
Casca
minuto 41'
minuto 91'L. SimonGol de L. Simon

Tarjetas

minuto 49'A. RaulT. Amarilla A. Raul
minuto 61'M. CarmenaT. Amarilla M. Carmena
BujeT. Amarilla
Buje
minuto 62'
CascaT. Amarilla
Casca
minuto 69'
D. DiazT. Amarilla
D. Diaz
minuto 89'

Cambios

M. TalaveraEntra en el partido
M. Talavera
minuto 45'
Raul JusdadoSale del partido
Raul Jusdado
minuto 45'
minuto 45'G. De La MataEntra en el partido G. De La Mata
minuto 45'P. ZarzuelaSale del partido P. Zarzuela
minuto 56'C. GonzalezEntra en el partido C. Gonzalez
minuto 56'M. GrossEntra en el partido M. Gross
minuto 56'E. BustosSale del partido E. Bustos
minuto 56'M. BarberoSale del partido M. Barbero
Rubén MunicioEntra en el partido
Rubén Municio
minuto 70'
CascaSale del partido
Casca
minuto 70'
minuto 72'A. RaulSale del partido A. Raul
minuto 72'V. SampedroSale del partido V. Sampedro
minuto 72'J. BeldaEntra en el partido J. Belda
minuto 72'S. AlvarezEntra en el partido S. Alvarez
V. GarciaSale del partido
V. Garcia
minuto 75'
G. GazapoEntra en el partido
G. Gazapo
minuto 75'
I. RamosSale del partido
I. Ramos
minuto 80'
A. PardoSale del partido
A. Pardo
minuto 80'
D. DiazEntra en el partido
D. Diaz
minuto 80'
Victor ClavoEntra en el partido
Victor Clavo
minuto 80'

Alineaciones

Rayo Majadahonda Sub 19

Rayo Majadahonda Sub 19

4-4-2
Alineación Inicial
Suplentes
Las Rozas CF Sub 19

Las Rozas CF Sub 19

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,321,896 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  1.0140
Total Execution Time  1.0151
  CADENA URL  
/partido/Rayo-Majadahonda-Juvenil/Rozas-Juvenil/2025?section=legal
  GET DATOS  
$_GET['/partido/Rayo-Majadahonda-Juvenil/Rozas-Juvenil/2025']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0017  SELECT data1 FROM stats2025 t WHERE league_id = 77075 AND teamId = 6656475 and type = 33
0.0017  SELECT data1 FROM stats2025 t WHERE league_id = 77075 AND teamId = 6656472 and type = 33
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '99748' and rp.type = 2025 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 99748 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 99748 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0050  SELECT t.points,t.team,t.round FROM `tables2025` 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 = 77075 AND t.round >= 7 AND t.round <= 22 ORDER BY t.round ASC, t.points DESC, cast(t.gf as signed) - cast(t.ga as signed) DESC, t.ga DESC, dt.nameShow ASC
0.0017  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='99748' AND `active` = 1 AND year = 2025
0.0035  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='77075' AND relp.team_id=6656475 WHERE relp.in_squad=1 and mp.`match_id` = '99748' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0028  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='77075' AND relp.team_id=6656472 WHERE relp.in_squad=1 and mp.`match_id` = '99748' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=99748 AND extraId = 77075 AND type_rel = 4
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=156 AND type_rel = 3
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 156 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1337598,1333627,1327006,1321373,1312138) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT rating1, rating2 FROM calendars_elo WHERE id=99748 AND league_id=77075 AND year=2025
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 99748 AND league_id = 77075 AND year = 2025