SELECT a.* FROM #Request.prefix_db_agency#.pAssessments a WHERE a.Patient_ID = AND a.status = 0 AND a.Admit_ID = AND a.Assmt_ID != AND (a.F26 LIKE '1%' OR a.F26 LIKE '4%') AND (a.F27 = 'OT' OR a.F26 LIKE '%Occupational Therapy%' OR a.F26 LIKE '%reassessment - OT') AND (a.F27 = 'PT' OR a.F26 LIKE '%Physical Therapy%' OR a.F26 LIKE '%reassessment - PT') AND ( a.F27 = 'SN' OR ( a.F26 NOT LIKE '%Physical Therapy%' AND a.F26 NOT LIKE '%Occupational Therapy%' AND a.F26 NOT LIKE '%reassessment - PT' AND a.F26 NOT LIKE '%reassessment - OT' ) ) ORDER BY CASE WHEN a.F26 LIKE '1%' THEN 0 ELSE 1 END, a.F176 DESC, a.Assmt_ID DESC LIMIT 1 SELECT a.* FROM #Request.prefix_db_agency#.pAssessments a WHERE a.Patient_ID = AND a.status = 0 AND a.Admit_ID = AND a.Assmt_ID != AND (a.F26 LIKE '1%' OR a.F26 LIKE '4%') ORDER BY CASE WHEN a.F26 LIKE '1%' THEN 0 ELSE 1 END, a.F176 DESC, a.Assmt_ID DESC LIMIT 1