¿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
Luarca CF - Llaranes CF
FINALIZADO
20
10
51 Pts. Elo
10º

43 Pts. Elo
19º

1-0
Domingo, 01 Diciembre 2024, 16:00
Efrén 35'
1 - 0

Eventos del partido

Goles

EfrénGol de
Efrén
minuto 35'

Tarjetas

I. VigilT. Amarilla
I. Vigil
minuto 37'
minuto 88'Félix SanzT. Amarilla Félix Sanz
P. MaderaT. Amarilla
P. Madera
minuto 90'

Cambios

minuto 46'K. VegaSale del partido K. Vega
G. RodriguezSale del partido
G. Rodriguez
minuto 46'
D. PiniellaEntra en el partido
D. Piniella
minuto 46'
minuto 46'CristianEntra en el partido Cristian
Pelayo SalasSale del partido
Pelayo Salas
minuto 60'
A. MesaSale del partido
A. Mesa
minuto 60'
D. FernandezEntra en el partido
D. Fernandez
minuto 60'
Raúl CarballoEntra en el partido
Raúl Carballo
minuto 60'
minuto 61'I. ProlSale del partido I. Prol
minuto 61'YonathanEntra en el partido Yonathan
J. St. PatrickEntra en el partido
J. St. Patrick
minuto 72'
I. VigilSale del partido
I. Vigil
minuto 72'
minuto 75'M. SantiagoEntra en el partido M. Santiago
minuto 75'S. RodríguezEntra en el partido S. Rodríguez
minuto 75'DavidSale del partido David
minuto 75'O. BarroSale del partido O. Barro
minuto 80'H. FaezEntra en el partido H. Faez
minuto 80'Ignacio DiazSale del partido Ignacio Diaz
EfrénSale del partido
Efrén
minuto 90'
R. AlvarezEntra en el partido
R. Alvarez
minuto 90'

Alineaciones

Luarca CF

Luarca CF

4-4-2
Alineación Inicial
Suplentes
Llaranes CF

Llaranes CF

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,581,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  1.9410
Total Execution Time  1.9421
  CADENA URL  
/partido/Luarca/Llaranes
  GET DATOS  
$_GET['/partido/Luarca/Llaranes']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0017  SELECT data1 FROM stats2025 t WHERE league_id = 77131 AND teamId = 6657461 and type = 33
0.0017  SELECT data1 FROM stats2025 t WHERE league_id = 77131 AND teamId = 6657458 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 = '97604' 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 = 97604 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 97604 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='97604' AND `active` = 1 AND year = 2025
0.0041  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='77131' AND relp.team_id=6657461 WHERE relp.in_squad=1 and mp.`match_id` = '97604' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0039  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='77131' AND relp.team_id=6657458 WHERE relp.in_squad=1 and mp.`match_id` = '97604' 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=97604 AND extraId = 77131 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=72 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 72 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 (865740,698945,420684,366243,365678) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT rating1, rating2 FROM calendars_elo WHERE id=97604 AND league_id=77131 AND year=2025
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 97604 AND league_id = 77131 AND year = 2025