select count(pdname) from product where class=1 group by pdname
http://club.heima.com/forum_display.aspx?forumid=100484&categoryid=116
http://club.heima.com/forum_display.aspx?forumid=100484&categoryid=116
select count(pdname) from product where class=1 group by pdname