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 ('026902','026896(1)','034227','028071(1)','028066(1)','026904(1)','026900(1)','033243','026906(1)','034225','028070(1)','026898(1)','034228','033242','028071','028067(1)','033245','026898(1)','034228','033242','028067(1)','028071','033245','026902','026896(1)','034227','028071(1)','') and CatCategories.__id <> '4837' and CatCategories.__id <> '5063' and CatItems.Active = '1' AND CatItems.isDomainMarket='0' ORDER BY field(CatItems.Code, '026902','026896(1)','034227','028071(1)','028066(1)','026904(1)','026900(1)','033243','026906(1)','034225','028070(1)','026898(1)','034228','033242','028071','028067(1)','033245','026898(1)','034228','033242','028067(1)','028071','033245','026902','026896(1)','034227','028071(1)','')
|
Интернет-магазин электрики и электротоваров Shop220 |
В корзине:
Корзина пуста. |
Выберите город:
|
|
|
||||||||||||||||