SELECT * FROM `uchome_space` AS `space` LEFT JOIN `uchome_spacefield` AS `spacefield` on `space`.`uid`=`spacefield`.`uid` WHERE `space`.`credit`>'0' AND `space`.`credit`<'500' AND `space`.`namestatus`='1' AND `space`.`avatar`='1' AND `space`.`groupid` in ('3','5','6','7')
SELECT * FROM `uchome_space` AS `space` LEFT JOIN `uchome_spacefield` AS `spacefield` on `space`.`uid`=`spacefield`.`uid` WHERE `space`.`namestatus`='1' AND `space`.`groupid` in ('3','5','6','7')