22,300
社区成员




SELECT d.catid,d.catname,COUNT(a.info_id) AS info_count
FROM cnsb_product a WITH(NOLOCK)
--LEFT JOIN cat b WITH(NOLOCK) ON a.cat_parentid = b.catid
--LEFT JOIN cat c WITH(NOLOCK) ON a.cat_childid = c.catid
LEFT JOIN cat d WITH(NOLOCK) ON a.cat_rootid = d.catid
--LEFT JOIN cat e WITH(NOLOCK) ON a.order4 = e.catid
WHERE ......
GROUP BY d.catid,d.catname