[Koha] New SQL Report - All titles with 008 for Continuing Resource

10 Jul 2013


      All titles with 008 for Continuing Resource
Developer: Nicole C. Engard, ByWater Solutions
Module: Statistical (Catalog)
Purpose: This report lists all titles that are coded as continuing
resources in the 008

SELECT b.title, m.issn
FROM biblioitems m
LEFT JOIN biblio b USING (biblionumber)
WHERE SUBSTR(ExtractValue(m.marcxml,'//controlfield[@tag="008"]'),22,1)
IN ('d','l','m','n','p','w')

Cheers,

Cab Vinton
Sanbornton Public Library
Sanbornton, NH