SELECT a.sex,a.grade,a.nickname,a.photo_s,a.photo_f,a.birthday,a.areatitle,a.photo_ifshow,b.id,b.uid,b.datingkind,b.title,b.price,b.yhtime,b.maidian,b.content,b.bmnum,b.click,b.flag,b.sex AS mate_sex FROM zeai_user a,zeai_dating b WHERE b.flag>0 AND b.uid=a.id AND a.flag=1 ORDER BY b.flag,b.px DESC,b.id DESC