Untitled query #75032

SQL

SELECT
  p.page_title AS template_title,
  p.page_id AS template_id,
  p.page_namespace AS template_namespace,
  GROUP_CONCAT(DISTINCT pr.pr_type) AS protection_status,
  COUNT(*) AS usage_count
FROM
  page AS p
JOIN
  templatelinks AS tl ON tl.tl_from = p.page_id
LEFT JOIN
  page_restrictions AS pr ON pr.pr_page = p.page_id
WHERE
  p.page_namespace = 10 -- Namespace for templates
  AND tl.tl_namespace = (SELECT ns_id FROM toolserver.namespace WHERE ns_name = 'উইকিপিডিয়া') -- Namespace for bnwiki
GROUP BY
  p.page_title, p.page_id, p.page_namespace
ORDER BY
  usage_count DESC
LIMIT 10; -- Specify the number of templates you want to retrieve
SQL

Checking query status...
