idwikibooks_p - Quarry

SQL

USE idwikibooks_p;
SELECT SQL_CALC_FOUND_ROWS rc_namespace, rc_title, rc_cur_id, GROUP_CONCAT(rc_log_type) AS log_types, GROUP_CONCAT(rc_log_action) AS log_actions, GROUP_CONCAT(rc_type) AS types, GROUP_CONCAT(rc_timestamp) AS timestamps, GROUP_CONCAT(rc_actor) AS actors, GROUP_CONCAT(rc_this_oldid) AS diffs, GROUP_CONCAT(rc_last_oldid) AS prev_diffs FROM recentchanges WHERE rc_bot = 0 AND /* exclude bots */ 0 <= rc_type AND rc_type <= 4 AND rc_timestamp >= 20190600000000 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;
SQL

Checking query status...
