select sku,COUNT(sku) cc from sales_flat_order_item where order_id in(SELECT entity_id from sales_flat_order where state in(‘complete‘,‘processing‘)) GROUP BY sku ORDER BY cc DESC #产品销量
相关文章
- 08-13php – Nginx上的Magento – 配置
- 08-13mac下安装magento2+nginx配置访问
- 08-13最火的电商网站magento2：系列（一）
- 08-13magento2 system.log 错误处理
- 08-13在magento里把查询语句转换称sql语句
- 08-13magento flat和eav表连接的不同
- 08-13Magento2入门之修改logo
- 08-13如何配置magento免运费商品方法
- 08-13[MySQL]快速解决"is marked as crashed and should be repaired"故障
- 08-13MySQL 问题分析：ERROR 1071 (42000) : Specified key was too long; max key length is 767 bytes