select 1 from category_translations where category_id = :category_id and locale = :locale delete from category_object_map where object_id = :object_id insert into category_object_map (category_id, object_id) values (:category_id, :object_id) select category_id from category_object_map where object_id = :object_id select category_id, locale, name from category_translations order by category_id, locale select locale, name from category_translations where category_id = :category_id order by locale select tree_id from categories where category_id = :object_id