Creation user and date for local media files with no license

For images without license information, output created user and date, used the logic of  https://quarry.wmcloud.org/query/53676

SQL

set @dbname = 'tewiki';

  select 

    CONCAT("File:", img_name) as pagename


  from  image 
  join  page ON  page_namespace=6  AND page_title=img_name
  join revision ON     rev_page = page_id AND  rev_parent_id = 0
  join actor ON    actor_id=rev_actor
  where
    page_is_redirect=0  

AND NOT EXISTS(
SELECT * FROM categorylinks 
WHERE page_id=cl_from 
AND (cl_to="All_free_media" 
OR cl_to= "అన్నిరకాల_ఉచితం_కాని_దస్త్రాలు"
OR cl_to= "All_non-free_media"
OR cl_to= "All_free_in_US_media" 
    ))    

ORDER BY actor_name
LIMIT 10000

SQL

Checking query status...