Untitled query #20786

Fork of Untitled query #20766 by Hall1467

This query is marked as a draft This query has been published by Hall1467.

SQL

select page_title
from wikidatawiki_p.revision 
INNER JOIN
wikidatawiki_p.page
ON page_id = rev_page
where rev_comment like '/* wbsetsitelink-add:1|enwiki%' AND rev_timestamp >= 20170808000000 AND page_namespace = 0 AND page_title NOT IN 
(
	SELECT pp_value
	FROM enwiki_p.page_props
	WHERE pp_propname = 'wikibase_item'
);
#select * from revision where rev_timestamp >= 20170801000000 AND rev_comment LIKE '/* Added link to [enwiki]%';
#select * from revision where rev_timestamp >= 20150801000000 AND rev_timestamp < 20150808000000 AND rev_comment LIKE '/* Added link to [enwiki]%';

SQL

Checking query status...