Partido B. Leverkusen - Venezia | Partidos Amistosos

Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

B. Leverkusen - Venezia B. Leverkusen - Venezia

Jornada 221

FINALIZADO

3271 Pts. Elo

B. Leverkusen

1326 Pts. Elo

Venezia

4-1

Domingo, 07 Enero 2024, 15:00

Adam Hložek	16'	1 - 0
Adam Hložek	20'	2 - 0
Patrik Schick	33'	3 - 0
J. Hofmann	55'	4 - 0
		4 - 1	78'	Marco Olivieri

B. Leverkusen

3-4-3

Alineación Inicial

17
74'

Matěj Kovář
3
65'

P. Hincapié
4
81'

Jonathan Tah
20
64'

A. Grimaldo
8
81'

Robert Andrich
25
65'

E. Palacios
34
65'

Granit Xhaka
10
64'

Florian Wirtz
19
46'

Nathan Tella
14
46'

Patrik Schick
23
2 64'

Adam Hložek

Suplentes

36
74'

Niklas Lomb
30
46'

J. Frimpong
48
64'

Reno Münz
24
65'

T. Fosu-Mensah
31
81'

M. Monamay
27
81'

Filip Milojevic
11
64'

N. Amiri
32
64'

Gustavo Puerta
18
65'

Noah Mbamba
F. Onyeka
47

Ayman Aourir
7
46'

J. Hofmann
38
65'

Ken Izekor

Venezia

4-5-1

Alineación Inicial

1
74'

J. Joronen
33
46'

M. Sverko
15
74'

Giorgio Altare
25
46'

Ali Dembélé
30

M. Svoboda
38
46'

M. Kofod Andersen
18
46'

M. Jajalo
77
46'

M. Ellertsson
10
46'

N. Pierini
19
46'

B. Bjarkason
20
46'

J. Pohjanpalo

Suplentes

23
74'

M. Grandi
12

Bruno
60

Lorenzo Busato
7
46'

F. Zampano
27
46'

A. Candela
13
74'

M. Modolo
6
46'

Gianluca Busio
24
46'

N. Lella
8
46'

T. Tessmann
99
46'

Marco Olivieri
17
46'

D. Johnsen
9
46'

C. Gytkjaer

Eventos del partido

Goles

Gol de

Adam Hložek

minuto 16'

Gol de

Adam Hložek

minuto 20'

Gol de

Patrik Schick

minuto 33'

Gol de

J. Hofmann

minuto 55'

minuto 78'

Gol de Marco Olivieri

Tarjetas

minuto 29'

T. Amarilla M. Ellertsson

Cambios

Sale del partido

Nathan Tella

minuto 46'

Sale del partido

Patrik Schick

minuto 46'

Entra en el partido

J. Hofmann

minuto 46'

Entra en el partido

J. Frimpong

minuto 46'

Entra en el partido F. Zampano

minuto 46'

Sale del partido M. Sverko

minuto 46'

Sale del partido Ali Dembélé

minuto 46'

Entra en el partido A. Candela

minuto 46'

Entra en el partido T. Tessmann

minuto 46'

Entra en el partido N. Lella

minuto 46'

Entra en el partido D. Johnsen

minuto 46'

Sale del partido M. Jajalo

minuto 46'

Sale del partido M. Ellertsson

minuto 46'

Entra en el partido Gianluca Busio

minuto 46'

Sale del partido B. Bjarkason

minuto 46'

Sale del partido M. Kofod Andersen

minuto 46'

Sale del partido J. Pohjanpalo

minuto 46'

Sale del partido N. Pierini

minuto 46'

Entra en el partido Marco Olivieri

minuto 46'

Sale del partido J. Joronen

minuto 74'

Entra en el partido M. Grandi

minuto 74'

Entra en el partido M. Modolo

minuto 74'

Sale del partido Giorgio Altare

Sale del partido

Jonathan Tah

minuto 81'

Entra en el partido

M. Monamay

minuto 81'

Entra en el partido

Filip Milojevic

minuto 81'

Sale del partido

Robert Andrich

minuto 81'

Otros

Asistencia

Nathan Tella

minuto 20'

Asistencia

Florian Wirtz

minuto 33'

Estadísticas del partido

Leverkusen		Venezia
4	Goles	1
0	Tarjetas Amarillas	1
0	Tarjetas Rojas	0
2	Asistencias	0
3	Sustituciones	3

0 Comentarios

No hay comentarios

NOTICIAS RELACIONADAS

Ver otras noticias destacadas »

Otros partidos

Mazatlán 1-2 Monterrey 76

ADO Den Haag 0-2 Como 1

Hertha Berlin II 3-1 CFC Hertha 06 1

Eldense 0-1 Twente 75

PSV 1-1 Heracles 54

VVV Venlo 3-0 Lommel SK 1

FC Wil 0-5 Grasshopper 7

Universitatea Cluj 1-0 Kocaelispor 1

Ajax 2-1 Hannover 96 26

JIPPO Joensuu 5-0 LehPa 1

Botafogo SP 2-1 Noroeste 2

Sprockhövel 1-2 Wuppertaler SV 2

USO DE MEMORIA

7,116,416 bytes

BENCHMARKS

Loading Time Base Classes	0.0010
Controller Execution Time ( Match / Index )	0.9906
Total Execution Time	0.9916

CADENA URL

/partido/Bayer-Leverkusen/Venezia/2024

GET DATOS

$_GET['/partido/Bayer-Leverkusen/Venezia/2024']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.2159	SELECT COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`league_id` = '71432' AND c.`match_id` = '657410'
0.0063	SELECT c., c.stadium as real_stadium, 2024 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* calendars2024 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 = 'Bayer-Leverkusen' AND dt2.basealias = 'Venezia'
0.0029	SELECT c., 2024 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* calendars2024 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 = 'Bayer-Leverkusen' AND dt2.basealias = 'Venezia'
0.0019	SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2024 AS ev WHERE ev.match_id=657410 ORDER BY (ev.action=1 OR ev.action=2 OR ev.action=6 OR ev.action=11 OR ev.action=12 OR ev.action=13) DESC,(ev.action=3 OR ev.action=4 OR ev.action=5) DESC,(ev.action=14 OR ev.action=15 OR ev.action=16 OR ev.action=17 OR ev.action=21) DESC,(ev.action=18 OR ev.action=19) DESC,(ev.action=20 OR ev.action=22) DESC, minute ASC, ev.real_date ASC, ev.id DESC, ev.action DESC
0.0034	SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=71432 WHERE dp.id IN (502294,216945,128290,319387,678168,369727,427277,203064,295998,3212611,347693,859987,448512,360912,26943,596760,662356,385421,182313,312621,216045,3171990,825895,264433,1013847,118948,295795,924438,851488,314997,67187,3190831,146769,637644,182301,207245,192798,376752,186542,3197409,973334,202152) AND (rp.team_id=6578674 OR rp.team_id=6585510)
0.0019	SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2024 AS ev WHERE ev.match_id=657410 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0028	SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=71432 WHERE dp.id IN (502294,369727,678168,216945,825895,128290,427277,203064,295998,3212611,347693,859987,448512,360912,26943,596760,662356,385421,182313,312621,319387,216045,3171990,264433,1013847,118948,295795,924438,851488,314997,67187,3190831,146769,637644,182301,207245,192798,376752,186542,3197409,973334,202152) AND (rp.team_id=6578674 OR rp.team_id=6585510)
0.0018	SELECT data1 FROM stats2024 t WHERE league_id = 71432 AND teamId = 6578674 and type = 33
0.0019	SELECT data1 FROM stats2024 t WHERE league_id = 71432 AND teamId = 6585510 and type = 33
0.0018	SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 71432 AND id_match = 657410
0.0022	SELECT rel.,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='71432' AND relp.team_id = drea.team_id WHERE rel.team_number=5132852 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0024	SELECT rel.,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='71432' AND relp.team_id = drea.team_id WHERE rel.team_number=5132851 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0085	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='71432' AND relp.team_id=6578674 WHERE mp.`match_id` = '657410' AND mp.year='2024' AND p.id NOT IN (182301,295998,376752,3212611,397962,385421,26943,678168,312621,662356,182313,637644,851488,186542,118948,202152,295795,67187,825895,369727,216945,502294) ORDER BY mp.`team` ASC, p.`role` ASC
0.0091	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='71432' AND relp.team_id=6585510 WHERE mp.`match_id` = '657410' AND mp.year='2024' AND p.id NOT IN (182301,295998,376752,3212611,397962,385421,26943,678168,312621,662356,182313,637644,851488,186542,118948,202152,295795,67187,825895,369727,216945,502294) ORDER BY mp.`team` ASC, p.`role` ASC
0.0019	SELECT kit FROM kit_data_real WHERE league_id = 71432 AND id_match = 657410
0.0020	SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '657410' and rp.type = 2024 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021	SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '657410' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021	SELECT ,rel.id as rel_id FROM* `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='10' AND rel.active = 1 AND rel.league_id = 71432 AND rel.team1 = 6578674 AND rel.team2 = 6585510 ORDER BY FIELD(m.location,'es','en') DESC
0.0018	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 657410 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 657410 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0021	SELECT ,rel.id as rel_id FROM* `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='11' AND rel.active = 1 AND rel.league_id = 71432 AND rel.team1 = 6578674 AND rel.team2 = 6585510 ORDER BY FIELD(m.location,'es','en') DESC
0.0018	SELECT teamId FROM teams WHERE id = 6578674
0.0018	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2024 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2024 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 != 99 or c.r2 != 99) AND (c.datateam1 = 3668 OR c.datateam2 = 3668) ORDER BY shedule DESC LIMIT 10
0.0018	SELECT teamId FROM teams WHERE id = 6585510
0.0018	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2024 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2024 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 != 99 or c.r2 != 99) AND (c.datateam1 = 2673 OR c.datateam2 = 2673) ORDER BY shedule DESC LIMIT 10
0.0024	SELECT teamId FROM teams WHERE id = 6578674
0.0018	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2024 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2024 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 = 99 or c.r2 = 99) AND (c.datateam1 = 3668 OR c.datateam2 = 3668) ORDER BY shedule ASC LIMIT 10
0.0019	SELECT teamId FROM teams WHERE id = 6585510
0.0018	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2024 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2024 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 = 99 or c.r2 = 99) AND (c.datateam1 = 2673 OR c.datateam2 = 2673) ORDER BY shedule ASC LIMIT 10
0.0017	SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2, c.shedule,c.id, c.r1, c.r2, c.round, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.comments,c.league_id FROM `calendars2024` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 71432 AND c.`round` = 221 ORDER BY shedule ASC LIMIT 12
0.0104	SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2024` WHERE league_id = 71432 AND round >= 335 AND round <= 335 AND team = 6578674 ORDER BY round ASC
0.0099	SELECT dr.name as showName, dr2.name as referee_var FROM calendars2024 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2024 and r.role=1 INNER JOIN datareferees dr on dr.id=r.referee_id INNER JOIN rel_calendars_referee as r2 ON c.id = r2.match_id and r2.year=2024 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 6578674 AND c.team2 = 6585510 AND c.league_id = 71432
0.0020	SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='657410' AND `active` = 1 AND year = 2024
0.0018	SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='657410' AND `active` = 1 AND year = 2024
0.0018	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='71432' AND relp.team_id=6578674 WHERE relp.in_squad=1 and mp.`match_id` = '657410' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018	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='71432' AND relp.team_id=6585510 WHERE relp.in_squad=1 and mp.`match_id` = '657410' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018	SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '71432' AND id_match = '657410'
0.0018	SELECT rel., dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '5132852' ORDER BY rating DESC LIMIT 1
0.0018	SELECT rel., dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM* rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '5132851' ORDER BY rating DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=657410 AND extraId = 71432 AND type_rel = 4
0.0018	SELECT rating1, rating2 FROM calendars_elo WHERE id=657410 AND league_id=71432 AND year=2024
0.0018	SELECT position FROM tables2024 WHERE team=6578674 AND league_id=71432 AND round=221
0.0018	SELECT position FROM tables2024 WHERE team=6585510 AND league_id=71432 AND round=221
0.0018	SELECT * FROM futbol.calendars_lineups WHERE id = 657410 AND league_id = 71432 AND year = 2024


	¡Vas a denunciar un contenido! x Denuncia sólo contenidos que incumplan nuestras Normas de uso o conducta. Aunque revisamos todas las denuncias que nos llegan, sólo respondemos si procede. El uso indebido de esta herramienta también incumple las normas de conducta. Elige una de las siguientes opciones: Incumplimiento de las normas: Otra:

Alineación Inicial

Suplentes

Alineación Inicial

Suplentes

Eventos del partido

Goles

Tarjetas

Cambios

Otros

Estadísticas del partido

Goles

Tarjetas Amarillas

Tarjetas Rojas

Asistencias

Sustituciones

NOTICIAS RELACIONADAS

Otros partidos

LIGAS RELACIONADAS