wikidata: number of deleted items per Q-ID bin

SQL

USE wikidatawiki_p;

-- log_type='delete'; log_action='delete|restore'

-- SELECT * FROM logging WHERE log_namespace=0 AND log_type='delete' AND log_action='delete' AND log_timestamp<20150000000000 AND log_title NOT IN (SELECT page_title FROM page WHERE page_namespace=0);
SELECT CEILING(SUBSTRING(log_title FROM 2) / 250000) AS bin, COUNT(log_title) AS cnt FROM logging WHERE log_namespace=0 AND log_type='delete' AND log_action='delete' AND log_title NOT IN (SELECT page_title FROM page WHERE page_namespace=0);

SQL

Checking query status...