Termos mais pesquisados

Procurei mas não achei onde.
Alguém sabe dizer se há no koha, como saber quais são os termos mais pesquisados no OPAC?

Gustavo, encontrei na comunidade internacional dois relatórios, veja se atende:

Most Popular Searches
Purpose: Find popular search terms

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*

Most Popular Searches II
Purpose: Find popular search terms

SELECT search_history.sessionid,
search_history.query_desc,
search_history.type,
search_history.total,
search_history.time,
borrowers.branchcode,
borrowers.categorycode
FROM search_history
JOIN borrowers ON (search_history.userid=borrowers.borrowernumber)
JOIN branches ON (borrowers.branchcode=branches.branchcode)
WHERE borrowers.branchcode=<<
SELECT Library|branches>>
AND search_history.time BETWEEN <<SEARCH history TIMESTAMP BETWEEN (yyyy-mm-dd)|date>> AND <<AND (yyyy-mm-dd)|date>>

O primeiro apresentou a seguinte mensagem de erro ao ser executado

O segundo também deu erro, com a seguinte mensagem

:frowning:

Gustavo, observei que o editor mudou o código. Tenta acessar o link https://wiki.koha-community.org/wiki/SQL_Reports_Library#Most_Popular_Searches
e procurar (Crtl+F) por ‘Most Popular Searches’
e veja se dá o mesmo erro.

Tentei colar o código novamente agora sem deixar o editor do fórum alterar automaticamente:
Opção 1

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

Opção 2

 SELECT search_history.sessionid,
           search_history.query_desc,
           search_history.type,
           search_history.total,
           search_history.time,
           borrowers.branchcode,
           borrowers.categorycode
    FROM search_history
    JOIN borrowers ON (search_history.userid=borrowers.borrowernumber)
    JOIN branches ON (borrowers.branchcode=branches.branchcode)
    WHERE borrowers.branchcode=<<
      SELECT Library|branches>>
      AND search_history.time BETWEEN <<SEARCH history TIMESTAMP BETWEEN (yyyy-mm-dd)|date>> AND <<AND (yyyy-mm-dd)|date>>

Muito obrigado Ingrid.
Essa segunda opção já nos deu um resultado.
Agora vou trabalhar os ajustes por aqui.
Obg.