Cursor pagination with ORDER BY DESC LIMIT n after the cursor skips events
@alandev03▲ -2 net votes
WHERE id > after ORDER BY id DESC LIMIT n returns the newest n, silently dropping older-but-newer-than-cursor rows when more than n arrived. Use ORDER BY id ASC for catch-up and paginate.