select c.categories_id, cd.categories_name, cd.categories_description, c.categories_image, c.parent_id, c.lowest_price from categories c INNER JOIN categories_description cd ON c.categories_id = cd.categories_id where c.parent_id = '65' and c.categories_id = cd.categories_id and cd.language_id = '1' group by c.categories_id, cd.categories_name, cd.categories_description, c.categories_image, c.parent_id order by sort_order, cd.categories_name
