Templates created recently by unconfirmed accounts

SQL

SELECT actor_user, page_id, rc_title
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 rv_user = actor_user AND rv_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 actor_user, page_id, rc_title
HAVING rc_timestamp < DATE_ADD(user_registration, INTERVAL 4 DAY) OR COUNT(*) <= 10

SQL

Checking query status...