SELECT * FROM `uchome_space` AS `space` LEFT JOIN `uchome_spacefield` AS `spacefield` on `space`.`uid`=`spacefield`.`uid` WHERE `space`.`namestatus`='1' AND `space`.`avatar`='1' AND `spacefield`.`sex`='2' AND `spacefield`.`marry`='1' ORDER BY `space`.`viewnum` DESC, `space`.`friendnum` DESC, `space`.`updatetime` DESC
SELECT * FROM `uchome_space` AS `space` LEFT JOIN `uchome_spacefield` AS `spacefield` on `space`.`uid`=`spacefield`.`uid` WHERE `space`.`namestatus`='1' AND `space`.`avatar`='1' AND `spacefield`.`sex`='1' AND `spacefield`.`marry`='1' ORDER BY `space`.`viewnum` DESC, `space`.`friendnum` DESC, `space`.`updatetime` DESC
SELECT * FROM `uchome_space` AS `space` LEFT JOIN `uchome_spacefield` AS `spacefield` on `space`.`uid`=`spacefield`.`uid` WHERE `space`.`namestatus`='1' AND `space`.`avatar`='1' ORDER BY `space`.`viewnum` DESC, `space`.`credit` DESC, `space`.`updatetime` DESC