Inactive admins in recent 7 days

SQL

(Select 
     REPLACE(page_title,"_","")as user_name
FROM page
join categorylinks ON cl_from=page_id AND cl_type="page"
 WHERE   cl_to ="వికీపీడియా_నిర్వాహకులు")
MINUS 
(SELECT DISTINCT 
     user_name
FROM revision
JOIN page ON revision.rev_page = page.page_id 
JOIN revision_actor_temp
     ON  revactor_rev=rev_id
JOIN actor
     ON revactor_actor=actor_id
JOIN user
     ON user_id =actor_user
WHERE LEFT(rev_timestamp,8)  >= REPLACE(CURDATE() - interval 7 day,'-','') AND LEFT(rev_timestamp,8)  != REPLACE(CURDATE(),'-','')
      AND page_namespace  IN (0,6)
      AND REPLACE(user_name," ","_") in (
			Select page_title
			FROM page
			join categorylinks ON cl_from=page_id AND cl_type="page"
        WHERE   cl_to ="వికీపీడియా_నిర్వాహకులు") )
LIMIT 100;
SQL

Checking query status...
