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 '%Inter City Reserve League Division 2%' 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