4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
FK Pirmasens - Kaiserslautern II
Jornada 15
FINALIZADO
20
10
238 Pts. Elo
3º

131 Pts. Elo
7º

3-0
Martes, 03 Octubre 2023, 14:00
Marc Erhart 11'
1 - 0
D. Krob 22'
2 - 0
Kristof Scherpf 93'
3 - 0

Eventos del partido

Goles

Marc ErhartGol de
Marc Erhart
minuto 11'
D. KrobGol de
D. Krob
minuto 22'
Kristof ScherpfGol de
Kristof Scherpf
minuto 93'

Tarjetas

minuto 57'Görkem KocaT. Amarilla Görkem Koca
EdonartT. Amarilla
Edonart
minuto 62'
M. DehoT. Amarilla
M. Deho
minuto 69'

Cambios

minuto 46'Marco MüllerSale del partido Marco Müller
minuto 46'Marcel KuhlmannEntra en el partido Marcel Kuhlmann
minuto 46'I. CatovicSale del partido I. Catovic
minuto 46'Faton SulejmaniEntra en el partido Faton Sulejmani
minuto 46'Drini MiftariEntra en el partido Drini Miftari
minuto 46'Ben ReinheimerSale del partido Ben Reinheimer
Maurice SchnellEntra en el partido
Maurice Schnell
minuto 65'
Marc ErhartSale del partido
Marc Erhart
minuto 65'
minuto 74'Thomas KaraberisSale del partido Thomas Karaberis
minuto 74'TalhaEntra en el partido Talha
minuto 74'Mike ScharwathEntra en el partido Mike Scharwath
minuto 74'Görkem KocaSale del partido Görkem Koca
Kristof ScherpfEntra en el partido
Kristof Scherpf
minuto 76'
K. BüchlerSale del partido
K. Büchler
minuto 76'
Y. GriessEntra en el partido
Y. Griess
minuto 87'
Markus HappersbergerEntra en el partido
Markus Happersberger
minuto 87'
L. DimitrijevicSale del partido
L. Dimitrijevic
minuto 87'
LennartEntra en el partido
Lennart
minuto 87'
D. KrobSale del partido
D. Krob
minuto 87'
D. BohlSale del partido
D. Bohl
minuto 87'

Otros

D. KrobAsistencia
D. Krob
minuto 11'
K. BüchlerAsistencia
K. Büchler
minuto 22'

Alineaciones

FK Pirmasens

FK Pirmasens

4-4-2
Alineación Inicial
Suplentes
Kaiserslautern II

Kaiserslautern II

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,889,472 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.3424
Total Execution Time  0.3434
  CADENA URL  
/partido/Pirmasens-Fk/Kaiserslautern-Ii
  GET DATOS  
$_GET['/partido/Pirmasens-Fk/Kaiserslautern-Ii']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0105  SELECT data1 FROM stats2024 t WHERE league_id = 72627 AND teamId = 6590627 and type = 33
0.0105  SELECT data1 FROM stats2024 t WHERE league_id = 72627 AND teamId = 6590628 and type = 33
0.0107  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '131781' and rp.type = 2024 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 = 131781 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0105  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 131781 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0105  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='131781' AND `active` = 1 AND year = 2024
0.0143  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='72627' AND relp.team_id=6590627 WHERE relp.in_squad=1 and mp.`match_id` = '131781' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0129  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='72627' AND relp.team_id=6590628 WHERE relp.in_squad=1 and mp.`match_id` = '131781' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=131781 AND extraId = 72627 AND type_rel = 4
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 131781 AND league_id = 72627 AND year = 2024