SELECT CONCAT('https://en.wikipedia.org/wiki/', pm.page_title) AS 'Article', GROUP_CONCAT(il.il_to) 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|season summary map)\.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