SQL
AخA
select page_title as mainspace_title from (
select cl_from as entry_id from categorylinks
where cl_to = 'English_lemmas'
) as English_entries
left join page on page_id = entry_id
left join categorylinks on cl_from = entry_id
where page_namespace = 0
group by entry_id
having sum(cl_to like 'en:%') = 0 and sum(cl_to like 'English_greetings') = 0;
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.