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

(-)a/C4/VirtualShelves.pm (-2 / +1 lines)
Lines 267-273 sub GetShelfContents { Link Here
267
       " SELECT vc.biblionumber, vc.shelfnumber, vc.dateadded, itemtypes.*,
267
       " SELECT vc.biblionumber, vc.shelfnumber, vc.dateadded, itemtypes.*,
268
            biblio.*, biblioitems.itemtype, biblioitems.publicationyear as year, biblioitems.publishercode, biblioitems.place, biblioitems.size, biblioitems.pages
268
            biblio.*, biblioitems.itemtype, biblioitems.publicationyear as year, biblioitems.publishercode, biblioitems.place, biblioitems.size, biblioitems.pages
269
         FROM   virtualshelfcontents vc
269
         FROM   virtualshelfcontents vc
270
         LEFT JOIN biblio      ON      vc.biblionumber =      biblio.biblionumber
270
         JOIN biblio      ON      vc.biblionumber =      biblio.biblionumber
271
         LEFT JOIN biblioitems ON  biblio.biblionumber = biblioitems.biblionumber
271
         LEFT JOIN biblioitems ON  biblio.biblionumber = biblioitems.biblionumber
272
         LEFT JOIN itemtypes   ON biblioitems.itemtype = itemtypes.itemtype
272
         LEFT JOIN itemtypes   ON biblioitems.itemtype = itemtypes.itemtype
273
         WHERE  vc.shelfnumber=? ";
273
         WHERE  vc.shelfnumber=? ";
274
- 

Return to bug 7973