cswiki articles enriched by MediaGrant III photos

SQL

USE commonswiki_p;
SELECT *
FROM (
  SELECT * FROM categorylinks WHERE cl_to = "Mediagrant_III:Wikiexpedice_Západ" AND cl_type = 'file'
  UNION
  SELECT * FROM categorylinks WHERE cl_to IN ("Media based on data from Wikiexpedice Západ", "Wikiexpedice Západ dodělat")
  AND cl_type = 'file'
  #SELECT page_title FROM categorylinks JOIN page ON cl_from = page_id WHERE page_title = "Mediagrant_III:Wikiexpedice_Západ" AND cl_type = 'subcat'
  )
) AS files
JOIN page ON cl_from = page_id
JOIN globalimagelinks ON gil_to = page_title
WHERE gil_wiki = 'cswiki';

SQL

Checking query status...