MariaDB [enwiki_p]> SELECT ar_namespace AS namespace, 'arc' AS type, ar_title AS page_title, 
       0 AS page_len, '0' AS page_is_redirect, MIN(ar_timestamp) AS rev_timestamp,
       ar_user AS rev_user, ar_user_text AS username, ar_len AS rev_len,
       ar_rev_id AS rev_id 
FROM `arwiki_p`.`archive_userindex` a
WHERE ar_user = '314820'\G;
*************************** 1. row ***************************
       namespace: 0
            type: arc
      page_title: بالمال_تستطيع_ان_تدخل_الجنة
        page_len: 0
page_is_redirect: 0
   rev_timestamp: 20150124195114
        rev_user: 314820
        username: علاء
         rev_len: 359
          rev_id: 14817206
1 row in set (0.02 sec)

MariaDB [enwiki_p]> (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
    ->             FROM `arwiki_p`.`archive_userindex` a
    ->             JOIN
    ->             (
    ->                 SELECT b.ar_namespace, b.ar_title
    ->                 FROM `arwiki_p`.`archive_userindex` AS b
    ->                 LEFT JOIN `arwiki_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 = '314820' 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 = '314820'
    ->             );
+-----------+------+--------------+----------+------------------+----------------+----------+----------+---------+----------+
| namespace | type | page_title   | page_len | page_is_redirect | rev_timestamp  | rev_user | username | rev_len | rev_id   |
+-----------+------+--------------+----------+------------------+----------------+----------+----------+---------+----------+
|         0 | arc  | تجربة22      |        0 | 0                | 20170307122534 |   314820 | علاء     |      26 | 22704217 |
+-----------+------+--------------+----------+------------------+----------------+----------+----------+---------+----------+
1 row in set (2 min 46.88 sec)