select type from survsimp_surveys where survey_id = :survey_id select name from survsimp_surveys where survey_id = :survey_id select logic, survsimp_logic.logic_id from survsimp_logic, survsimp_logic_surveys_map where survsimp_logic.logic_id = survsimp_logic_surveys_map.logic_id and survey_id = :survey_id