SELECT * FROM #Request.prefix_db_lookup#.vetted_190924 as vt JOIN #Request.prefix_db_lookup#.CW_Coding_Class_PDGM as cw ON vt.Priority = cw.Priority WHERE vt.Pathway = cw.Pathway_ID AND vt.ICD = SELECT vt.id as id,vt.Diagnosis,vt.ICD as ICD,'ICD' as Code_Type,cw.Default as Pathway_Type,vt.Diagnosis_Short as Short_Diagnosis, vt.Comorbid as Other_DG,vt.PDGM,vt.Comorbid FROM #Request.prefix_db_lookup#.vetted_190924 as vt JOIN #Request.prefix_db_lookup#.CW_Coding_Class_PDGM as cw ON vt.Pathway = cw.Pathway_ID WHERE (vt.Diagnosis LIKE OR vt.ICD LIKE ) AND vt.MANIFESTATION_FLAG = GROUP BY vt.ID Order by vt.ICD SELECT vt.id as id,vt.Diagnosis,vt.ICD as ICD,'ICD' as Code_Type,cw.Default as Pathway_Type,vt.Diagnosis_Short as Short_Diagnosis, vt.Comorbid as Other_DG,vt.PDGM,vt.Comorbid FROM #Request.prefix_db_lookup#.vetted_190924 as vt JOIN #Request.prefix_db_lookup#.CW_Coding_Class_PDGM as cw ON vt.Priority = cw.Priority WHERE vt.ID = SELECT * FROM #Request.prefix_db_agency#.Diagnosis WHERE Patient_ID = AND Assessment_ID = AND M0230_Link like '%M0230%' and M0230_Link is not null AND Disabled <> 1 ORDER BY Dx_Order ASC