2--SELECT com104,g2name,id,strkey,flag,cnt FROM `gyousyu_strkey` WHERE `g2name` LIKE '楽団' order by cnt desc

view|check|strkey

com104g2nameidstrkeyflagcnt
音楽映像楽団フィルハーモニー05
音楽映像楽団交響楽団05