1054 - Unknown column 'NEW_PRODUCT_INTERVAL' in 'where clause'
select count(*) as total from products p, products_description pd where DATE_SUB(CURDATE(),INTERVAL NEW_PRODUCT_INTERVAL DAY) <= p.products_date_added and p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1'