Wikimedia Commons media with Czech description needing categories

SQL

SELECT CONCAT('*[[:File:', p.page_title, ']]') AS wikitext
FROM commonswiki_p.page p
WHERE p.page_namespace = 6
AND EXISTS(SELECT pc.cl_from FROM commonswiki_p.categorylinks pc WHERE pc.cl_from=p.page_id AND pc.cl_to IN (
 SELECT cp.page_title
 FROM commonswiki_p.categorylinks c2
 JOIN commonswiki_p.page cp ON c2.cl_from = cp.page_id
 WHERE c2.cl_to = 'Media_needing_categories'
))
AND EXISTS(SELECT pt.tl_from FROM commonswiki_p.templatelinks pt WHERE pt.tl_from = p.page_id AND pt.tl_namespace = 10 AND pt.tl_title='Cs')
ORDER BY p.page_title

SQL

Checking query status...