Untitled query #36487

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_actor) AS actors,
        GROUP_CONCAT(rc_this_oldid) AS diffs,
        GROUP_CONCAT(rc_last_oldid) AS prev_diffs
    FROM recentchanges
    INNER JOIN actor ON recentchanges.rc_actor = actor.actor_name
    WHERE
        rc_bot = 0 AND /* exclude bots */
        0 <= rc_type AND rc_type <= 4
    GROUP BY rc_namespace, rc_title
    HAVING LOCATE('1', GROUP_CONCAT(rc_type)) > 0
    ORDER BY MAX(rc_timestamp) DESC
    LIMIT 0, 100;
SELECT FOUND_ROWS();
SQL

Checking query status...
