Rowing and Rugby Social with special guests BROAR In association with Campbell Dallas
GHK are hosting a pre-match Business Social and informal lunch with presentation from BROAR (The Talisker Whisky Atlantic Challenge.) MC and Q & A will be led by Glasgow Warriors’ very own Chris Fusaro So come and join us from 1pm onwards to meet and network with fellow sponsors, business contacts and Club supporters and stay for GHK V Newton Stewart 3pm KO. Meet the BROAR brothers; former GHK 1st XV Jamie MacLean and brothers Ewan and Lachlan to hear for yourself how their training and preparations are coming along as well as getting to check out the very boat they will row across the Atlantic! At just £20 a head contact us now to secure a place for you, your colleagues, clients and contacts. FOR TICKETS ewancameron36@gmail.com
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
