ike 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.meiss...@hs-gesundheit.de> wrote:
>>>>
>>>> &
---
>>>> ---
>>>> "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 <
laine,
>>> >
>>> > how about this:
>>> >
>>> > SELECT
>>> > biblioitems.biblionumber,
>>> > biblio.title,
>>> > ExtractValue(biblioitems.marcxml,
>>> '//datafield[@tag="260"]/subfie
lio.title,
>> > ExtractValue(biblioitems.marcxml, '//datafield[@tag="260"]/
>> subfield[@code="c"]')
>> > AS text
>> > FROM items
>> > LEFT JOIN biblioitems on (items.biblioitemnumber=
>> > biblioitems.biblioitemnumber)
>> >
"]')
> > 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
number >= '17920' AND items.biblionumber <= '17959'
> > ORDER BY text ASC
> >
> >
> > -Ursprüngliche Nachricht-
> > Von: Koha [mailto:koha-boun...@lists.katipo.co.nz] Im Auftrag von Elaine
> > Bradtke
> > Gesendet: Donne
lionumber <= '17959'
> ORDER BY text ASC
>
>
> -Ursprüngliche Nachricht-----
> Von: Koha [mailto:koha-boun...@lists.katipo.co.nz] Im Auftrag von Elaine
> Bradtke
> Gesendet: Donnerstag, 5. Oktober 2017 15:08
> An: koha
> Betreff: [Koha] Help needed with SQ
tke
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,b
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.biblioitemnumb
9 matches
Mail list logo