[Koha] SQL help

[Patricia Dowling]

Hi Tomas,
It’s 19.11.07







From: Tomas Cohen Arazi <tomascohen at gmail.com>
Sent: Wednesday 19 August 2020 16:19
To: Patricia Dowling <Patricia.Dowling at oireachtas.ie>
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] SQL help

What Koha version are you using? The table and column names have changed a bit between versions.

El mié., 19 ago. 2020 a las 11:13, Patricia Dowling (<Patricia.Dowling at oireachtas.ie<mailto:Patricia.Dowling at oireachtas.ie>>) escribió:

I wonder if anyone in the community can steer me on this basic SQL query? I am a very novice SQL user so apologies in advance!

I want to get a list of bibnumbers for all records with a value of “Irish Office pamphlets” in the 440a tag (series) with title, author and publication date so that I can export this list to excel as a csv file.

I have had a look around the Reports Library but got bogged down between the various tables biblio, items, marcxml etc.)

Thanks in advance!
Patricia



Patricia Dowling,
Research Librarian,
Oireachtas Library & Research Service,
Leinster House,
Dublin 2,
Ireland
patricia.dowling at oireachtas.ie<mailto:patricia.dowling at oireachtas.ie>
tel: (01) 6184311
Central Enquiry Desk: Tel. 00 353 1 6184701
Email library.and.research at oireachtas.ie<mailto:library.and.research at oireachtas.ie><mailto:library.and.research at oireachtas.ie<mailto:library.and.research at oireachtas.ie>>












________________________________

Oireachtas email policy and disclaimer. http://www.oireachtas.ie/parliament/about/oireachtasemailpolicyanddisclaimer/


Beartas ríomhphoist an Oireachtais agus séanadh. http://www.oireachtas.ie/parliament/ga/eolas/beartasriomhphoistanoireachtaisagusseanadh/
_______________________________________________

Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz<mailto:Koha at lists.katipo.co.nz>
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha<https://smex12-5-en-ctp.trendmicro.com:443/wis/clicktime/v1/query?url=https%3a%2f%2flists.katipo.co.nz%2fmailman%2flistinfo%2fkoha&umid=fdc66489-3523-4c07-b776-757a0b7c0ddd&auth=43ff9ca5824af5fcf2ab3da15bfea1b8c1c54367-00ae457d2fd400a1e81cdeaa60b5a51fcc5dd46d>


--
Tomás Cohen Arazi
Theke Solutions (http://theke.io<https://smex12-5-en-ctp.trendmicro.com:443/wis/clicktime/v1/query?url=http%3a%2f%2ftheke.io&umid=fdc66489-3523-4c07-b776-757a0b7c0ddd&auth=43ff9ca5824af5fcf2ab3da15bfea1b8c1c54367-81254ffb49f88c3b1c1a377ab640d5b93bb87c79>)
✆ +54 9351 3513384
GPG: B2F3C15F

________________________________

Oireachtas email policy and disclaimer. http://www.oireachtas.ie/parliament/about/oireachtasemailpolicyanddisclaimer/


Beartas ríomhphoist an Oireachtais agus séanadh. http://www.oireachtas.ie/parliament/ga/eolas/beartasriomhphoistanoireachtaisagusseanadh/