Templates created recently by unconfirmed accounts

SQL

SELECT user_name, rc_title, user_registration, rc_timestamp, COUNT(DISTINCT rev_id) AS Nth_edit
FROM recentchanges
JOIN actor ON actor_id = rc_actor
JOIN user ON user_id = actor_user AND (rc_timestamp < DATE_ADD(user_registration, INTERVAL 4 DAY) OR user_editcount < 10)
LEFT JOIN page ON page_id = rc_cur_id
JOIN revision_userindex ON rev_actor = rc_actor AND rev_timestamp BETWEEN user_registration AND rc_timestamp
WHERE rc_type = 1 /* RC_NEW */ AND rc_namespace = 10 /* Template: */ /* AND NOT (page_is_redirect = 1) */
GROUP BY user_name, rc_title, user_registration, rc_timestamp
HAVING Nth_edit <= 10

SQL

Checking query status...