JanZerebecki added a subscriber: JanZerebecki. JanZerebecki added a comment.
In https://phabricator.wikimedia.org/T90115#1413173, @Bene wrote: > What about oversight-deleted items? I recently stumbled about a property > which got deleted on Wikidata on June 3rd but still was referenced in the > SPARQL query service. query <http://wdqs-beta.wmflabs.org/#PREFIX%20wd%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%20%0APREFIX%20wdt%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX%20skos%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0APREFIX%20wikibase%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology%23%3E%0A%0ASELECT%20%3Fproperty%20%3Falias%20%3Foccurences%20WHERE%20{%0A%20%20hint%3AQuery%20hint%3Aoptimizer%20%22None%22%20.%0A%0A%20%20{%0A%20%20%20%20SELECT%20%3Falias%20%28COUNT%20%28%3Falias%29%20as%20%3Foccurences%29%20WHERE%20{%09%0A%20%20%20%20%20%20%3Ftmp%20a%20wikibase%3AProperty%20.%0A%20%20%20%20%20%20%3Ftmp%20rdfs%3Alabel%20%3Falias%20FILTER%20%28LANG%20%28%3Falias%29%20%3D%20%22en%22%29%0A%20%20%20%20}%20GROUP%20BY%20%3Falias%0A%20%20}%0A%0A%20%20%3Fproperty%20a%20wikibase%3AProperty%20.%0A%20%20%3Fproperty%20rdfs%3Alabel%20%3Falias%20FILTER%20%28%3Foccurences%20%3E%201%29%20.%0A }%20ORDER%20BY%20%3Falias> and [[ link to property | https://www.wikidata.org/wiki/Property:P1926 ]] Oversight-deleted items are just gone completely, there is no way to see that they got removed. That one is not oversight-deleted, just normally deleted so I created https://phabricator.wikimedia.org/T104355 for it. In our discussion yesterday it was suggested to instruct the people who oversight to never do oversight-deletes but instead add an empty revision and then normally delete. The only reason to oversight-delete is to to remove the title, which for Wikibase entities is an incremented ID. If someone manages again to convince courts to require us to delete such a number we can still give them some butterflies ( https://xkcd.com/378/ ) or reload all our WDQS instances. Another suggestion was to change Mediawiki to publish a log with the page-ids that were oversight-deleted and store the page-ids to know what to delete. (Other projects might need this or a similar solution. Please don't create solutions that only work with special access.) TASK DETAIL https://phabricator.wikimedia.org/T90115 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: csteipp, JanZerebecki Cc: JanZerebecki, Bene, MoritzMuehlenhoff, GWicke, Thompsonbry.systap, Smalyshev, Joe, Liuxinyu970226, csteipp, Beebs.systap, Haasepeter, Aklapper, Manybubbles, jkroll, Wikidata-bugs, Jdouglas, aude, Krenair, Malyacko, P.Copp _______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
