SQL
AخA
USE itwiki_p;
SELECT CONCAT('# [[:File:', page_title, ']]')
FROM page
WHERE page_namespace = 6
AND page_is_redirect = 0
AND page_title IN
(SELECT il_to
FROM imagelinks
WHERE il_from_namespace = 0)
AND page_title IN
(SELECT img_name
FROM image)
AND page_title IN
(SELECT page_title
FROM page, categorylinks
WHERE page_id = cl_from
AND cl_to LIKE 'Immagini_orfane%')
ORDER BY page_title;
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.