select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '25' and c.category_featured_status = '0' and c.categories_id = cd.categories_id and cd.language_id='1' and c.categories_status = '1' order by sort_order, cd.categories_name
|