wanted articles in rowiki based on en:template-banner

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 
join page p2 on p.page_title=p2.page_title 
#JOIN templatelinks ON tl_from=p2.page_id
where p.page_namespace=0 and p2.page_id in (select tl_from from templatelinks
		where tl_namespace=10  and tl_from_namespace=1 and tl_title in ("WikiProject_France","France","WP France",
"WPFR","WPFRANCE","WPFrance","WPfr","Wikiproject France"))/*
		where tl_namespace=10  and tl_from_namespace=1 and tl_title in ("WikiProject_Physics","PHYSICS","Template:WP France",
"Template:WPFR","Template:Physics","Template:WP Physics","WPPHYSICS","Template:WPPhysics"))*/
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...
