Arrangements for the memorial service for former GHSFP RFC player and Scottish Internationalist Bill Black are as below:
BLACK WILLIAM POLLOK, aged 91, dearly loved father, died peacefully with his family in Tunbridge Wells, on 9th May, 2019. He is predeceased by his second wife Patricia and survived by his first wife, Marie and daughters, Marie and Gillian. Grandpa to Christopher and Andrew. Great-grandpa to Max and Alice. There will be a private cremation in Tunbridge Wells on 14th June, 2019. The family would like to invite all Bill’s relatives, friends and colleagues to a celebration of his life at a Memorial Service at Kelvinside Hillhead Parish Church, Saltoun Street, Glasgow, on Friday, 5th July at 3pm. All welcome. Family flowers only.
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
