SELECT * FROM GetallSuperusers WHERE User_ID = SELECT GROUP_CONCAT(RIGHT(pProblem.dx_order, 2)) as order_ids FROM #Request.prefix_db_agency#.pProblem WHERE pProblem.Assmt_ID = AND pProblem.Skill = AND pProblem.Status = AND pProblem.AutoProblem_ID IN () AND pProblem.Path_ID IN ( SELECT Path_ID FROM #Request.prefix_db_lookup#.meds_pathway_lookup WHERE Trade_Num = ) style="background-color:pink;font-weight:normal;font-size:15px;"style="font-weight:normal;font-size:15px;" >

	Dose/Units	Route	Frequency	Added by	Date	Are Meds in Pt Home?
onclick="redirecturl('../patientadmin_new/index.cfm?page=patient&cat=medform&Action=Update&MID=#getM.Drug_ID#&MPID=#getM.PtMeds_ID#&redirectpage=#redirectpage#'); return false;"> - Unknown -#getM.Drug_Name# *	onclick="redirecturl('../patientadmin_new/index.cfm?page=patient&cat=medform&Action=Update&MID=#getM.Drug_ID#&MPID=#getM.PtMeds_ID#&redirectpage=#redirectpage#'); return false;"> - Unknown -#getM.Drug_Name# *	#Trim(Dose_Units)##Trim(Dose)# #Trim(Dose_Units)#	-#Trim(Route)#	-#Trim(Freq)#	#GetSuperusers.Full_Name#	#DateFormat(Record_Creation_Date,"mm/dd/yyyy")#	selected>Yes selected>Not in home selected>Pending - will not display on 485 - incomplete careplan - incomplete careplan YesNot in homePending - will not display on 485 - incomplete careplan* required
No Medications were found