Re: [Koha] OPAC Search Report

Hi! Looking at the database schema of Koha ILS and Koha mysql report https://wiki.koha-community.org/wiki/SQL_Reports_Library, you can use this report: https://wiki.koha-community.org/wiki/SQL_Reports_Library#Most_Popular_Search..., the mysql code below: SELECT COUNT(*) AS Count, RIGHT( query_desc, Length(query_desc) - Instr(query_desc, ':') ) AS 'Search string' FROM search_history GROUP BY RIGHT(query_desc, Length(query_desc) - Instr(query_desc, ':')) ORDER BY COUNT(*) DESC Mabuhay and HTH! -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html