SQL
x
SELECT page_title,
REGEXP_REPLACE(el_to_path, '[^0-9]', '') AS "Neue VIAF",
CONCAT(' Spezial:diff/', rev_id) As DIFF,
rev_timestamp,
comment_text
FROM revision, comment, actor, page LEFT JOIN externallinks
ON el_from = page_id
AND el_to_domain_index = 'https://org.viaf.'
AND el_to_path LIKE '/viaf/%'
WHERE page_id = rev_page
AND rev_actor = actor_id
AND actor_name = 'APPERbot'
AND rev_comment_id = comment_id
AND rev_timestamp > '20180000'
AND comment_text LIKE "%ungültige VIAF entfernt%"
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.