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 ('911401823283','14143','608055','LPDO601-30-40-K02','4058075421134','4058075176652','4058075709294','29495','911401828981','607874','911401732392','Б0052031','613100230','Б0043560','911401823283','14143','608055','LPDO601-30-40-K02','4058075421134','4058075176652','4099854137006','4058075709294','29495','616036','4099854400070','607874','911401732392','95426','Б0052031','911401859498','613100230','Б0043560','') and CatCategories.__id <> '4837' and CatCategories.__id <> '5063' and CatItems.Active = '1' AND CatItems.isDomainMarket='0' ORDER BY field(CatItems.Code, '911401823283','14143','608055','LPDO601-30-40-K02','4058075421134','4058075176652','4058075709294','29495','911401828981','607874','911401732392','Б0052031','613100230','Б0043560','911401823283','14143','608055','LPDO601-30-40-K02','4058075421134','4058075176652','4099854137006','4058075709294','29495','616036','4099854400070','607874','911401732392','95426','Б0052031','911401859498','613100230','Б0043560','')
|
Интернет-магазин электрики и электротоваров Shop220 |
В корзине:
Корзина пуста. |
Выберите город:
|
|
|
||||||||||||||||