|
Lines 94-100
my $launcher = sub {
Link Here
|
| 94 |
my $green = 0; |
94 |
my $green = 0; |
| 95 |
|
95 |
|
| 96 |
#Results before the cn_sort |
96 |
#Results before the cn_sort |
| 97 |
$query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author |
97 |
$query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode |
| 98 |
FROM items AS i |
98 |
FROM items AS i |
| 99 |
JOIN biblio AS b USING (biblionumber) |
99 |
JOIN biblio AS b USING (biblionumber) |
| 100 |
LEFT OUTER JOIN branches ON (branches.branchcode = homebranch) |
100 |
LEFT OUTER JOIN branches ON (branches.branchcode = homebranch) |
|
Lines 124-130
my $launcher = sub {
Link Here
|
| 124 |
my $green = 0; |
124 |
my $green = 0; |
| 125 |
|
125 |
|
| 126 |
#Results after the cn_sort |
126 |
#Results after the cn_sort |
| 127 |
$query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author |
127 |
$query = "SELECT b.title, b.subtitle, itemcallnumber, biblionumber, barcode, cn_sort, branchname, author, ccode |
| 128 |
FROM items AS i |
128 |
FROM items AS i |
| 129 |
JOIN biblio AS b USING (biblionumber) |
129 |
JOIN biblio AS b USING (biblionumber) |
| 130 |
LEFT OUTER JOIN branches ON (branches.branchcode = homebranch) |
130 |
LEFT OUTER JOIN branches ON (branches.branchcode = homebranch) |