Unprotected Templates with most transclusions

SQL

#SELECT page_namespace, page_title, count(*) as num_transclusions
#    (
#      SELECT COUNT(*)  FROM linktarget
#      WHERE lt_namespace = page_namespace AND lt_title = page_title
#    ) AS num_transclusions
#FROM page
#join linktarget on lt_namespace = page_namespace AND lt_title = page_title
#WHERE page_namespace in (10, 828)
#AND NOT EXISTS ( 
#    SELECT *  FROM page_restrictions  
#    WHERE page_id = pr_page AND pr_type = 'edit' AND pr_level = 'sysop' AND pr_expiry = 'infinity'
#  )
#HAVING num_transclusions > 1000  
#group by page_id
#ORDER BY num_transclusions DESC
#LIMIT 10

SELECT lt_title, COUNT(*) as num_transclusions
FROM templatelinks JOIN linktarget ON tl_target_id = lt_id
WHERE lt_namespace = 828
GROUP BY tl_target_id
ORDER BY num_transclusions DESC
LIMIT 10
SQL

Checking query status...
