It appears that some sales are not removing themselves when they expire. I did a sale for an entire category of items which has since expired. The category, and all it's sub categories are still showing the discount. In sale maker, that sale was displaying as being expired but the price had not updated in the store. To try remove the sale, I deleted it from sale maker, but the sale price is still showing the reduced amount. The category view shows that it is still being discounted:
Click image for larger version.  Name: categories.jpg  Views: 104  Size: 8.6 KB  ID: 11636 Click image for larger version.  Name: categories2.jpg  Views: 123  Size: 21.4 KB  ID: 11637
How can I manually delete this sale from my database? I was able to create a new sale for the category and set it for a different amount, which showed up correctly; and I could even set the price for a 0% discount to try to get the price back to normal, but that isn't an acceptable work around because I dont want to have a 0% off 'sale' which is shown to the customer.

Currently there is no sale or special at all which includes the corrupt categories.

What to do?

Thanks for the help.