[Koha] SQL report for duplicate items

[Beverly Church]

You may want to try this query:

select title,count(*) from biblio group by title having count(*) > 1



On Thu, Jul 23, 2009 at 4:05 PM, Nicole Engard <nicole.engard at liblime.com>wrote:

> You might want to list your report request here:
> http://wiki.koha.org/doku.php?id=sql_library  And when you get an
> answer make sure you share it with all of us on that page :)
>
> ---
>
> Nicole C. Engard
> Open Source Evangelist, LibLime
> (888) Koha ILS (564-2457) ext. 714
> nce at liblime.com
> AIM/Y!/Skype: nengard
>
> http://liblime.com
> http://blogs.liblime.com/open-sesame/
>
>
>
> 2009/7/23 Banks, Joy M <jbanks at flsouthern.edu>:
> > Hi everyone-
> >
> >
> >
> > We’re a hosted Koha library using whatever the most recent release of the
> > product is. I’ve been asked if I can generate a report through Koha that
> > would tell us all the duplicate items in the collection. Try as I might,
> I
> > can’t seem to figure out a simple way of doing this without pulling a
> report
> > of every single item, sorting by call number, and sifting through the
> tens
> > of thousands of items. Has anyone generated a report like this? It
> wouldn’t
> > be enough to pull titles that have more than one record because then
> we’ll
> > get multi-volume sets too. And there isn’t a single identifying entry in
> the
> > call number (e.g. pt. or c.) because there hasn’t been any consistency
> with
> > our tracking of duplicate items. If anyone has ideas, please let me know.
> > I’ll only be able to copy/paste generated SQL into the Report Wizard. We
> > have no access to the backend of the system.
> >
> >
> >
> > Thank you!
> >
> >
> >
> > ~Joy
> >
> >
> >
> > Joy M. Banks
> >
> > Catalog Librarian
> >
> > Roux Library
> >
> > Florida Southern College
> >
> > 111 Lake Hollingsworth Dr.
> >
> > Lakeland, FL 33801
> >
> > (863)680-4736
> >
> > jbanks at flsouthern.edu
> >
> >
> >
> >
> >
> > _______________________________________________
> > Koha mailing list
> > Koha at lists.katipo.co.nz
> > http://lists.katipo.co.nz/mailman/listinfo/koha
> >
> >
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 
-----------------
Beverly Church
Project Manager - LibLime
phone: 1.888.564.2457 x717
email: beverly.church at liblime.com
skype: beverlychurch
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090723/bd19b740/attachment-0001.htm