# query3:

SELECT CEILING(SUBSTRING(page_title FROM 2) / 500000) AS bin, COUNT(*) AS cnt FROM page WHERE page_namespace=0 GROUP BY bin ORDER BY bin ASC;

​

# query4:

# bin 0 objects were not items, e.g. [[d:Main page]] etc.; ignore them with "HAVING bin>0"!

SELECT CEILING(SUBSTRING(log_title FROM 2) / 500000) 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 HAVING bin>0 ORDER BY bin ASC;