fr-ro cat - Quarry

SQL

/*use rowiki_p;
#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_historic_site" 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;*/
select p.page_title #p.page_title, count(l.ll_lang)
from frwiki_p.page p 
join frwiki_p.langlinks lfr on p.page_id=lfr.ll_from and p.page_namespace=0 and lfr.ll_lang="ro"
join frwiki_p.categorylinks cfr on cfr.cl_from=p.page_id and cfr.cl_to = "Astéroïde_de_la_ceinture_principale"
#/*left*/ join /*(select **//*pro.page_title from*/ rowiki_p.page tro/*join rowiki_p.categorylinks cro on pro.page_id=cro.cl_from 
#                         where cro.cl_to = "Centura_de_asteroizi"*//*) as tro*/ on REPLACE(tro.page_title, '_', ' ')=REPLACE(lfr.ll_title, '_', ' ')
where REPLACE(lfr.ll_title, '_', ' ') not in
(select REPLACE(rop.page_title, '_', ' ') from rowiki_p.page rop join rowiki_p.categorylinks cro on rop.page_id=cro.cl_from 
                        where cro.cl_to like "Centura_de_asteroizi")
/*
select lfr.ll_title #p.page_title, count(l.ll_lang)
from frwiki_p.langlinks lfr
join frwiki_p.categorylinks cfr on cfr.cl_from=lfr.ll_from
join frwiki_p.page p on p.page_id=lfr.ll_from
where cfr.cl_to = "Astéroïde_de_la_ceinture_principale" and p.page_namespace=0 and lfr.ll_lang="ro" 
and lfr.ll_title 
not in (select rop.page_title from rowiki_p.page rop join rowiki_p.categorylinks cro on rop.page_id=cro.cl_from 
                         where cro.cl_to = "Centura_de_asteroizi")*/
SQL

Checking query status...
