SELECT page_title, revs.rev_timestamp, revs.rev_comment,

       (CAST(revs.rev_len AS SIGNED) - IFNULL(parentrevs.rev_len, 0)) AS diff_size

FROM revision_userindex AS revs

LEFT JOIN revision_userindex AS parentrevs ON (revs.rev_parent_id = parentrevs.rev_id)

JOIN page ON revs.rev_page = page_id

WHERE revs.rev_user = 54890

AND page_namespace = 4

AND page_title RLIKE "Articles_for_deletion"

AND (

  revs.rev_comment RLIKE "Closed as" OR

  revs.rev_comment RLIKE "result was"

)

ORDER BY revs.rev_timestamp DESC

LIMIT 500