frroen aster - Quarry

SQL

use frwiki_p;
select page_title, ll_title, page_len
from page
JOIN templatelinks ON tl_from = page_id
join langlinks on page_id=ll_from and ll_lang = 'en'
join revision on page.page_id = revision.rev_page 
WHERE tl_namespace = 10
AND tl_title = "Infobox_Planète_mineure"
#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 
/*
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 page_id not in (select ll_from from langlinks where ll_lang = 'ro')
#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...
