SELECT v.id, v.product_id , v.price, v.rrc, v.barcode, v.ozon_connect, v.dimensions, NULLIF(v.compare_price, 0) as compare_price, (v.price+b.add_percent_yandex_price/100*v.price) as time_price, v.sku, v.market_sku, v.weight, IFNULL(v.stock, '500') as stock, (v.stock IS NULL) as infinity, v.name, v.param2, v.attachment, v.position, v.wildberries_id,v.karcher_sku, v.wildberries_barcobe, v.wildberries_sklad_id FROM s_variants AS v LEFT JOIN s_products p ON p.id = v.product_id LEFT JOIN s_brands b ON b.id = p.brand_id WHERE 1 AND v.product_id in('52150','15816','52179','52180') AND (v.stock>0 OR v.stock IS NULL) ORDER BY v.position SELECT v.id, v.product_id , v.price, v.rrc, v.barcode, v.ozon_connect, v.dimensions, NULLIF(v.compare_price, 0) as compare_price, (v.price+b.add_percent_yandex_price/100*v.price) as time_price, v.sku, v.market_sku, v.weight, IFNULL(v.stock, '500') as stock, (v.stock IS NULL) as infinity, v.name, v.param2, v.attachment, v.position, v.wildberries_id,v.karcher_sku, v.wildberries_barcobe, v.wildberries_sklad_id FROM s_variants AS v LEFT JOIN s_products p ON p.id = v.product_id LEFT JOIN s_brands b ON b.id = p.brand_id WHERE 1 AND v.product_id in('52150','15816','52179','52180') ORDER BY v.position Сидении и лежаки
Мы экономим ваше время и деньги
О компании Оплата Доставка Контакты Отзывы Правовая информация