ru silrada articles without uk IW

SQL

USE ruwiki_p;
SELECT page_title/*, page_len*/
	FROM page
    /*
join categorylinks on cl_from=page_id
*/
/**/
JOIN templatelinks ON tl_from = page_id and tl_title ="Административная_единица_Украины"
/**/
	LEFT JOIN langlinks
    	ON ll_from = page_id
	LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
		ON pp_page = page_id
WHERE #pp_value is NULL
#and cl_to like "Comunele_Ucrainei"
#AND ll_title IS NULL
/*and*/ ll_from not in (select m.ll_from from langlinks m where m.ll_lang="uk")
AND page_namespace = 0 and page_is_redirect = 0
ORDER BY page_title;
SQL

Checking query status...
