Hi Please see the reference SQL reports listed here https://wiki.koha-community.org/wiki/SQL_Reports_Circulation You should be able to set up one to your requirements using these as reference. regards Indranil Das Gupta L2C2 Technologies -- Indranil Das Gupta L2C2 Technologies Phone : +91-98300-20971 WWW : http://www.l2c2.co.in Blog : http://blog.l2c2.co.in IRC : indradg on irc://irc.freenode.net Twitter : indradg On Wed, Jan 23, 2019 at 10:17 AM MAMCET Library <mamcet.library10@gmail.com> wrote:

How to find a Books highest readers in mysql report.

On Wed, Jan 23, 2019 at 9:45 AM Indranil Das Gupta <indradg@gmail.com> wrote:

...

You cant do this using only Koha. You need to use an Analytics tools like PiWik / Matamo or an analytics service like Google Analytics. Or you wish to do it the old school way then you need to use a tool like AWstats.

Hope this helps

Indranil Das Gupta L2C2 Technologies

On Wed 23 Jan, 2019, 9:22 AM MAMCET Library, <mamcet.library10@gmail.com> wrote:

...

Dear sir/Madam How to find a great number of visitors in the library. How to prepare the mysql Report. please help me.

-- Thanking you..

Librarian, MAMCET <http://mamcet.com/> Trichy-Chennai Trunk Road, Siruganur, Tiruchirappalli-621 105. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

-- Thanking you..

Librarian, MAMCET Trichy-Chennai Trunk Road, Siruganur, Tiruchirappalli-621 105.