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 < cmkelley...@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] > > mnogoja...@aol.com [h] > cmkelley...@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@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
