#USE ukwiki_p;

SELECT

 CONCAT("# [[:File:", img_name, "]]") AS file, CONCAT("[[:User:", actor_name, "]]") as uploader

FROM templatelinks

JOIN page ON tl_from = page_id

JOIN image ON img_name = page_title AND page_namespace = 6

JOIN actor_image ON img_actor = actor_id

AND page_is_redirect=0 

AND NOT EXISTS(

SELECT * FROM categorylinks 

WHERE page_id=cl_from 

AND (cl_to="Вільні_файли" 

OR cl_to= "Файли_без_ліцензії"# Files_without_a_license

OR cl_to= "Невільні_файли"

OR cl_to= "All_free_in_US_media" 

    ))

GROUP BY img_name ASC