User Namespace license templates sorted by frequency of use

SQL

USE commonswiki_p;
SELECT concat("Template:",license.page_title) as pagename-- list of license templates
FROM page license
-- transclude "License_template_tag"
INNER JOIN templatelinks t1 ON t1.tl_from = license.page_id AND t1.tl_title = 'License_template_tag'
WHERE
  license.page_namespace = 2 
  -- not in "Primary_license_tags_(flat_list)" or "Style_formatting_templates" categories

  AND NOT exists ( -- does not transclude any templates in "Primary_license_tags_(flat_list)" category
    SELECT *
    FROM templatelinks t2
    WHERE t2.tl_from = license.page_id 
    AND t2.tl_title IN (SELECT p2.page_title -- templates in "Primary_license_tags_(flat_list)" category
                   FROM page p2
                   INNER JOIN categorylinks c2 on c2.cl_from = p2.page_id 
                   WHERE p2.page_namespace = 10 
                   AND   c2.cl_to = "Primary_license_tags_(flat_list)"
                  )
	limit 1 
  )
SQL

Checking query status...
