Untitled query #88787

SQL

USE enwiktionary_p; -- Ensure you are using the correct database

SELECT DISTINCT p.page_id, p.page_title
FROM page p
JOIN categorylinks cl1 ON p.page_id = cl1.cl_from
LEFT JOIN categorylinks cl2 ON p.page_id = cl2.cl_from 
JOIN revision r ON p.page_id = r.rev_page
JOIN text t ON r.rev_text_id = t.old_id
WHERE cl1.cl_to = 'Portuguese_non-lemma_forms'
AND (cl2.cl_to IS NULL OR cl2.cl_to != 'Portuguese_forms_superseded_in_1945')
AND p.page_namespace = 0
AND t.old_text NOT LIKE '%{{pt-verb form of%'
AND t.old_text NOT LIKE '%{{plural of|pt%'
AND t.old_text NOT LIKE '%{{adj form of|pt%'
AND t.old_text NOT LIKE '%{{feminine singular of|pt%'
AND t.old_text NOT LIKE '%{{feminine plural of|pt%'
AND t.old_text NOT LIKE '%{{masculine plural of|pt%'
AND r.rev_id = p.page_latest;
SQL

Checking query status...
