select count(*) from (select goods_id from order_goods group by goods_id) as t 自己留着记录的,,别哪天犯浑时,又不记得怎么写,,,,,嘿嘿,,,,,