select b.sguid,b.iCode,b.sMember_mid_pic ,b.sNick_name,b.isex,b.iage,b.SPROVINCE,b.SCITY,b.imember_pic_state from tb_basic_member b
JOIN tb_advanced_member a
on b.sguid=a.sguid
where 1=1 and b.iMember_state=0 and b.iMember_rat_code>0
AND b.isex = ?
order by dbms_random.value desc
) where rownum <=?