Uploads of mine that are CC * 3.0 but not 4.0

SQL

SELECT page_title, tl1.tl_title
FROM page
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 = 'Lucas_Werkmeister'
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-%-4.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-%-3.0%'
WHERE page_namespace = 6 -- NS_FILE
 AND tl2.tl_from IS NULL;
SQL

Checking query status...
