#USE viwiki_p;

SELECT

 CONCAT("# [[:File:", img_name, "]]")  AS file, actor_name #, GROUP_CONCAT(c.cl_from SEPARATOR ' ¤¤¤ ')

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 LIKE 'Imagini_Creative_Commons%' 

cl_to= "All_free_media"

OR cl_to= "All_free_in_US_media" 

#OR cl_to LIKE "Imagini_din%" 

OR cl_to= "All_non-free_media"

    ))

###

#OR cl_to LIKE 'GFDL-B%'

#OR cl_to LIKE 'Public-Domain%'

###

GROUP BY img_name ASC