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