SELECT sk.*, b.name AS brand_name, s.name AS supplier_name, s.term, s.term_description, s.class, ( IF(sk.count > 0, 2, 99999)*IF(sk.price=0, 9999, sk.price) ) AS sorting FROM shop_product_skus AS sk LEFT JOIN shop_siteprofsupplier_brands AS b ON b.id=sk.brand_id LEFT JOIN shop_siteprofsuppliers AS s ON s.id=sk.supplier_id WHERE 2=2 AND sk.number_id IN (169739) ORDER BY sorting ASC LIMIT 500SELECT sk.*, b.name AS brand_name, s.name AS supplier_name, s.term, s.term_description, s.class, ( IF(sk.count > 0, 2, 99999)*IF(sk.price=0, 9999, sk.price) ) AS sorting FROM shop_product_skus AS sk LEFT JOIN shop_siteprofsupplier_brands AS b ON b.id=sk.brand_id LEFT JOIN shop_siteprofsuppliers AS s ON s.id=sk.supplier_id WHERE 2=2 AND sk.number_id IN (169739) ORDER BY sorting ASC LIMIT 500
Внимание! Актуальные цены по позициям выделенные красным цветом уточняйте у менеджеров по запросу. Мера временная, спасибо за понимание.
Артикул | Бренд | Наименование | Цена | ||
---|---|---|---|---|---|
GJ6A34150A | MAZDA | деталь | от 3717 Р |
FDL6675 | FIRSTLINE | тяга / стойка стабилизатор | отсутствует | ||
GJ6A34150A | AUWRTER | отсутствует |
Оригинальные производители | Не оригинальные кузовные производители | ||||||
---|---|---|---|---|---|---|---|
VAG | FCA | API | Body Parts | ||||
BMW | Bentley | Denso | DEPO | ||||
PSA | Chery | Eagle Eyes | Eurobump | ||||
Daewoo | Ford | Gordon | Jorden | ||||
Great Wall | GM - AC Delco | Jun Yan | Klokkerholm | ||||
Honda | Hyundai-Kia | Koyorad | Magneti Marelli | ||||
Iveco | Jaguar - Land Rover | Nissens | NTP | ||||
Mercedes Benz | Mazda | Polcar | R2a | ||||
Mitsubishi | Nissan | RPG | SAT | ||||
Porsche | Renault | Seintex | Signeda | ||||
Suzuki | Subaru | Simyi | Sonar | ||||
Ssang Yong | Toyota | TYC | TYG | ||||
Volvo | Yamaha | Termal | Valeo | ||||
Yih Sheng | Hella |