All files on fa.wiki with no license

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

#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
;

SQL

Checking query status...