Wikimedia Commons media with Czech description needing categories

SQL

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

SQL

Checking query status...