An error occurred executing the following query, and page execution has been terminated.

select top 1 s.CAT_Name1, c.CH_ParentID,c.CH_ChildID from tblCactuShop1CategoryHierachy c inner join tblCactuShop1Categories s on s.CAT_ID = c.CH_ChildID where c.CH_ChildID= order by ch_parentID desc

Error Description : Incorrect syntax near the keyword 'order'.

Page of error : /404.asp

Query String :

404;http://www.blackburndistributions.com:80/healthcare/amino-acids/l---glutamine/p-80-113-310/