[Koha] Koha 18.11 - SQL report to select ISBNs by Subject

[Craig Butosi]

Hi everyone,

Running Koha 18.11 on Ubuntu 16.04 w/ MariaDB. Having a bit of trouble
understanding the db structural changes made in 18.xx and how SQL reports
are built in Koha 18.11. I know some tables and such have changed since the
old 16.xx days.

*I'd like to create a report that draws a list of ISBNs, along with call
number and title, for my coverflow carousel based on subject (i.e., 650$a)
keyword*. I'd like to start featuring subject-based resources on the
carousel, not just new items.

Any help would be very much appreciated. Just a note: there are a few
reports on the Koha SQL reports wiki that involve querying on the 650
field; but these do not work for what I would like to achieve.

Many thanks,

Craig Butosi, MA, MLIS, B Mus (Hons)
Library: library.craigbutosi.ca