SELECT biblio.title, biblio.author, items.replacementprice, items.itype, items.ccode, count(DISTINCT reserves.borrowernumber) as reservecount, count(DISTINCT items.itemnumber) as itemcount FROM reserves LEFT JOIN items ON items.biblionumber=reserves.biblionumber LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber WHERE notforloan = 0 AND damaged = 0 AND itemlost = 0 AND wthdrawn = 0 AND items.itype = "BOOK" OR items.itype = "NEWBOOK" OR items.itype = "LOCALHOLD2" GROUP BY reserves.biblionumber ORDER BY reservecount DESC