SELECT access_type, survey_codes FROM YTY_survey_report_access WHERE emp_id = '084999888' AND report_type = '1' SELECT id, code, name FROM YTY_surveys_entities WHERE code = :code SELECT id, name FROM YTY_surveys_entity_questionnaires WHERE survey_id = :survey_id AND is_active = :is_active ORDER BY sort_order ASC SELECT id, entity_questionnaire_id, question_text, question_type_id FROM YTY_surveys_entity_questionnaire_items WHERE entity_questionnaire_id IN (:entity_questionnaire_id_0) AND question_type_id NOT IN (17) AND is_active = :is_active ORDER BY sort_order ASC SELECT id, entity_questionnaire_item_id, question_type_id, row_title, content, content_value FROM YTY_surveys_entity_questionnaire_item_variants WHERE entity_questionnaire_item_id IN (:entity_questionnaire_item_id_0,:entity_questionnaire_item_id_1,:entity_questionnaire_item_id_2,:entity_questionnaire_item_id_3,:entity_questionnaire_item_id_4,:entity_questionnaire_item_id_5,:entity_questionnaire_item_id_6,:entity_questionnaire_item_id_7,:entity_questionnaire_item_id_8,:entity_questionnaire_item_id_9,:entity_questionnaire_item_id_10,:entity_questionnaire_item_id_11,:entity_questionnaire_item_id_12,:entity_questionnaire_item_id_13,:entity_questionnaire_item_id_14,:entity_questionnaire_item_id_15,:entity_questionnaire_item_id_16,:entity_questionnaire_item_id_17,:entity_questionnaire_item_id_18,:entity_questionnaire_item_id_19,:entity_questionnaire_item_id_20,:entity_questionnaire_item_id_21,:entity_questionnaire_item_id_22,:entity_questionnaire_item_id_23,:entity_questionnaire_item_id_24) ORDER BY sort_order ASC, id ASC [] {"code":"LAOPCP2FS6"} {"survey_id":"28","is_active":1} {"entity_questionnaire_id_0":"44","is_active":1} {"entity_questionnaire_item_id_0":355,"entity_questionnaire_item_id_1":356,"entity_questionnaire_item_id_2":357,"entity_questionnaire_item_id_3":358,"entity_questionnaire_item_id_4":374,"entity_questionnaire_item_id_5":382,"entity_questionnaire_item_id_6":360,"entity_questionnaire_item_id_7":362,"entity_questionnaire_item_id_8":363,"entity_questionnaire_item_id_9":364,"entity_questionnaire_item_id_10":365,"entity_questionnaire_item_id_11":366,"entity_questionnaire_item_id_12":367,"entity_questionnaire_item_id_13":368,"entity_questionnaire_item_id_14":375,"entity_questionnaire_item_id_15":376,"entity_questionnaire_item_id_16":377,"entity_questionnaire_item_id_17":378,"entity_questionnaire_item_id_18":379,"entity_questionnaire_item_id_19":380,"entity_questionnaire_item_id_20":369,"entity_questionnaire_item_id_21":370,"entity_questionnaire_item_id_22":359,"entity_questionnaire_item_id_23":372,"entity_questionnaire_item_id_24":373}