Untitled query #36861

SQL

USE idwiki_p;
(SELECT GROUP_CONCAT(rc_actor DISTINCT) FROM recentchanges 
     WHERE rc_bot = 0 AND 0 <= rc_type 
     AND rc_type <= 4 
     AND rc_timestamp >= 20190612000000 
     AND rc_timestamp < 20190613000000 
     GROUP BY rc_namespace, rc_title 
     HAVING LOCATE('1', GROUP_CONCAT(rc_type)) > 0 ORDER BY MAX(rc_timestamp) DESC LIMIT 0, 100);
     /*
SELECT actor_id, actor_name FROM actor INNER JOIN 
	(SELECT rc_actor FROM recentchanges 
     WHERE rc_bot = 0 AND 0 <= rc_type 
     AND rc_type <= 4 
     AND rc_timestamp >= 20190612000000 
     AND rc_timestamp < 20190613000000 
     GROUP BY rc_namespace, rc_title 
     HAVING LOCATE('1', GROUP_CONCAT(rc_type)) > 0 ORDER BY MAX(rc_timestamp) DESC LIMIT 0, 100) as rc 

ON rc.rc_actor = actor.actor_id;*/
SQL

Checking query status...
