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/Sports-Supplements/BCAAS/L---Glutamine/p-74-83-310/