Partido Örgryte - Häcken | Partidos Amistosos 2023

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

Örgryte - Häcken Örgryte - Häcken

Jornada 16

FINALIZADO

628 Pts. Elo

Örgryte

1817 Pts. Elo

Häcken

2-2

Lunes, 20 Junio 2022, 14:00

N. Bärkroth	1'	1 - 0
		1 - 1	12'	Mikkel Rygaard
K. Ackermann	13'	2 - 1
		2 - 2	58'	A. Jeremejeff

Eventos del partido

Goles

Gol de

N. Bärkroth

minuto 1'

minuto 12'

Gol de Mikkel Rygaard

Gol de

K. Ackermann

minuto 13'

minuto 58'

Gol de penalti A. Jeremejeff

Tarjetas

T. Amarilla

K. Ackermann

minuto 38'

minuto 87'

2a Amarilla y Roja S. Lagerlund

Cambios

minuto 46'

Entra en el partido V. Friðriksson

minuto 46'

Sale del partido T. Totland

minuto 46'

Entra en el partido K. Hodzic

minuto 46'

Sale del partido K. Lund

Entra en el partido

A. Lans

minuto 47'

Sale del partido

J. Azulay

minuto 47'

Entra en el partido

A. Andreasson

minuto 47'

Sale del partido

E. Nohlgren

minuto 47'

Entra en el partido

I. Dahlqvist

minuto 47'

Sale del partido

H. Dahlqvist

minuto 47'

Entra en el partido

Olle Johansson

minuto 47'

Sale del partido

M. Haglind Sangre

minuto 47'

Entra en el partido

A. Raskaj

minuto 47'

Sale del partido

K. Ackermann

minuto 47'

Entra en el partido

A. Brorsson

minuto 50'

Sale del partido

N. Bärkroth

minuto 50'

minuto 59'

Entra en el partido Ibrahim Sadiq

minuto 59'

Sale del partido O. Uddenäs

minuto 59'

Entra en el partido Blair Turgott

minuto 59'

Sale del partido A. Jeremejeff

minuto 59'

Entra en el partido Ali Youssef

minuto 59'

Sale del partido L. Bengtsson

minuto 70'

Entra en el partido Semir Bosnic

minuto 70'

Sale del partido J. Hammar

minuto 70'

Entra en el partido F. Tebo

minuto 70'

Sale del partido Mikkel Rygaard

Entra en el partido

Hugo Hultberg

minuto 76'

Sale del partido

A. Zeljkovic

minuto 76'

Entra en el partido

Jonatan Vennberg

minuto 76'

Sale del partido

D. Paulson

minuto 76'

Entra en el partido

S. Abraham

minuto 76'

Sale del partido

Gustafson

minuto 76'

Alineaciones

Örgryte

4-4-2

Alineación Inicial

13

Robin Wallinder
3
47'

J. Azulay
17
47'

H. Dahlqvist
22
47'

M. Haglind Sangre
10
47'

K. Ackermann
11
76'

Gustafson
6
47'

E. Nohlgren
14
76'

D. Paulson
8
50'

N. Bärkroth
16

A. Holmström
9
76'

A. Zeljkovic

Suplentes

5
47'

A. Lans
2
50'

A. Brorsson
19
47'

A. Andreasson
27
76'

Hugo Hultberg
21
47'

A. Raskaj
2
76'

Jonatan Vennberg
15
47'

I. Dahlqvist
20
47'

Olle Johansson
30

A. Skoglund
19

M. Said Adan
25
76'

S. Abraham

Häcken

4-4-2

Alineación Inicial

23

J. Rasheed
3
70'

J. Hammar
5

E. Hovland
25
46'

K. Lund
2
46'

T. Totland
17

G. Berggren
6

A. Faltsetas
18
70'

Mikkel Rygaard
7
59'

L. Bengtsson
9
59'

A. Jeremejeff
19
59'

O. Uddenäs

Suplentes

26

P. Abrahamsson
12
46'

V. Friðriksson
33

S. Lagerlund
15
46'

K. Hodzic
4
70'

F. Tebo
70'

Semir Bosnic
37
59'

Ibrahim Sadiq
20
59'

Blair Turgott
10
59'

Ali Youssef

Estadísticas del partido

Örgryte		Häcken
2	Goles	2
3	Tarjetas Amarillas	4
0	Tarjetas Rojas	1
3	Sustituciones	3

Otros partidos

América 1-3 Pumas UNAM 15

Torpedo Moscow 2-1 Yenisey 1

Volga Ulyanovsk 2-1 KamAZ 0

MFK Dukla 3-2 Trenčín 2

Rubin Kazán 1-0 Akron Tolyatti 8

Dalkurd FF 1-3 Östersunds FK 0

Torpedo Moscow 3-1 Tekstilshchik 0

SV Lafnitz 1-2 FC Arges 35

SKA-Khabarovsk 0-2 Yenisey 0

Malmö FF 2-0 IFK Trelleborg 31

ND Gorica 5-0 FK Rudar Pljevlja 0

NOTICIAS RELACIONADAS

Ver otras noticias destacadas »

USO DE MEMORIA

6,976,944 bytes

BENCHMARKS

Loading Time Base Classes	0.0010
Controller Execution Time ( Match / Index )	1.0723
Total Execution Time	1.0733

CADENA URL

/partido/Orgryte/Hacken/2001?section=legal

GET DATOS

$_GET['/partido/Orgryte/Hacken/2001']
$_GET['section']	legal

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0149	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 = 'Orgryte' AND dt2.basealias = 'Hacken'
0.0360	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 = 'Orgryte' AND dt2.basealias = 'Hacken'
0.0170	SELECT c., c.stadium as real_stadium, 2023 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* calendars2023 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 = 'Orgryte' AND dt2.basealias = 'Hacken'
0.0133	SELECT c., 2023 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* calendars2023 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 = 'Orgryte' AND dt2.basealias = 'Hacken'
0.0127	SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2023 AS ev WHERE ev.match_id=29576 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.0135	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=67320 WHERE dp.id IN (212320,213770,398151,213318,892609,618043,325581,289562,709605,217263,212691,215812,447752,889819,374222,3181685,226998,224188,211809,447144,796435,212489,699266,350263,3181709,183926,907559,3181674,370827,3211840,218706,304558,381705) AND (rp.team_id=6519127 OR rp.team_id=6518272)
0.0126	SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2023 AS ev WHERE ev.match_id=29576 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0133	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=67320 WHERE dp.id IN (212320,213770,398151,618043,325581,289562,709605,217263,212691,215812,447752,889819,374222,3181685,226998,224188,211809,213318,447144,796435,212489,699266,350263,3181709,183926,907559,3181674,370827,3211840,218706,304558,381705,892609) AND (rp.team_id=6519127 OR rp.team_id=6518272)
0.0125	SELECT data1 FROM stats2023 t WHERE league_id = 67320 AND teamId = 6519127 and type = 33
0.0125	SELECT data1 FROM stats2023 t WHERE league_id = 67320 AND teamId = 6518272 and type = 33
0.0130	SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 67320 AND id_match = 29576
0.0154	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='67320' AND relp.team_id = drea.team_id WHERE rel.team_number=4065140 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0155	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='67320' AND relp.team_id = drea.team_id WHERE rel.team_number=4065141 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0267	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='67320' AND relp.team_id=6519127 WHERE mp.`match_id` = '29576' AND mp.year='2023' AND p.id NOT IN (699256,212691,374222,226998,398151,381705,447752,218706,212320,699339,370827,233900,183926,219400,709605,325581,277239,211900,213770,350263,213318,796435) ORDER BY mp.`team` ASC, p.`role` ASC
0.0287	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='67320' AND relp.team_id=6518272 WHERE mp.`match_id` = '29576' AND mp.year='2023' AND p.id NOT IN (699256,212691,374222,226998,398151,381705,447752,218706,212320,699339,370827,233900,183926,219400,709605,325581,277239,211900,213770,350263,213318,796435) ORDER BY mp.`team` ASC, p.`role` ASC
0.0130	SELECT kit FROM kit_data_real WHERE league_id = 67320 AND id_match = 29576
0.0129	SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '29576' and rp.type = 2023 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0131	SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '29576' and rp.type = 2023 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0132	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 = 67320 AND rel.team1 = 6519127 AND rel.team2 = 6518272 ORDER BY FIELD(m.location,'es','en') DESC
0.0127	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 29576 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0129	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 29576 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0136	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 = 67320 AND rel.team1 = 6519127 AND rel.team2 = 6518272 ORDER BY FIELD(m.location,'es','en') DESC
0.0128	SELECT teamId FROM teams WHERE id = 6519127
0.0127	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2023 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2023 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 = 3045 OR c.datateam2 = 3045) ORDER BY shedule DESC LIMIT 10
0.0143	SELECT teamId FROM teams WHERE id = 6519127
0.0127	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2023 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2023 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 = 3045 OR c.datateam2 = 3045) ORDER BY shedule ASC LIMIT 10
0.0135	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 `calendars2023` 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` = 67320 AND c.`round` = 16 ORDER BY shedule ASC LIMIT 12
0.0129	SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2023` WHERE league_id = 67320 AND round >= 262 AND round <= 262 AND team = 6519127 ORDER BY round ASC
0.0128	SELECT dr.name as showName, dr2.name as referee_var FROM calendars2023 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2023 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=2023 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 6519127 AND c.team2 = 6518272 AND c.league_id = 67320
0.0403	SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='29576' AND `active` = 1 AND year = 2023
0.0257	SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='29576' AND `active` = 1 AND year = 2023
0.0127	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='67320' AND relp.team_id=6519127 WHERE relp.in_squad=1 and mp.`match_id` = '29576' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0127	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='67320' AND relp.team_id=6518272 WHERE relp.in_squad=1 and mp.`match_id` = '29576' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0127	SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '67320' AND id_match = '29576'
0.0127	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 = '4065140' ORDER BY rating DESC LIMIT 1
0.0131	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 = '4065141' ORDER BY rating DESC LIMIT 1
0.0128	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=29576 AND extraId = 67320 AND type_rel = 4
0.0128	SELECT rating1, rating2 FROM calendars_elo WHERE id=29576 AND league_id=67320 AND year=2023
0.0125	SELECT position FROM tables2023 WHERE team=6519127 AND league_id=67320 AND round=16
0.0125	SELECT position FROM tables2023 WHERE team=6518272 AND league_id=67320 AND round=16
0.0125	SELECT * FROM futbol.calendars_lineups WHERE id = 29576 AND league_id = 67320 AND year = 2023


	¡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:

Eventos del partido

Goles

Tarjetas

Cambios

Alineaciones

Alineación Inicial

Suplentes

Alineación Inicial

Suplentes

Estadísticas del partido

Goles

Tarjetas Amarillas

Tarjetas Rojas

Sustituciones

Otros partidos

LIGAS RELACIONADAS

NOTICIAS RELACIONADAS