You may want to try this query:<br><br>select title,count(*) from biblio group by title having count(*) > 1<br><br><br><br><div class="gmail_quote">On Thu, Jul 23, 2009 at 4:05 PM, Nicole Engard <span dir="ltr"><<a href="mailto:nicole.engard@liblime.com">nicole.engard@liblime.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">You might want to list your report request here:<br>
<a href="http://wiki.koha.org/doku.php?id=sql_library" target="_blank">http://wiki.koha.org/doku.php?id=sql_library</a> And when you get an<br>
answer make sure you share it with all of us on that page :)<br>
<br>
---<br>
<br>
Nicole C. Engard<br>
Open Source Evangelist, LibLime<br>
(888) Koha ILS (564-2457) ext. 714<br>
<a href="mailto:nce@liblime.com">nce@liblime.com</a><br>
AIM/Y!/Skype: nengard<br>
<br>
<a href="http://liblime.com" target="_blank">http://liblime.com</a><br>
<a href="http://blogs.liblime.com/open-sesame/" target="_blank">http://blogs.liblime.com/open-sesame/</a><br>
<br>
<br>
<br>
2009/7/23 Banks, Joy M <<a href="mailto:jbanks@flsouthern.edu">jbanks@flsouthern.edu</a>>:<br>
<div><div></div><div class="h5">> Hi everyone-<br>
><br>
><br>
><br>
> We’re a hosted Koha library using whatever the most recent release of the<br>
> product is. I’ve been asked if I can generate a report through Koha that<br>
> would tell us all the duplicate items in the collection. Try as I might, I<br>
> can’t seem to figure out a simple way of doing this without pulling a report<br>
> of every single item, sorting by call number, and sifting through the tens<br>
> of thousands of items. Has anyone generated a report like this? It wouldn’t<br>
> be enough to pull titles that have more than one record because then we’ll<br>
> get multi-volume sets too. And there isn’t a single identifying entry in the<br>
> call number (e.g. pt. or c.) because there hasn’t been any consistency with<br>
> our tracking of duplicate items. If anyone has ideas, please let me know.<br>
> I’ll only be able to copy/paste generated SQL into the Report Wizard. We<br>
> have no access to the backend of the system.<br>
><br>
><br>
><br>
> Thank you!<br>
><br>
><br>
><br>
> ~Joy<br>
><br>
><br>
><br>
> Joy M. Banks<br>
><br>
> Catalog Librarian<br>
><br>
> Roux Library<br>
><br>
> Florida Southern College<br>
><br>
> 111 Lake Hollingsworth Dr.<br>
><br>
> Lakeland, FL 33801<br>
><br>
> (863)680-4736<br>
><br>
> <a href="mailto:jbanks@flsouthern.edu">jbanks@flsouthern.edu</a><br>
><br>
><br>
><br>
><br>
><br>
</div></div>> _______________________________________________<br>
> Koha mailing list<br>
> <a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
> <a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
><br>
><br>
_______________________________________________<br>
Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>-----------------<br>Beverly Church <br>Project Manager - LibLime <br>phone: 1.888.564.2457 x717 <br>email: <a href="mailto:beverly.church@liblime.com">beverly.church@liblime.com</a><br>
skype: beverlychurch<br>