Is it only me or this is what's happening?
I just want to get all posts starting from a certain offset, like 10. Instead I get all posts starting from the 0.
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It only takes a minute to sign up.Sign up to join this community
posts_per_page => -1 is equivalent to
'nopaging' => true, which basically means no LIMIT clause is used at all.
The workaround is to set posts_per_page to a large number.
This is a limitation of the LIMIT syntax itself: