select categoryID from tcontentcategories where siteid= and parentID= and parentID is null update tcontentcategories set path= where siteid= and categoryID=