SELECT  patient_interferences.id,patient_interferences.id,icd10s.description AS icd10_name,icd10s.code AS icd10_code,ncsp_string.name AS nscp,ncsp.code AS nscp_code,patient_interferences.interference_date,departments._Description AS clinic_department,patient_interferences.comment FROM [patient_interferences] LEFT JOIN icd10s ON patient_interferences.icd10_id = icd10s.id LEFT JOIN users AS doctors ON patient_interferences.doctor_id = doctors.id LEFT JOIN [vabaco_hr_prod_1].[dbo].[_Reference100] AS business_units ON patient_interferences.business_unit_id = CONVERT(CHAR(34), business_units._IDRRef,1) LEFT JOIN [vabaco_hr_prod_1].[dbo].[_Reference100] AS departments ON patient_interferences.department_id = CONVERT(CHAR(34), departments._IDRRef,1) OUTER APPLY (SELECT STUFF((SELECT '', '' + CASE WHEN interference_ncsps.ncsp_manually = 1 THEN interference_ncsps.ncsp_text ELSE ncsp_elements.name END
                                                FROM interference_ncsps
                                                LEFT JOIN ncsp_elements ON interference_ncsps.ncsp_element_id = ncsp_elements.id
                                                WHERE interference_ncsps.patient_interference_id = patient_interferences.id
                                                FOR XML PATH(''''),TYPE).
                                               VALUE(''.'', ''nvarchar(MAX)''),1,2,'''') AS ncsp_string
                                 ) AS ncsps WHERE ( patient_interferences.patient_id = 7 AND patient_interferences.mark_for_deletion = 0)  ORDER BY patient_interferences.interference_date DESC OFFSET 0 ROWS FETCH NEXT 30 ROWS ONLY'