Primary license template candidates

This query is marked as a draft This query has been published by Jarekt.

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

SELECT license.page_title -- list of license templates
FROM page license
INNER JOIN templatelinks ON tl_from = license.page_id
WHERE
  tl_title = 'License_template_tag' and
  license.page_title not like "%/%" and -- no subtemplates
  license.page_namespace = 10 AND
  NOT exists (
    SELECT *
    FROM templatelinks
    WHERE tl_from=page_id 
    AND tl_title IN (SELECT p2.page_title -- 
                   FROM page p2
                   INNER JOIN categorylinks c2 on c2.cl_from = p2.page_id 
                   AND c2.cl_to = "Primary_license_tags_(flat_list)"
                  )
	limit 1 
  )

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...