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