I haven't seen the SQL, but you might be able to change an INNER JOIN somewhere into a LEFT JOIN and get the results you need.
Joel Coehoorn Director of Information Technology 402.363.5603 *[email protected] <[email protected]>* *Please contact [email protected] <[email protected]> for technical assistance.* The mission of York College is to transform lives through Christ-centered education and to equip students for lifelong service to God, family, and society On Fri, Aug 30, 2019 at 12:20 PM King, Fred <[email protected]> wrote: > Thanks to Chris and a script from George Williams, it worked like a charm. > > Almost. With a few of them. > > After a lot of trial and error, I think I might have found the problem: my > SQL queries can’t find the item type EBOOK, or any data associated with bib > records of that type. Since there aren’t any items associated with these > records, that makes sense, but… > > Is there any way to run an SQL report looking for something in the > biblioitems.isbn field when there aren’t any items attached? The 020 field > has them, and I can put the ISBN in the search box, so the system knows > they’re there. > > Thanks! And if I’m totally confused, could someone point me in the right > direction? > > I’m about to leave for the day, and Monday is a holiday here in the > States, so I might not be checking e-mail for a while. Have a great weekend > everybody. > > Fred King, AHIP > Medical Librarian, MedStar Washington Hospital Center > [email protected]<mailto:[email protected]> > 202-877-6670 > ORCID 0000-0001-5266-0279 > MedStar Authors Catalog: http://medstarauthors.org > > Rest is not idleness, and to lie sometimes on the grass under trees on a > summer's day, listening to the murmur of the water, or watching the clouds > float across the sky, is by no means a waste of time. > --Sir John Lubbock, The Use of Life (1894) > > From: Chris Cormack <[email protected]> > Sent: Thursday, August 29, 2019 5:23 PM > To: [email protected]; King, Fred <[email protected]> > Subject: [EXTERNAL] Re: [Koha] Bulk search/delete by ISBNs? > > ** ATTENTION: This email originated from outside the MedStar network. > ** DO NOT CLICK links or attachments unless you recognize the sender and > know the content is safe. > Hi Fred > > You might be able to write a report to get all biblio with no items > attached, of a certain type and then use that list of biblionumbers in the > bulk biblio delete. > > Hope this helps > Chris > On 30 August 2019 1:51:31 AM NZST, "King, Fred" <[email protected] > <mailto:[email protected]>> wrote: > > Esteemed Colleagues, > > My library has a collection of about 5000 online books that are in Koha > with bib records and no items. The publisher periodically archives titles > so they're no longer available, and I have a list of them that I'd like to > remove from Koha. The problem is that my list consists of ISBNs and that > there are over 450 of them. I could search and delete one-by-one, but > that's an awful lot of searching and deleting. Is there an easier way? > > We're on Koha 17.05* and Ubuntu 16.04. > > *I know, I know, but I'm hoping to get a new server before I upgrade. > > Fred King, AHIP > Medical Librarian, MedStar Washington Hospital Center > [email protected]<mailto:[email protected]%3E<mailto: > [email protected]%3cmailto:[email protected]%3E> > 202-877-6670 > ORCID 0000-0001-5266-0279 > MedStar Authors Catalog: http://medstarauthors.org< > https://urldefense.proofpoint.com/v2/url?u=http-3A__medstarauthors.org&d=DwMFaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=E4eNiVIJtiO21Ua5DyrKj9CVOqS-pVLhHLXrzdtSCxA&s=nxjZBoMiTfLJ423yCYGyfFHjNanefLzmsCqbKH1soE0&e= > > > > Rest is not idleness, and to lie sometimes on the grass under trees on a > summer's day, listening to the murmur of the water, or watching the clouds > float across the sky, is by no means a waste of time. > --Sir John Lubbock, The Use of Life (1894) > > ________________________________ > > MedStar Health is a not-for-profit, integrated healthcare delivery system, > the largest in Maryland and the Washington, D.C., region. Nationally > recognized for clinical quality in heart, orthopaedics, cancer and GI. > > IMPORTANT: This e-mail (including any attachments) may contain information > that is private, confidential, or protected by attorney-client or other > privilege. If you received this e-mail in error, please delete it from your > system without copying it and notify sender by reply e-mail, so that our > records can be corrected... Thank you. > > Help conserve valuable resources - only print this email if necessary. > > ________________________________ > > Koha mailing list http://koha-community.org< > https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.org&d=DwMFaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=E4eNiVIJtiO21Ua5DyrKj9CVOqS-pVLhHLXrzdtSCxA&s=6sMFUxsF0xaQemqufEI6aYJ45LI1E5iAfi3JhLkRFC8&e= > > > [email protected]<mailto:[email protected]> > https://lists.katipo.co.nz/mailman/listinfo/koha< > https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.katipo.co.nz_mailman_listinfo_koha&d=DwMFaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=E4eNiVIJtiO21Ua5DyrKj9CVOqS-pVLhHLXrzdtSCxA&s=16UQvxVDiNyisn80ywDdWsKJ0Skgz1BnItHUhoVZrxU&e= > > > > -- > Sent from my Android device with K-9 Mail. Please excuse my brevity. > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
