items created - Quarry

SQL

USE wikidatawiki_p;
SELECT CONCAT("[[Q",epp1.epp_entity_id,"]]") AS item
	FROM wb_entity_per_page epp1
	LEFT JOIN wb_items_per_site
		ON ips_item_id = epp_entity_id
        /*
	LEFT JOIN (SELECT * FROM pagelinks JOIN wb_entity_per_page epp2 ON epp2.epp_page_id = pl_from
				WHERE pl_from_namespace = 0 AND pl_namespace = 0) AS backlinks
		ON backlinks.pl_title = CONCAT("Q",epp1.epp_entity_id)*/
WHERE ips_site_page IS NULL
 AND epp1.epp_page_id not in (SELECT pl_from FROM pagelinks WHERE pl_from_namespace = 0 AND pl_namespace = 0)
 AND CONCAT("Q",epp1.epp_entity_id) not in (SELECT pl_title FROM pagelinks WHERE pl_from_namespace = 0 AND pl_namespace = 0)
GROUP BY epp1.epp_entity_id
#having COUNT(DISTINCT backlinks.pl_from) = 0
SQL

Checking query status...
