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