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