- FRANCE LAMPES

Top » MEDICAL LAMP » NEGATOSCOPE

[?]

Compare Products

You have no items to compare
Help on "Compare Products" [?]

Manufacturers

Specials

New Products

Bestsellers

01.	G13 Fluorescent Lamp 58w 6500K /865 DayLight
02.	G13 Fluorescent Lamp 36w 6500K /865 DayLight
03.	G13 Fluorescent Lamp 58W 6500K /765 DayLight
04.	G13 Fluorescent Lamp 30w 6500K /865 DayLight
05.	G13 Fluorescent Lamp 15W 6500K /765 DayLight

10737 items

MEDICAL LAMPS

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, 20' 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, 20

[TEP STOP]