None - blank - for temporar

USE enwiki_p;
select count(tl.tl_from) from templatelinks tl
						where tl.tl_title="Infobox_NRHP" and tl_namespace=10 and tl.tl_from_namespace=0

use enwiki_p;
select concat('* [[{{ns:',pla.page_namespace,'}}:',REPLACE(pla.page_title, '_', ' '),']]')
                from categorylinks cla
                join page pla on cla.cl_from=pla.page_id# and cla.tl_from_
                where cla.cl_type="page" and cla.cl_to="Stale_userspace_drafts"# and pla.page_title<"Jtodsen/John_Todsen"
                order by pla.page_title asc
                #limit 15;
#having count(l.ll_lang)>10
#order by count(l.ll_lang) desc

use lvwiki_p;
select pl_title#pl.pl_title, COUNT(pl.pl_title)
from pagelinks pl
#left join page p on pl.pl_from=p.page_id
where #pl.pl_title="1951._gada_Tour_de_France" and
pl.pl_title NOT IN (Select page_title from page where page_namespace=0) and pl.pl_from_namespace=0 and pl.pl_namespace=0
and pl_title like "DZDAT%" or pl_title like "MIRDAT%"
order by pl_title
	#and pl.pl_title NOT LIKE "%Tour_de_France"
#limit 850;

USE enwiki_p;
select tl.tl_title, count(tl.tl_from) from templatelinks tl
						where tl.tl_title in (select pl_title from pagelinks pl where pl_from=37800330)
                        and tl_namespace=10 and tl.tl_from_namespace=0
                        group by tl.tl_title
                        order by count(tl.tl_from) desc

use lvwiki_p;
select pl_title#pl.pl_title, COUNT(pl.pl_title)
from pagelinks pl
where #pl.pl_title="1951._gada_Tour_de_France" and
pl.pl_title NOT IN (Select page_title from page where page_namespace=0) and pl.pl_from_namespace=0 and pl.pl_namespace=0
and pl_title like "DZDAT%" or pl_title like "MIRDAT%"
order by pl_title

SQL

use enwiki_p;
select REPLACE(l.ll_title, '_', ' ')
from langlinks l
#join page p on p.page_id=l.ll_from
#where  l.ll_from in (select tl.tl_from from templatelinks tl
#                                               where tl.tl_title="Portail_Lettonie" and tl_namespace=10 and tl.tl_from_namespace=0)
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 pla.page_namespace=0 and cla.cl_type="page" and
                                              cla.cl_to="Grammy_Award_winners")
and l.ll_from in (select m.ll_from from langlinks m where m.ll_lang="lv")
and l.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...