¿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 Calahorra Sub 19 - La Calzada Sub 19
Jornada 12
FINALIZADO
10
00
20 Pts. Elo
12º

24 Pts. Elo
3º

0-3
Sábado, 30 Noviembre 2024, 15:45
0 - 1
 30' R. Ochoa
0 - 2
 38' S. Lopez
0 - 3
 84' D. Gomez

Eventos del partido

Goles

minuto 30'R. OchoaGol de R. Ochoa
minuto 38'S. LopezGol de S. Lopez
minuto 84'D. GomezGol de D. Gomez

Tarjetas

J. AlhamadT. Amarilla
J. Alhamad
minuto 80'

Cambios

P. YoldiEntra en el partido
P. Yoldi
minuto 3'
A. MagdiSale del partido
A. Magdi
minuto 3'
M. PuertaEntra en el partido
M. Puerta
minuto 52'
M. MellahSale del partido
M. Mellah
minuto 52'
J. MateoEntra en el partido
J. Mateo
minuto 52'
P. GarciaSale del partido
P. Garcia
minuto 52'
minuto 59'G. OrtegaSale del partido G. Ortega
minuto 59'R. OchoaSale del partido R. Ochoa
minuto 59'D. NovoaEntra en el partido D. Novoa
minuto 59'E. CamposEntra en el partido E. Campos
I. RiesgoEntra en el partido
I. Riesgo
minuto 67'
J. HerceEntra en el partido
J. Herce
minuto 67'
A. GarciaSale del partido
A. Garcia
minuto 67'
M. EzquerroSale del partido
M. Ezquerro
minuto 67'
minuto 73'G. MartínSale del partido G. Martín
minuto 73'D. GomezEntra en el partido D. Gomez
minuto 88'R. NavazoSale del partido R. Navazo
minuto 88'B. MonteroEntra en el partido B. Montero

Alineaciones

CD Calahorra Sub 19

CD Calahorra Sub 19

4-4-2
Alineación Inicial
Suplentes
La Calzada Sub 19

La Calzada Sub 19

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,398,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  1.0028
Total Execution Time  1.0038
  CADENA URL  
/partido/Calahorra-Juvenil/La-Calzada-Juvenil/2025?section=legal
  GET DATOS  
$_GET['/partido/Calahorra-Juvenil/La-Calzada-Juvenil/2025']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0213  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 76825
0.0104  SELECT data1 FROM stats2025 t WHERE league_id = 76825 AND teamId = 6662948 and type = 33
0.0104  SELECT data1 FROM stats2025 t WHERE league_id = 76825 AND teamId = 6662954 and type = 33
0.0106  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '142576' and rp.type = 2025 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 142576 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0105  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 142576 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0106  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 76825 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0105  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='142576' AND `active` = 1 AND year = 2025
0.0114  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='76825' AND relp.team_id=6662948 WHERE relp.in_squad=1 and mp.`match_id` = '142576' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0112  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='76825' AND relp.team_id=6662954 WHERE relp.in_squad=1 and mp.`match_id` = '142576' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0104  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=142576 AND extraId = 76825 AND type_rel = 4
0.0104  SELECT rating1, rating2 FROM calendars_elo WHERE id=142576 AND league_id=76825 AND year=2025
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 142576 AND league_id = 76825 AND year = 2025