1054 - Unknown column 'NEW_PRODUCT_INTERVAL' in 'where clause'
select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd, products_to_categories p2c, categories c
where c.categories_status='1' and p.products_id = p2c.products_id
and (p2c.categories_id = 122
|| p2c.categories_id = 132
|| p2c.categories_id = 133
|| p2c.categories_id = 134
|| p2c.categories_id = 135
|| p2c.categories_id = 136
|| p2c.categories_id = 138
|| p2c.categories_id = 285
|| p2c.categories_id = 146
|| p2c.categories_id = 147
|| p2c.categories_id = 148
|| p2c.categories_id = 149
|| p2c.categories_id = 150
|| p2c.categories_id = 151
|| p2c.categories_id = 154
|| p2c.categories_id = 155
|| p2c.categories_id = 158
|| p2c.categories_id = 159
|| p2c.categories_id = 160
|| p2c.categories_id = 161
|| p2c.categories_id = 129
)
and c.parent_id = '0'
and p.products_status = '1'
and p.products_id = pd.products_id
and pd.language_id = '7'
AND DATE_SUB(CURDATE(),INTERVAL NEW_PRODUCT_INTERVAL DAY) <= products_date_added
order by p.products_date_added desc limit 99999
[TEP STOP]