[Koha] Report on Titles in the collection

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)

Re: [Koha] Report on Titles in the collection

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.m...@gmail.com wrote: I want

Re: [Koha] Report on Titles in the collection

At 04:45 PM 8/26/2013 +0530, Madhura Deodhar IES Library wrote: I want a list of titles having more than one items . Can anyone help me with the SQL query? Here's one that I wrote for our cataloguers: SELECT CONCAT('a