Magento的订单相关的SQL（订单编号、创建时间、总金额、收货人、收货人地址、收货人城市、州或省(简称)、收货邮编、收货人电话、付款人邮箱）

关注

原创最新推荐文章于 2026-07-21 16:19:14 发布 4.2k 阅读 AI 写同款· GEO 优化 ›

数据库第十次作业——视图 1.创建视图“view_info”,查询所有员工姓名、员工联系电话、车间地址、车间主任姓名、主任联系方式 2.查看“view_info”视图字段信息 3.创建视图“view_ chisel”,查询“Chisel”所在车间的所有员工姓名、员工联系电话、车间地址 4.查看库中所有表 5.创建视图“view_ standard”,查询生产出质量达标产品的产品编号、员工姓名、员工联系电话 6.查看“view_ standard”视图创建语句 7.创建视图“view_... 阅读详情

/*
订单编号、创建时间、总金额、收货人、收货人地址、收货人城市、州或省(简称)、收货邮编、收货人电话、付款人邮箱
*/
SELECT `main_table`.increment_id, `main_table`.created_at,`main_table`.base_grand_total,`main_table`.shipping_name,
CONCAT_WS(", ",sales_flat_order_address.street,sales_flat_order_address.city,sales_flat_order_address.region) AS `ShippingAddress`,
 sales_flat_order_address.city, directory_country_region.code,sales_flat_order_address.postcode,sales_flat_order_address.telephone,
 `customer_entity`.`email` AS `customer_email`
FROM `sales_flat_order_grid` AS `main_table`
LEFT JOIN `sales_flat_order_address` ON main_table.entity_id = sales_flat_order_address.parent_id
LEFT JOIN `customer_entity` ON main_table.customer_id = customer_entity.entity_id
LEft JOIN `directory_country_region` ON directory_country_region.default_name=sales_flat_order_address.region
WHERE (sales_flat_order_address.address_type="shipping")

收录于