Old quary for files in a cat incl user id

SQL

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

SQL

Checking query status...