insert into user_variable (user_variable_user_id, user_variable_variable_id, user_variable_value) select user.user_id as `user_variable_user_id`, variable.variable_id as `user_variable_variable_id`, 0 as `user_variable_value` from user left join variable on 1 left join user_variable on user.user_id=user_variable.user_variable_user_id and variable.variable_id=user_variable.user_variable_variable_id where user_variable.user_variable_id is null; select variable.variable_name as `name`, user_variable.user_variable_value as `value` from user_variable left join user on user_variable.user_variable_user_id = user.user_id left join variable on user_variable.user_variable_variable_id = variable.variable_id where user.user_login = ;