All Checked Out Books in your Library (Koha SQL Reports Queries)

All Checked Out Books

• Crete the New SQL Report
• Copy and Paste  following lines in the SQL report. Save and close.

SELECT issues.issuedate, issues.date_due,borrowers.cardnumber, borrowers.surname,borrowers.borrowernotes,

       borrowers.phone, borrowers.email, biblio.title, biblio.author,

       items.itemcallnumber, items.barcode, items.location,borrowers.branchcode

FROM issues

LEFT JOIN items ON (issues.itemnumber=items.itemnumber)

LEFT JOIN borrowers ON (issues.borrowernumber=borrowers.borrowernumber)

LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber)

ORDER BY issues.date_due ASC

Run Report