- Koha - lists.katipo.co.nz

Re: [Koha] Help needed with SQL report
by Elaine Bradtke 09 Oct '17

09 Oct '17

Thanks everyone! I added the limit by biblio number and this works: SELECT biblioitems.biblionumber,biblio.title,biblio.copyrightdate, ExtractValue(m.metadata, '//datafield[@tag="260"]/subfield[@code="c"]') AS text FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) LEFT JOIN biblio_metadata m ON (biblio.biblionumber=m.biblionumber) WHERE items.biblionumber >= '17920' AND items.biblionumber <= '17959' ORDER BY biblio.copyrightdate asc Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) On Mon, Oct 9, 2017 at 9:42 AM, Jonathan Druart < jonathan.druart(a)bugs.koha-community.org> wrote: > Sorry, I badly pasted the query. > Try: > SELECT biblioitems.biblionumber,biblio.title,biblio.copyrightdate, > ExtractValue(m.metadata, '//datafield[@tag="260"]/subfield[@code="c"]') > AS text FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) > LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) LEFT > JOIN biblio_metadata m ON (biblio.biblionumber=m.biblionumber) ORDER BY > biblio.copyrightdate asc; > > > On Mon, 9 Oct 2017 at 13:10 Elaine Bradtke <eb(a)efdss.org> wrote: > >> this time it says: You have an error in your SQL syntax; check the >> manual that corresponds to your MySQL server version for the right syntax >> to use near 'JOIN biblio_metadata m ON (biblio.biblionumber=m.biblionumber) >> ORDER BY biblio' at line 7 >> I think we're getting closer. >> >> Elaine Bradtke >> Data Wrangler >> VWML >> English Folk Dance and Song Society | http://www.efdss.org >> Cecil Sharp House, 2 Regent >> <https://maps.google.com/?q=2+Regent's+Park+Road,+London+NW1+7AY&entry=gmail&source=g> >> 's Park Road, London NW1 7AY >> <https://maps.google.com/?q=2+Regent's+Park+Road,+London+NW1+7AY&entry=gmail&source=g> >> Tel +44 (0) 20 7485 2206 <+44%2020%207485%202206> (This number is for >> the English Folk Dance and Song Society in London, England. If you wish to >> phone me personally, send an e-mail first. I work off site) >> ------------------------------------------------------------ >> -------------- >> Registered Company No. 297142 >> Charity Registered in England and Wales No. 305999 >> ------------------------------------------------------------ >> --------------- >> "Writing about music is like dancing about architecture" >> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) >> >> On Thu, Oct 5, 2017 at 8:11 AM, Jonathan Druart < >> jonathan.druart(a)bugs.koha-community.org> wrote: >> >>> Since 17196 (17.05) you need to join on biblio_metadata >>> Try the following query: >>> SELECT biblioitems.biblionumber, biblio.title, biblio.copyrightdate, >>> ExtractValue(m.metadata, '//datafield[@tag="260"]/subfield[@code="c"]') >>> AS text >>> FROM items >>> LEFT JOIN biblioitems on (items.biblioitemnumber= >>> biblioitems.biblioitemnumber) >>> LEFT JOIN biblio on (biblioitems.biblionumber= >>> LEFT JOIN biblio_metadata m ON (biblio.biblionumber=m.biblionumber) >>> ORDER BY biblio.copyrightdate asc; >>> >>> On Thu, 5 Oct 2017 at 11:43 Elaine Bradtke <eb(a)efdss.org> wrote: >>> >>>> It gives the error message: >>>> *The following error was encountered:* >>>> The database returned the following error: >>>> Unknown column 'biblioitems.marcxml' in 'field list' >>>> >>>> Elaine Bradtke >>>> Data Wrangler >>>> VWML >>>> English Folk Dance and Song Society | http://www.efdss.org >>>> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY >>>> <https://maps.google.com/?q=2+Regent's+Park+Road,+London+NW1+7AY&entry=gmail&source=g> >>>> Tel +44 (0) 20 7485 2206 <+44%2020%207485%202206> (This number is >>>> for the English Folk Dance and >>>> Song Society in London, England. If you wish to phone me personally, >>>> send >>>> an e-mail first. I work off site) >>>> ------------------------------------------------------------ >>>> -------------- >>>> Registered Company No. 297142 >>>> Charity Registered in England and Wales No. 305999 >>>> ------------------------------------------------------------ >>>> --------------- >>>> "Writing about music is like dancing about architecture" >>>> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) >>>> >>>> On Thu, Oct 5, 2017 at 3:16 PM, Holger Meissner < >>>> Holger.Meissner(a)hs-gesundheit.de> wrote: >>>> >>>> > Hi Elaine, >>>> > >>>> > how about this: >>>> > >>>> > SELECT >>>> > biblioitems.biblionumber, >>>> > biblio.title, >>>> > ExtractValue(biblioitems.marcxml, '//datafield[@tag="260"]/ >>>> subfield[@code="c"]') >>>> > AS text >>>> > FROM items >>>> > LEFT JOIN biblioitems on (items.biblioitemnumber= >>>> > biblioitems.biblioitemnumber) >>>> > LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) >>>> > WHERE >>>> > items.biblionumber >= '17920' AND items.biblionumber <= '17959' >>>> > ORDER BY text ASC >>>> > >>>> > >>>> > -----Ursprüngliche Nachricht----- >>>> > Von: Koha [mailto:koha-bounces@lists.katipo.co.nz] Im Auftrag von >>>> Elaine >>>> > Bradtke >>>> > Gesendet: Donnerstag, 5. Oktober 2017 15:08 >>>> > An: koha >>>> > Betreff: [Koha] Help needed with SQL report >>>> > >>>> > I need a report that gives bib number, title and 260$c from a set of >>>> > records within a range of biblio numbers. >>>> > >>>> > This is what the wizard gives me: >>>> > SELECT biblioitems.biblionumber,biblio.title,biblio.copyrightdate >>>> FROM >>>> > items LEFT JOIN biblioitems on >>>> > (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN >>>> biblio on >>>> > (biblioitems.biblionumber=biblio.biblionumber) WHERE >>>> items.biblionumber >>>> > >= '17920' AND items.biblionumber <= '17959' ORDER BY >>>> > >biblio.copyrightdate >>>> > asc >>>> > >>>> > But it's only giving the year (presumably from the 008?) I need the >>>> > actual text of the 260$c field. >>>> > >>>> > Any help would be greatly appreciated. Thanks! >>>> > I looked for a way I could configure the csv output from a list to >>>> give me >>>> > that information, but didn't find it . >>>> > Elaine Bradtke >>>> > Data Wrangler >>>> > VWML >>>> > English Folk Dance and Song Society | http://www.efdss.org Cecil >>>> Sharp >>>> > House, 2 Regent >>>> <https://maps.google.com/?q=2+Regent's+Park+Road,+London+NW1+7AY&entry=gmail&source=g> >>>> 's Park Road, London NW1 7AY >>>> <https://maps.google.com/?q=2+Regent's+Park+Road,+London+NW1+7AY&entry=gmail&source=g> >>>> > Tel +44 (0) 20 7485 2206 <+44%2020%207485%202206> (This number is >>>> for the English Folk Dance and >>>> > Song Society in London, England. If you wish to phone me personally, >>>> send >>>> > an e-mail first. I work off site) >>>> > ------------------------------------------------------------ >>>> -------------- >>>> > Registered Company No. 297142 >>>> > Charity Registered in England and Wales No. 305999 >>>> > ------------------------------------------------------------ >>>> > --------------- >>>> > "Writing about music is like dancing about architecture" >>>> > --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) >>>> > _______________________________________________ >>>> > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz >>>> > https://lists.katipo.co.nz/mailman/listinfo/koha >>>> > >>>> _______________________________________________ >>>> Koha mailing list http://koha-community.org >>>> Koha(a)lists.katipo.co.nz >>>> https://lists.katipo.co.nz/mailman/listinfo/koha >>>> >>> >>

1 0

Re: [Koha] Help needed with SQL report
by Elaine Bradtke 09 Oct '17

09 Oct '17

OK, that works. Now I just need to limit it to the range of biblio numbers. I think I can manage that. Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) On Mon, Oct 9, 2017 at 9:42 AM, Jonathan Druart < jonathan.druart(a)bugs.koha-community.org> wrote: > Sorry, I badly pasted the query. > Try: > SELECT biblioitems.biblionumber,biblio.title,biblio.copyrightdate, > ExtractValue(m.metadata, '//datafield[@tag="260"]/subfield[@code="c"]') > AS text FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) > LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) LEFT > JOIN biblio_metadata m ON (biblio.biblionumber=m.biblionumber) ORDER BY > biblio.copyrightdate asc; > > > On Mon, 9 Oct 2017 at 13:10 Elaine Bradtke <eb(a)efdss.org> wrote: > >> this time it says: You have an error in your SQL syntax; check the >> manual that corresponds to your MySQL server version for the right syntax >> to use near 'JOIN biblio_metadata m ON (biblio.biblionumber=m.biblionumber) >> ORDER BY biblio' at line 7 >> I think we're getting closer. >> >> Elaine Bradtke >> Data Wrangler >> VWML >> English Folk Dance and Song Society | http://www.efdss.org >> Cecil Sharp House, 2 Regent >> <https://maps.google.com/?q=2+Regent's+Park+Road,+London+NW1+7AY&entry=gmail&source=g> >> 's Park Road, London NW1 7AY >> <https://maps.google.com/?q=2+Regent's+Park+Road,+London+NW1+7AY&entry=gmail&source=g> >> Tel +44 (0) 20 7485 2206 <+44%2020%207485%202206> (This number is for >> the English Folk Dance and Song Society in London, England. If you wish to >> phone me personally, send an e-mail first. I work off site) >> ------------------------------------------------------------ >> -------------- >> Registered Company No. 297142 >> Charity Registered in England and Wales No. 305999 >> ------------------------------------------------------------ >> --------------- >> "Writing about music is like dancing about architecture" >> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) >> >> On Thu, Oct 5, 2017 at 8:11 AM, Jonathan Druart < >> jonathan.druart(a)bugs.koha-community.org> wrote: >> >>> Since 17196 (17.05) you need to join on biblio_metadata >>> Try the following query: >>> SELECT biblioitems.biblionumber, biblio.title, biblio.copyrightdate, >>> ExtractValue(m.metadata, '//datafield[@tag="260"]/subfield[@code="c"]') >>> AS text >>> FROM items >>> LEFT JOIN biblioitems on (items.biblioitemnumber= >>> biblioitems.biblioitemnumber) >>> LEFT JOIN biblio on (biblioitems.biblionumber= >>> LEFT JOIN biblio_metadata m ON (biblio.biblionumber=m.biblionumber) >>> ORDER BY biblio.copyrightdate asc; >>> >>> On Thu, 5 Oct 2017 at 11:43 Elaine Bradtke <eb(a)efdss.org> wrote: >>> >>>> It gives the error message: >>>> *The following error was encountered:* >>>> The database returned the following error: >>>> Unknown column 'biblioitems.marcxml' in 'field list' >>>> >>>> Elaine Bradtke >>>> Data Wrangler >>>> VWML >>>> English Folk Dance and Song Society | http://www.efdss.org >>>> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY >>>> <https://maps.google.com/?q=2+Regent's+Park+Road,+London+NW1+7AY&entry=gmail&source=g> >>>> Tel +44 (0) 20 7485 2206 <+44%2020%207485%202206> (This number is >>>> for the English Folk Dance and >>>> Song Society in London, England. If you wish to phone me personally, >>>> send >>>> an e-mail first. I work off site) >>>> ------------------------------------------------------------ >>>> -------------- >>>> Registered Company No. 297142 >>>> Charity Registered in England and Wales No. 305999 >>>> ------------------------------------------------------------ >>>> --------------- >>>> "Writing about music is like dancing about architecture" >>>> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) >>>> >>>> On Thu, Oct 5, 2017 at 3:16 PM, Holger Meissner < >>>> Holger.Meissner(a)hs-gesundheit.de> wrote: >>>> >>>> > Hi Elaine, >>>> > >>>> > how about this: >>>> > >>>> > SELECT >>>> > biblioitems.biblionumber, >>>> > biblio.title, >>>> > ExtractValue(biblioitems.marcxml, '//datafield[@tag="260"]/ >>>> subfield[@code="c"]') >>>> > AS text >>>> > FROM items >>>> > LEFT JOIN biblioitems on (items.biblioitemnumber= >>>> > biblioitems.biblioitemnumber) >>>> > LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) >>>> > WHERE >>>> > items.biblionumber >= '17920' AND items.biblionumber <= '17959' >>>> > ORDER BY text ASC >>>> > >>>> > >>>> > -----Ursprüngliche Nachricht----- >>>> > Von: Koha [mailto:koha-bounces@lists.katipo.co.nz] Im Auftrag von >>>> Elaine >>>> > Bradtke >>>> > Gesendet: Donnerstag, 5. Oktober 2017 15:08 >>>> > An: koha >>>> > Betreff: [Koha] Help needed with SQL report >>>> > >>>> > I need a report that gives bib number, title and 260$c from a set of >>>> > records within a range of biblio numbers. >>>> > >>>> > This is what the wizard gives me: >>>> > SELECT biblioitems.biblionumber,biblio.title,biblio.copyrightdate >>>> FROM >>>> > items LEFT JOIN biblioitems on >>>> > (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN >>>> biblio on >>>> > (biblioitems.biblionumber=biblio.biblionumber) WHERE >>>> items.biblionumber >>>> > >= '17920' AND items.biblionumber <= '17959' ORDER BY >>>> > >biblio.copyrightdate >>>> > asc >>>> > >>>> > But it's only giving the year (presumably from the 008?) I need the >>>> > actual text of the 260$c field. >>>> > >>>> > Any help would be greatly appreciated. Thanks! >>>> > I looked for a way I could configure the csv output from a list to >>>> give me >>>> > that information, but didn't find it . >>>> > Elaine Bradtke >>>> > Data Wrangler >>>> > VWML >>>> > English Folk Dance and Song Society | http://www.efdss.org Cecil >>>> Sharp >>>> > House, 2 Regent >>>> <https://maps.google.com/?q=2+Regent's+Park+Road,+London+NW1+7AY&entry=gmail&source=g> >>>> 's Park Road, London NW1 7AY >>>> <https://maps.google.com/?q=2+Regent's+Park+Road,+London+NW1+7AY&entry=gmail&source=g> >>>> > Tel +44 (0) 20 7485 2206 <+44%2020%207485%202206> (This number is >>>> for the English Folk Dance and >>>> > Song Society in London, England. If you wish to phone me personally, >>>> send >>>> > an e-mail first. I work off site) >>>> > ------------------------------------------------------------ >>>> -------------- >>>> > Registered Company No. 297142 >>>> > Charity Registered in England and Wales No. 305999 >>>> > ------------------------------------------------------------ >>>> > --------------- >>>> > "Writing about music is like dancing about architecture" >>>> > --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) >>>> > _______________________________________________ >>>> > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz >>>> > https://lists.katipo.co.nz/mailman/listinfo/koha >>>> > >>>> _______________________________________________ >>>> Koha mailing list http://koha-community.org >>>> Koha(a)lists.katipo.co.nz >>>> https://lists.katipo.co.nz/mailman/listinfo/koha >>>> >>> >>

1 0

Help needed with SQL report
by Elaine Bradtke 09 Oct '17

09 Oct '17

I need a report that gives bib number, title and 260$c from a set of records within a range of biblio numbers. This is what the wizard gives me: SELECT biblioitems.biblionumber,biblio.title,biblio.copyrightdate FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.biblionumber >= '17920' AND items.biblionumber <= '17959' ORDER BY biblio.copyrightdate asc But it's only giving the year (presumably from the 008?) I need the actual text of the 260$c field. Any help would be greatly appreciated. Thanks! I looked for a way I could configure the csv output from a list to give me that information, but didn't find it . Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

4 6

Who created records
by Ma. Victoria H. Silva-Manuel 09 Oct '17

09 Oct '17

Hi. How to know or to show who created records in cataloging module? There are records that I need to find out who created them. Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

3 2

Help Me
by Rajesh Shelar 09 Oct '17

09 Oct '17

Dears Friends, I am using the Koha Open Source library software ,so Please send me the Details of Library Catalog add in koha cloud base . i humbly request please help me . My Koha Ip Address Is. http://192.168.1.82:8080/ -- ***Thanks & Regards* *Mr. Rajesh R.Shelar* *Sadhu Vaswani Institute Of Management Studies For Girl's ( MBA )* *Koregaon Road,Pune* *Mob.No.8380941380* *Save Water......Conserve Life.............*

6 6

Re: [Koha] Koha und GND
by Stowasser Rainer 09 Oct '17

09 Oct '17

Hallo Katrin danke für die Antwort. Die Titeldaten funktionieren perfekt (hier eine Anleitung wie der Zugang funktioniert http://abunchofthings.net/blog/freie-metadaten-von-der-dnb-per-sru/ ) Bin gerade dabei Kostenabschätzungen einzuholen um die Implementierung eines SRU für Normdaten in Koha abschätzen zu können (und bei mir für 2018 zu budgetieren ;-) LG Hofrat Mag. Rainer Stowasser Head of Library ZAMG ________________________________________ Von: Katrin Fischer [katrin.fischer.83(a)web.de] Gesendet: Montag, 09. Oktober 2017 08:10 An: Stowasser Rainer Betreff: Re: Koha und GND Hallo Rainer, Koha kann im Moment meines Wissens Normdaten leider nur über Z39.50 übernehmen. Ich habe dazu einmal ein enhancement aufgenommen, da wir auch immer wieder über dieses Problem stolpern: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19436 Das BSZ bietet einen Z39.50-Zugang zur OGND an, der frei genutzt werden kann: z3950n.bsz-bw.de:20210 Datenbank: swb104 kein Passwort UTF-8 Einige weitere Informationen findest du hier: https://wiki.bsz-bw.de/doku.php?id=v-team:daten:z39.50neu Allerdings haben wir einige Probleme mit der Suche festgestellt, da die Suchattribute bei uns anders als von Koha erwartet oder nicht implementiert sind. Dies kann aktuell leider auch nicht geändert werden. Generell Fragen immer lieber auf eine der Mailinglisten. Auf der deutschen Mailingliste ist zwar nicht viel los, aber in der Regel kommt auf eine Frage schnell eine Antwort: http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-de Viele Grüße, Katrin Fischer On 04.10.2017 14:20, Stowasser Rainer wrote: > Hallo Kathrin > > wir haben uns beim Koha Vortrag Bibliothekarstag Linz gesehen > und soweit ich das verstanden habe bist Du die "Koha Deutsch Spezialistin". > > Deshalb technische Frage (geht sowas eigentlich auch über die Koha Liste ?) > > Habe mir einen Zugang zu den Titeldaten und der GND der DNB organisiert. > > Die Einrichtung des SRU für die Titeldaten ist kein Problem und funktioniert super. > > Bei den Normdaten will Koha aber einen z39.50 Server ...? > > Habe keine Möglichkeit gefunden die > > <recordSchema>MARC21-xml</recordSchema><recordPacking>xml</recordPacking><recordData><record type="Authority"> > > einzurichten da dies ja bei der DNB ja auch ein sru/gnd ist > > Kann man die GND direkt in Koha verwenden ? > > Gibts da einen Trick ? > > (Dr Google hat hier nicht weitergeholfen ;-) > > Vielen Dank. > > LG > Hofrat Mag. Rainer Stowasser > Head of Library ZAMG

1 0

Bug 19116
by Joel Sasse 08 Oct '17

08 Oct '17

Has the patch for bug # 19116 "Holds not set to waiting when "Confirm" is used" been pushed to 16.11 or 17.05? If not, will it be? I see it has been pushed to 17.11 Thanks, Joel Sasse Network Systems Administrator Plum Creek Library System 290 S Lake St Worthington, MN 56187 Office: 507-376-5803 Mobile: 507-360-8961 Fax: 507-376-9244 O

2 1

Software error: Koha Web Installer-MARC21
by bwengu 07 Oct '17

07 Oct '17

Hello, I am installing Koha on Ubuntu 16 and I have managed to go through everything until on *stage 3* where after selecting *mandatory* and *optional options* I get a *software error*. The error am getting is; DBIx::Class::Storage::DBI::_dbh_execute(): Incorrect integer value: '' for column 'suggestible' at row 1 at /usr/share/koha/lib/Koha/SearchField.pm line 38 or DBIx::Class::Storage::DBI::_dbh_execute(): Data truncated for column 'type' at row 1 at /usr/share/koha/lib/Koha/Objects.pm line 101 Please hep me because am stack -- View this message in context: http://koha.1045719.n5.nabble.com/Software-error-Koha-Web-Installer-MARC21-… Sent from the Koha-general mailing list archive at Nabble.com.

7 7

Nature of Contents
by Ma. Victoria H. Silva-Manuel 06 Oct '17

06 Oct '17

Hi. How to make "Nature of Contents" field in 008 mandatory? Thanks. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

2 2

Slow report for periodicals ranked by circ
by Cab Vinton 05 Oct '17

05 Oct '17

Hi, All -- The following report takes several minutes to run, which leads to me the sad probability that my SQL skillz are ... weak: SELECT b.title, count(s.datetime) AS circs FROM statistics s JOIN ( SELECT itemnumber, biblionumber, homebranch, itype FROM deleteditems UNION SELECT itemnumber, biblionumber, homebranch, itype FROM items ) AS all_items USING (itemnumber) LEFT JOIN biblio b ON (b.biblionumber=all_items.biblionumber) WHERE all_items.itype = 'MAGAZINE' AND all_items.homebranch = <<Owning Library|branches>> AND s.itemnumber IS NOT NULL AND s.type IN ('issue') AND s.datetime BETWEEN <<Between (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> GROUP BY b.biblionumber ORDER BY circs DESC The report did run much quicker when I eliminated the UNION statement & used just one of the Items tables. Would be grateful to know if there's a better way of writing this report. Many thanks, Cab Vinton Plaistow Public Library Plaistow, NH

1 0