How to Create Item Type wise Circulation Check out Report.

SELECT DATE_FORMAT(c.issuedate, "%d %b %Y %h:%i") AS Issue_Date, DATE_FORMAT(c.date_due, "%d %b %Y") AS Due_Date, 
p.cardnumber AS Card_No,
p.surname AS Name,
p.borrowernotes AS Department,
p.Categorycode AS Category,
i.barcode AS Barcode,
i.itype AS Section,
b.title AS Title,
b.author AS Author,
p.branchcode AS Library
FROM issues c 
LEFT JOIN items i ON (c.itemnumber=i.itemnumber) 
LEFT JOIN borrowers p ON (c.borrowernumber=p.borrowernumber) 
LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) 
WHERE c.issuedate 
BETWEEN <<From Date |date>> AND <<To Date |date>> AND i.itype = <<Item Type|itemtypes>>
ORDER BY DATE(i.itype), CONCAT( c.issuedate, " ", i.itype)