select distinct p.products_image, pd.products_name, p.products_id, p.products_status, p.products_price as final_price, p.products_tax_class_id, p.products_image from (products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id ), products_description pd where p.products_status > '0' and pd.products_id = p.products_id and pd.language_id = '1' and DATE_SUB(CURDATE(),INTERVAL 90 DAY) <= p.products_date_added
|
Shopping cart is empty
Title of modal window
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||