select name, description, type from survsimp_surveys where survey_id = :survey_id select count(variable_name) as n_variables from survsimp_variables, survsimp_variables_surveys_map where survey_id = :survey_id and survsimp_variables.variable_id = survsimp_variables_surveys_map.variable_id