Might something like this work? SELECT * FROM items WHERE ((cn_sort = ? AND itemnumber >= ?) OR (cn_sort > ?)) AND homebranch = ? AND location = ? ORDER BY cn_sort, itemnumber ASC LIMIT 3