Wikimedia Commons media with Czech description needing categories

SQL

SELECT CONCAT('#[[:File:', files.page_title, ']]') AS wikitext
FROM commonswiki_p.categorylinks AS categories
JOIN commonswiki_p.page AS cat_page ON cat_page.page_id = categories.cl_from
JOIN commonswiki_p.categorylinks AS cl_files ON cl_files.cl_to = cat_page.page_title
JOIN commonswiki_p.templatelinks ON tl_from = cl_files.cl_from
JOIN commonswiki_p.page AS files ON files.page_id = cl_files.cl_from
WHERE categories.cl_to = 'Media_needing_categories'
AND categories.cl_type = 'subcat' AND cat_page.page_namespace = 14
AND cl_files.cl_type = 'file' AND files.page_namespace = 6
AND tl_namespace = 10 AND tl_title = 'Cs'
ORDER BY files.page_title;

SQL

Checking query status...