SELECT Change_Memo, HHA_Reason_Code, HHA_Action_Code FROM #Request.prefix_db_lookup#.EVV_Update_Log WHERE Schedule_ID = AND Agency_ID = AND Status = 0 ORDER BY Update_Log_ID DESC LIMIT 1 #serializeJSON(response)# SELECT San_status FROM #Request.prefix_db_lookup#.EVV WHERE LOWER(TRIM(IFNULL(API_Type, ''))) = AND Agency_ID = AND Schedule_ID = AND status = ORDER BY EVV_ID DESC LIMIT 1 #serializeJSON(response)#