SELECT DISTINCT  d1.did,d1.hospids,d2.name,d2.doctorzc,d2.doctortc,d2.doctorgj,d2.description,d2.cityid,d2.main_hospid,d2.doctorcyjy,d1.zhizhao,d1.items,d1.cai,d1.zan,d1.zhizhaopic,d1.keyword,d1.description as _description,if(d2.imagefile<>'',d2.imagefile,'/Public/Images/default.gif') as imagefile FROM jd9191zxwzx.zx_doctor d1 LEFT JOIN jd9191zx.cms_doctorlist d2 on d2.id=d1.did LEFT JOIN jd9191zxwzx.zx_mclass c on find_in_set(c.id,d1.items) WHERE ( d1.provid = 8 ) AND ( d1.cityid = 122 ) AND ( c.pid = 2 ) AND ( find_in_set(1,d1.siteid) and d1.ishide=0  ) GROUP BY d1.did ORDER BY d1.did LIMIT 0,10