SELECT issues.issuedate,items.barcode,biblio.title,
 author,borrowers.firstname,borrowers.surname FROM issues LEFT JOIN
borrowers ON borrowers.borrowernumber=issues.borrowernumber LEFT JOIN
items ON issues.itemnumber=items.itemnumber LEFT JOIN biblio ON
items.biblionumber=biblio.biblionumber WHERE issues.issuedate BETWEEN
<<Between Date (yyyy-mm-dd)|date>> and <<and (yyyy-mm-dd)|date>> ORDER BY
issues.issuedate

 