¿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
La Fresneda - Andés
Jornada 18
FINALIZADO
10
20
22 Pts. Elo
9º

39 Pts. Elo
16º

2-1
Domingo, 19 Enero 2025, 13:00
P. Perez 27'
1 - 0
1 - 1
 44' T. González
Meneses 85'
2 - 1

Eventos del partido

Goles

P. PerezGol de
P. Perez
minuto 27'
minuto 44'T. GonzálezGol de T. González
MenesesGol de
Meneses
minuto 85'

Tarjetas

minuto 53'N. GarcíaT. Amarilla N. García
P. PerezT. Amarilla
P. Perez
minuto 61'
minuto 80'I. FernándezT. Amarilla I. Fernández

Cambios

M. PerezEntra en el partido
M. Perez
minuto 46'
F. LopezEntra en el partido
F. Lopez
minuto 46'
D. GonzalezSale del partido
D. Gonzalez
minuto 46'
AlexSale del partido
Alex
minuto 46'
P. BerenguerSale del partido
P. Berenguer
minuto 46'
V. AmezEntra en el partido
V. Amez
minuto 46'
R. SuarezEntra en el partido
R. Suarez
minuto 67'
P. PerezSale del partido
P. Perez
minuto 67'
minuto 72'SergiEntra en el partido Sergi
minuto 72'MagadanSale del partido Magadan
SantiagoSale del partido
Santiago
minuto 86'
A. LopezEntra en el partido
A. Lopez
minuto 86'

Alineaciones

La Fresneda

La Fresneda

4-4-2
Alineación Inicial
Suplentes
Andés

Andés

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,717,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.9054
Total Execution Time  0.9064
  CADENA URL  
/partido/La-Fresneda/Andes
  GET DATOS  
$_GET['/partido/La-Fresneda/Andes']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0017  SELECT data1 FROM stats2025 t WHERE league_id = 77131 AND teamId = 6657453 and type = 33
0.0017  SELECT data1 FROM stats2025 t WHERE league_id = 77131 AND teamId = 6657450 and type = 33
0.0019  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '97656' 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 = 97656 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 97656 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='97656' AND `active` = 1 AND year = 2025
0.0040  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=6657453 WHERE relp.in_squad=1 and mp.`match_id` = '97656' 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=6657450 WHERE relp.in_squad=1 and mp.`match_id` = '97656' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=97656 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.0021  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.0026  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.0020  SELECT rating1, rating2 FROM calendars_elo WHERE id=97656 AND league_id=77131 AND year=2025
0.0020  SELECT * FROM futbol.calendars_lineups WHERE id = 97656 AND league_id = 77131 AND year = 2025