Untitled query #41432

SQL

SELECT page_title, revs.rev_timestamp, cmt.comment_text
FROM revision_userindex AS revs
LEFT JOIN revision_userindex AS parentrevs ON (revs.rev_parent_id= parentrevs.rev_id)
LEFT JOIN comment AS cmt ON revs.rev_comment_id = cmt.comment_id
LEFT JOIN page ON revs.rev_page = page_id
LEFT JOIN actor AS act ON revs.rev_actor = act.actor_id
LEFT JOIN user AS usr ON act.actor_user = usr.user_id
WHERE usr.user_name = "SoWhy"
AND page_namespace = 4
AND page_title RLIKE "Articles_for_deletion"
AND ((cmt.comment_text RLIKE "Closed as" AND cmt.comment_text RLIKE "XFDcloser") OR cmt.comment_text RLIKE "result was")
LIMIT 1
SQL

Checking query status...
