¿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
CD Maavi - PD Garrucha
Jornada 4
FINALIZADO
20
40
37 Pts. Elo
1º

25 Pts. Elo
6º

3-1
Domingo, 06 Octubre 2024, 12:00
F. Navarro 24'
1 - 0
Miguel 51'
2 - 0
V. Martinez 62'
3 - 0
3 - 1
 90' C. Sánchez

Eventos del partido

Goles

F. NavarroGol de
F. Navarro
minuto 24'
MiguelGol de
Miguel
minuto 51'
V. MartinezGol de
V. Martinez
minuto 62'
minuto 90'C. SánchezGol de penalti C. Sánchez

Tarjetas

F. ManbucaT. Amarilla
F. Manbuca
minuto 41'
minuto 44'A. WelleT. Amarilla A. Welle
Kevin TorresT. Amarilla
Kevin Torres
minuto 44'
minuto 44'Alex PilasT. Amarilla Alex Pilas
minuto 76'KhalidT. Amarilla Khalid
minuto 91'J. EnadiT. Amarilla J. Enadi

Alineaciones

CD Maavi

CD Maavi

4-4-2
Alineación Inicial
Suplentes
PD Garrucha

PD Garrucha

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,922,768 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.7733
Total Execution Time  0.7743
  CADENA URL  
/partido/Cd-Maavi-Senior/Pd-Garrucha-Senior
  GET DATOS  
$_GET['/partido/Cd-Maavi-Senior/Pd-Garrucha-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0106  SELECT data1 FROM stats2025 t WHERE league_id = 77375 AND teamId = 6662544 and type = 33
0.0106  SELECT data1 FROM stats2025 t WHERE league_id = 77375 AND teamId = 6662543 and type = 33
0.0109  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '140879' and rp.type = 2025 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0107  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 140879 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0107  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 140879 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0113  SELECT AVG(points) as avg_points, AVG(gf) as avg_gf, AVG(ga) as avg_gc, SUM(win_h) as win_home, SUM(win_a) as win_away, SUM(draw_h) as draw_home, SUM(draw_a) as draw_away from `tables2025` where league_id = 77375 and round = 21 group by league_id, round
0.0213  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 = 77375 AND t.round >= 6 AND t.round <= 21 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.0109  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='140879' AND `active` = 1 AND year = 2025
0.0183  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='77375' AND relp.team_id=6662544 WHERE relp.in_squad=1 and mp.`match_id` = '140879' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0194  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='77375' AND relp.team_id=6662543 WHERE relp.in_squad=1 and mp.`match_id` = '140879' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=140879 AND extraId = 77375 AND type_rel = 4
0.0107  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5 AND type_rel = 3
0.0113  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 5 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0118  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 (1315346,1267671,1255959,1148089,1109642) ORDER BY n.cover_points DESC, update_date DESC
0.0106  SELECT rating1, rating2 FROM calendars_elo WHERE id=140879 AND league_id=77375 AND year=2025
0.0108  SELECT * FROM futbol.calendars_lineups WHERE id = 140879 AND league_id = 77375 AND year = 2025