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 ('','1013000010','01457','02782','10461','1029000030','ЦБ000000728','TLC418 P2 ECO','10430','1019000210','09552','09019','1029000050','1015000160','TLC418 P2 EL','1015000280','1019000200','02041','10478','16876','1002775','16869','1023000110','1023000050','09538','1029000020','1027000120','00283','15589','1017000180','16845','1002779','1027000200','1003252','16838','1013000020','') and CatCategories.__id <> '4837' and CatCategories.__id <> '5063' and CatItems.Active = '1' AND CatItems.isDomainMarket='0' ORDER BY field(CatItems.Code, '','1013000010','01457','02782','10461','1029000030','ЦБ000000728','TLC418 P2 ECO','10430','1019000210','09552','09019','1029000050','1015000160','TLC418 P2 EL','1015000280','1019000200','02041','10478','16876','1002775','16869','1023000110','1023000050','09538','1029000020','1027000120','00283','15589','1017000180','16845','1002779','1027000200','1003252','16838','1013000020','')
|
Интернет-магазин электрики и электротоваров Shop220 |
В корзине:
Корзина пуста. |
Выберите город:
|
|
|
||||||||||||||||