Most used modules (lvwiki)

SQL

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"
*/
SQL

Checking query status...
