i - Quarry

SQL

/*USE rowiki_p;
SELECT user_name, page_len
	FROM page
	JOIN user
		ON replace(page_title,"_"," ") = user_name
               and page_namespace = 3
    JOIN revision
ON revision.rev_page = page.page_id
WHERE page_len < 1300
having COUNT((select * from revision JOIN page ON page_id = rev_page
               WHERE page_namespace = 3 group by rev_page) as tt) < 2*/
use frwiki_p;
select page_title, ll_title, page_len
from page
join langlinks on page_id=ll_from and page_namespace=0 and ll_lang="it"
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 ll_title not in (select REPLACE(page_title, '_', ' ') from rowiki_p.page where page_is_redirect = 0)
/*
#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...
