Fork of
All files on si.wiki with no license
by MGA73
This query is marked as a draft
This query has been published
by MGA73.
SQL
AخA
#USE glwiki_p;
SELECT
CONCAT("* [[:File:", img_name, "]]") AS file #,
# img_timestamp AS img_creation
# ^^Timestamp of when upload took place. Not necessarily the same timestamp as logging.log_timestamp.
FROM image
JOIN page
ON page_namespace = 6
AND page_title = img_name
JOIN categorylinks
ON cl_from = page_id
AND cl_type = "file"
#AND cl_to = "No_license" # ENTER THE CATEGORY HERE
AND page_is_redirect=0
AND NOT EXISTS(
SELECT * FROM categorylinks
WHERE page_id=cl_from
AND (#cl_to LIKE 'Imagini_Creative_Commons%'
cl_to= 'محتویات_آزاد'
OR cl_to= 'محتویات_غیر_آزاد'
))
GROUP BY img_name ASC
;
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.