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 ('КВК-П-2 2х0,75','01-4221','КВК-В-2x0,75М','Б0052735','01-4108','01-4015','01-4107','01-4103','КВК-П-2x0,75М','01-4109','01-4014','КВК-В-2 2х0,75','01-4105','SQ0123-0003','01-4101-1','01-4103','КВК-В-2x0,75М','01-4109','01-4014','КВК-В-2 2х0,75','SQ0123-0003','01-4101-1','КВК-П-2 2х0,75','01-4221','Б0052735','01-4108','01-4015','01-4105','01-4107','') and CatCategories.__id <> '4837' and CatCategories.__id <> '5063' and CatItems.Active = '1' AND CatItems.isDomainMarket='0' ORDER BY field(CatItems.Code, 'КВК-П-2 2х0,75','01-4221','КВК-В-2x0,75М','Б0052735','01-4108','01-4015','01-4107','01-4103','КВК-П-2x0,75М','01-4109','01-4014','КВК-В-2 2х0,75','01-4105','SQ0123-0003','01-4101-1','01-4103','КВК-В-2x0,75М','01-4109','01-4014','КВК-В-2 2х0,75','SQ0123-0003','01-4101-1','КВК-П-2 2х0,75','01-4221','Б0052735','01-4108','01-4015','01-4105','01-4107','')
|
Интернет-магазин электрики и электротоваров Shop220 |
В корзине:
Корзина пуста. |
Выберите город:
|
|
|
||||||||||||||||