SQL
AخA
#USE hiwiki_p;
SELECT
CONCAT("# [[:File:", img_name, "]]") AS file
FROM image
JOIN page
ON page_namespace=6
AND page_title = img_name
AND page_is_redirect=0
AND NOT EXISTS(
SELECT * FROM categorylinks
WHERE page_id=cl_from
AND (cl_to="सभी_मुक्त_मीडिया"
OR cl_to= "सभी_ग़ैर-मुक्त_मीडिया"
OR cl_to= "Non_Licensed_Images"))
ORDER BY img_name ASC
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.