¿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
Notec Czarnków - Zawisza Bydgoszcz
Jornada 3
FINALIZADO
40
00
215 Pts. Elo
6º

469 Pts. Elo
9º

2-1
Sábado, 17 Agosto 2024, 16:00
0 - 1
 7' P. Skórecki
K. Magdziarz 24'
1 - 1
A. Kaczmarek 68'
2 - 1

Eventos del partido

Goles

minuto 7'P. SkóreckiGol de P. Skórecki
K. MagdziarzGol de penalti
K. Magdziarz
minuto 24'
A. KaczmarekGol de
A. Kaczmarek
minuto 68'

Tarjetas

Kacper ZaborskiT. Amarilla
Kacper Zaborski
minuto 28'
S. PiekarskiT. Amarilla
S. Piekarski
minuto 64'
B. KalupaT. Amarilla
B. Kalupa
minuto 64'
Jakub BialczykT. Amarilla
Jakub Bialczyk
minuto 75'

Cambios

minuto 46'O. GorvatEntra en el partido O. Gorvat
minuto 46'K. SanockiSale del partido K. Sanocki
Szymon RolaSale del partido
Szymon Rola
minuto 59'
minuto 59'M. MlynarczykSale del partido M. Mlynarczyk
minuto 59'Lukasz SzramowskiEntra en el partido Lukasz Szramowski
E. KrysztopowiczEntra en el partido
E. Krysztopowicz
minuto 59'
minuto 67'Jakub BojasSale del partido Jakub Bojas
minuto 67'Fabian LeonowiczEntra en el partido Fabian Leonowicz
Jan MierzwaEntra en el partido
Jan Mierzwa
minuto 70'
Jakub PoterskiSale del partido
Jakub Poterski
minuto 70'
Jakub BialczykEntra en el partido
Jakub Bialczyk
minuto 70'
Eryk KrygSale del partido
Eryk Kryg
minuto 70'
minuto 80'Sebastian RugowskiSale del partido Sebastian Rugowski
minuto 80'Maciej WanatEntra en el partido Maciej Wanat
J. OrwatEntra en el partido
J. Orwat
minuto 90'
A. KaczmarekSale del partido
A. Kaczmarek
minuto 90'

Otros

minuto 7'Jakub BojasAsistencia Jakub Bojas
K. MagdziarzAsistencia
K. Magdziarz
minuto 68'

Alineaciones

Notec Czarnków

Notec Czarnków

4-4-2
Alineación Inicial
Suplentes
Zawisza Bydgoszcz

Zawisza Bydgoszcz

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
7,112,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.9211
Total Execution Time  0.9220
  CADENA URL  
/partido/Klub-Sportowy-Notec-Czarnkow/Zawisza-Bydgoszcz
  GET DATOS  
$_GET['/partido/Klub-Sportowy-Notec-Czarnkow/Zawisza-Bydgoszcz']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0061   SELECT c.*, c.stadium as real_stadium, 2025 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2025 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Klub-Sportowy-Notec-Czarnkow' AND dt2.basealias = 'Zawisza-Bydgoszcz'
0.0026  SELECT c.*, 2025 AS year, dt1.id AS dteam1_id, dt1.nameShow AS team1_name, dt1.basealias AS team1_basealias, dt1.fullName AS team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow AS team2_name, dt2.basealias AS team2_basealias, dt2.fullName AS team2_fullName, dt2.color1 AS team2_color1, t1.name AS team1_Oname, t2.name AS team2_Oname, s.id AS stadium_id, dt1.id AS stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2025 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Klub-Sportowy-Notec-Czarnkow' AND dt2.basealias = 'Zawisza-Bydgoszcz'
0.0017  SELECT data1 FROM stats2025 t WHERE league_id = 76721 AND teamId = 6649579 and type = 33
0.0017  SELECT data1 FROM stats2025 t WHERE league_id = 76721 AND teamId = 6649592 and type = 33
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '28136' and rp.type = 2025 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 28136 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 28136 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='28136' AND `active` = 1 AND year = 2025
0.0048  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='76721' AND relp.team_id=6649579 WHERE relp.in_squad=1 and mp.`match_id` = '28136' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0055  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='76721' AND relp.team_id=6649592 WHERE relp.in_squad=1 and mp.`match_id` = '28136' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=28136 AND extraId = 76721 AND type_rel = 4
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 28136 AND league_id = 76721 AND year = 2025