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

(-)a/C4/Items.pm (-4 / +4 lines)
Lines 1185-1198 sub GetItemsInfo { Link Here
1185
           items.notforloan as itemnotforloan,
1185
           items.notforloan as itemnotforloan,
1186
           itemtypes.description,
1186
           itemtypes.description,
1187
           itemtypes.notforloan as notforloan_per_itemtype,
1187
           itemtypes.notforloan as notforloan_per_itemtype,
1188
           branchurl
1188
           holding.branchurl
1189
     FROM items
1189
     FROM items
1190
     LEFT JOIN branches ON items.holdingbranch = branches.branchcode
1190
     LEFT JOIN branches AS holding ON items.holdingbranch = holding.branchcode 
1191
     LEFT JOIN branches AS home ON items.homebranch=home.branchcode
1191
     LEFT JOIN biblio      ON      biblio.biblionumber     = items.biblionumber
1192
     LEFT JOIN biblio      ON      biblio.biblionumber     = items.biblionumber
1192
     LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber
1193
     LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber
1193
     LEFT JOIN itemtypes   ON   itemtypes.itemtype         = "
1194
     LEFT JOIN itemtypes   ON   itemtypes.itemtype         = "
1194
     . (C4::Context->preference('item-level_itypes') ? 'items.itype' : 'biblioitems.itemtype');
1195
     . (C4::Context->preference('item-level_itypes') ? 'items.itype' : 'biblioitems.itemtype');
1195
    $query .= " WHERE items.biblionumber = ? ORDER BY branches.branchname,items.dateaccessioned desc" ;
1196
    $query .= " WHERE items.biblionumber = ? ORDER BY home.branchname,items.dateaccessioned desc" ;
1196
    my $sth = $dbh->prepare($query);
1197
    my $sth = $dbh->prepare($query);
1197
    $sth->execute($biblionumber);
1198
    $sth->execute($biblionumber);
1198
    my $i = 0;
1199
    my $i = 0;
1199
- 

Return to bug 7271