We recently added index on (author_id, id, created_at) which covers this one

Changelog: performance