Untitled query #20766

SQL

select *
from 
(
	select *
	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 > 20120808000000 AND page_namespace = 0 limit 1
) as inner_query
INNER JOIN
enwiki_p.page_props
ON page_title = pp_value
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...
