3.TITLEWISE REPORT

select distinct
items.barcode as "Barcode Number",
items.dateaccessioned as "Accession Date",
itemtypes.description as "Item Type",
items.itemcallnumber as "Callnumber",
biblio.title as Title,
biblio.author as Author,
biblioitems.publishercode as "Publisher",
biblioitems.place as "Place",
biblio.copyrightdate as Year,
biblioitems.isbn as ISBN,
biblioitems.editionstatement as Edition,
biblioitems.pages as Pages
from
items
left join biblio on biblio.biblionumber = items. biblionumber
left join biblioitems on biblioitems.biblionumber = biblio.biblionumber
left join aqorders_items on aqorders_items.itemnumber = items.itemnumber
left join biblio_metadata on biblio_metadata.biblionumber = biblio.biblionumber
left join aqorders on aqorders.ordernumber = aqorders_items.ordernumber
left join aqbudgets on aqbudgets.budget_id = aqorders.budget_id
left join aqbasket on aqbasket.basketno = aqorders.basketno
left join aqbooksellers on aqbooksellers.id = aqbasket.booksellerid
left join aqinvoices on aqinvoices.invoiceid = aqorders.invoiceid
left join itemtypes on itemtypes.itemtype = items.itype
where
items.homebranch=<<Select branch|branches>> and ExtractValue(biblio_metadata.metadata,'//datafield[@tag="245"]/subfield[@code>="a"]') like CONCAT('%',<<Enter title>>,'%')
order by CONCAT( REPEAT(  "0", 18 - LENGTH( LEFT( barcode , 10 ) ) ) , LEFT( barcode , 10 ) )