aster lipsa pt

SQL

use ptwiki_p;
#select page_title, /*ll_title, */page_len
select count(page_title)
from page
join categorylinks on cl_from=page_id and page_namespace=0 and page_is_redirect = 0 and cl_to = "Asteroides_da_cintura_principal"
left join langlinks on page_id=ll_from /*and ll_lang="it"*/
#join revision on page.page_id = revision.rev_page
where ll_from not in (select m.ll_from from langlinks m where m.ll_lang="ro")
#and REPLACE(page_title, '(', '') = REPLACE(ll_title, ' ', ')_')
#ll_title not in (select REPLACE(page_title, '_', ' ') from rowiki_p.page where page_is_redirect = 0 AND page_namespace = 0)
/*
#and REPLACE(page_title, '_', ' ') not like REPLACE(ll_title, '_', ' ')
and page_id not in (select ll_from from langlinks where ll_lang = 'ro') */
#group by page_id
SQL

Checking query status...
