Fork of
Untitled query #20766
by Hall1467
This query is marked as a draft
This query has been published
by Hall1467.
SQL
AخA
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]%';
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.