GermanEnglish
string(800) "SELECT SQL_CALC_FOUND_ROWS `IDP_product`.* FROM `IDP_product` LEFT JOIN `IDP_manufacturer` ON `IDP_product`.ManufacturerID = `IDP_manufacturer`.ID LEFT JOIN`IDP_product_category` ON `IDP_product`.ProductCategoryID = `IDP_product_category`.ID LEFT JOIN (SELECT productCode, count(*) AS db FROM `IDP_inv_import` WHERE customerID NOT IN ('301096V', '174465V') AND kelt BETWEEN '2019-01-01' AND '2020-04-30' AND productCode NOT IN ('S', 'U') GROUP BY productCode ORDER BY db DESC) AS sale ON `IDP_product`.Code = sale.productCode WHERE `IDP_product`.ProductCategoryID='184' AND `IDP_product`.STATUS = '1' AND (`IDP_manufacturer`.Status = '1' OR ISNULL(`IDP_manufacturer`.Status)) AND(`IDP_product_category`.CategoryShow = '1' OR ISNULL(`IDP_product_category`.CategoryShow)) ORDER BY sale.db DESC LIMIT 12"
ivoclar-ips-emax-crowns
telio-cad
sr-nexco
Webshop / Labor / FastProtec
Keresés
Találatok száma: 45 db
Rendezés
FP300016
Teeth Clean
Rendelésre
FP300017
Fast for Plaster
Rendelésre
FP599300
Fast Precison Blue - 5 kg 5 kg (70 Shore)
Rendelésre
FP599301
Fast Precison Blue - 1 kg 1 kg (70 Shore)
Rendelésre
FP599302
Fast Putty - 5 kg 5 kg (70 Shore)
Rendelésre
FP599303
Fast Putty - 1 kg 1 kg (70 Shore)
Szállítás alatt
FP599307
Teeth Fast - 50 ml 50 ml (58 Shore)
Rendelésre
FP599308
Teeth Fast Trasp - 50 ml 50 ml (67 Shore)
Rendelésre
FP599312
Fast Spray Silicone - 400 ml
Rendelésre
FP599313
Fast Traspa 22 Shore - 1 kg 1 kg
Rendelésre
FP599314
Fast Traspa 40 Shore - 1 kg 1 kg
Rendelésre
FP599341
Acrylic Fast Powder Micro Pearl Pink - 1 kg
Rendelésre
Találatok száma: 45 db