Testing [[phab:T177096]]

SQL

(SELECT DISTINCT page_namespace AS namespace, 'rev' AS type, page_title AS page_title,
    page_len, page_is_redirect, rev_timestamp AS rev_timestamp,
    rev_user, rev_user_text AS username, rev_len, rev_id , pa_class, pa_importance, pa_page_revision
FROM `enwiki_p`.`page`
JOIN `enwiki_p`.`revision_userindex` ON page_id = rev_page
LEFT JOIN `enwiki_p`.`page_assessments` ON rev_page = pa_page_id
WHERE  rev_user = '11656865' AND rev_timestamp > 1  AND rev_parent_id = '0'  AND page_namespace = '0'   AND page_is_redirect = '0' 
GROUP BY rev_page
)

UNION

(SELECT a.ar_namespace AS namespace, 'arc' AS type, a.ar_title AS page_title,
    0 AS page_len, '0' AS page_is_redirect, MIN(a.ar_timestamp) AS rev_timestamp,
    a.ar_user AS rev_user, a.ar_user_text AS username, a.ar_len AS rev_len,
    a.ar_rev_id AS rev_id , NULL AS pa_class, NULL AS pa_page_id, NULL AS pa_page_revision
FROM `enwiki_p`.`archive_userindex` a
JOIN
(
    SELECT b.ar_namespace, b.ar_title
    FROM `enwiki_p`.`archive_userindex` AS b
    LEFT JOIN `enwiki_p`.`logging_userindex` ON log_namespace = b.ar_namespace AND log_title = b.ar_title
        AND log_user = b.ar_user AND (log_action = 'move' OR log_action = 'move_redir')
    WHERE  ar_user = '11656865' AND ar_timestamp > 1  AND b.ar_parent_id = '0'  AND ar_namespace = '0'  AND log_action IS NULL
) AS c ON c.ar_namespace= a.ar_namespace AND c.ar_title = a.ar_title
GROUP BY a.ar_namespace, a.ar_title
HAVING  rev_user = '11656865' 
)
SQL

Checking query status...
