[Koha] sql query

[Yatheesh lis]

Hi

I would like to add the following fields to sql query after OnlineURL

koha 19.05

1. 8 - Collection code
2.c - Shelving location



SELECT items.Barcode,biblio.Author,biblio.Title AS
Titles,biblioitems.Pages,biblioitems.Editionstatement AS
Edition,biblio.Copyrightdate AS Year,items.Price,biblioitems.publishercode
AS Publisher,biblioitems.Place,biblio.unititle AS Subject,items.location AS
Department,biblioitems.itemtype AS Department,items.itype AS
Status,biblioitems.url AS
OnlineURL,items.Dateaccessioned,biblioitems.ISBN,biblio.notes,biblio.Serial,items.Issues,items.Renewals
FROM items
LEFT JOIN biblioitems ON
(items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
ORDER BY LPAD(items.barcode,40,' ') ASC

please help me
-- 

Y.Yatheesh Babu
8247838231