tests - Quarry

SQL

/*use rowiki_p;
SELECT * FROM page	WHERE page_title = 'Olt'*/
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="pl"
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" /*13379 */
#and REPLACE(page_title, '_', ' ') = REPLACE(ll_title, '_', ' ') /* =  7687; not like 150 */
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...
