Untitled query #79843

SQL

select
	page_title
from page
	inner join categorylinks on cl_from = page_id
    inner join revision on rev_page = page_id
    inner join actor on actor_id = rev_actor
    left join change_tag on ct_rev_id = rev_id
where
	cl_type = "file" and
	cl_to = "Media_contributed_by_the_National_Museum_in_Kraków" and
    actor_name = "Filip (MNK)" and
    (ct_id is null or not exists (
      select *
      from revision r
      	inner join change_tag ct on ct.ct_rev_id = r.rev_id
      	inner join change_tag_def on ctd_id = ct.ct_tag_id
      where
      	r.rev_page = page_id and
      	ctd_name = "openrefine-3.7"
    ))
group by
	page_id
SQL

Checking query status...
