SELECT
order_table.increment_id, item_table.created_at, item_table.sku, item_table.price, order_table.`status`
FROM sales_flat_order_item AS item_table
LEFT JOIN sales_flat_order AS order_table ON order_table.entity_id=item_table.order_id
WHERE item_table.created_at <= '2015-09-30'
and order_table.`status`='complete'
AND item_table.sku='PS5784';
Magento根据sku查询在历史订单中的销售价格的SQL
最新推荐文章于 2021-01-19 01:33:35 发布