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(DISTINCT 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) GROUP BY bin ORDER BY bin ASC;
SELECT CEILING(SUBSTRING(log_title FROM 2) / 250000) AS bin, 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) ORDER BY bin ASC LIMIT 100;
SQL

Checking query status...
