Asiakkaalla varaus jo hänellä lainassa olevaan nimekkeeseen

reserve-on-already-issued.sql

SELECT 
	RTRIM(REGEXP_REPLACE(biblio.title,'[/,:]$','')) as 'Nimeke',
	DATE(issues.issuedate) AS 'Lainattu',
	reserves.reservedate AS 'Varattu',
	CONCAT(
        '<a target="_blank" href=\"/cgi-bin/koha/members/moremember.pl?borrowernumber=',
        borrowers.borrowernumber,
        '\">',
        borrowers.cardnumber,
        '</a>'
    ) AS Lainaaja,
	items.itype AS 'Asiakkaalla lainassa oleva nidetyyppi'
FROM issues
INNER JOIN items USING(itemnumber)
INNER JOIN biblio USING(biblionumber)
INNER JOIN reserves ON items.biblionumber = reserves.biblionumber AND issues.borrowernumber = reserves.borrowernumber
INNER JOIN borrowers ON issues.borrowernumber = borrowers.borrowernumber