SQL
AخA
SELECT page_title
FROM page
WHERE page_namespace = 14
AND page_is_redirect = 0
-- page_title stores spaces as underscores, which aren't recognized as word boundaries by the regex engine; so change them back first
AND REPLACE(page_title, '_', ' ') RLIKE '\\b[Oo]rgani[sz]ations?\\b'
AND NOT EXISTS (SELECT 1 FROM templatelinks
WHERE tl_from = page_id
AND tl_namespace = 10
AND tl_title IN ('Category_redirect', 'Category_disambiguation'));
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.