I had to mark several products and catagories as "Unpublished" due to some manufacture concerns. I now need to republish them but they do not show up in the Manage Products area, so I cannot find them. I could republish them all if there is a script to run against the database. Any help would be appreciated.