GHK Rugby Club would like to wish you all a very Merry Christmas and a Happy New Year! Thank you to all our supporters, sponsors, bar staff, groundsmen, coaches, physios, players, bufties, social members and those who have been loyal to the club this year. We greatly value your continued support and friendship. Just to note that theclub bar will also be shut during the festive period and will reopen on the 5th January. See you all in 2024! #weareghk
SELECT * FROM (SELECT a.*, l.image as team2_logo
FROM (
SELECT r.id as fixture_id, r.competition_name, r.date, r.time, r.team1, r.team2, r.season, l.image as team1_logo
FROM wp_e1b349da27_fixtures r LEFT JOIN wp_e1b349da27_team_logo l on LOWER(r.team1) = LOWER(l.name)
) as a LEFT JOIN wp_e1b349da27_team_logo l on LOWER(a.team2) = LOWER(l.name)
WHERE (LOWER(team1) like 'ghk %' or LOWER(team2) like 'ghk %') and competition_name not like '%(Women\'s)%' and competition_name like 'National League Division 1%' and season='2023-2024') tb, wp_e1b349da27_crawler_index ci WHERE tb.fixture_id >= ci.start_id and tb.fixture_id <= ci.end_id and table_name = "wp_e1b349da27_fixtures" and STR_TO_DATE(ci.crawl_date, "%Y-%m-%dT%T") in (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 fixture_id asc limit 1
Thank you to all our supporters, sponsors, bar staff, groundsmen, coaches, physios, players, bufties, social members and those who have been loyal to the club this year. We greatly value your continued support and friendship. 
Just to note that the club bar will also be shut during the festive period and will reopen on the 5th January. 
See you all in 2024! 
#weareghk