items created - Quarry

SQL

USE wikidatawiki_p;
SELECT page_title
FROM page, revision
WHERE page.page_id = revision.rev_page
AND rev_user_text = 'JAnDbot'
AND page_namespace = 0
AND rev_parent_id = 0
AND page_is_redirect = 0
ORDER BY rev_timestamp DESC
LIMIT 5000
/*USE wikidatawiki_p;
SELECT page_title
 FROM page
WHERE page_namespace = 0
 AND page_title not in (SELECT distinct pl_title from pagelinks WHERE pl_namespace = 0 AND pl_from_namespace = 0)
 AND page_id not in (SELECT pl_from from pagelinks WHERE pl_namespace = 0 AND pl_from_namespace = 0)
 AND page_title not in (SELECT CONCAT("Q",ips_item_id) from wb_items_per_site)
GROUP BY page_title
#having COUNT(pl1.pl_title) = 0
#LIMIT 1000;
*/

        /*
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...
