Misc Learning - Quarry

SQL

#SELECT * FROM page 
#LEFT JOIN templatelinks t1
#	ON t1.tl_title=page_title
#WHERE page_id = '1406921'


SELECT page_title, num_transclusions FROM (
  SELECT page_namespace, page_title, (
      SELECT COUNT(*)  FROM templatelinks
      WHERE tl_namespace = page_namespace AND tl_title = page_title
    ) AS num_transclusions
  FROM page
  WHERE page_namespace = 10
  AND NOT EXISTS ( 
    SELECT * FROM templatelinks 
	WHERE tl_from=page_id AND tl_namespace = 828 AND tl_title = 'Check_for_unknown_parameters'
  )
  HAVING num_transclusions > 500000  
) AS innerquery
#ORDER BY num_transclusions DESC
LIMIT 20
SQL

Checking query status...
