e-transaction, le Paiement Sécurisé sur Internet par le Crédit Agricole
Top » Catalog » Printable Catalog My Account  |  Cart Contents  |  Checkout
Le Relais de la Pogne
Le Relais de la Pogne - Av. Dauphiné-Provence 26300 Alixan, France - Tél : +33 (0) 4 75 47 08 67
Email: contact@relaisdelapogne.fr
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.
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, 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, m.manufacturers_name, pd.products_description, 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 = '1' and cd.language_id = '1' order by cd.categories_name, pd.products_name

[TEP STOP]

 
 
Image
Sort Ascending
Sort Descending
Name
Sort Ascending
Sort Descending
Category
Sort Ascending
Sort Descending
Model
Sort Ascending
Sort Descending
Price