Magento根据sku查询在历史订单中的销售价格的SQL

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';