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