items created - Quarry

SQL

USE wikidatawiki_p;
SELECT CONCAT("[[Q",epp_entity_id,"]]") AS item, 
    GROUP_CONCAT(DISTINCT CONCAT("[[",links.pl_title,"]]") SEPARATOR ', ') AS links_on_page,
	GROUP_CONCAT(DISTINCT CONCAT("Q",backlinks.epp_entity_id) SEPARATOR ', ') AS backlinks
	FROM wb_entity_per_page
	LEFT JOIN wb_items_per_site
		ON ips_item_id = epp_entity_id
	LEFT JOIN (SELECT * FROM pagelinks WHERE pl_from_namespace = 0 AND pl_namespace = 0) AS links
		ON links.pl_from = epp_page_id
	LEFT JOIN (SELECT * FROM pagelinks JOIN wb_entity_per_page ON epp_page_id = pl_from
				WHERE pl_namespace = 0) AS backlinks
		ON backlinks.pl_title = CONCAT("Q",epp_entity_id)
WHERE ips_item_id IS NULL
GROUP BY total.pl_from
having COUNT(DISTINCT backlinks.pl_from) = 0 AND COUNT(links.pl_title) = 0
#ORDER BY COUNT(DISTINCT backlinks.pl_from) DESC, total.pl_from;
SQL

Checking query status...
