Untitled query #9629

SQL

USE idwiki_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_user_text) AS users,
        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 >= 20160509000000 AND rc_timestamp < 20160510000000
    GROUP BY rc_namespace, rc_title
    ORDER BY MAX(rc_timestamp) DESC
    LIMIT 19, 100;
    
    SELECT FOUND_ROWS();
SQL

Checking query status...
