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
FROM revision rn, page, actor, `comment`, revision ro
WHERE
	rn.rev_timestamp REGEXP '^202' 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=ro.rev_id AND
    (CONVERT(rn.rev_len,SIGNED)-CONVERT(ro.rev_len,SIGNED)) = -17 AND
    NOT EXISTS (SELECT * FROM revision rc WHERE rc.rev_parent_id=rn.rev_id)
ORDER BY rev_timestamp DESC

SQL

Checking query status...