maiji - Quarry

SQL

use enwiki_p;
select p.page_title, count(l.ll_lang)
from langlinks l
join page p on p.page_id=l.ll_from
where p.page_title in (select pla.page_title
		from categorylinks cla
		join page pla on cla.cl_from=pla.page_id# and cla.tl_from_
		where p.page_title=pla.page_title and pla.page_namespace=1
                     and cla.cl_type="page" and cla.cl_to in ("WikiProject_Mesoamerica_articles","Indigenous_peoples_of_the_Americas_articles"))

#where  l.ll_from in (select tl.tl_from from templatelinks tl
#						where tl.tl_title="Infobox_drug" and tl_namespace=10 and tl.tl_from_namespace=0)
and 
p.page_namespace=0 and l.ll_from not in (select m.ll_from from langlinks m where m.ll_lang="lv")
group by l.ll_from
order by count(l.ll_lang) desc
limit 600;
SQL

Checking query status...
