Liste des documents en retard réservés

SELECT p.cardnumber, p.surname, p.firstname,
p.phone, p.address, p.city, p.email,
c.date_due,
(TO_DAYS(curdate())-TO_DAYS( date_due)) AS ‘Jours de retards’,
i.itype, b.title, b.author,
i.barcode, COUNT(h.biblionumber) AS ‘NB de réservations’,
CONCAT(‘‘,b.biblionumber,’‘)
FROM borrowers p
LEFT JOIN issues c USING (borrowernumber)
LEFT JOIN items i USING (itemnumber)
LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)
LEFT JOIN reserves h ON (b.biblionumber=h.biblionumber)
WHERE c.date_due < curdate() GROUP BY h.biblionumber HAVING COUNT(h.biblionumber) > 0
ORDER BY p.surname ASC, c.date_due ASC

Rapport permettant de repérer les documents attendus et d’identifier les adhérents retardataires.

Liste des prêts en cours

SELECT c.date_due, p.categorycode, b.title, b.author, i.itemcallnumber, i.barcode, i.location FROM issues c LEFT JOIN items i ON (c.itemnumber=i.itemnumber) LEFT JOIN borrowers p ON […]