SELECT page.page_title, first_actor.actor_name, MIN(rev.rev_timestamp) AS rev_timestamp

FROM 

  (SELECT rev_page, rev_actor, rev_timestamp

   FROM revision_userindex

   JOIN actor_revision ON actor_revision.actor_id = rev_actor

   WHERE actor_revision.actor_name = 'RangersRus'

  ) AS rev

JOIN page ON rev.rev_page = page.page_id

JOIN revision_userindex AS first_rev ON first_rev.rev_page = page.page_id

AND first_rev.rev_parent_id = 0

JOIN actor_revision AS first_actor ON first_actor.actor_id = first_rev.rev_actor

WHERE page.page_namespace = 4

AND page.page_title LIKE 'Articles_for_deletion/%'

AND NOT page.page_title LIKE 'Articles_for_deletion/Log/%'

GROUP BY page.page_title, first_actor.actor_name

ORDER BY rev.rev_timestamp DESC;