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