From e608a73369fb35b35e036da0d748ec166a25fe80 Mon Sep 17 00:00:00 2001
From: Nick Clemens <nick@bywatersolutions.com>
Date: Wed, 15 Apr 2020 17:53:49 +0000
Subject: [PATCH] Bug 25144: [19.05.x only] Remove subtitle from query
Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
---
cataloguing/value_builder/cn_browser.pl | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/cataloguing/value_builder/cn_browser.pl b/cataloguing/value_builder/cn_browser.pl
index 7aa8cd1b80..6802d083e7 100755
--- a/cataloguing/value_builder/cn_browser.pl
+++ b/cataloguing/value_builder/cn_browser.pl
@@ -98,7 +98,7 @@ my $launcher = sub {
my $green = 0;
#Results before the cn_sort
- $query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author
+ $query = "SELECT b.title, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author
FROM items AS i
JOIN biblio AS b USING (biblionumber)
LEFT OUTER JOIN branches ON (branches.branchcode = homebranch)
@@ -128,7 +128,7 @@ my $launcher = sub {
my $green = 0;
#Results after the cn_sort
- $query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author
+ $query = "SELECT b.title, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author
FROM items AS i
JOIN biblio AS b USING (biblionumber)
LEFT OUTER JOIN branches ON (branches.branchcode = homebranch)
--
2.11.0