compar lipsa ro sh it

SQL

use shwiki_p;
select page_title, /*ll_title, */page_len
from page
join categorylinks c1 on cl_from=page_id and page_namespace=0 and page_is_redirect = 0 and c1.cl_to = "Vikiprojekat_geografija/Naselja_u_Italiji"
left join langlinks on page_id=ll_from /*and ll_lang="it"*/
join categorylinks c2 on page_id=c2.cl_from and c2.cl_to like "Naselja%" 
#join revision on page.page_id = revision.rev_page
where 
#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)
ll_from not in (select m.ll_from from langlinks m where m.ll_lang="ro")
/*
#and REPLACE(page_title, '_', ' ') not like REPLACE(ll_title, '_', ' ')
and page_id not in (select ll_from from langlinks where ll_lang = 'ro') */
/*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...
