From ba938c87243b33ebf7912a9efd291a4bf7f7e34a Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@biblibre.com>
Date: Thu, 4 Dec 2014 16:05:34 +0100
Subject: [PATCH] Bug 12059: Prefer to list fields in the query

To avoir further issue, it's better to explicitely list the fields we
want to retrieve.

Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com>
Signed-off-by: Mason James <mtj@kohaaloha.com>
---
 C4/Acquisition.pm | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm
index c6993c3da6..7e3bb1ff48 100644
--- a/C4/Acquisition.pm
+++ b/C4/Acquisition.pm
@@ -2734,7 +2734,11 @@ sub GetInvoiceDetails {
     my $invoice = $sth->fetchrow_hashref;
 
     $query = q{
-        SELECT aqorders.*, biblio.*, biblioitems.*, aqbasket.basketname
+        SELECT aqorders.*, biblio.*,
+        biblio.copyrightdate,
+        biblioitems.publishercode,
+        biblioitems.publicationyear,
+        aqbasket.basketname
         FROM aqorders
           LEFT JOIN aqbasket ON aqorders.basketno = aqbasket.basketno
           LEFT JOIN biblio ON aqorders.biblionumber = biblio.biblionumber
-- 
2.39.5