SELECT * FROM lot l WHERE veiling_item_id = ? AND ( SELECT id FROM lot_category lc WHERE lc.lot_id = l.id AND lc.category_id IN (34) LIMIT 1 ) IS NOT NULL AND title NOT LIKE "NO LOT" LIMIT 24 OFFSET 0