ru.wiki files used in MD articles

SQL

use ruwiki_p;
SELECT CONCAT('* [[:File:',il_to, ']]')
FROM imagelinks
join page p1 on il_from = p1.page_id and il_from_namespace = 0
JOIN pagelinks ON pl_from = 6635836 AND pl_title = p1.page_title AND p1.page_namespace = 0
where il_to in (select img_name from image)
/*
join categorylinks on page_id = cl_from 
where (categorylinks.cl_to = "Файлы:К_переносу_на_Викисклад" 
            or categorylinks.cl_to = "Файлы:GFDL" 
            or categorylinks.cl_to = "Файлы:GPL" 
            or categorylinks.cl_to = "Файлы:LGPL" 
            or categorylinks.cl_to like "Файлы:PD%" 
            or categorylinks.cl_to like "Файлы:CC%")
            */
            group by il_to
ORDER BY page_title
SQL

Checking query status...
