[Lankey]

SELECT T1.CHILDPARTY,
	T1.LEGALENTITYDATAAREAID,
	T1.PARENTPARTY,
	T1.RELATIONSHIPTYPEID,
	T1.VALIDFROM,
	T1.VALIDFROMTZID,
	T1.VALIDTO,
	T1.VALIDTOTZID,
	T1.SCHEMAVERSION,
	T1.RECVERSION,
	T1.PARTITION,
	T1.RECID,
	T2.CHILDPARENTNAME,
	T2.CHILDPARTYTYPE,
	T2.DESCRIPTION,
	T2.ISSYMMETRIC,
	T2.PARENTCHILDNAME,
	T2.PARENTPARTYTYPE,
	T2.RELATIONSHIPTYPEID,
	T2.SYSTEMTYPE,
	T2.RECVERSION,
	T2.PARTITION,
	T2.RECID,
	T3.NAME,
	T3.RECVERSION,
	T3.RECID,
	T3.INSTANCERELATIONTYPE,
	T4.NAME,
	T4.RECVERSION,
	T4.RECID,
	T4.INSTANCERELATIONTYPE 
FROM DIRPARTYRELATIONSHIP T1 CROSS 
JOIN DIRRELATIONSHIPTYPETABLE T2 LEFT 
OUTER 
JOIN DIRPARTYTABLE T3 ON ((T3.PARTITION=5637144576) 
	AND (T1.CHILDPARTY=T3.RECID)) LEFT 
OUTER 
JOIN DIRPARTYTABLE T4 ON ((T4.PARTITION=5637144576) 
	AND (T1.PARENTPARTY=T4.RECID)) 
WHERE ((T1.PARTITION=5637144576) 
	AND ((T1.PARENTPARTY=0) 
	OR (T1.CHILDPARTY=0))) 
	AND ((T2.PARTITION=5637144576) 
	AND (((T2.SYSTEMTYPE<29) 
	OR (T2.SYSTEMTYPE>40)) 
	AND (T1.RELATIONSHIPTYPEID=T2.RELATIONSHIPTYPEID))) 
	AND (
EXISTS (
SELECT 'X' 
FROM DIRPARTYRELATIONSHIPSUNIONVIEW T5 
WHERE ((T5.PARTITION=5637144576) 
	AND (((T5.SYSTEMTYPE<29) 
	OR (T5.SYSTEMTYPE>40)) 
	AND (T1.CHILDPARTY=T5.OTHERPARTY))))) 
	AND (
EXISTS (
SELECT 'X' 
FROM DIRPARTYRELATIONSHIPSUNIONVIEW T6 
WHERE ((T6.PARTITION=5637144576) 
	AND (((T6.SYSTEMTYPE<29) 
	OR (T6.SYSTEMTYPE>40)) 
	AND (T1.PARENTPARTY=T6.OTHERPARTY))))) 
	ORDER BY T1.VALIDFROM DESC OPTION(FAST 9)

Это из трейспарсера. В SQL Server Management Studio возвращает тут же 0 записей.