Untitled query #18921

SQL

use wikidatawiki_p;
SELECT page_title, rc_comment FROM recentchanges 
JOIN page ON rc_namespace=page_namespace AND 
rc_title=page_title AND page_namespace=0
JOIN page_props AS site_props ON page_id=site_props.pp_page
AND site_props.pp_propname='wb-sitelinks' AND site_props.pp_value=0
JOIN page_props AS claim_props ON page_id=claim_props.pp_page
AND claim_props.pp_propname='wb-claims' AND claim_props.pp_value<3
WHERE rc_namespace=0 AND rc_comment LIKE '/* clientsitelink-remove:1||lvwiki */%' LIMIT 100;
SQL

Checking query status...
