nlwiki Template edits from Telianet

SQL

SELECT 
	rn.rev_timestamp, rn.rev_len AS `new-len`, ro.rev_len AS `old-len`, page_title, actor_name, comment_text,
    NOT EXISTS (SELECT * FROM revision rc WHERE page_id=rc.rev_page AND rc.rev_parent_id!=0 AND rc.rev_parent_id=rn.rev_id) AS latest,
    GROUP_CONCAT(DISTINCT pr_level) AS pr_level
FROM revision rn, (page LEFT JOIN page_restrictions ON page_id=pr_page), actor, `comment`, revision ro
WHERE
	rn.rev_timestamp REGEXP '^202[234]' AND
    rn.rev_page=page_id AND
    page_namespace=10 AND
    rn.rev_actor=actor_id AND
    actor_user IS NULL AND
    rn.rev_comment_id=comment_id AND
    rn.rev_parent_id!=0 AND rn.rev_parent_id=ro.rev_id AND
    rn.rev_len<ro.rev_len AND
    actor_name REGEXP '^(5\\.24|31\\.208\\.|46\\.2|62\\.116\\.2|78\\.|80\\.|90\\.2|194\\.103\\.95\\.|217\\.2|2A04:AE00:2805:F600:)'
GROUP BY rev_timestamp, page_title
ORDER BY rev_timestamp DESC
SQL

Checking query status...
