SELECT Schedule_ID FROM #Request.prefix_db_agency#.pSchedules WHERE Patient_ID = AND Status = 0 AND IFNULL(Missed, 0) = 0 AND Visit_Type = AND ( Assmt_ID = OR Visit_Date = ) AND Schedule_ID <> LIMIT 1 SELECT Schedule_ID FROM #Request.prefix_db_agency#.pSchedules WHERE Patient_ID = AND Status = 0 AND IFNULL(Missed, 0) > 0 AND Visit_Type = AND Visit_Date = AND Schedule_ID <> LIMIT 1