4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Sonthofen - Rain / Lech
Jornada 19
FINALIZADO
50
20
116 Pts. Elo
12º

135 Pts. Elo
11º

0-2
Sábado, 04 Noviembre 2023, 14:00
0 - 1
 14' R. Domislic
0 - 2
 50' F. Triebel

Eventos del partido

Goles

minuto 14'R. DomislicGol de R. Domislic
minuto 50'F. TriebelGol de F. Triebel

Tarjetas

minuto 16'G. HasenbichlerT. Amarilla G. Hasenbichler
A. HindelangT. Amarilla
A. Hindelang
minuto 28'
Kevin HaugT. Amarilla
Kevin Haug
minuto 39'
T. SchmölzT. Amarilla
T. Schmölz
minuto 56'
Marco ZettlerT. Amarilla
Marco Zettler
minuto 56'
minuto 78'F. TriebelT. Amarilla F. Triebel
M. MethfesselT. Amarilla
M. Methfessel
minuto 86'

Cambios

minuto 46'M. SodjiEntra en el partido M. Sodji
minuto 46'G. HasenbichlerSale del partido G. Hasenbichler
A. BechterSale del partido
A. Bechter
minuto 46'
A. HindelangEntra en el partido
A. Hindelang
minuto 46'
M. FallerSale del partido
M. Faller
minuto 59'
L. RudenkoEntra en el partido
L. Rudenko
minuto 59'
minuto 60'R. DomislicSale del partido R. Domislic
minuto 60'Matej RadosEntra en el partido Matej Rados
minuto 73'Eugen BelousowEntra en el partido Eugen Belousow
minuto 73'B. AlišanovićSale del partido B. Ališanović
P. WegeleEntra en el partido
P. Wegele
minuto 81'
J. HolzapfelSale del partido
J. Holzapfel
minuto 81'
minuto 88'Muris AvdicEntra en el partido Muris Avdic
M. MethfesselSale del partido
M. Methfessel
minuto 88'
minuto 88'Benjamin KristSale del partido Benjamin Krist
A. OggerEntra en el partido
A. Ogger
minuto 88'
minuto 92'M. SengerSale del partido M. Senger
minuto 92'L. MüllerEntra en el partido L. Müller

Alineaciones

Sonthofen

Sonthofen

4-4-2
Alineación Inicial
Suplentes
Rain / Lech

Rain / Lech

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,788,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Match / Index )  0.6305
Total Execution Time  0.6319
  CADENA URL  
/partido/Sonthofen/Rain-Lech/2024
  GET DATOS  
$_GET['/partido/Sonthofen/Rain-Lech/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0298  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 = 72394
0.0145  SELECT data1 FROM stats2024 t WHERE league_id = 72394 AND teamId = 6588056 and type = 33
0.0145  SELECT data1 FROM stats2024 t WHERE league_id = 72394 AND teamId = 6588055 and type = 33
0.0146  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '63659' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 63659 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0145  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 63659 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0146  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 = 72394 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='63659' AND `active` = 1 AND year = 2024
0.0162  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='72394' AND relp.team_id=6588056 WHERE relp.in_squad=1 and mp.`match_id` = '63659' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0166  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='72394' AND relp.team_id=6588055 WHERE relp.in_squad=1 and mp.`match_id` = '63659' 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=63659 AND extraId = 72394 AND type_rel = 4
0.0145  SELECT * FROM futbol.calendars_lineups WHERE id = 63659 AND league_id = 72394 AND year = 2024