4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Sparta Praha II - Sigma Olomouc II
Jornada 14
FINALIZADO
40
30
498 Pts. Elo
49%
16º

468 Pts. Elo
51%
11º

0-2
Domingo, 29 Octubre 2023, 10:30
  • Asistencia: 308 espectadores
0 - 1
 63' M. Emmanuel
0 - 2
 72' Matěj Mikulenka

Eventos del partido

Goles

minuto 63'M. EmmanuelGol de M. Emmanuel
minuto 72'Matěj MikulenkaGol de Matěj Mikulenka

Tarjetas

minuto 45'D. IsraelT. Amarilla D. Israel
Vojtěch HranošT. Amarilla
Vojtěch Hranoš
minuto 58'
Dalibor VecerkaT. Amarilla
Dalibor Vecerka
minuto 69'
minuto 71'Matěj MikulenkaT. Amarilla Matěj Mikulenka
Roman HorákT. Amarilla
Roman Horák
minuto 81'
Daniel RusT. Amarilla
Daniel Rus
minuto 86'
minuto 91'Jakub FabianekT. Amarilla Jakub Fabianek

Cambios

minuto 61'M. EmmanuelEntra en el partido M. Emmanuel
minuto 61'Matej HadasEntra en el partido Matej Hadas
minuto 61'Jachym SipSale del partido Jachym Sip
minuto 61'D. IsraelSale del partido D. Israel
Vojtěch HranošSale del partido
Vojtěch Hranoš
minuto 64'
David HoloubekEntra en el partido
David Holoubek
minuto 64'
Daniel RusEntra en el partido
Daniel Rus
minuto 64'
Daniel KastanekSale del partido
Daniel Kastanek
minuto 64'
Petr HodoušSale del partido
Petr Hodouš
minuto 71'
Filip SilhartEntra en el partido
Filip Silhart
minuto 71'
minuto 80'V. KristalSale del partido V. Kristal
minuto 80'Matěj MikulenkaSale del partido Matěj Mikulenka
minuto 80'Jakub FabianekEntra en el partido Jakub Fabianek
minuto 80'Filip SlavíčekEntra en el partido Filip Slavíček
minuto 89'Jan FialaSale del partido Jan Fiala
minuto 89'D. GrecmalEntra en el partido D. Grecmal

Otros

minuto 63'J. SpacilAsistencia J. Spacil
minuto 72'M. EmmanuelAsistencia M. Emmanuel

Alineaciones

Sparta Praha II

Sparta Praha II

3-4-3
Alineación Inicial
Suplentes
Sigma Olomouc II

Sigma Olomouc II

4-5-1
Alineación Inicial
Suplentes

Estadísticas del partido

Sparta Praha II Sparta Praha Sigma Olomouc II Sigma
49%
Posesión del balón
 51%
0
Goles
 2
1
Tiros a puerta
 3
7
Tiros fuera
 12
8
Total tiros
 15
1
Paradas del portero
 1
4
Saques de esquina
 7
4
Tarjetas Amarillas
 3
0
Tarjetas Rojas
 0
0
Asistencias
 2
3
Sustituciones
 3


  USO DE MEMORIA  
6,903,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  0.6334
Total Execution Time  0.6346
  CADENA URL  
/partido/Sparta-Praha-B/Sigma-Olomouc-Ii/2024
  GET DATOS  
$_GET['/partido/Sparta-Praha-B/Sigma-Olomouc-Ii/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0147  SELECT data1 FROM stats2024 t WHERE league_id = 72248 AND teamId = 6585714 and type = 33
0.0147  SELECT data1 FROM stats2024 t WHERE league_id = 72248 AND teamId = 6585713 and type = 33
0.0155  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '30158' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0149  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 30158 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0149  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 30158 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0156  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 `tables2024` 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 = 72248 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='30158' AND `active` = 1 AND year = 2024
0.0200  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='72248' AND relp.team_id=6585714 WHERE relp.in_squad=1 and mp.`match_id` = '30158' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0199  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='72248' AND relp.team_id=6585713 WHERE relp.in_squad=1 and mp.`match_id` = '30158' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30158 AND extraId = 72248 AND type_rel = 4
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=367 AND type_rel = 3
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 367 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0150  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 (808298,779859,463893,375302) ORDER BY n.cover_points DESC, update_date DESC
0.0148  SELECT * FROM futbol.calendars_lineups WHERE id = 30158 AND league_id = 72248 AND year = 2024