Untitled query #88787

SQL

SELECT DISTINCT page_title
FROM page
JOIN categorylinks ON page_id = cl_from
JOIN revision ON revision.rev_page = page.page_id
WHERE page_namespace = 0
AND cl_to = "Portuguese_non-lemma_forms"
AND page_id NOT IN (
    SELECT cl_from 
    FROM categorylinks 
    WHERE cl_to = "Portuguese_forms_superseded_in_1945"
    )
AND text NOT LIKE '%{{pt-verb form of%'
AND text.old_text NOT LIKE '%{{plural of|pt%'
AND text.old_text NOT LIKE '%{{adj form of|pt%'
AND text.old_text NOT LIKE '%{{feminine singular of|pt%'
AND text.old_text NOT LIKE '%{{feminine plural of|pt%'
AND text.old_text NOT LIKE '%{{masculine plural of|pt%'
ORDER BY page_title;
SQL

Checking query status...
