26.04.2006, 13:32 | #1 |
Участник
|
Временная таблица + 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 в несколько десятков раз вместо одного. |
|
|
Похожие темы | ||||
Тема | Ответов | |||
Отчет и временная таблица | 2 | |||
Временная таблица | 21 | |||
производительность: map или временная таблица | 5 | |||
select sum(amount) from временная таблица | 6 | |||
next и временная таблица | 3 |
|