Liste d'une cote (titre, auteur, date, localisation, statut, etc.)

Liste d'une cote (titre, auteur, date, localisation, statut, etc.)Remplacer votre_cote par la cote à rechercher

SQL: 
SELECT items.itemcallnumber AS COTE, biblio.title AS TITRE, biblio.author AS AUTEUR, SUBSTRING(ExtractValue(marcxml,'//datafield[@tag="100"]/subfield[@code>="a"]'),10,4) AS DATE_PUBLICATION, biblioitems.publishercode AS EDITEUR, items.issues AS NB_PRET, items.datelastborrowed AS DATE_LAST_ISSUE, v1.lib AS STATUT_DOC, v2.lib AS TYPE_DOC, v3.lib AS EMPLACEMENT, v4.lib AS PROPRIETAIRE, v5.lib AS DEPOSITAIRE, v6.lib AS PERDU FROM `items` LEFT JOIN biblio USING (biblionumber) LEFT JOIN biblioitems USING (biblionumber) LEFT JOIN authorised_values v1 ON (items.notforloan = v1.authorised_value AND v1.category='statut' ) LEFT JOIN authorised_values v2 ON (items.itype = v2.authorised_value AND v2.category='ITYPE' ) LEFT JOIN authorised_values v3 ON (items.location = v3.authorised_value AND v3.category='salle' ) LEFT JOIN authorised_values v4 ON (items.homebranch = v4.authorised_value AND v4.category='site' ) LEFT JOIN authorised_values v5 ON (items.holdingbranch = v5.authorised_value AND v5.category='site' ) LEFT JOIN authorised_values v6 ON (items.itemlost = v6.authorised_value AND v6.category='LOST' ) WHERE itemcallnumber like '%votre_cote%'
Type d'établissement: 
Tout type
Votre établissement: 
Ecole nationale des chartes