[Koha] New Report Update

[Cab Vinton]

 Overdues With Holds Waiting

   - *Developer:* Nicole C. Engard, ByWater Solutions
   - *Module:* Holds/Circulation
   - *Purpose:* A list of items that are overdue that have holds on them. A
   report to help you know who to call with overdues to tell them others are
   waiting for their items
   - *Status:* Complete

SELECT p.cardnumber, p.surname, p.firstname,
       p.phone, p.address, p.city, p.zipcode,
       c.date_due,
       (TO_DAYS(curdate())-TO_DAYS( date_due)) AS 'days overdue',
       i.itype, b.title, b.author, i.itemcallnumber,
       i.barcode, COUNT(h.biblionumber) AS 'holds' FROM borrowers
pLEFT 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.branchcode = <<Branch Code|branches>> AND c.date_due <
curdate()GROUP BY h.biblionumber HAVING COUNT(h.biblionumber) > 0
ORDER BY p.surname ASC, c.date_due ASC