gal a - Quarry

SQL

/*select p.page_title, lfr.ll_title
from frwiki_p.page p 
join frwiki_p.langlinks lfr on p.page_id=lfr.ll_from and p.page_namespace=0 and lfr.ll_lang="ro"
join frwiki_p.categorylinks cfr on cfr.cl_from=p.page_id and cfr.cl_to = "Astéroïde_de_la_ceinture_principale"
where REPLACE(lfr.ll_title, '_', ' ') not in REPLACE(p.page_title, '_', ' ')*/
USE frwiki_p;
SELECT /*CONCAT('# [[', page_title, ']]') AS*/ page_title, page_len
FROM page, revision, categorylinks/*, templatelinks*/
/*join categorylinks on*/
WHERE page.page_id = revision.rev_page and categorylinks.cl_from=page.page_id
/*AND page.page_id = templatelinks.tl_from
AND tl_namespace = 10
AND tl_title = 'Infocaseta_Așezare'*/
AND page_namespace = 0 AND rev_parent_id = 0 AND page_is_redirect = 0 AND rev_user_text = 'Gallicbot' and cl_to not like "Astéroïde_de_la_ceinture_principale"
group by page_id
ORDER BY page_title
SQL

Checking query status...
