SELECT * FROM #Request.prefix_db_lookup#.assessment_questions_lookup as ques JOIN #Request.prefix_db_lookup#.assessment_answers_lookup as answ ON answ.question_id = ques.ques_id WHERE ques.Deleted = 0 AND answ.Deleted = 0 AND (ques.new_wizard = OR ( ques.new_wizard = 0 AND ques.display IN ('yes','VertexAPI'))) AND (ques.wizard = OR ques.wizard = 0) AND ques.assessment_reason = AND ques.assessment_reason = answ.assessment_reason ORDER BY ques.order_id ASC SELECT ques.ques_id, answ.question_id AS question_id, ques.answer_label, ques.questions, ques.questions_2, ques.questions_label, answ.answer_type, ques.important, ques.other, ques.alert_message, ques.wizard, ques.new_wizard, ques.display, ques.title, ques.title_2, ques.quescolor, ques.ques_identifier, ques.ques_identifier_2, ques.text_labels, ques.assessment_reason, ques.order_id, ques.new_order_ID, answ.ans_id, answ.answer, answ.answer_2, answ.srt_id, answ.tooltip_title, CASE WHEN 1=11=0 AND TRIM(IFNULL(ques.questions_2,'')) <> '' THEN ques.questions_2 ELSE ques.questions END AS question_display, CASE WHEN 1=11=0 AND TRIM(IFNULL(ques.questions_2,'')) <> '' THEN 1 ELSE 0 END AS show_question_hover, CASE WHEN 1=11=0 THEN ques.title_2 ELSE ques.title END AS title_display, CASE WHEN 1=11=0 AND TRIM(IFNULL(ques.ques_identifier_2,'')) <> '' THEN ques.ques_identifier_2 ELSE ques.ques_identifier END AS ques_identifier_display, CASE WHEN 1=11=0 AND TRIM(IFNULL(answ.answer_2,'')) <> '' THEN answ.answer_2 ELSE answ.answer END AS answer_display FROM #Request.prefix_db_lookup#.assessment_questions_lookup as ques JOIN #Request.prefix_db_lookup#.assessment_answers_lookup as answ ON answ.question_id = ques.ques_id WHERE ques.Deleted = 0 AND answ.Deleted = 0 AND ques.assessment_reason = AND ques.assessment_reason = answ.assessment_reason AND (ques.new_wizard = OR (ques.new_wizard = 0 AND ques.display = )) AND (ques.wizard = OR ques.wizard = 0) AND ((ques.answer_label = 'F26' AND LEFT(answ.answer,1) = '1') OR ques.answer_label != 'F26' ) ORDER BY CASE WHEN UPPER(TRIM(ques.answer_label)) = 'F175' THEN 1 ELSE 0 END, IFNULL(NULLIF(ques.new_order_ID, 0), ques.order_id), ques.new_wizard, answ.question_id, answ.srt_id, ques.answer_label ASC SELECT 1 AS ok FROM information_schema.COLUMNS WHERE table_schema = AND table_name = AND COLUMN_NAME = LIMIT 1 SELECT assessment_tabs_id, tab_name, status, wizard, COALESCE(NULLIF(new_wizard, 0), NULLIF(wizard, 0), 0) AS new_wizard wizard AS new_wizard FROM #Request.prefix_db_lookup#.assessment_tabs WHERE status = AND assessment_reason = ORDER BY COALESCE(NULLIF(new_wizard, 0), NULLIF(wizard, 0), assessment_tabs_id), wizard, assessment_tabs_id SELECT DISTINCT new_wizard FROM #Request.prefix_db_lookup#.assessment_questions_lookup WHERE assessment_reason = AND Deleted = 0 AND new_wizard IS NOT NULL AND new_wizard <> 0 ORDER BY new_wizard ]*>", "", "all") /> SELECT 1 FROM information_schema.COLUMNS WHERE table_schema = AND table_name = 'QuestionImportanceRules' AND COLUMN_NAME = 'Rule_Type' SELECT Rule_ID, Trigger_Question, Trigger_Quest_ID, Value_Match_Type, Value_Pattern, Target_Questions, Target_Quest_Ids, Action_Value, Rule_Type, Validation_Message, Validation_Condition FROM #Request.prefix_db_lookup#.QuestionImportanceRules WHERE Status = 0 AND Assessment_Reason = ORDER BY Rule_ID SELECT Rule_ID, Trigger_Question, Trigger_Quest_ID, Value_Match_Type, Value_Pattern, Target_Questions, Target_Quest_Ids, Action_Value FROM #Request.prefix_db_lookup#.QuestionImportanceRules WHERE Status = 0 AND Assessment_Reason = ORDER BY Rule_ID