View | Details | Raw Unified | Return to bug 20144
Collapse All | Expand All

(-)a/C4/Items.pm (-1 / +1 lines)
Lines 882-889 sub GetItemsForInventory { Link Here
882
        $query .= 'WHERE ';
882
        $query .= 'WHERE ';
883
        $query .= join ' AND ', @where_strings;
883
        $query .= join ' AND ', @where_strings;
884
    }
884
    }
885
    $query .= ' ORDER BY items.cn_sort, itemcallnumber, title';
886
    my $count_query = $select_count . $query;
885
    my $count_query = $select_count . $query;
886
    $query .= ' ORDER BY items.cn_sort, itemcallnumber, title';
887
    $query .= " LIMIT $offset, $size" if ($offset and $size);
887
    $query .= " LIMIT $offset, $size" if ($offset and $size);
888
    $query = $select_columns . $query;
888
    $query = $select_columns . $query;
889
    my $sth = $dbh->prepare($query);
889
    my $sth = $dbh->prepare($query);
(-)a/t/db_dependent/Items/GetItemsForInventory.t (-2 / +1 lines)
Lines 123-130 sub OldWay { Link Here
123
        $query .= 'WHERE ';
123
        $query .= 'WHERE ';
124
        $query .= join ' AND ', @where_strings;
124
        $query .= join ' AND ', @where_strings;
125
    }
125
    }
126
    $query .= ' ORDER BY items.cn_sort, itemcallnumber, title';
127
    my $count_query = $select_count . $query;
126
    my $count_query = $select_count . $query;
127
    $query .= ' ORDER BY items.cn_sort, itemcallnumber, title';
128
    $query .= " LIMIT $offset, $size" if ($offset and $size);
128
    $query .= " LIMIT $offset, $size" if ($offset and $size);
129
    $query = $select_columns . $query;
129
    $query = $select_columns . $query;
130
    my $sth = $ldbh->prepare($query);
130
    my $sth = $ldbh->prepare($query);
131
- 

Return to bug 20144