Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
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
.
Toggle Highlighting
SQL
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
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...