Azerbaijani lemmas not edited by Allahverdi Verdizade

SQL

set @category_name := 'Old_Norse_lemmas';

select
	page_namespace, page_title
from categorylinks
left join page on page_id = rev_page
where cl_to = @category_name
and NOT EXISTS(
  select 1 from revision
  left join revision on rev_page = cl_from
  left join actor on actor_id = rev_actor
  where actor_name = 'Mårtensås')
group by cl_from
-- inefficient because it requires going through all edits!
-- having sum(if(actor_name = 'Mårtensås', 0, 1)) > 0
-- having sum(if(actor_name = 'Allahverdi Verdizade' or actor_name = 'Ketiga123', 0, 1)) > 0
order by page_namespace, page_title;

SQL

Checking query status...