22,301
社区成员




SELECT a.id ,
a.categoryname ,
SUM(CASE WHEN b.Categoryid <> 0 THEN 1
ELSE 0
END) total
FROM Category a
LEFT JOIN PlanDatas b ON a.id = b.Categoryid
WHERE a.State = 1
AND a.type = 1
GROUP BY a.id ,
a.categoryname