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

(-)a/C4/Items.pm (-3 / +2 lines)
Lines 777-785 sub GetItemsForInventory { Link Here
777
    my $max_cnsort = GetClassSort($class_source,undef,$maxlocation);
777
    my $max_cnsort = GetClassSort($class_source,undef,$maxlocation);
778
778
779
    my $select_columns = q{
779
    my $select_columns = q{
780
        SELECT items.itemnumber, barcode, itemcallnumber, title, author, biblio.biblionumber, biblio.frameworkcode, datelastseen, homebranch, location, notforloan, damaged, itemlost, withdrawn, stocknumber
780
        SELECT DISTINCT(items.itemnumber), barcode, itemcallnumber, title, author, biblio.biblionumber, biblio.frameworkcode, datelastseen, homebranch, location, notforloan, damaged, itemlost, withdrawn, stocknumber
781
    };
781
    };
782
    my $select_count = q{SELECT COUNT(*)};
782
    my $select_count = q{SELECT COUNT(DISTINCT(items.itemnumber))};
783
    my $query = q{
783
    my $query = q{
784
        FROM items
784
        FROM items
785
        LEFT JOIN biblio ON items.biblionumber = biblio.biblionumber
785
        LEFT JOIN biblio ON items.biblionumber = biblio.biblionumber
786
- 

Return to bug 22219