[Koha] list of biblio without items and empty marc 773

[Alvaro Cornejo]

Hi

I´m trying to get a report of all biblios that does not have an item and
marc 773 / * are empty/NULL or just 773 / 0.

The issue is that when linking analytical monographic reccord  to a
specific biblio, field/subfields of 773 are populated with "parent" record
information.

Analitical Monographic record remains with no item so further queries still
return those items.

I tried several variations of the following query unsuccessfully

SELECT CONCAT('<a
href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',b.biblionumber,'\">',b.biblionumber,'</a>')
AS RecEdit,
b.title AS TITLE

FROM systempreferences, biblio AS b
    LEFT JOIN items AS i ON b.biblionumber = i.biblionumber
    LEFT JOIN biblio_metadata AS m  ON i.biblionumber = m.biblionumber

WHERE

i.itemnumber IS NULL
AND systempreferences.variable='OPACBaseURL'
AND (SELECT
ExtractValue(metadata,'//datafield[@tag="773"]/subfield[@code="0"]')
FROM biblio_metadata AS m
WHERE m.biblionumber)  IS NULL

Any ideas as how to fix this query?

Regards,

Alvaro



|-----------------------------------------------------------------------------------------------------------------|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
y GPRS online
              Visitenos en www.perusms.com