代码如下: $params_sql = $this->_buildParamsSql()." WHERE ps.flag='1' AND ps.lovestatus='1'" .$countwhere." ORDER BY ps.userid DESC LIMIT ".$start.", ".$pagesize.""; $users = parent::$obj->getall($params_sql); $ids = $this->_getUserIds($users); $sql = $this->_buildSql()." WHERE v.userid IN (".$ids.") ORDER BY avatarflag DESC"; $data = parent::$obj->getall($sql); }
$params_sql = $this->_buildParamsSql()." WHERE ps.flag='1' AND ps.lovestatus='1'"
.$countwhere." ORDER BY ps.userid DESC LIMIT ".$start.", ".$pagesize."";
$users = parent::$obj->getall($params_sql);
$ids = $this->_getUserIds($users);
$sql = $this->_buildSql()." WHERE v.userid IN (".$ids.") ORDER BY avatarflag DESC";
$data = parent::$obj->getall($sql);
}