¿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
Astur CF Sub 19 - Romanón Sub 19
Jornada 3
FINALIZADO
20
30
14 Pts. Elo
12º

8 Pts. Elo
9º

1-0
Domingo, 22 Septiembre 2024, 18:00
Alfonso Cosío 37'
1 - 0

Eventos del partido

Goles

Alfonso CosíoGol de
Alfonso Cosío
minuto 37'

Tarjetas

J. FernandezT. Amarilla
J. Fernandez
minuto 1'
minuto 39'H. NaredoT. Amarilla H. Naredo
minuto 44'D. FernandezT. Amarilla D. Fernandez
minuto 56'C. FigaredoT. Amarilla C. Figaredo
G. GonzalezT. Amarilla
G. Gonzalez
minuto 76'

Cambios

minuto 45'O. SanchezEntra en el partido O. Sanchez
minuto 45'A. MegidoSale del partido A. Megido
minuto 54'D. VigilSale del partido D. Vigil
A. MoranSale del partido
A. Moran
minuto 54'
A. MilánEntra en el partido
A. Milán
minuto 54'
J. FernandezSale del partido
J. Fernandez
minuto 54'
Miguel GonzalezEntra en el partido
Miguel Gonzalez
minuto 54'
minuto 54'H. BarradoEntra en el partido H. Barrado
M. HuelgaEntra en el partido
M. Huelga
minuto 60'
Alfonso CosíoSale del partido
Alfonso Cosío
minuto 60'
M. RusEntra en el partido
M. Rus
minuto 68'
J. PalacioSale del partido
J. Palacio
minuto 68'
D. MartinezSale del partido
D. Martinez
minuto 68'
C. DiezEntra en el partido
C. Diez
minuto 68'
minuto 79'H. NaredoSale del partido H. Naredo
minuto 79'F. LongoriaEntra en el partido F. Longoria

Alineaciones

Astur CF Sub 19

Astur CF Sub 19

4-4-2
Alineación Inicial
Suplentes
Romanón Sub 19

Romanón Sub 19

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,112,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.0914
Total Execution Time  0.0924
  CADENA URL  
/partido/Astur-Cf-Juvenil/Cd-Romanon-Juvenil/2025?section=legal
  GET DATOS  
$_GET['/partido/Astur-Cf-Juvenil/Cd-Romanon-Juvenil/2025']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0017  SELECT data1 FROM stats2025 t WHERE league_id = 76822 AND teamId = 6658061 and type = 33
0.0017  SELECT data1 FROM stats2025 t WHERE league_id = 76822 AND teamId = 6658073 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 = '102679' and rp.type = 2025 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 102679 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 102679 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='102679' AND `active` = 1 AND year = 2025
0.0033  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='76822' AND relp.team_id=6658061 WHERE relp.in_squad=1 and mp.`match_id` = '102679' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0029  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='76822' AND relp.team_id=6658073 WHERE relp.in_squad=1 and mp.`match_id` = '102679' 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=102679 AND extraId = 76822 AND type_rel = 4
0.0017  SELECT rating1, rating2 FROM calendars_elo WHERE id=102679 AND league_id=76822 AND year=2025
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 102679 AND league_id = 76822 AND year = 2025