Files by uploader on mswiki

SQL

USE mswiki_p;
SELECT i.img_user_text AS username, p.page_title AS filename FROM page p
INNER JOIN categorylinks c ON cl_from = p.page_id AND cl_to = 'All_free_media'
INNER JOIN image i ON i.img_name = p.page_title
WHERE p.page_namespace = 6
UNION
SELECT DISTINCT o.oi_user_text AS username, p.page_title AS filename FROM page p
INNER JOIN categorylinks c ON cl_from = p.page_id AND cl_to = 'All_free_media'
INNER JOIN oldimage o ON o.oi_name = p.page_title
WHERE p.page_namespace = 6
ORDER BY username, filename

SQL

Checking query status...