str veidnes/ women - tagging

pl_from // pl_namespace // pl_title // pl_from_namespace
286329 // 0 // Foo_(bar // 2

use lvwiki_p;
select * from templatelinks pl
						#join page p on p.page_title=pl.pl_title and pl.pl_namespace=p.page_namespace
						where pl.tl_title="Laba_raksta_atzīmēšana"
                        limit 10;

use lvwiki_p;
select p.page_title from page p
where p.page_title like "Str%" and p.page_namespace=10
limit 100;

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_namespace=0 and 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 cla.cl_to="WikiProject_Linguistics_articles" and cla.cl_type="page" and pla.page_namespace=1)
and l.ll_from not in (select m.ll_from from langlinks m where m.ll_lang="lv")
group by l.ll_from
having count(l.ll_lang)>10
order by count(l.ll_lang) desc

SQL

Checking query status...