The Snap Store offers high quality snap press, die sets, polyacetal resin snaps, long prone metal snaps and more. Enjoy an exciting online shopping experience from the convenience of your own home.
Product Image
Product Name
Model
Manufacturer
Price
1054 - Unknown column 'p.manufacturers_id' in 'on clause'
select s.specials_new_products_price, p.products_id, p.products_model, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from products p , categories c, products_to_categories p2c left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id where p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' order by pd.products_name
