Test Query 2 - Quarry

SQL

USE commonswiki_p;
SELECT CONCAT('#[[:File:', REPLACE (page_title, '_', ' '), ']]')
FROM categorylinks
INNER JOIN page ON page_id = cl_from AND page_namespace = 6
LEFT JOIN imagelinks ON  il_to = page_title
LEFT JOIN globalimagelinks ON gil_to = page_title
WHERE cl_type = 'file'
AND cl_to = 'Personal_files'
AND gil_to IS NULL
AND il_to IS NULL;
SELECT CONCAT('#[[:File:', REPLACE (page_title, '_', ' '), ']]')
FROM categorylinks
INNER JOIN page ON page_id = cl_from AND page_namespace = 6
LEFT JOIN imagelinks ON  il_to = page_title
LEFT JOIN globalimagelinks ON gil_to = page_title
WHERE cl_type = 'file'
AND cl_to = 'User_page_images'
AND gil_to IS NULL
AND il_to IS NULL;
SQL

Checking query status...
