Nombre total d'exemplaires empruntables avec statut

Nombre total d'exemplaires empruntables avec statut

Enquête: 
ESGBU
SQL: 
SELECT items.dateaccessioned AS DATE_ACQU, biblio.title AS TITRE, biblio.author AS AUTEUR, SUBSTRING(ExtractValue(marcxml,'//datafield[@tag="100"]/subfield[@code>="a"]'),10,4) AS DATE_PUBLICATION, items.datelastborrowed AS DATE_LAST_ISSUE, av1.lib AS STATUT_DOC, av2.lib AS TYPE_DOC, av3.lib AS PERDU FROM `items` LEFT JOIN biblio USING (biblionumber) LEFT JOIN biblioitems USING (biblionumber) LEFT JOIN authorised_values av1 ON (items.notforloan = av1.authorised_value AND av1.category='statut' ) LEFT JOIN authorised_values av2 ON (items.itype = av2.authorised_value AND av2.category='ITYPE' ) LEFT JOIN authorised_values av3 ON (items.itemlost = av3.authorised_value AND av3.category='LOST' ) WHERE av1.lib="Empruntable"
Type d'établissement: 
BU
Votre établissement: 
Ecole nationale des chartes