分割SQL 规则不够 导致count计算报错

[longxianghui]

分割SQL 规则不够 导致count计算报错

[KiisMyGun]

写成这样可通过分割
select o.id,o.store_name storeName,o.cover_avatar coverAvatar,u.nick_name userNickName,u.avatar userAvatar,o.sales,t.count,o.create_time createTime,xx.订单明细数 from goods o
left join (select goods_id,count(ID) as 订单明细数 from user_trade_order_detail uto WHERE DATE_FORMAT(uto.create_time, '%Y%m')= DATE_FORMAT(CURDATE(),'%Y%m') group by uto.goods_id) xx on o.id = xx.goods_id
left JOIN (select goods_id,name,COUNT(1) count from goods_browse_history g where goods_id <> '1429622205922283520'
GROUP BY g.goods_id,g.name ORDER BY count desc) t on o.id=t.goods_id
INNER JOIN user_info u ON u.id=o.user_id

[longxianghui]

参考文档，使用select * from (sql) xx 再拼接一下。