发布一条home 调用某用户组日志的SQL语句。

发布一条home 调用某用户组日志的SQL语句：
SELECT * FROM `uchome_blog` AS `blog` LEFT JOIN `uchome_space` AS `space` ON `blog`.`uid`=`space`.`uid` WHERE `blog`.`friend`='0' AND `space`.`groupid` in ('用户级ID')  ORDER BY `blog`.`dateline` DESC

如调用普通用户组的日志：

SELECT * FROM `uchome_blog` AS `blog` LEFT JOIN `uchome_space` AS `space` ON `blog`.`uid`=`space`.`uid` WHERE `blog`.`friend`='0' AND `space`.`groupid` in ('5')  ORDER BY `blog`.`dateline` DESC

要的拿去。