Untitled query #73109

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= 'محتویات_آزاد' #Free
OR cl_to= 'محتویات_آزاد_در_ایالات_متحده_آمریکا' #Free in us
OR cl_to= 'محتویات_غیر_آزاد' #Non-free1
      ))
GROUP BY img_name ASC
;
SQL

Checking query status...
