[Koha] SQL Report of Recently Edited Records

[Manos PETRIDIS]

The following will show the last 30 changed biblio records and is ready if
you wish to add more conditions on other related tables. It can also be
used as a coverflow datasource.

SELECT
 b.biblionumber,
 i.Barcode,
 SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn,
 b.title,
 c.imagenumber AS localcover
 FROM items i
 LEFT JOIN biblioitems m USING (biblioitemnumber)
 LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)
 LEFT JOIN cover_images c ON (i.biblionumber=c.biblionumber)
 LEFT JOIN biblio_metadata mt on mt.biblionumber = b.biblionumber
 GROUP BY biblionumber
 LIMIT 30
 order by b.timestamp desc

Kind regards,
Manos Petridis

Στις Τρί 18 Ιαν 2022 στις 12:08 π.μ., ο/η Charles Kelley <
cmkelleymls at gmail.com> έγραψε:

> Hi, all!
>
>     Is it possible to get a SQL report of recently edited records? I looked
> on the Koha wiki, but I didn't see one.
>
>     Thanks, all!
>
> --
>
>     よろしくお願いします。
>
>     -- Charles.
>
>     Charles Kelley, MLS
>     PSC 704 Box 1029
>     APO AP 96338
>
>     Charles Kelley
>     Tsukimino 1-Chome 5-2
>     Tsukimino Gaadenia #210
>     Yamato-shi, Kanagawa-ken
>     〒242-0002 JAPAN
>
>     +1-301-741-7122 [US cell]
>     +81-80-4356-2178 [JPN cell]
>
>     mnogojazyk at aol.com [h]
>     cmkelleymls at gmail.com [p]
>
>     linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls>
>     Meeting Your Information Needs. Virtually.
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>