WPTC articles with potentially wrong images

SQL

SELECT CONCAT('https://en.wikipedia.org/wiki/', pm.page_title) AS 'Article', GROUP_CONCAT(il.il_to SEPARATOR ', ') AS 'Matching images'
FROM page p
INNER JOIN categorylinks cl ON p.page_id = cl.cl_from AND cl.cl_to = 'WikiProject_Tropical_cyclones_articles'
INNER JOIN page pm ON p.page_title = pm.page_title AND pm.page_namespace = 0
INNER JOIN imagelinks il ON il.il_from = pm.page_id AND il.il_from_namespace = 0 AND il.il_to RLIKE '202[3-9].*track\.png'
INNER JOIN revision r ON pm.page_id = r.rev_page AND r.rev_parent_id = 0 AND (r.rev_timestamp > '20230101000000' OR pm.page_title RLIKE '202[3-9]')
WHERE p.page_namespace = 1
GROUP BY pm.page_title

SQL

Checking query status...