Untitled query #79843

This query is marked as a draft This query has been published by Peter Bowman.

SQL

select
	page_title,
    count(rev_id) as tagged_revs
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
    left join change_tag_def on ctd_id = ct_tag_id and ctd_name = "openrefine-3.7"
where
	cl_type = "file" and
	cl_to = "Media_contributed_by_the_National_Museum_in_Kraków" and
    actor_name = "Filip (MNK)" and
    ctd_id is null
having
    tagged_revs = 0
group by
	page_id

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...