select case when t1.fchannel='1' then '微信好友'when t1.fchannel='2' then'微信群聊'when t1.fchannel='3' then '朋友圈' else t1.fchannel end as fchannel,count(0)fcount
from tarchives_ad_shareform t1
where t1.siteid = $siteid$ and t1.tarchives_adid = $tarchives_adid$
group by case when t1.fchannel='1' then '微信好友'when t1.fchannel='2' then'微信群聊'when t1.fchannel='3' then '朋友圈' else t1.fchannel end