Untitled query #54487

SQL

SELECT CONCAT('# [[Wikipedia:', page_title, ']]')
FROM page
WHERE page_title LIKE 'Pagine_da_cancellare/%'
AND page_title NOT LIKE 'Pagine_da_cancellare/Conta/%'
AND page_title NOT LIKE 'Pagine_da_cancellare/Log/%'
AND page_title NOT LIKE 'Pagine_da_cancellare/Trasferimenti/%'
AND page_namespace = 4
AND page_is_redirect = 0
AND page_id NOT IN
(SELECT pr_page FROM page_restrictions
WHERE pr_type = 'edit' AND pr_level = 'sysop' AND pr_expiry = 'infinity')
AND page_id NOT IN 
(SELECT cl_from
FROM categorylinks
WHERE cl_to = 'Procedure_di_cancellazione_in_corso')
ORDER BY page_title
SQL

Checking query status...
