|
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) |