in:
[select c.categories_id, cd.categories_name, c.parent_id from zen_categories c, zen_categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.categories_status != '0' order by c.parent_id, c.sort_order, cd.categories_name]