select * from page where page_namespace = 10 and not exists (select 1 from page a where a.page_namespace = 10 and a.page_title = SUBSTRING_INDEX(page.page_title,"/",1)) 

-- These should be cleaned up someday

and page_title not like "%/meta/color" and page_title not like "%/meta/shortname" 

and page_title not like "Alberta_provincial_election,%" 

and page_title not like "British_Columbia_provincial_election,%"

and page_title not like "Canadial_federal_election,%" limit 1000;