Запрос вроде в порядке...
Код:
SELECT * FROM InventTable USING INDEX ItemIdx
JOIN * FROM OwnerTM
WHERE InventTable.OwnerTMId = OwnerTM.OwnerTMId
JOIN * FROM InventSummaryData
WHERE InventTable.ItemId = InventSummaryData.ItemId
AND ((InventLocationAbstractId = 05PRO))
JOIN * FROM InventSummarySales
WHERE InventTable.ItemId = InventSummarySales.ItemId
AND ((CalculationId = 26609392))
JOIN * FROM RetailShopLocationGroupInventSettings
WHERE InventTable.ItemId = RetailShopLocationGroupInventSettings.ItemId
AND ((ShopId = 05PRO))
JOIN * FROM RetailShopLocationGroupInvent
WHERE InventTable.ItemId = RetailShopLocationGroupInvent.ItemId
JOIN * FROM RetailShopLocationGroup
WHERE RetailShopLocationGroupInvent.LocationGroupId = RetailShopLocationGroup.LocationGroupId
JOIN * FROM RetailShopLocationGroupSettings
WHERE RetailShopLocationGroup.LocationGroupId = RetailShopLocationGroupSettings.LocationGroupId
AND ((ShopId = 05PRO))
EXISTS JOIN * FROM InventItemRangeRef
WHERE InventTable.ItemRangeIdRef = InventItemRangeRef.RangeIdRef
AND ((RangeIdRefParent = 881))