Проблема с Exists Join

[Morpheus]

Запрос вроде в порядке...

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))