Most used templates at lvwiki

SQL

use lvwiki_p;
SELECT
  Concat('[[Template:',tl_title,']]'),
  COUNT(*)
FROM templatelinks
WHERE tl_namespace = 10# and tl_from_namespace=0# tl_from_namespace=0
and tl_title not like "%/%"
GROUP BY tl_title
ORDER BY COUNT(*) DESC
LIMIT 4000;

use lvwiki_p;
SELECT
  Concat('[[Template:',tl_title,']]'),
  COUNT(*)
FROM templatelinks
WHERE tl_namespace = 10 and tl_from_namespace=6
GROUP BY tl_title
ORDER BY COUNT(*) DESC;

​x
 
use lvwiki_p;SELECT  Concat('[[Template:',tl_title,']]'),  COUNT(*)FROM templatelinksWHERE tl_namespace = 10# and tl_from_namespace=0# tl_from_namespace=0and tl_title not like "%/%"GROUP BY tl_titleORDER BY COUNT(*) DESCLIMIT 4000;​use lvwiki_p;SELECT  Concat('[[Template:',tl_title,']]'),  COUNT(*)FROM templatelinksWHERE tl_namespace = 10 and tl_from_namespace=6GROUP BY tl_titleORDER BY COUNT(*) DESC;

SQL

Checking query status...