other wanted articles in ro.wiki

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="WikiProject_Football_articles")#in ("cat1", "cat2")
and l.ll_from not in (select m.ll_from from langlinks m where m.ll_lang="ro")
group by l.ll_from
#having count(l.ll_lang)>20
order by count(l.ll_lang) desc
limit 1000;
SQL

Checking query status...
