Untitled query #84883

SQL

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 'English_terms_with_IPA_pronunciation') = 0 
and sum(cl_to like 'English_terms_with_usage_examples') = 0
and sum(cl_to like 'English_terms_with_IPA_pronunciation') = 0
and sum(cl_to like 'English_terms_with_quotations') = 0
and sum(cl_to like 'English_terms_prefixed_with%') = 0
and sum(cl_to like 'English_terms_derived%') = 0;
and sum(cl_to like 'Requests for%') = 0;
SQL

Checking query status...
