|
Lines 81-88
if($advanced_search_types eq 'ccode'){
Link Here
|
| 81 |
$whereclause .= ' AND authorised_values.authorised_value='.$dbh->quote($itemtype) if $itemtype; |
81 |
$whereclause .= ' AND authorised_values.authorised_value='.$dbh->quote($itemtype) if $itemtype; |
| 82 |
$query = "SELECT datecreated, biblio.biblionumber, title, |
82 |
$query = "SELECT datecreated, biblio.biblionumber, title, |
| 83 |
author, sum( items.issues ) AS tot, biblioitems.itemtype, |
83 |
author, sum( items.issues ) AS tot, biblioitems.itemtype, |
| 84 |
biblioitems.publishercode,biblioitems.publicationyear, |
84 |
biblioitems.publishercode, biblioitems.place, biblioitems.publicationyear, biblio.copyrightdate, |
| 85 |
authorised_values.lib as description |
85 |
authorised_values.lib as description, biblioitems.pages, biblioitems.size |
| 86 |
FROM biblio |
86 |
FROM biblio |
| 87 |
LEFT JOIN items USING (biblionumber) |
87 |
LEFT JOIN items USING (biblionumber) |
| 88 |
LEFT JOIN biblioitems USING (biblionumber) |
88 |
LEFT JOIN biblioitems USING (biblionumber) |
|
Lines 107-114
if($advanced_search_types eq 'ccode'){
Link Here
|
| 107 |
} |
107 |
} |
| 108 |
$query = "SELECT datecreated, biblio.biblionumber, title, |
108 |
$query = "SELECT datecreated, biblio.biblionumber, title, |
| 109 |
author, sum( items.issues ) AS tot, biblioitems.itemtype, |
109 |
author, sum( items.issues ) AS tot, biblioitems.itemtype, |
| 110 |
biblioitems.publishercode,biblioitems.publicationyear, |
110 |
biblioitems.publishercode, biblioitems.place, biblioitems.publicationyear, biblio.copyrightdate, |
| 111 |
itemtypes.description |
111 |
itemtypes.description, biblioitems.pages, biblioitems.size |
| 112 |
FROM biblio |
112 |
FROM biblio |
| 113 |
LEFT JOIN items USING (biblionumber) |
113 |
LEFT JOIN items USING (biblionumber) |
| 114 |
LEFT JOIN biblioitems USING (biblionumber) |
114 |
LEFT JOIN biblioitems USING (biblionumber) |
| 115 |
- |
|
|