WLM Italy overwrites - Quarry

Fork of Last successful uploads by geograph2commons by Bjh21

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

These are files where the WLM Italy app has made an edit that isn't the first edit of a page.  These are probably mistaken overwrites of existing files.

SQL

select rev_timestamp, page_namespace, concat('[[:File:', page_title, ']]') as link
from change_tag, change_tag_def, revision, page
where ct_tag_id = ctd_id and rev_id = ct_rev_id and page_id = rev_page
and ctd_name = 'OAuth CID: 5309' and rev_parent_id <> 0 order by rev_timestamp ;

AخA
 
select rev_timestamp, page_namespace, concat('[[:File:', page_title, ']]') as linkfrom change_tag, change_tag_def, revision, pagewhere ct_tag_id = ctd_id and rev_id = ct_rev_id and page_id = rev_pageand ctd_name = 'OAuth CID: 5309' and rev_parent_id <> 0 order by rev_timestamp ;

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.

Checking query status...