USE lvwiki_p;

SELECT Concat('[[Modulis:',page_title,']]'), (SELECT COUNT(tl_title)

                                                FROM templatelinks

                                                where tl_namespace=828

                                                and tl_title=page_title

                                                group by tl_title) as 'links'

FROM page

where page_namespace=828

and page_title not like "VietasKarte/dati/%"  and page_title not like "%/doc"

order by links desc, page_title asc/*

USE lvwiki_p;

SELECT Concat('[[Module:',page_title,']]'), COUNT(tl_title)

FROM page

where page_namespace=828

and page_title not like "%/doc"

*/