1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by sort_order asc' at line 1
in:
[select cd.categories_name,c.categories_id,c.all_count from categories_description cd,categories c where c.categories_id = cd.categories_id and c.categories_status = 1 and c.parent_id= order by sort_order asc]