Fork of Uploads of mine that are CC * 3.0 but not 4.0 by Lucas Werkmeister
This query is marked as a draft This query has been published by Mvolz.

SQL

AخA
 
SELECT page_title, tl1.tl_target_id,
FROM page
JOIN linktarget
 ON lt_id = t1_target_id
JOIN pagelinks -- links to my user page (probably uploaded by me, false positives could be reviewed manually)
 ON page_id = pl_from
 AND pl_from_namespace = 6 -- NS_FILE
 AND pl_namespace = 2 -- NS_USER
 AND pl_title = 'Mvolz'
JOIN templatelinks AS tl1 -- transcludes any CC * 3.0 template
 ON page_id = tl1.tl_from
 AND tl1.tl_from_namespace = 6 -- NS_FILE
 AND tl1.tl_namespace = 10 -- NS_TEMPLATE
 AND tl1.tl_title LIKE 'Cc-%-3.0%'
LEFT JOIN templatelinks AS tl2 -- does not (IS NULL below) transclude any CC * 4.0 template
 ON page_id = tl2.tl_from
 AND tl2.tl_from_namespace = 6 -- NS_FILE
 AND tl2.tl_namespace = 10 -- NS_TEMPLATE
 AND tl2.tl_title LIKE 'Cc-%-4.0%'
WHERE page_namespace = 6 -- NS_FILE
 AND tl2.tl_from IS NULL;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...