SELECT biblio.Title, items.itype AS 'Item Type', items.itemcallnumber AS 'Call Number',
      SUM( IF(type = 'issue', 1, 0 )) AS 'Check-outs',
      SUM( IF(type = 'return', 1, 0 )) AS Returns,
      SUM( IF(type = 'renew', 1, 0 )) AS Renewals,
      SUM( IF(type = 'localuse', 1, 0 )) AS 'Mark Items Used'
FROM borrowers
LEFT JOIN statistics s on (s.borrowernumber=borrowers.borrowernumber)
LEFT JOIN items on (items.itemnumber = s.itemnumber)
JOIN biblioitems on (biblioitems.biblioitemnumber = items.biblioitemnumber)
JOIN biblio on (biblio.biblionumber=biblioitems.biblioitemnumber)
WHERE items.location = 'LITERACY' AND s.datetime BETWEEN <<BETWEEN (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>>
GROUP BY title