Pages in Category: edited only by a specific user

Fork of Pages in Category: edited only by a specific user by Samuele2002

This query is marked as a draft This query has been published by Samuele2002.

SQL

USE srwiktionary_p;
SELECT CONCAT(CASE page_namespace
                WHEN 0 THEN ''
                WHEN 1 THEN 'Talk:'
                WHEN 2 THEN 'User:'
                WHEN 10 THEN 'Template:'
                WHEN 4 THEN 'Project:'
                ELSE CONCAT('{{ns:', page_namespace, '}}:')
              END,
              page_title)
FROM page
JOIN categorylinks ON cl_from = page_id
WHERE cl_to = 'Брзо брисање'
AND NOT EXISTS (SELECT 1
                FROM revision_userindex
                JOIN actor_revision ON actor_id = rev_actor
                WHERE rev_page = page_id
                  AND actor_name != 'Asinis632')
AND NOT EXISTS (SELECT 1
                FROM pagelinks
                WHERE pl_namespace = page_namespace
                  AND pl_title = page_title);

SQL

Checking query status...