4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sparta Praha Sub 19

Partidos del Sparta Praha Sub 19

Ir al LIVESCORE
UEFA Youth League UEFA Youth League »
29 Nov 23  Finalizado Žilina Sub 19
4 - 4
 Sparta PrahaTarjeta Roja 11
08 Nov 23  Finalizado Sparta Praha
2 - 2
 Žilina Sub 19 20
25 Oct 23  Aplazado Maccabi Haifa
-
 Sparta Praha 1
04 Oct 23  Finalizado Sparta Praha
1 - 1
 Maccabi Haifa 13
Liga Checa Sub 19 Liga Checa Sub 19 »
08 Jun 24  en 1 mes Sparta Praha
13:00
 Zlín Sub 19 0
25 May 24  en 24 días Sparta Praha
11:00
 Pardubice Sub 19 0
18 May 24  en 18 días Zbrojovka Brno
12:30
 Sparta Praha 0
11 May 24  en 11 días Sparta Praha
12:30
 Sigma Olomouc 0
04 May 24  en 3 días Slovan Liberec
10:00
 Sparta Praha 0
27 Abr 24  Finalizado Sparta Praha
1 - 3
 Slovácko Sub 19 0
24 Abr 24  Finalizado Vysočina Jihlava
0 - 5
 Sparta Praha 0
20 Abr 24  Finalizado Mladá Boleslav
2 - 3
 Sparta Praha 0
17 Abr 24  Finalizado Tarjeta RojaSlavia Praha
0 - 2
 Sparta Praha 0
13 Abr 24  Finalizado Sparta Praha
5 - 2
 Viktoria Plzeň 0
06 Abr 24  Finalizado Dukla Praha
0 - 3
 Sparta Praha 0
30 Mar 24  Finalizado Sparta Praha
1 - 0
 Karvina Sub 19 0
15 Mar 24  Finalizado Sparta Praha
4 - 0
 Baník Ostrava 0
09 Mar 24  Finalizado České
2 - 6
 Sparta Praha 0
02 Mar 24  Finalizado Sparta Praha
2 - 1
 Frýdek-Místek 0
21 Feb 24  Finalizado Tarjeta RojaZlín Sub 19
2 - 2
 Sparta PrahaTarjeta RojaTarjeta Roja 0
22 Nov 23  Finalizado Pardubice Sub 19
1 - 3
 Sparta Praha 3
04 Nov 23  Finalizado Sparta Praha
2 - 1
 Slavia Praha 0
31 Oct 23  Finalizado Sigma Olomouc
0 - 2
 Sparta Praha 0
21 Oct 23  Finalizado Sparta Praha
1 - 0
 Zbrojovka Brno 0
07 Oct 23  Finalizado Sparta Praha
3 - 3
 Slovan Liberec 0
30 Sep 23  Finalizado Slovácko Sub 19
2 - 1
 Sparta Praha 0
23 Sep 23  Finalizado Sparta Praha
1 - 1
 Mladá Boleslav 0
19 Sep 23  Finalizado Sparta Praha
1 - 0
 Dukla Praha 0
16 Sep 23  Finalizado Viktoria Plzeň
1 - 1
 Sparta Praha 0
02 Sep 23  Finalizado Karvina Sub 19
1 - 2
 Sparta Praha 0
26 Ago 23  Finalizado Sparta Praha
1 - 1
 Vysočina Jihlava 0
19 Ago 23  Finalizado Baník Ostrava
1 - 1
 Sparta Praha 0
12 Ago 23  Finalizado Sparta Praha
3 - 2
 České 0
09 Ago 23  Finalizado Frýdek-Místek
1 - 0
 Sparta PrahaTarjeta Roja 0

  USO DE MEMORIA  
5,112,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1687
Total Execution Time  0.1700
  CADENA URL  
/partidos/Sparta-Praha-Sub19
  GET DATOS  
$_GET['/partidos/Sparta-Praha-Sub19']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (6)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62596 AND type_rel = 2
0.0129  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '62596' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id WHERE (c.datateam1 = 62596 or c.datateam2 = 62596) AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0132  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 62596 or c.datateam2 = 62596) AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 365
0.0129  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN events2024 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 62596 or c.datateam2 = 62596) AND l.year = 2024)
0.0130  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 74025 ORDER BY nameShow LIMIT 100