GHK and our good friends at Hearts+Balls would like to thank our respective sponsors and supporters and are delighted to extend an invitation for you to join us on Zoom at 7pm Thursday 22nd April 2021 for a complimentary Whisky Tasting evening, hosted and supported by Douglas Laing & Co. We are very grateful to Stuart Baxter and the team at Douglas Laing for their generosity, which is much appreciated.
There is no charge for this event, and those attending will also be entered into a raffle for a bottle of one of Douglas Laing’s special malt whiskies..
Places are limited and going quickly, so please contact GHK President, Ewan Cameron at (ewancameron36@gmail.com) as soon as possible and no later than 10th April, to book your place.
Confirmed applicants will receive a box of five whisky samples, delivered to their preferred address by Douglas Laing & Co, who will also e-mail their zoom link a few days in advance, to access the event.
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
