Creation user and date for local media files with no license and no usage

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("[[User:",actor_name,"]]") as username,
    LEFT(rev_timestamp,8) as date,
    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 EXISTS(
SELECT * FROM categorylinks 
WHERE page_id=cl_from 
AND (cl_to="లైసెన్సు_సమాచారం_లేని,_ఎక్కడా_వాడని_దస్త్రాలు" 
))    

ORDER BY actor_name
LIMIT 10000

SQL

Checking query status...