select c1.sort_order,
c1.categories_id,
cd.categories_name,
c1.parent_id,
c1.categories_image, 0 as matches from zen_categories c1 , zen_categories_description cd
where c1.categories_id = cd.categories_id and
cd.language_id='1' and
c1.categories_status= 1 group by c1.categories_id
order by c1.lft asc, c1.sort_order, cd.categories_name : 0