select hf_pro_id,hf_pro_title,hf_pro_cuxiao,hf_pro_smallpic,hf_pro_pinpai,b.* from hf_pro a,hf_pinpai b where b.hf_pinpai_id=hf_pro_pinpai and hf_pro_online=1 and charindex(@en,hf_pro_title)>0 order by hf_pro_id desc
汇聚Hi-End影音,发烧从6HIFI开始,买音响上6HIFI音响发烧站!-6HIFI,HIFI功放,HIFI音箱,音响发烧站,发烧音响,hifi音响,家庭影院音响,MBL,天朗,猛牌音响-产品
