View | Details | Raw Unified | Return to bug 11139
Collapse All | Expand All

(-)a/opac/opac-topissues.pl (-3 / +4 lines)
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
- 

Return to bug 11139