From 03662989ac91d25fcb9986db7f6c3f8b78747345 Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Wed, 15 Apr 2020 17:53:49 +0000 Subject: [PATCH] Bug 25144: [19.05.x only] Remove subtitle from query --- 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