Interlanguage links in enwiki files

SQL

SELECT DISTINCT CONCAT("File:", page.page_title)
FROM page
INNER JOIN categorylinks ON page.page_id = categorylinks.cl_from
INNER JOIN iwlinks ON page.page_id = iwlinks.iwl_from
WHERE page.page_namespace = 6
AND categorylinks.cl_to = "Copy_to_Wikimedia_Commons_(bot-assessed)"
AND iwlinks.iwl_prefix NOT IN ("commons", "c", "meta", "wikt", "foundation", "wmf", "wikimedia", "m", "ja")
ORDER BY page.page_title

AخA
 
SELECT DISTINCT CONCAT("File:", page.page_title)FROM pageINNER JOIN categorylinks ON page.page_id = categorylinks.cl_fromINNER JOIN iwlinks ON page.page_id = iwlinks.iwl_fromWHERE page.page_namespace = 6AND categorylinks.cl_to = "Copy_to_Wikimedia_Commons_(bot-assessed)"AND iwlinks.iwl_prefix NOT IN ("commons", "c", "meta", "wikt", "foundation", "wmf", "wikimedia", "m", "ja")ORDER BY page.page_title

SQL

Checking query status...