select site_wide_p
from category_trees
where tree_id = :tree_id
select 1
from category_tree_translations
where tree_id = :tree_id
and locale = :locale
select tree_id, subtree_category_id
from category_tree_map
where object_id = :object_id
select tree_id, category_id, left_ind, right_ind,
case when deprecated_p = 'f' then '' else '1' end as deprecated_p
from categories
order by tree_id, left_ind
select category_id, left_ind, right_ind,
case when deprecated_p = 'f' then '' else '1' end as deprecated_p
from categories
where tree_id = :tree_id
order by left_ind
select tree_id, locale, name, description
from category_tree_translations
order by tree_id, locale
select locale, name, description
from category_tree_translations
where tree_id = :tree_id
order by locale