View | Details | Raw Unified | Return to bug 25144
Collapse All | Expand All

(-)a/cataloguing/value_builder/cn_browser.pl (-3 / +2 lines)
Lines 98-104 my $launcher = sub { Link Here
98
        my $green = 0;
98
        my $green = 0;
99
99
100
        #Results before the cn_sort
100
        #Results before the cn_sort
101
        $query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author
101
        $query = "SELECT b.title, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author
102
        FROM items AS i
102
        FROM items AS i
103
        JOIN biblio AS b USING (biblionumber)
103
        JOIN biblio AS b USING (biblionumber)
104
        LEFT OUTER JOIN branches ON (branches.branchcode = homebranch)
104
        LEFT OUTER JOIN branches ON (branches.branchcode = homebranch)
Lines 128-134 my $launcher = sub { Link Here
128
        my $green = 0;
128
        my $green = 0;
129
129
130
        #Results after the cn_sort
130
        #Results after the cn_sort
131
        $query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author
131
        $query = "SELECT b.title, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author
132
        FROM items AS i
132
        FROM items AS i
133
        JOIN biblio AS b USING (biblionumber)
133
        JOIN biblio AS b USING (biblionumber)
134
        LEFT OUTER JOIN branches ON (branches.branchcode = homebranch)
134
        LEFT OUTER JOIN branches ON (branches.branchcode = homebranch)
135
- 

Return to bug 25144