Velkommen til Web Shop Service
My Profile  Cart Contents  Checkout  
   » Catalog » Printable Catalog My Profile  |  Cart Contents  |  Checkout   
www.SmartProdukter.com
co/Andre Stornes
Holstun 2, 6065 Ulsteinvik
Norway
Email: support@smartprodukter.com
Telefon: +47 91616800
Note: All prices are subject to change without notice. All products will be billed in our shop Currency only.
          The Currency feature is just for your convenience. This catalog is current on the day of printing.

NB! All prices are not incl.Taxes in this Catalog.

Currencies
1054 - Unknown column 'p.products_id' in 'on clause'

select distinct p.products_id, p.products_image, p.products_model, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, p.products_price, p.products_date_added, 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,cd.categories_name from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join categories_description cd on p2c.categories_id = cd.categories_id left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '5' and cd.language_id = '5' order by cd.categories_name, pd.products_name

[TEP STOP]

 
 
Image
 
 
Options
Sort Asending
Sort Desending
Name
Sort Asending
Sort Desending
Category
Sort Asending
Sort Desending
Model
Sort Asending
Sort Desending
Price