从订单表选择6个月的商品销售量前十两表关联查询
SELECT or_goods_id,go_name,SUM(or_count) as count from tb_order AS a
LEFT JOIN tb_goods AS b ON a.or_goods_id=b.go_id
where or_datetime>DATE_SUB(CURDATE(), INTERVAL 6 MONTH)
GROUP BY or_goods_id ORDER BY count DESC LIMIT 10