An Error Was Encountered

Error Number: 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 ') AS c, pr_category AS cc WHERE (cc.CategoryParentID = c.ParentID OR cc.Category' at line 1

SELECT * FROM (SELECT CategoryParentID AS ParentID FROM pr_category WHERE CategoryID = ) AS c, pr_category AS cc WHERE (cc.CategoryParentID = c.ParentID OR cc.CategoryID = c.ParentID) AND status = "active" ORDER BY cc.CategoryOrder