some wanted articles in ro

SQL

use enwiki_p;
select concat('# [[:en:',p.page_title,']] // [[:d:',pp_value,']] — ',count(l.ll_lang))
from langlinks l
join page p on p.page_id=l.ll_from
	JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
		ON pp_page = p.page_id 
where p.page_namespace=0 and p.page_title in (select pla.page_title
		from categorylinks cla
		join page pla on cla.cl_from=pla.page_id
		where pla.page_namespace=1 and cla.cl_type="page" and cla.cl_to="Actors_and_filmmakers_work_group_articles")#WikiProject_Geology_articlesin ("cat1", "cat2")
and l.ll_from not in (select m.ll_from from langlinks m where m.ll_lang="ro")
#and l.ll_from not in (select m.ll_from from langlinks m where m.ll_lang="en")
group by l.ll_from
#having count(l.ll_lang)>20
order by count(l.ll_lang) desc
limit 1000;
/*
select p.page_title, lfr.ll_title
from plwiki_p.page p 
join plwiki_p.langlinks lfr on p.page_id=lfr.ll_from and p.page_namespace=0 and lfr.ll_lang="ro"
join plwiki_p.categorylinks cfr on cfr.cl_from=p.page_id and cfr.cl_to = "Planetoidy_pasa_głównego"
*/
SQL

Checking query status...
