<xml>
CREATE TABLE #tempSessionID
(
    ID   BIGINT
);
<xml>

<xml>
INSERT INTO #tempSessionID VALUES (), ()
</xml>


</xml>
SELECT src.ID, *
  FROM TEMPLATE_INSTANCE_ATTR_VAL val
    INNER JOIN #tempSessionID tempID ON tempID = src.TARGET_RECORD_ID
    INNER JOIN ATTRIBUTE_SOURCE src ON src.ATTR_VAL_ID = val.ID
    INNER JOIN ATTRIBUTE_SOURCE_TYPE srcType ON srcType.ID = src.ATTRIBUTE_SOURCE_TYPE_ID AND srcType.ALIAS = 'item'
    INNER JOIN TEMPLATE_ATTRIBUTE_PROP prop ON prop.ATTRIBUTE_ID = val.ATTRIBUTE_ID AND prop.PROPERTY_ID != 1

SELECT src.ID, *
  FROM ATTRIBUTE_SOURCE src
    INNER JOIN #tempSessionID tempID ON tempID = src.TARGET_RECORD_ID
    INNER JOIN TEMPLATE_INSTANCE_ATTR_VAL val ON val.ID = src.ATTR_VAL_ID
    INNER JOIN ATTRIBUTE_SOURCE_TYPE srcType ON srcType.ID = src.ATTRIBUTE_SOURCE_TYPE_ID AND srcType.ALIAS = 'item'
    INNER JOIN TEMPLATE_ATTRIBUTE_PROP prop ON prop.ATTRIBUTE_ID = val.ATTRIBUTE_ID AND prop.PROPERTY_ID != 1
</xml>


<xml>
DROP TABLE #tempSessionID
</xml>