Lines 86-95
if($advanced_search_types eq 'ccode'){
Link Here
|
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) |
89 |
LEFT JOIN authorised_values ON items.ccode = authorised_values.authorised_value |
89 |
LEFT JOIN authorised_values ON ( |
|
|
90 |
authorised_values.category = 'CCODE' |
91 |
AND items.ccode = authorised_values.authorised_value |
92 |
) |
90 |
WHERE 1 |
93 |
WHERE 1 |
91 |
$whereclause |
94 |
$whereclause |
92 |
AND authorised_values.category = 'ccode' |
|
|
93 |
GROUP BY biblio.biblionumber |
95 |
GROUP BY biblio.biblionumber |
94 |
HAVING tot >0 |
96 |
HAVING tot >0 |
95 |
ORDER BY tot DESC |
97 |
ORDER BY tot DESC |
96 |
- |
|
|