Article creations since 2016 (enwikivoyage)

SQL

USE enwikivoyage_p;
SELECT rev_id, rev_timestamp, page_id, page_title, user_id, actor_name, user_registration, ug_group FROM revision_userindex
INNER JOIN actor ON rev_actor = actor_id
INNER JOIN page ON rev_page = page_id
LEFT JOIN user ON actor_user = user_id
LEFT JOIN user_groups ON ug_user = user_id AND ug_group = "bot"
WHERE rev_parent_id = 0 AND page_namespace = 0 AND rev_timestamp > "2016"
UNION ALL
SELECT 
	ar_rev_id AS rev_id, 
    ar_timestamp AS rev_timestamp, 
    ar_page_id AS page_id, 
    ar_title AS page_title, 
    user_id, 
    actor_name, 
    user_registration, 
    ug_group 
FROM archive_userindex
INNER JOIN actor ON ar_actor = actor_id
LEFT JOIN user ON ar_user = user_id
LEFT JOIN user_groups ON ug_user = user_id AND ug_group = "bot"
WHERE ar_parent_id = 0 AND ar_namespace = 0 AND rev_timestamp > "2016"
SQL

Checking query status...
