Pages in Category:Azonnali törlésre váró lapok edited only by a specific user

SQL

USE huwikibooks_p;
SELECT CONCAT(CASE page_namespace
                WHEN 0 THEN ''
                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 = 'Azonnali_törlésre_váró_lapok'
AND NOT EXISTS (SELECT 1
                FROM revision_userindex
                JOIN actor_revision ON actor_id = rev_actor
                WHERE rev_page = page_id
                  AND actor_name != 'KeFe')
AND NOT EXISTS (SELECT 1
                FROM pagelinks
                WHERE pl_namespace = page_namespace
                  AND pl_title = page_title);

SQL

Checking query status...