draft, to work on

SQL

use enwiki_p;
#6552#6658
#SHOW COLUMNS FROM langlinks;
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 page_namespace=0 and
l.ll_from in (select tl.tl_from from templatelinks tl
						where tl.tl_title="Infobox_football_club" and tl_namespace=10 and tl.tl_from_namespace=0)
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;
/*
use frwiki_p;
select page_title, page_len, ll_title
from page
join langlinks on page_id=ll_from #and page_namespace=0and ll_lang="pl"
join categorylinks on cl_from=page_id
join revision on page.page_id = revision.rev_page
where cl_to = "Astéroïde_de_la_ceinture_principale"
#and REPLACE(page_title, '_', ' ') = REPLACE(ll_title, '_', ' ')
and page_id not in (select ll_from from langlinks where ll_lang = 'ro') #7687; not like 150
AND (rev_user_text = 'Gallicbot'
AND rev_parent_id = 0
AND page_is_redirect = 0)
AND page_namespace = 0
group by page_id*/
SQL

Checking query status...
