Untitled query #36861

SQL

USE idwiki_p;
(SELECT
 	GROUP_CONCAT(rc_actor) as actors,
 	 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
  		SUBSTRING_INDEX(SUBSTRING_INDEX(actors, ',', numbers.n), ',', -1) name
		FROM
  			(SELECT 1 n UNION ALL SELECT 2
   				UNION ALL SELECT 3 UNION ALL SELECT 4) numbers INNER JOIN tablename
  				ON CHAR_LENGTH(tablename.name)
     			-CHAR_LENGTH(REPLACE(tablename.name, ',', ''))>=numbers.n-1
         ORDER BY n)
         */
     /*
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...
