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 ('607812','911401858898','Б0054264','4058075574595','LPDO601-10-40-K02','4058075709218','610935','Б0043554','911401732332','4058075420885','29490','608031','613100210','607812','911401858898','Б0054264','4058075574595','4058075791121','LPDO601-10-40-K02','4058075709218','911401813487','610935','Б0043554','911401732332','4058075420885','29490','608031','FLL-4001-10-4000','613100210','') and CatCategories.__id <> '4837' and CatCategories.__id <> '5063' and CatItems.Active = '1' AND CatItems.isDomainMarket='0' ORDER BY field(CatItems.Code, '607812','911401858898','Б0054264','4058075574595','LPDO601-10-40-K02','4058075709218','610935','Б0043554','911401732332','4058075420885','29490','608031','613100210','607812','911401858898','Б0054264','4058075574595','4058075791121','LPDO601-10-40-K02','4058075709218','911401813487','610935','Б0043554','911401732332','4058075420885','29490','608031','FLL-4001-10-4000','613100210','')
|
Интернет-магазин электрики и электротоваров Shop220 |
В корзине:
Корзина пуста. |
Выберите город:
|
|
|
||||||||||||||||