For cataloguing itemtypes/biblios: books containing DVD cataloguing Creating a list of biblios which have itemtypes beginning with 'B' but which contain 'motion picture' or 'performance' or 'television programme' in their subject field. Cannot be done in SQL as subject information is stored in MARC record
This kind of seems like a support request more than a Koha bug. You should send this to the Koha mailing list so I'm closing this bug. I can tell you that you can actually query the Marc record and tips for that are on the wiki: http://wiki.koha-community.org/wiki/SQL_Reports_Library