wikidata: number of items per Q-ID bin

SQL

USE wikidatawiki_p;
-- SELECT CEILING(SUBSTRING(page_title FROM 2) / 100000) AS bin, (100000-COUNT(*)) AS cnt FROM page WHERE page_namespace=0 GROUP BY bin ORDER BY bin ASC;
SELECT CEILING(SUBSTRING(ar_title FROM 2) / 100000) AS bin, COUNT(*) AS cnt FROM archive WHERE ar_namespace=0 GROUP BY bin ORDER BY bin ASC;

-- SELECT ?bin (COUNT(*) AS ?cnt) WHERE {
--   #?item wikibase:statements 0 .
--   #?item owl:sameAs [] .
--   ?item wikibase:sitelinks [] .
--   BIND(ceil(xsd:integer(SUBSTR(STR(?item),33)) / 100000) AS ?bin) .
-- } GROUP BY ?bin ORDER BY ASC(?bin)

SQL

Checking query status...