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='186' 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 / IPS Style Ceram
Keresés
Találatok száma: 190 db
Rendezés
IPS Style Ceram Dentin 20g A2
673260
IPS Style Ceram Dentin 20g A2
Raktáron!
IPS Style Ceram Dentin 20g A1
673259
IPS Style Ceram Dentin 20g A1
Raktáron!
IPS Style Ceram Incisal 20g I2
673292
IPS Style Ceram Incisal 20g I2
Raktáron!
IPS Style Ceram Dentin 20g A3
673261
IPS Style Ceram Dentin 20g A3
Raktáron!
IPS Style Ceram Incisal 20g I1
673291
IPS Style Ceram Incisal 20g I1
Raktáron!
IPS Style Ceram Pow Opaquer 870 18g A3
673150
IPS Style Ceram Pow Opaquer 870 18g A3
Raktáron!
IPS Style Ceram Incisal 20g I3
673293
IPS Style Ceram Incisal 20g I3
Raktáron!
IPS Style Ceram Pow Opaquer 870 18g A1
673148
IPS Style Ceram Pow Opaquer 870 18g A1
Raktáron!
IPS Style Ceram Deep Dentin 20g A1
673243
IPS Style Ceram Deep Dentin 20g A1
Raktáron!
IPS Style Ceram Dentin 20g C3
673270
IPS Style Ceram Dentin 20g C3
Raktáron!
IPS Style Ceram Dentin 20g D2
673272
IPS Style Ceram Dentin 20g D2
Raktáron!
IPS Style Ceram Incisal 20g I4
673294
IPS Style Ceram Incisal 20g I4
Raktáron!
Találatok száma: 190 db