Products JPY 0 - JPY 50

List View
There is no product that matches the search criteria.
Did you mean "C"? If not, contact us and we'll do our best to find it for you!
There is no product that matches the search criteria.

select distinct p.products_quantity, p.products_date_available, p.products_image, m.manufacturers_id, p.products_id, pd.products_name, pd.products_subtitle, pd.products_subtitle, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id, products_description pd, categories c, products_to_categories p2c, categories_description cd WHERE c.hidden = '0' AND p.products_status = '1' AND p.products_id = pd.products_id AND pd.language_id = '1' AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND cd.categories_id = c.categories_id AND (p.products_quantity > '0' OR p.products_date_available >= (NOW() - INTERVAL 1 DAY)) and (IF(s.status, s.specials_new_products_price, p.products_price) >= 0.01) and (IF(s.status, s.specials_new_products_price, p.products_price) <= 50) and ((pd.products_name LIKE '%c%' OR pd.products_subtitle LIKE '%c%' OR p.products_model LIKE '%c%' OR m.manufacturers_name LIKE '%c%' OR cd.categories_name LIKE '%c%' )) order by p.products_date_added DESC, pd.products_name, p.products_id