It is with profound sadness and shock that we learned that Jim had died early this morning in hospital. He was not only a much-loved club member and supporter of GHK, but an inspiration to all who were lucky enough to know Jim. Love to Sandra. Rest easy, Jim.
A fuller tribute will be posted here together with funeral arrangements in due course.
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
