draft, to work on

SQL

/*use rowiki_p;
#6552
#6658
#SHOW COLUMNS FROM langlinks;
select l.ll_lang, l.ll_title #p.page_title, count(l.ll_lang)
from langlinks l
join page p on p.page_id=l.ll_from
where page_title="Kylie_Minogue" and page_namespace=0*//*l.ll_from in (select tl.tl_from from templatelinks tl
						where tl.tl_title="Infobox_titlu -- cantec" 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="en")
group by l.ll_from
#having count(l.ll_lang)>20
order by count(l.ll_lang) desc
limit 200;*/
/**/use frwiki_p;
select page_title
from page
join langlinks on page_id=ll_from and page_namespace=0
join categorylinks on cl_from=page_id
where cl_to = "Astéroïde_de_la_ceinture_principale" 
and page_id not in (select ll_from from langlinks where ll_lang = 'ro')
group by page_id
SQL

Checking query status...
