A wee reminder that it’s this Sunday, 13th December, we’re collecting donations for the Glasgow North West Foodbank. All details as below.
GHK Rugby Club playing our part
The pandemic has hit us hard, but some more than others. As a club with a strong community spirit, GHK Rugby Club is running a food bank drive on behalf of the Glasgow North West Food Bank, and we’re asking for donations to be brought along to training on Sunday 13th December 2020. Recommended donations can be found here, but cash is also welcome. All club members and supporters are encouraged to support this initiative.
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
