X-Git-Url: http://koha-dev.rot13.org:8081/gitweb/?a=blobdiff_plain;f=circ%2Fview_holdsqueue.pl;h=4b514239a4911648ecda348cefc3b3f9ff69d3d9;hb=791fe1bbd7ccf58110fa0da9f751eccb199a6c47;hp=3023cdf43aed01ad21a59f4d0334f03deafee76f;hpb=2ea6fdec156419fbbdd5f64da927d0b2b45e751c;p=koha_fer diff --git a/circ/view_holdsqueue.pl b/circ/view_holdsqueue.pl index 3023cdf43a..4b514239a4 100755 --- a/circ/view_holdsqueue.pl +++ b/circ/view_holdsqueue.pl @@ -81,7 +81,7 @@ sub GetHoldsQueueItems { my $dbh = C4::Context->dbh; my @bind_params = (); - my $query = q/SELECT tmp_holdsqueue.*, biblio.author, items.ccode, items.location, items.enumchron, items.cn_sort, biblioitems.publishercode,biblio.copyrightdate,biblioitems.publicationyear,biblioitems.pages,biblioitems.size,biblioitems.publicationyear,biblioitems.isbn + my $query = q/SELECT tmp_holdsqueue.*, biblio.author, items.ccode, items.location, items.enumchron, items.cn_sort, biblioitems.publishercode,biblio.copyrightdate,biblioitems.publicationyear,biblioitems.pages,biblioitems.size,biblioitems.publicationyear,biblioitems.isbn,items.copynumber FROM tmp_holdsqueue JOIN biblio USING (biblionumber) LEFT JOIN biblioitems USING (biblionumber)