¿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
Roda Sub 19 B - Canet Sub 19
Jornada 14
FINALIZADO
10
10
20 Pts. Elo
12º

15 Pts. Elo
17º

0-0
Jueves, 05 Diciembre 2024, 19:30

Eventos del partido

Tarjetas

minuto 78'A. MoraruT. Amarilla A. Moraru
Mateo YepesT. Amarilla
Mateo Yepes
minuto 83'

Cambios

minuto 52'P. VivoEntra en el partido P. Vivo
minuto 52'P. MonterrubioSale del partido P. Monterrubio
S. VicentEntra en el partido
S. Vicent
minuto 63'
M. BoriaSale del partido
M. Boria
minuto 63'
N. SanchezSale del partido
N. Sanchez
minuto 63'
Alejandro PérezEntra en el partido
Alejandro Pérez
minuto 63'
M. HuesoSale del partido
M. Hueso
minuto 63'
T. ChouliEntra en el partido
T. Chouli
minuto 63'
minuto 65'J. ClimentSale del partido J. Climent
minuto 65'C. ArtuñedoEntra en el partido C. Artuñedo
minuto 75'J. RodriguezSale del partido J. Rodriguez
minuto 75'A. MartinezSale del partido A. Martinez
minuto 75'X. BrochEntra en el partido X. Broch
minuto 75'I. BenedictoEntra en el partido I. Benedicto
I. MartíEntra en el partido
I. Martí
minuto 79'
Unai MontillaSale del partido
Unai Montilla
minuto 79'
Diego BeltranSale del partido
Diego Beltran
minuto 89'
P. BruEntra en el partido
P. Bru
minuto 89'

Alineaciones

Roda Sub 19 B

Roda Sub 19 B

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

Canet Sub 19

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,503,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  0.7573
Total Execution Time  0.7585
  CADENA URL  
/partido/Cd-Roda-B-Juvenil/Cd-De-Futbol-Canet-Juvenil
  GET DATOS  
$_GET['/partido/Cd-Roda-B-Juvenil/Cd-De-Futbol-Canet-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0018  SELECT data1 FROM stats2025 t WHERE league_id = 76828 AND teamId = 6661593 and type = 33
0.0019  SELECT data1 FROM stats2025 t WHERE league_id = 76828 AND teamId = 6661586 and type = 33
0.0026  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '136810' and rp.type = 2025 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 136810 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0022  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 136810 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0033  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 = 76828 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.0019  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='136810' AND `active` = 1 AND year = 2025
0.0047  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='76828' AND relp.team_id=6661593 WHERE relp.in_squad=1 and mp.`match_id` = '136810' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
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='76828' AND relp.team_id=6661586 WHERE relp.in_squad=1 and mp.`match_id` = '136810' 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=136810 AND extraId = 76828 AND type_rel = 4
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=112 AND type_rel = 3
0.0025  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 112 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0025  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 (1243526,1233227,1223087,1219000,1197928) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT rating1, rating2 FROM calendars_elo WHERE id=136810 AND league_id=76828 AND year=2025
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 136810 AND league_id = 76828 AND year = 2025