SELECT pAdmit.drafts FROM #Request.prefix_db_agency#.pAdmit WHERE pAdmit.Patient_ID = AND pAdmit.Status = AND pAdmit.Admit_ID = ( SELECT Admit_ID FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND Status = LIMIT 1 ) ORDER BY pAdmit.Admit_ID DESC LIMIT 1 SELECT PtMeds_ID FROM #Request.prefix_db_agency#.pPtmeds WHERE Patient_ID = AND Status = AND ( LOWER(TRIM(IFNULL(Dose_Units,''))) = OR LOWER(TRIM(IFNULL(Route,''))) = OR LOWER(TRIM(IFNULL(Freq,''))) = OR In_Home IS NULL OR In_Home = ) LIMIT 1