[Koha-patches] [PATCH] Don't pull all of biblioitems in GetItemsInfo

[Michael Hafen]

Pulling marc and marcxml for some 1200 copies takes a lot of RAM.  Lets
not do that.
---
 C4/Items.pm |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/C4/Items.pm b/C4/Items.pm
index dd78f98..1f92491 100644
--- a/C4/Items.pm
+++ b/C4/Items.pm
@@ -1184,7 +1184,7 @@ If this is set, it is set to C<One Order>.
 sub GetItemsInfo {
     my ( $biblionumber, $type ) = @_;
     my $dbh   = C4::Context->dbh;
-    my $query = "SELECT *,items.notforloan as itemnotforloan
+    my $query = "SELECT items.*,biblio.*,biblioitems.volume,biblioitems.number,biblioitems.itemtype,biblioitems.isbn,biblioitems.issn,biblioitems.publicationyear,biblioitems.publishercode,biblioitems.volumedate,biblioitems.volumedesc,biblioitems.lccn,biblioitems.url,items.notforloan as itemnotforloan
                  FROM items 
                  LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber
                  LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber";
-- 
1.5.4.3