Active newcomers engaged in newcomer spaces (since June 2014)

SQL

SELECT DISTINCT user_id, user_name, user_registration, user_editcount
FROM page
INNER JOIN user
	ON user_name = REPLACE(SUBSTRING_INDEX(page_title, "/", 1), "_", " ")
WHERE
	page_namespace = 2 AND
	page_title LIKE "%/TWA%" AND
	user_editcount > 50 AND
	user_registration > "20140601"
UNION
SELECT DISTINCT user_id, user_name, user_registration, user_editcount
FROM revision_userindex
INNER JOIN page ON rev_page = page_id
INNER JOIN user ON rev_user = user_id
WHERE
    page_namespace IN (4,5) AND
    (
        page_title LIKE "Teahouse%" OR
        page_title LIKE "Articles_for_creation%"
    ) AND
    rev_timestamp > "20140601" AND
    user_editcount > 50 AND
    user_registration > "20140601";

SQL

Checking query status...