6--SELECT com104,g2name,count(*) as cnt FROM `gyousyu_strkey` WHERE `com104` LIKE '酒場居酒屋' group by com104,g2name order by count(*) desc

view|check|strkey

com104g2namecnt
酒場居酒屋酒造業166
酒場居酒屋居酒屋140
酒場居酒屋酒類卸57
酒場居酒屋ワイン醸造13
酒場居酒屋酒店11
酒場居酒屋ろばた焼2