Query test 5 - Quarry

SQL

SELECT concat("*[[Template:",page_title, "]]: "), num_transclusions 
FROM (
  SELECT page_namespace, page_title, (
      SELECT COUNT(*) FROM linktarget
      WHERE lt_namespace = page_namespace AND lt_title = page_title
    ) AS num_transclusions
  FROM page
  WHERE page_namespace = 10
  AND page_title IN ('11_settembre')
  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 > 500000*/
) AS innerquery
ORDER BY num_transclusions DESC;

SELECT COUNT(*) FROM linktarget
WHERE lt_namespace = page_namespace AND lt_title = page_title
LIMIT 100;
SQL

Checking query status...
