SELECT issues.issuedate,issues.date_due,items.barcode,biblio.title, author,borrowers.firstname,borrowers.surname,borrowers.cardnumber  
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 
ORDER BY issues.issuedate DESC