X++:
(@P1 bigint,@P2 bigint,@P3 int,@P4 int,@P5 int,@P6 int,@P7 int,@P8 int)
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=@P1) OR (T1.CHILDPARTY=@P2)))
AND ((T2.PARTITION=5637144576) AND (((T2.SYSTEMTYPE<@P3) OR (T2.SYSTEMTYPE>@P4))
AND (T1.RELATIONSHIPTYPEID=T2.RELATIONSHIPTYPEID)))
AND
(EXISTS (SELECT 'x' FROM DIRPARTYRELATIONSHIPSUNIONVIEW T5
WHERE ((T5.PARTITION=5637144576)
AND (((T5.SYSTEMTYPE<@P5) OR (T5.SYSTEMTYPE>@P6)) AND (T1.CHILDPARTY=T5.OTHERPARTY)))))
AND
(EXISTS (SELECT 'x' FROM DIRPARTYRELATIONSHIPSUNIONVIEW T6
WHERE ((T6.PARTITION=5637144576) AND (((T6.SYSTEMTYPE<@P7) OR (T6.SYSTEMTYPE>@P8)) AND (T1.PARENTPARTY=T6.OTHERPARTY)))))
ORDER BY T1.VALIDFROM DESC OPTION(FAST 8)
В dirPartyTable 84024 записи
В dirPartyRelationship 284046 записи
В dirRelationshipTypeTable 42 записи
В трейспарсере то же самое, но с подставленными значениями