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) = 'ghk rfc' or LOWER(team2) = 'ghk rfc') and competition_name not like '%(Women\'s)%' and competition_name like 'Tennent\'s West Reserve League Division 1%' and season='2021-2022') 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) order by fixture_id asc