Lines 110-116
my $launcher = sub {
Link Here
|
110 |
|
110 |
|
111 |
#Results before the cn_sort |
111 |
#Results before the cn_sort |
112 |
$query = |
112 |
$query = |
113 |
"SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode, itype |
113 |
"SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode, location, itype |
114 |
FROM items AS i |
114 |
FROM items AS i |
115 |
JOIN biblio AS b USING (biblionumber) |
115 |
JOIN biblio AS b USING (biblionumber) |
116 |
LEFT OUTER JOIN branches ON (branches.branchcode = homebranch) |
116 |
LEFT OUTER JOIN branches ON (branches.branchcode = homebranch) |
Lines 141-147
my $launcher = sub {
Link Here
|
141 |
|
141 |
|
142 |
#Results after the cn_sort |
142 |
#Results after the cn_sort |
143 |
$query = |
143 |
$query = |
144 |
"SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode, itype |
144 |
"SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode, location, itype |
145 |
FROM items AS i |
145 |
FROM items AS i |
146 |
JOIN biblio AS b USING (biblionumber) |
146 |
JOIN biblio AS b USING (biblionumber) |
147 |
LEFT OUTER JOIN branches ON (branches.branchcode = homebranch) |
147 |
LEFT OUTER JOIN branches ON (branches.branchcode = homebranch) |