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 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>