SELECT * FROM photographs LIMIT 8 OFFSET 10

This will return a “limit of 8”, with an “offset of 10”.