Временная таблица + RLS
Наткнулся на следующую ситуацию.
Есть временная таблица (создается на сервере), к ней присоединена InventDim.
Все нормально работает.
Но как только на InventDim настроил RLS (в моем случае десяток складов, разделенных запятыми) то тут же начинаются жуткие тормоза при прокручивании записей в гриде, после чего аксапта вообще вылетает с сообщением, что сервер завершил сессию.
Если строк во временной таблице немного (порядка 100) то еще кое-как работает.
Посмотрел мониторинг запросов, испугался. Вот пример запроса:
SELECT A.INVENTDIMID,A.INVENTBATCHID,A.WMSLOCATIONID,A.WMSPALLETID,A.INVENTSERIALID,A.INVENTLOCATIONID,A.CONFIGID,A.INVENTSIZEID,A.INVENTCOLORID,A.INVENTGTDID_RU,A.RECID
FROM INVENTDIM A
WHERE ((DATAAREAID=?)
AND ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((INVENTDIMID=?)
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)))
AND (((((((((((((((((INVENTLOCATIONID=?) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?)) OR (INVENTLOCATIONID=?))))
ORDER BY A.DATAAREAID,A.INVENTDIMID OPTION(FAST 1)
Такое ощущение, что аксапта прибавила условия RLS в несколько десятков раз вместо одного.
|