Most used modules (lvwiki)

SQL

USE ruwiki_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 "Statistical/%"
group by tl_title
order by COUNT(tl_title) desc
limit 200
/*
USE cswiki_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 "VietasKarte/dati%"  and tl_title not like "%/doc"
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"

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

lvwiki
and tl_title not like "VietasKarte/dati%"
and tl_title not like "VietasKarte/dati%"  and tl_title not like "%/doc"

cs
and tl_title not like "%/Dokumentace"#  and tl_title not like "%/doc"
*/
SQL

Checking query status...
