19--SELECT com104,g2name,count(*) as cnt FROM `gyousyu_strkey` WHERE `com104` LIKE '畜産' group by com104,g2name order by count(*) desc

view|check|strkey

com104g2namecnt
畜産食肉卸110
畜産アイスクリーム60
畜産飼料44
畜産養鶉32
畜産食肉加工32
畜産乳製品製造・卸30
畜産食肉店28
畜産牧場22
畜産牛乳21
畜産畜産17
畜産鳥肉14
畜産はちみつ13
畜産卵10
畜産養豚9
畜産畜産機材8
畜産乳酸飲料5
畜産家畜商3
畜産養蜂業2
畜産蚕種2