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_Searches,
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
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
