[Koha] Report on Titles in the collection

[sunil sharma]

Here is the query, what you want :-

SELECT items.barcode, biblio.title FROM items
LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber)
GROUP BY items.biblionumber HAVING ( COUNT(*) > 1 )


On Mon, Aug 26, 2013 at 7:15 AM, Madhura Deodhar IES Library <
library.mcrc at gmail.com> wrote:

> I want a list of titles having more than one items . Can anyone help me
> with the SQL query?
>
> --
> *Regards,*
> **
> *Madhura M.Deodhar*
> *Librarian
> *IES Management College and Research Centre
> VMD Lotlikar Vidya Sankul
> Opp.Lilavati Hospital, Bandra Reclamation
> Bandra (West) Mumbai - 50
> 61378327(direct)
> 9869385665/9167004647
>
> http://iesmglib.blogspot.com
>
> *P  **Please consider the environment before printing this e-mail.*
> *
> *
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>


//BR

Sunil