Untitled query #26699

SQL

/* select page_namespace, cast(page_title as char) title, cast(actor_name as char) user 
from revision join page on rev_page=page_id 
join actor on actor_id=rev_actor 
where actor_user in (select ug_user from user_groups where (ug_group = "sysop" or ug_group = "closer")) 
and rev_timestamp >=" + now.AddMonths(-6).Year + mnumber(now.AddMonths(-6).Month) + "01000000 and rev_timestamp <" + now.Year + mnumber(now.Month) + "01000000;
*/
USE ruwiki_p;
SELECT DISTINCT rev_page 
  FROM revision
 WHERE rev_actor IN (SELECT actor_id FROM actor INNER JOIN user_groups ON ug_user=actor_user WHERE ug_group IN ("sysop", "closer"))
   AND rev_timestamp BETWEEN 20200101000000 AND 20200102000000
-- LIMIT 10;
SQL

Checking query status...
