SELECT IF(CatItems.Sale = 0, CatCategories.Sale, CatItems.Sale) AS Sale, CatItems.__id, CatItems.smallImage, CatItems.AddTime, CatItems.Active, CatItems.Name, CatItems.isNew, CatItems.Action, CatItems.Code, CatItems.Price, CatItems.Price2,CatItems.Price3,CatItems.Price4, CatItems.Price6, CatItems.Brand, CatItems.Remains FROM CatItems LEFT JOIN CatCategories ON CatItems.Category = CatCategories.__id WHERE CatItems.Code IN ('','PR16.0771','PR16.0766','PR16.0760','PR16.0755','PR16.0783','PR16.0778','PR16.0773','PR16.0768','PR16.0763','PR16.0757','PR16.0780','PR16.0775','PR16.0770','PR16.0765','PR16.0759','PR16.0782','PR16.0777','PR16.0772','PR16.0767','PR16.0761','PR16.0756','PR16.0779','PR16.0774','') and CatCategories.__id <> '4837' and CatCategories.__id <> '5063' and CatItems.Active = '1' AND CatItems.isDomainMarket='0' ORDER BY field(CatItems.Code, '','PR16.0771','PR16.0766','PR16.0760','PR16.0755','PR16.0783','PR16.0778','PR16.0773','PR16.0768','PR16.0763','PR16.0757','PR16.0780','PR16.0775','PR16.0770','PR16.0765','PR16.0759','PR16.0782','PR16.0777','PR16.0772','PR16.0767','PR16.0761','PR16.0756','PR16.0779','PR16.0774','')
|
Интернет-магазин электрики и электротоваров Shop220 |
В корзине:
Корзина пуста. |
Выберите город:
|
|
|
||||||||||||||||