USE plwiki_p;

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

FROM templatelinks

where tl_namespace=828# and tl_from_namespace=0

and tl_title not like "Wikidane/%" and tl_title not like "Kalendarium/%"

group by tl_title

order by COUNT(tl_title) desc

limit 200

/*

ruwiki:

tl_title not like "Statistical/%"

​

frwiki:

tl_title not like "Infobox/%" and tl_title not like "Country_data/%" and tl_title not like "Carte/données%"

​

eswiki

​

and tl_title not like "Zona_de_pruebas/%" and tl_title not like "%/doc"

*/