Most of us will probably be trying to have a bit of a rest at this time of year – but not GHK’s Niall Hall as, starting on 21st December, he’s running a 10K on each of the last 10 days of the year to raise money for mental health charity Mental Health Aberdeen.
Niall (on the right) receiving his Edinburgh Gin GHK Player of the Match Award from back in the day when we played rugby!
SELECT
r.id AS fixture_id,
r.competition_name,
r.date,
r.time,
r.team1,
r.team2,
r.season,
l1.image AS team1_logo,
l2.image AS team2_logo
FROM wp_e1b349da27_fixtures r
LEFT JOIN wp_e1b349da27_team_logo l1
ON LOWER(r.team1) = LOWER(l1.name)
LEFT JOIN wp_e1b349da27_team_logo l2
ON LOWER(r.team2) = LOWER(l2.name)
INNER JOIN wp_e1b349da27_crawler_index ci
ON r.id >= ci.start_id
AND r.id <= ci.end_id
AND ci.table_name = 'wp_e1b349da27_fixtures'
WHERE (LOWER(r.team1) LIKE LOWER('ghk %') OR LOWER(r.team2) LIKE LOWER('ghk %')) AND r.competition_name NOT LIKE '%(Women\'s)%' AND r.competition_name LIKE '%National League Division 1%' AND r.season = '2026-2027' AND r.id >= ci.start_id AND r.id <= ci.end_id AND ci.table_name = 'wp_e1b349da27_fixtures' AND STR_TO_DATE(ci.crawl_date, '%Y-%m-%dT%T') = (
SELECT MAX(STR_TO_DATE(crawl_date, '%Y-%m-%dT%T'))
FROM wp_e1b349da27_crawler_index
WHERE start_id > 0 AND end_id > 0
)
ORDER BY r.id ASC
LIMIT 1
