Untitled query #59490

SQL

set @dbname = 'tewiki';

  select DISTINCT
--    actor_name,
--    LEFT(rev_timestamp,8) as date,
    CONCAT("దస్త్రం:",img_name) as pagename
-- img_name

  from
    image,
    page,
    actor,
    revision
  where
    page_title=img_name and
    page_namespace = 6 and
    page_is_redirect=0  AND
    rev_page = page_id AND
    rev_parent_id = 0 AND
    actor_id=rev_actor and
    img_name not in (select il_to from imagelinks)
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...
