SELECT t_userdesire.*,(SELECT count(*) from t_viewtelephone where view_userid=(select id from t_user where telephone=t_userdesire.telephone) and view_type=2 and state=1 and identity =0 ) as cntboda,(SELECT count(*) from t_viewtelephone where view_userid=(select id from t_user where telephone=t_userdesire.telephone) and view_type=1 and state=1 and identity =0 ) as cntview FROM t_userdesire ORDER BY cntboda desc LIMIT 0, 30