France Lampes  

Phone: +33 5 63 63 94 69 - Fax: +33 5 47 74 50 81 - Schedule of opening (GMT+1) - Contact us
  Top » MEDICAL LAMP » NEGATOSCOPE
 
  
 [?]
Fr    Eng
   Search

 

   Compare Products
You have no items to compare
Help on "Compare Products" [?]
   Manufacturers
   Specials
   New Products
   Bestsellers
01.
02.
03.
04.
05.
MEDICAL LAMPS Let's See What We Have Here
Displaying 1 to 5 (of 5 products)
Click on product name to reach the product information
Result Pages:  1 
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 50' at line 11

select p.products_model, pd.products_name, pd.products_description, p.products_on_order,p.products_image, p.luminance, p.flux, p.products_abandon,p.philips_view, p.products_quantity_pro, p.products_id, p.manufacturers_id, p.bailey_view, p.products_quantity_bailey, p.osram_view, p.products_quantity_leuch, p.products_price, p.products_tax_class_id, p.products_abandon, p.eco_pourcent, p.products_status_only_pro, 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 specials_retail_prices s using(products_id)) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2' and p2c.categories_id = '374' order by limit 0, 50

[TEP STOP]