From 88ceb5864ab03e0f8572cc95e873340053252e12 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 Signed-off-by: Lucas Gass Signed-off-by: Jonathan Druart --- 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.20.1