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