...
my $sql  = "select id, account_number, box,number,address, type, quantity, count, new_line, date
                from my_table where id <>''
                order by date desc";

    my $results = $self->_all_data($sql);
...