SQLite Forum

SELECT with LIMIT OFFSET clause return unexpected result (with sample db and query)
Login
Chronological Hierarchical 
>Did I misunderstand the query ?

Yes. It being a sub-query is part of whatever the bug is.

Can add that I'm seeing what they're seeing with the 3.37.2 CLI