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