Listaa niteiden tilat BIBID:n perusteella.

item-status-query.sql

SELECT
	biblio.title as 'Nimeke',
	CONCAT('<a href=\"/cgi-bin/koha/catalogue/moredetail.pl?', 
       'biblionumber=', biblio.biblionumber, '&itemnumber=', items.itemnumber, 
       '\">', items.barcode, '</a>' ) AS 'Viivakoodi',
	items.datelastborrowed as 'Lainattu viimeksi',
	items.datelastseen as 'Käsitelty viimeksi',
	  CONCAT(
        '<a target="_blank" href=\"/cgi-bin/koha/members/moremember.pl?borrowernumber=',
        borrower.borrowernumber,
        '\">',
        borrower.cardnumber,
        '</a>'
    ) AS 'Lainassa asiakkaalla',
	  CONCAT(
        '<a target="_blank" href=\"/cgi-bin/koha/members/moremember.pl?borrowernumber=',
        reserver.borrowernumber,
        '\">',
        reserver.cardnumber,
        '</a>'
    ) AS 'Varattu asiakkaalle',
	items.holdingbranch as 'Oletussijainti',
	items.itype as 'Tyyppi',
	items.itemlost_on as 'Merkitty kadonneeksi',
	old_issues.returndate as 'Palautettu viimeksi'
FROM
	items
LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber
LEFT JOIN issues ON items.itemnumber = issues.itemnumber
LEFT JOIN reserves ON reserves.itemnumber = items.itemnumber
LEFT JOIN borrowers AS borrower ON borrower.borrowernumber = issues.borrowernumber
LEFT JOIN borrowers AS reserver ON reserver.borrowernumber = reserves.borrowernumber
LEFT JOIN old_issues ON old_issues.itemnumber = items.itemnumber AND DATEDIFF(old_issues.returndate,DATE(items.datelastseen)) = 0 
WHERE biblio.biblionumber = <<BIBID>>
ORDER BY items.itype, items.datelastseen DESC