Wikinews use counts

SQL

use enwikinews_p;
SELECT
CONCAT (
  CASE
  	WHEN tl.tl_namespace = 10 THEN 'Template'
	WHEN tl.tl_namespace = 828 THEN 'Module'
  END,
  ':',
  tl.tl_title
) AS 'Page',
COUNT(*) AS 'Transclusions',
CASE
	WHEN COUNT(*) < 100 THEN CONCAT( SUBSTR(COUNT(*), 1, LENGTH(COUNT(*)) - 1), 0 )
    ELSE 'More'
END AS 'Over'
FROM templatelinks tl
WHERE tl.tl_title IN (
SELECT
  SUBSTR(pg.page_title, 1, LENGTH(pg.page_title) - 18)
FROM
  page pg
WHERE
  pg.page_title LIKE '%/doc/use-count/doc'
  AND pg.page_id IN (
    SELECT
      cl.cl_from
    FROM
      categorylinks cl
    WHERE
      cl.cl_to = 'Possible-risk/use-count'
  )
)
AND tl.tl_namespace IN ( 10, 828 )
GROUP BY CONCAT( tl.tl_title, tl.tl_namespace )
ORDER BY COUNT(*) DESC;
SQL

Checking query status...
