X++ SQL to SQL Server Conversion: PurchTable and IdcfCodeLine Query

SELECT TOP * FROM PurchTable WITH (INDEX=PurchIdx) LEFT JOIN IdcfCodeLine AS IdcfCodeLine_1 ON (IdcfTypeCd = N'355') LEFT JOIN IdcfCodeLine AS IdcfCodeLine_1_1 ON IdcfCodeLine_1.IdcfCodeFreeStrSpace = IdcfCodeLine_1_1.IdcfCodeFreeStrSpace AND (IdcfTypeCd = N'355') WHERE (IdcfCodeLine_1_1.IdcfCodeFreeStrSpace2 LIKE '31%' OR PurchTable.IdcfApplicantDept LIKE '31%') AND PurchTable.IdcfApplicantDept LIKE IdcfCodeLine_1_1.IdcfCodeFreeStrSpace2 + '%' AND (PurchTable.IdcfDrafterId = 'hongmin.liang' OR PurchTable.IdcfApplicantId = 'hongmin.liang') AND PurchTable.IdcfPurchCategory_1 != '43支払依頼:秘匿'