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