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