Untitled query #36487

SQL

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 >= $query_date_min AND rc_timestamp < $query_date_max
    GROUP BY rc_namespace, rc_title
    ORDER BY MAX(rc_timestamp) DESC
    LIMIT $offset_rows, 100;
SQL

Checking query status...
