One of the magento based website had strange issue. All rules in the admin > Promtions > Catalog Price Rules were inactive. But still some products were displaying as sale items. So ran mysql code listed below to find out what was happening.
Today because of magento bug when I saved payment info on client's site, it replaced all payment info on database with encrypted values.