SELECT * FROM #Request.prefix_db_lookup#.Assessment_Questions_lookup JOIN #Request.prefix_db_lookup#.Assessment_Answer_lookup ON Assessment_Answer_lookup.question_id = Assessment_Questions_lookup.id WHERE Assessment_Questions_lookup.Deleted <> 1 AND Assessment_Questions_lookup.new_oasis <> 1 AND Assessment_Answer_lookup.Deleted <> 1 AND Assessment_Questions_lookup.assessment_reason = '#assessment_reason#' AND Assessment_Questions_lookup.questions like 'GG0%' AND Assessment_Questions_lookup.wizard = '#wizard#' OR (Assessment_Questions_lookup.wizard = '0' AND Assessment_Questions_lookup.assessment_reason = '#assessment_reason#') ORDER BY Assessment_Questions_lookup.order_id ASC SELECT MAX(wizard) as count FROM Assessment_Questions_lookup WHERE assessment_reason = '#assessment_reason#' AND Assessment_Questions_lookup.Deleted <> 1 AND Assessment_Questions_lookup.new_oasis <> 1 SELECT * FROM #Request.prefix_db_lookup#.Assessment_Questions_lookup JOIN #Request.prefix_db_lookup#.Assessment_Answer_lookup ON Assessment_Answer_lookup.question_id = Assessment_Questions_lookup.id WHERE Assessment_Questions_lookup.Deleted <> 1 AND Assessment_Questions_lookup.new_oasis <> 1 AND Assessment_Answer_lookup.Deleted <> 1 AND Assessment_Questions_lookup.assessment_reason = '#assessment_reason#' AND Assessment_Questions_lookup.wizard = '#wizard#' OR (Assessment_Questions_lookup.wizard = '0' AND Assessment_Questions_lookup.assessment_reason = '#assessment_reason#') ORDER BY Assessment_Questions_lookup.order_id ASC SELECT * FROM #Request.prefix_db_lookup#.pain_braden_questions_lookup WHERE pain_braden_questions_lookup.Deleted <> 1 AND pain_braden_questions_lookup.assessment_reason = '#assessment_reason#' AND pain_braden_questions_lookup.type = '#type#' SELECT * FROM #Request.prefix_db_lookup#.pain_braden_answers_lookup WHERE pain_braden_answers_lookup.Deleted <> 1 AND pain_braden_answers_lookup.question_id = #question_id# SELECT * FROM #Request.prefix_db_lookup#.pain_braden_questions_lookup JOIN #Request.prefix_db_lookup#.pain_braden_answers_lookup ON pain_braden_answers_lookup.question_id = pain_braden_questions_lookup.id WHERE pain_braden_answers_lookup.Deleted <> 1 AND pain_braden_questions_lookup.Deleted <> 1 AND pain_braden_questions_lookup.assessment_reason = '#assessment_reason#' AND pain_braden_questions_lookup.type = '#type#' SELECT * FROM #Request.prefix_db_lookup#.pain_braden_questions_lookup JOIN #Request.prefix_db_lookup#.pain_braden_answers_lookup ON pain_braden_answers_lookup.question_id = pain_braden_questions_lookup.id WHERE pain_braden_answers_lookup.Deleted <> 1 AND pain_braden_questions_lookup.Deleted <> 1 AND pain_braden_questions_lookup.assessment_reason = '#assessment_reason#' AND pain_braden_questions_lookup.type = '#type#' SELECT * FROM #Request.prefix_db_agency#.Assessment_New WHERE Patient_ID = '#session.cs.patientid#' AND Assessment_ID = '#session.cs.assessment_id#' AND Deleted <> 1 date_diff_M0104 gt 2 OR date_diff_M0102 gt 2> SELECT Diagnosis_ID,Diagnosis,Short_Diagnosis,Text_ICD,M0245_ICD, Severity,ICD,CONVERT(Diagnosis.Dx_Order, CHAR(10)) as Dx_Order,Primary_Diagnosis,DG_Usage, Secondary_Diagnosis,DG_Type,error_check from #Request.prefix_db_agency#.Diagnosis WHERE Assessment_ID= AND patient_ID = AND M0230_Link like '%M0230%' and M0230_Link is not null order by Dx_Order asc SELECT * FROM #Request.prefix_db_lookup#.companion_diagnosis_lookup WHERE companion_diagnosis_lookup.diagnosis_1 = companion_diagnosis_lookup.diagnosis_2 = SELECT * FROM #Request.prefix_db_agency#.Assessment_New JOIN #Request.prefix_db_agency#.patient ON patient.Patient_ID = Assessment_New.Patient_ID WHERE Assessment_ID = SELECT * FROM #Request.prefix_db_agency#.Assessment_New WHERE Patient_ID = AND Start_of_Care_M0030 = AND Assessment_Reason_M0100 = '9 - Discharge from agency' ORDER BY Assessment_ID DESC LIMIT 0,1 SELECT * FROM #Request.prefix_db_agency#.Coding_Results WHERE Patient_ID = AND Assessment_ID = AND Question_ID =