SELECT
Dx_list_ICD10_PDGM.ID as Dx_id,Dx_list_ICD10_PDGM.Diagnosis as Dx_Diagnosis,Dx_list_ICD10_PDGM.ICD as Dx_ICD,Dx_list_ICD10_PDGM.Pathway_ID as Dx_Pathway_ID
FROM
#Request.prefix_db_lookup#.Dx_list_ICD10_PDGM
WHERE
Dx_list_ICD10_PDGM.ICD LIKE '%#url.text#%'
OR Diagnosis like '%#url.text#%'
Order by Dx_list_ICD10_PDGM.ID
