Partido Hednesford Town - Gainsborough Trinity

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

Hednesford Town - Gainsborough Trinity Hednesford Town - Gainsborough Trinity

Fases Previas

FINALIZADO

144 Pts. Elo

43%

Hednesford Town

298 Pts. Elo

57%

Gainsborough Trinity

4(4-5)4

Sábado, 02 Noviembre 2024, 16:00

Manny Duku	4'	1 - 0
O. Holness	21'	2 - 0
D. Mchale	49'	3 - 0
		3 - 1	65'	D. Howe
		3 - 2	77'	D. Howe
		3 - 3	94'	W. Lancaster
D. Mchale	95'	4 - 3
		4 - 4	109'	J. Clarke

Eventos del partido

Goles

Gol de

Manny Duku

minuto 4'

Gol de

O. Holness

minuto 21'

Gol de

D. Mchale

minuto 49'

minuto 65'

Gol de D. Howe

minuto 77'

Gol de D. Howe

minuto 94'

Gol de W. Lancaster

Gol de

D. Mchale

minuto 95'

minuto 109'

Gol de J. Clarke

Tarjetas

minuto 9'

T. Amarilla D. Cogill

minuto 55'

T. Amarilla Sisa Tuntulwana

T. Amarilla

O. Holness

minuto 55'

T. Amarilla

J. Taylor

minuto 61'

minuto 113'

T. Amarilla Jordan Helliwell

Cambios

minuto 46'

Entra en el partido Sisa Tuntulwana

minuto 46'

Sale del partido L. Butroid

minuto 46'

Entra en el partido J. Stacey

minuto 46'

Entra en el partido B. Johnson

minuto 46'

Sale del partido B. Conway

minuto 46'

Sale del partido A. Simpson

Entra en el partido

S. Spence

minuto 66'

Sale del partido

S. Maye

minuto 66'

Entra en el partido

R. Stevenson

minuto 72'

Sale del partido

Manny Duku

minuto 72'

Entra en el partido

J. Gwilt

minuto 89'

Sale del partido

D. Trickett-Smith

minuto 89'

Sale del partido

J. Endall

minuto 91'

Entra en el partido

B. Rowe

minuto 91'

minuto 106'

Entra en el partido G. Hornshaw

Sale del partido

D. Mchale

minuto 106'

Sale del partido D. Howe

Entra en el partido

Daniel Sparkes

minuto 106'

minuto 119'

Entra en el partido J. Mcloughlin

minuto 119'

Sale del partido A. Jackson

Otros

Asistencia

D. Trickett-Smith

minuto 4'

Asistencia

Jack Bearne

minuto 49'

minuto 65'

Asistencia J. Clarke

Lesionado

Manny Duku

minuto 71'

minuto 77'

Asistencia J. Clarke

Asistencia

J. Gwilt

minuto 95'

minuto 109'

Asistencia Sisa Tuntulwana

minuto 118'

Lesionado A. Jackson

Tanda de penaltis

R. Stevenson

D. Cogill

Daniel Sparkes

Sisa Tuntulwana

Jack Bearne

B. Johnson

O. Holness

J. Stacey

J. Taylor

W. Lancaster

J. Gwilt

G. Hornshaw

S. Spence

F. Preston

E. Johnson

J. Clarke

B. Rowe

Jordan Helliwell

Alineaciones

Hednesford Town

4-4-2

Alineación Inicial

1

J. Rose
6

E. Johnson
5
91'

J. Endall
3

J. Taylor
2

K. Roberts
8

O. Holness
4
66'

S. Maye
7
89'

D. Trickett-Smith
11

Jack Bearne
9
72'

Manny Duku
10
2 106'

D. Mchale

Suplentes

19
89'

J. Gwilt
15
91'

B. Rowe
18

A. Alamu
20
66'

S. Spence
16
106'

Daniel Sparkes
17

Ryan Brown
14

Z. Sutherland
12
72'

R. Stevenson

Gainsborough Trinity

4-3-3

Alineación Inicial

1

D. Wharton
6

D. Cogill
3
119'

A. Jackson
2
46'

A. Simpson
8

Jordan Helliwell
7
46'

L. Butroid
5

W. Lancaster
4
46'

B. Conway
11

F. Preston
10
2 106'

D. Howe
9

J. Clarke

Suplentes

17

K. Simpson
18

O. Sykes
13

K. Johnson
16
106'

G. Hornshaw
15
119'

J. Mcloughlin
14
46'

J. Stacey
19
46'

Sisa Tuntulwana
12
46'

B. Johnson

Estadísticas del partido

Hednesford		Gainsborough
43%	Posesión del balón	57%
4	Goles	4
5	Tiros a puerta	10
2	Tiros fuera	5
9	Total tiros	17
6	Paradas del portero	1
4	Saques de esquina	15
2	Fueras de juego	4
0	Tarjetas Rojas	0
3	Asistencias	3
1	Lesiones	1
3	Sustituciones	3
13	Faltas	13

Otros partidos

Tonbridge Angels 1-4 Harborough Town 0

Chesterfield 3-1 Horsham 2

Stevenage 1-1 Guiseley 1

Northampton 1-2 Kettering Town 1

Solihull Moors 3-0 Maidstone United 0

Brackley Town 0-0 Braintree Town 0

Boreham Wood 2-2 Leyton Orient 4

Burton Albion 1-0 Scarborough Athletic 0

Chesham United 0-4 Lincoln City 15

Bristol Rovers 3-1 Weston-super-Mare 0

Worthing 0-2 Morecambe 1

NOTICIAS RELACIONADAS

USO DE MEMORIA

7,173,424 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Match / Index )	2.3523
Total Execution Time	2.3534

CADENA URL

/partido/Hednesford-Town/Gainsborough-Trinity/2025

GET DATOS

$_GET['/partido/Hednesford-Town/Gainsborough-Trinity/2025']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0146	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 = 'Hednesford-Town' AND dt2.basealias = 'Gainsborough-Trinity'
0.0111	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 = 'Hednesford-Town' AND dt2.basealias = 'Gainsborough-Trinity'
0.0107	SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2025 AS ev WHERE ev.match_id=216447 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.0113	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=77365 WHERE dp.id IN (345285,234115,243168,3393809,920687,3173283,642311,3626372,351071,770425,354223,3497384,393123,3356345,3348181,341887,344188,3628372,3628368,329160,711492,711509,442526,209409,1000814,471092,631201,368748,209572) AND (rp.team_id=6662141 OR rp.team_id=6662356)
0.0107	SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2025 AS ev WHERE ev.match_id=216447 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0121	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=77365 WHERE dp.id IN (345285,329160,642311,234115,3626372,354223,3497384,393123,3356345,3348181,631201,243168,351071,3173283,3393809,341887,344188,3628372,3628368,711492,711509,920687,442526,209409,770425,471092,1000814,368748,209572) AND (rp.team_id=6662141 OR rp.team_id=6662356)
0.0105	SELECT data1 FROM stats2025 t WHERE league_id = 77365 AND teamId = 6662141 and type = 33
0.0105	SELECT data1 FROM stats2025 t WHERE league_id = 77365 AND teamId = 6662356 and type = 33
0.0109	SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 77365 AND id_match = 216447
0.0138	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='77365' AND relp.team_id = drea.team_id WHERE rel.team_number=5682218 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0126	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='77365' AND relp.team_id = drea.team_id WHERE rel.team_number=5682362 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0246	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='77365' AND relp.team_id=6662141 WHERE mp.`match_id` = '216447' AND mp.year='2025' AND p.id NOT IN (244141,209572,711492,351071,336703,234115,344188,329160,631201,345285,243168,870083,642311,471092,3348181,770425,354223,920687,3356345,368748,3393809,3173283) ORDER BY mp.`team` ASC, p.`role` ASC
0.0134	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='77365' AND relp.team_id=6662356 WHERE mp.`match_id` = '216447' AND mp.year='2025' AND p.id NOT IN (244141,209572,711492,351071,336703,234115,344188,329160,631201,345285,243168,870083,642311,471092,3348181,770425,354223,920687,3356345,368748,3393809,3173283) ORDER BY mp.`team` ASC, p.`role` ASC
0.0108	SELECT kit FROM kit_data_real WHERE league_id = 77365 AND id_match = 216447
0.0106	SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '216447' and rp.type = 2025 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0107	SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '216447' and rp.type = 2025 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0107	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 = 77365 AND rel.team1 = 6662141 AND rel.team2 = 6662356 ORDER BY FIELD(m.location,'es','en') DESC
0.0106	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 216447 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0105	SELECT iframe, title FROM futbol.match_videos WHERE matchId = 216447 AND year = 2025 AND channel = 'Footters' LIMIT 1
0.0108	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 = 77365 AND rel.team1 = 6662141 AND rel.team2 = 6662356 ORDER BY FIELD(m.location,'es','en') DESC
0.0105	SELECT teamId FROM teams WHERE id = 6662356
0.0105	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2025 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2025 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 = 11172 OR c.datateam2 = 11172) ORDER BY shedule DESC LIMIT 10
0.0113	SELECT teamId FROM teams WHERE id = 6662356
0.0107	SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2025 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2025 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 = 11172 OR c.datateam2 = 11172) ORDER BY shedule ASC LIMIT 10
0.0107	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 `calendars2025` 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` = 77365 AND c.`round` = 7 ORDER BY c.type ASC,((c.team1c.team1)+(c.team2c.team2)) ASC,shedule ASC LIMIT 12
0.0116	SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2025` WHERE league_id = 77365 AND round >= 11 AND round <= 11 AND team = 6662141 ORDER BY round ASC
0.0109	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2025` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 77365 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107	SELECT dr.name as showName, dr2.name as referee_var FROM calendars2025 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2025 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=2025 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 6662141 AND c.team2 = 6662356 AND c.league_id = 77365
0.0165	SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='216447' AND `active` = 1 AND year = 2025
0.0131	SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='216447' AND `active` = 1 AND year = 2025
0.0107	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='77365' AND relp.team_id=6662141 WHERE relp.in_squad=1 and mp.`match_id` = '216447' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0107	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='77365' AND relp.team_id=6662356 WHERE relp.in_squad=1 and mp.`match_id` = '216447' AND mp.year='2025' ORDER BY mp.`team` ASC, p.`role` ASC
0.0109	SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '77365' AND id_match = '216447'
0.0106	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 = '5682218' ORDER BY rating DESC LIMIT 1
0.0106	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 = '5682362' ORDER BY rating DESC LIMIT 1
0.0166	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=216447 AND extraId = 77365 AND type_rel = 4
0.0122	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=139 AND type_rel = 3
0.0108	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 139 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0109	SELECT /53 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1347731,1347423,1347260,1347248,1347189) ORDER BY n.cover_points DESC, update_date DESC
0.0107	SELECT rating1, rating2 FROM calendars_elo WHERE id=216447 AND league_id=77365 AND year=2025
0.0106	SELECT avg_rating FROM elo_teams WHERE id=11172
0.0105	SELECT position FROM tables2025 WHERE team=6662141 AND league_id=77365 AND round=7
0.0105	SELECT position FROM tables2025 WHERE team=6662356 AND league_id=77365 AND round=7
0.0105	SELECT * FROM futbol.calendars_lineups WHERE id = 216447 AND league_id = 77365 AND year = 2025


	¡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

Otros

Tanda de penaltis

Alineaciones

Alineación Inicial

Suplentes

Alineación Inicial

Suplentes

Estadísticas del partido

Posesión del balón

Goles

Tiros a puerta

Tiros fuera

Total tiros

Paradas del portero

Saques de esquina

Fueras de juego

Tarjetas Rojas

Asistencias

Lesiones

Sustituciones

Faltas

Otros partidos

LIGAS RELACIONADAS

NOTICIAS RELACIONADAS