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 ('CNT-A310D33V22TELZ','CNT-A310D33V18-22ZTEZ','CNT-A310D33V18-22TELZ','STV320D22N4','CNT-A310D33V22TEL','CNT-A310D33V18-22TE','CNT-A310D33V18-22TEL','VT100-022-3','CNT-A310D33V22TEZ','CNT-A310D33V22TE','CNT-A310D33V22TELZ','STV600D22N4L1','CNT-A310D33V18-22ZTEZ','CNT-A310D33V18-22TELZ','STV320D22N4','CNT-A310D33V22TEL','STV600D22N4F2','CNT-A310D33V18-22TE','V2000-T0022G','CNT-A310D33V18-22TEL','VT100-022-3','CNT-A310D33V22TEZ','STV600D22N4','CNT-A310D33V22TE','A650-33E22TM','') and CatCategories.__id <> '4837' and CatCategories.__id <> '5063' and CatItems.Active = '1' AND CatItems.isDomainMarket='0' ORDER BY field(CatItems.Code, 'CNT-A310D33V22TELZ','CNT-A310D33V18-22ZTEZ','CNT-A310D33V18-22TELZ','STV320D22N4','CNT-A310D33V22TEL','CNT-A310D33V18-22TE','CNT-A310D33V18-22TEL','VT100-022-3','CNT-A310D33V22TEZ','CNT-A310D33V22TE','CNT-A310D33V22TELZ','STV600D22N4L1','CNT-A310D33V18-22ZTEZ','CNT-A310D33V18-22TELZ','STV320D22N4','CNT-A310D33V22TEL','STV600D22N4F2','CNT-A310D33V18-22TE','V2000-T0022G','CNT-A310D33V18-22TEL','VT100-022-3','CNT-A310D33V22TEZ','STV600D22N4','CNT-A310D33V22TE','A650-33E22TM','')
|
Интернет-магазин электрики и электротоваров Shop220 |
В корзине:
Корзина пуста. |
Выберите город:
|
|
|
||||||||||||||||