¿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
AD San Clemente - U.B. Conquense B
Jornada 7
FINALIZADO
20
40
45 Pts. Elo
1º

30 Pts. Elo
15º

3-0
Domingo, 20 Octubre 2024, 17:00
J. Rossi 23'
1 - 0
F. Benito 31'
2 - 0
Cifu 54'
3 - 0

Eventos del partido

Goles

J. RossiGol de
J. Rossi
minuto 23'
F. BenitoGol de
F. Benito
minuto 31'
CifuGol de
Cifu
minuto 54'

Tarjetas

minuto 29'D. LopezT. Amarilla D. Lopez
minuto 40'K. ValisiT. Amarilla K. Valisi
M. KaneT. Amarilla
M. Kane
minuto 40'
minuto 56'P. MendozaT. Amarilla P. Mendoza
minuto 56'A. AlvarezT. Amarilla A. Alvarez
CifuT. Amarilla
Cifu
minuto 57'

Cambios

M. KaneSale del partido
M. Kane
minuto 45'
AndrewEntra en el partido
Andrew
minuto 45'
minuto 46'J. SanchezEntra en el partido J. Sanchez
minuto 46'A. BucknerSale del partido A. Buckner
minuto 59'P. MendozaSale del partido P. Mendoza
minuto 59'R. HernandezEntra en el partido R. Hernandez
minuto 59'A. AlvarezSale del partido A. Alvarez
minuto 59'L. AcuñaEntra en el partido L. Acuña
O. MartinEntra en el partido
O. Martin
minuto 60'
CifuSale del partido
Cifu
minuto 60'
I. VillarSale del partido
I. Villar
minuto 64'
minuto 64'K. ValisiSale del partido K. Valisi
minuto 64'D. RubioEntra en el partido D. Rubio
minuto 64'M. MartinezEntra en el partido M. Martinez
A. HernandezEntra en el partido
A. Hernandez
minuto 64'
minuto 64'S. EscaladaSale del partido S. Escalada
F. BenitoSale del partido
F. Benito
minuto 64'
R. BellvisEntra en el partido
R. Bellvis
minuto 64'
J. RossiSale del partido
J. Rossi
minuto 76'
E. RosilloEntra en el partido
E. Rosillo
minuto 76'

Alineaciones

AD San Clemente

AD San Clemente

4-4-2
Alineación Inicial
Suplentes
U.B. Conquense B

U.B. Conquense B

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,435,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.9199
Total Execution Time  0.9209
  CADENA URL  
/partido/San-Clemente-Isla-Paraiso-Senior/Ub-Conquenseb
  GET DATOS  
$_GET['/partido/San-Clemente-Isla-Paraiso-Senior/Ub-Conquenseb']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0017  SELECT data1 FROM stats2025 t WHERE league_id = 77165 AND teamId = 6658415 and type = 33
0.0017  SELECT data1 FROM stats2025 t WHERE league_id = 77165 AND teamId = 6658431 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 = '104860' 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 = 104860 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 104860 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 = 77165 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='104860' AND `active` = 1 AND year = 2025
0.0050  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='77165' AND relp.team_id=6658415 WHERE relp.in_squad=1 and mp.`match_id` = '104860' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0046  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='77165' AND relp.team_id=6658431 WHERE relp.in_squad=1 and mp.`match_id` = '104860' 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=104860 AND extraId = 77165 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=86 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 86 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024  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 (1304399,1199941,1184917,1070918,701719) ORDER BY n.cover_points DESC, update_date DESC
0.0019  SELECT rating1, rating2 FROM calendars_elo WHERE id=104860 AND league_id=77165 AND year=2025
0.0019  SELECT * FROM futbol.calendars_lineups WHERE id = 104860 AND league_id = 77165 AND year = 2025