nlwiki Mistakes by Just Another Bot

SQL

/*SELECT page_title, revnew.rev_timestamp AS timestamp, revold.rev_len AS 'old-len', revnew.rev_len AS 'new-len', comment_text
FROM revision revnew, revision revold, page, `comment`
WHERE
	revnew.rev_actor=(SELECT actor_id FROM actor WHERE actor_name='Just Another Bot') AND
    revnew.rev_page=page_id AND page_namespace=3 AND revnew.rev_comment_id=comment_id AND
    revnew.rev_parent_id=revold.rev_id
#ORDER BY revnew.rev_timestamp
LIMIT 10*/
SELECT pl_title AS `to`, pf.page_title AS `from`
FROM pagelinks, page pf
WHERE
	pl_from_namespace=3 AND
    pl_namespace=3 AND
    pl_title REGEXP '^[0-9A-F\\.:]+$' AND
    pf.page_id=pl_from AND
    pf.page_title REGEXP '^[0-9A-F\\.:]+$/[0-9]+'
LIMIT 10
SQL

Checking query status...
