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