Untitled query #59489

SQL

set @dbname = 'tewiki';

  select
    actor_name,count(img_name)
--    LEFT(rev_timestamp,8) as date,
--    CONCAT("[[:File:",img_name,"]]") as pagename

  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)

--    actor_name="Chaduvari"
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" 
    ))    
group by actor_name
order by count(img_name) desc
SQL

Checking query status...
