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 ('MPR10-1-016','2CDD271111R0016','SQ0224-0003','SL29-1-16-bas','S63116','SL63-1-16-pro','tps-1-16','2CDD281101R0016','2CDD641051R0016','MPR10-1-016','17200DEK','2CDD271111R0016','SQ0224-0003','TPS116','SL29-1-16-bas','S63116','SL63-1-16-pro','tps-1-16','17206DEK','AR-SWN-1-016','2CDD281101R0016','2CDD641051R0016','avn-1-16-av','SL63-1-16-pro','TKE-PZ60-MDSI-1-16','tps-1-16','17206DEK','AR-SWN-1-016','2CDD281101R0016','2CDD641051R0016','avn-1-16-av','MPR10-1-016','17200DEK','') and CatCategories.__id <> '4837' and CatCategories.__id <> '5063' and CatItems.Active = '1' AND CatItems.isDomainMarket='0' ORDER BY field(CatItems.Code, 'MPR10-1-016','2CDD271111R0016','SQ0224-0003','SL29-1-16-bas','S63116','SL63-1-16-pro','tps-1-16','2CDD281101R0016','2CDD641051R0016','MPR10-1-016','17200DEK','2CDD271111R0016','SQ0224-0003','TPS116','SL29-1-16-bas','S63116','SL63-1-16-pro','tps-1-16','17206DEK','AR-SWN-1-016','2CDD281101R0016','2CDD641051R0016','avn-1-16-av','SL63-1-16-pro','TKE-PZ60-MDSI-1-16','tps-1-16','17206DEK','AR-SWN-1-016','2CDD281101R0016','2CDD641051R0016','avn-1-16-av','MPR10-1-016','17200DEK','')
|
Интернет-магазин электрики и электротоваров Shop220 |
В корзине:
Корзина пуста. |
Выберите город:
|
|
|
||||||||||||||||