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

(-)a/C4/VirtualShelves.pm (-2 / +1 lines)
Lines 292-298 sub GetShelfContents ($;$$$) { Link Here
292
	}
292
	}
293
    my $query =
293
    my $query =
294
       " SELECT vc.biblionumber, vc.shelfnumber, vc.dateadded, itemtypes.*,
294
       " SELECT vc.biblionumber, vc.shelfnumber, vc.dateadded, itemtypes.*,
295
            biblio.*, biblioitems.itemtype, biblioitems.publicationyear, biblioitems.publishercode, biblioitems.place, biblioitems.size, biblioitems.pages
295
            biblio.*, biblioitems.itemtype, biblioitems.publicationyear as year, biblioitems.publishercode, biblioitems.place, biblioitems.size, biblioitems.pages
296
         FROM   virtualshelfcontents vc
296
         FROM   virtualshelfcontents vc
297
		 LEFT JOIN biblio      ON      vc.biblionumber =      biblio.biblionumber
297
		 LEFT JOIN biblio      ON      vc.biblionumber =      biblio.biblionumber
298
		 LEFT JOIN biblioitems ON  biblio.biblionumber = biblioitems.biblionumber
298
		 LEFT JOIN biblioitems ON  biblio.biblionumber = biblioitems.biblionumber
299
- 

Return to bug 6402