SELECT * FROM lot l WHERE beurs_item_id = ? AND title NOT LIKE "NO LOT" LIMIT 24 OFFSET 48