sv articles with ceb IW in page + with WD item, but no ceb sitelink in WD

SQL

USE commonswiki_p;
SELECT page_title, ll_lang#, pp_value
FROM langlinks 
JOIN page ON page_id = ll_from and ll_lang = "lv"/*
	LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
		ON pp_page = page_id*/
join categorylinks on page_id=cl_from
WHERE page_namespace = 0 and page_is_redirect = 0
#and pp_value is not NULL 

#and cl_to like "Robotskapade_artiklar%"


and REPLACE(page_title, "_", " ") in (SELECT w1.ips_site_page 
                                      FROM wikidatawiki_p.wb_items_per_site w1 WHERE 
                                      w1.ips_item_id not in (select w2.ips_item_id from wikidatawiki_p.wb_items_per_site w2 where w2.ips_site_id = "commonswiki"))
group by page_id
limit 100

SQL

Checking query status...