4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Trefelin - Llantwit Major
Jornada 6
FINALIZADO
50
20
71 Pts. Elo
14º

172 Pts. Elo
13º

3-3
Sábado, 09 Septiembre 2023, 15:30
0 - 1
 29' J. Woodington
A. Hillier 29'
1 - 1
1 - 2
 43' M. Kimmins
J. Bevan 56'
2 - 2
2 - 3
 79' M. Kimmins
C. Woods 84'
3 - 3

Eventos del partido

Goles

minuto 29'J. WoodingtonGol de J. Woodington
A. HillierGol de
A. Hillier
minuto 29'
minuto 43'M. KimminsGol de M. Kimmins
J. BevanGol de
J. Bevan
minuto 56'
minuto 79'M. KimminsGol de M. Kimmins
C. WoodsGol de
C. Woods
minuto 84'

Tarjetas

minuto 58'Sam GoodwinT. Amarilla Sam Goodwin
C. WoodsT. Amarilla
C. Woods
minuto 59'
minuto 89'M. KimminsT. Amarilla M. Kimmins
L. GibbsT. Amarilla
L. Gibbs
minuto 89'
C. SaundersT. Amarilla
C. Saunders
minuto 89'
C. WilliamsT. Amarilla
C. Williams
minuto 89'
Finley HaymanT. Amarilla
Finley Hayman
minuto 99'

Ocasiones

minuto 91'Rob JonesPenalti fallado Rob Jones

Cambios

M. ColeyEntra en el partido
M. Coley
minuto 67'
L. RobinsonSale del partido
L. Robinson
minuto 67'
minuto 77'Tom WalbeoffEntra en el partido Tom Walbeoff
minuto 77'Nathan EvansSale del partido Nathan Evans
minuto 77'J. MorganSale del partido J. Morgan
minuto 77'C. PearceEntra en el partido C. Pearce
Jordan DaviesSale del partido
Jordan Davies
minuto 81'
J. BevanSale del partido
J. Bevan
minuto 81'
Finley HaymanEntra en el partido
Finley Hayman
minuto 81'
D. EdwardsEntra en el partido
D. Edwards
minuto 81'
minuto 86'N. RenfreeEntra en el partido N. Renfree
minuto 86'J. WoodingtonSale del partido J. Woodington

Alineaciones

Trefelin

Trefelin

4-3-3
Alineación Inicial
Suplentes
Llantwit Major

Llantwit Major

4-5-1
Alineación Inicial
Suplentes

Estadísticas del partido

Trefelin Trefelin Llantwit Major Llantwit
3
Goles
 3
1
Tarjetas Rojas
 0
3
Sustituciones
 3


  USO DE MEMORIA  
6,895,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.6324
Total Execution Time  0.6334
  CADENA URL  
/partido/Trefelin/Llantwit-Major
  GET DATOS  
$_GET['/partido/Trefelin/Llantwit-Major']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0128  SELECT data1 FROM stats2024 t WHERE league_id = 72374 AND teamId = 6587849 and type = 33
0.0128  SELECT data1 FROM stats2024 t WHERE league_id = 72374 AND teamId = 6587850 and type = 33
0.0132  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '55568' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0131  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 55568 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0132  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 55568 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0133  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` = 72374 AND c.`round` = 6 ORDER BY shedule ASC LIMIT 12
0.0132  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 `tables2024` 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 = 72374 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='55568' AND `active` = 1 AND year = 2024
0.0178  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='72374' AND relp.team_id=6587849 WHERE relp.in_squad=1 and mp.`match_id` = '55568' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0140  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='72374' AND relp.team_id=6587850 WHERE relp.in_squad=1 and mp.`match_id` = '55568' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=55568 AND extraId = 72374 AND type_rel = 4
0.0124  SELECT * FROM futbol.calendars_lineups WHERE id = 55568 AND league_id = 72374 AND year = 2024