Limit and offset should limit the main record
Stick the where clause inside the limited select