Jāsaliek iw - gadu kategorijas

SQL

use lvwiki_p;
select count(*)#concat('* [[:Template:',p.page_title,']]') as "Title"
from page p
where p.page_namespace =10
and not exists (select 1 from langlinks ll where p.page_id=ll.ll_from )
and p.page_is_redirect = 0 and p.page_title not like "%/%"
order by p.page_title
/*
use lvwiki_p;
select concat('* [[:Template:',p.page_title,']]') as "Title"
from page p
where p.page_namespace =10
and not exists (select 1 from langlinks ll where p.page_id=ll.ll_from )
and p.page_is_redirect = 0 and p.page_id in (select cl_from
												from categorylinks
												where cl_to="Valstu_karogu_veidnes" and cl_type="page")
order by p.page_title
*/
SQL

Checking query status...
