Query: SELECT COUNT(*) AS total_albums
                       FROM fanatphoto_category
                       WHERE cat_id = 9 AND DATE_FORMAT(a.add_date, '%y-%m-%d') = DATE_ADD(CURDATE(), INTERVAL -1 DAY)<br />Error Message: Unknown column 'a.add_date' in 'where clause'<br />Error Number: 1054