Inactive admins in recent 7 days

Fork of Active admins in main, file namespace in recent 7 days by Arjunaraoc

This query is marked as a draft This query has been published by Arjunaraoc.

SQL

(Select 
     REPLACE(page_title,"_"," ") as user_name
FROM page
join categorylinks ON cl_from=page_id AND cl_type="page"
WHERE   cl_to ="వికీపీడియా_నిర్వాహకులు")
EXCEPT 
(SELECT 
    DISTINCT (user_name) as username
FROM revision
JOIN page ON revision.rev_page = page.page_id 
JOIN actor
     ON rev_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 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...