X++ SQL to SQL Server Conversion: Purchasing Table Query

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