SELECT old_issues.returndate,items.barcode,biblio.title,biblio.author,borrowers.firstname,borrowers.surname,borrowers.cardnumber,borrowers.categorycode 
FROM old_issues  
LEFT JOIN borrowers ON borrowers.borrowernumber=old_issues.borrowernumber   
LEFT JOIN items ON old_issues.itemnumber=items.itemnumber 
LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber where old_issues.returndate 
BETWEEN <<Between Date (yyyy-mm-dd)|date>> and <<and (yyyy-mm-dd)|date>>  ORDER BY old_issues.returndate DESC