#Dbix::struct
sub list
{
  my ($self, $offset) = @_;

  my $result = all_rows([
                        "mc_news" =>
                        -join     => "mc_users"],
                        -order_by => "mc_news.id DESC",
                        -limit    => $self->conf->{per_page},
                        -offset   => $offset*$self->conf->{per_page},
  );

  return $result;
}

#Dbix::Custom
sub list
{
  my ($self, $params) = @_;
  my $result = $self->dbh->select(
    column => ['mc_news.*','mc_users.fullname'],
    table => 'mc_news',
    join => ['inner join mc_users on mc_news.author = mc_users.id'],
    append => 'order by id'
  );

  return $result->all;
}