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.