FROM DLN1 a inner join (SELECT Distinct T0.DocEntry, T0.BaseEntry FROM INV1 T0 inner join OINV T1 on T0.DocEntry=T1.DocEntry AND T0.BaseType=15
AND (T1.CardCode='[%0]' or IsNull('[%0]','')='') AND (T1.DocEntry=[%1] or IsNull([%1],0)=0) AND (T1.TransId=[%2] or IsNull([%2],0)=0)
) b on a.DocEntry=b.BaseEntry left join ORDR c on a.BaseEntry=c.DocEntry and a.BaseType=17
left join RDN1 d on a.DocEntry=d.baseEntry AND a.ItemCode=d.ItemCode and d.baseType=15
inner join OWHS w on a.whsCode=w.whscode inner join ODLN l on a.docEntry=l.docEntry
WHERE (a.ItemCode='[%3]' or IsNull('[%3]','')='')