select locale from ad_locale_user_prefs where user_id = :user_id and package_id = :package_id select count(*) from ad_locale_user_prefs where user_id = :user_id and package_id = :package_id update ad_locale_user_prefs set locale = :locale where user_id = :user_id and package_id = :package_id insert into ad_locale_user_prefs (user_id, package_id, locale) values (:user_id, :package_id, :locale) delete from ad_locale_user_prefs where user_id = :user_id and package_id = :package_id