SELECT a.*,count(b.goods_id) as bnum FROM ecs_appraise a LEFT JOIN ecs_appraise_key b ON a.goods_id = b.goods_id AND b.checks=1 WHERE a.checks=1 group by a.goods_id order by a.goods_id desc |
|
來自: 萬子千秋 > 《php知識點積累》