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='178' 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 / Renfert
Keresés
Találatok száma: 2 266 db
Rendezés
52000151-1
Fehér kecskeszőr kefe csillag
Raktáron!
PICOSEP separating agent
R-15520030
PICOSEP separating agent
Szállítás alatt
GEO Expert Gingiva Set A
R-6340801
GEO Expert Gingiva Set A
Szállítás alatt
Silent compact CAM 220V
R-29342500
Silent compact CAM 220V
Szállítás alatt
Universal polishing paste, beige
R-5131000
Universal polishing paste, beige
Raktáron!
GENIUS brush, size 4
R-17150004
GENIUS brush, size 4
Szállítás alatt
KOLINSKY brush, size 0/1
R-17131110
KOLINSKY brush, size 0/1
Raktáron!
KOLINSKY brush, size 2
R-17131002
KOLINSKY brush, size 2
Szállítás alatt
Basic classic 25-70µ/70-250µ220-240 V~, 50/60 Hz
R-29472025
Basic classic 25-70µ/70-250µ220-240 V~, 50/60 Hz
Raktáron!
Basic line brushes, size 02
R-17170002
Basic line brushes, size 02
Raktáron!
R- 6340001
GEO Expert Wax Set A. Bruguera English
Raktáron!
GEO Natural transparent
R-4990400
GEO Natural transparent
Raktáron!
Találatok száma: 2 266 db