@@ -, +, @@ --- cataloguing/value_builder/cn_browser.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) --- a/cataloguing/value_builder/cn_browser.pl +++ a/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) --