Primary license template candidates

templates that:
1) transclude "License_template_tag"
2) does not transclude any templates in "Primary_license_tags_(flat_list)" category
3) are not in "Primary_license_tags_(flat_list)" or "Style_formatting_templates" categories

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_title not like "%/%" and -- no subtemplates
  license.page_namespace = 10 AND
  -- not in "Primary_license_tags_(flat_list)" or "Style_formatting_templates" categories
  license.page_id NOT IN (SELECT cl_from FROM categorylinks WHERE 
                          cl_to in ( "Primary_license_tags_(flat_list)", "Style_formatting_templates", 
                                     "Non-media_deletion_requests", "License-related_tags")
                         ) 
  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...