Koha sql withrawn items

SELECT  items.barcode, biblio.author,biblio.title,items.dateaccessioned, biblioitems.publicationyear, items.withdrawn_on, items.price,
biblioitems.itemtype,
SUBSTRING(ExtractValue(biblio_metadata.metadata,'//controlfield[@tag=008]'),36,3) AS LANG,
SUBSTRING(ExtractValue(biblio_metadata.metadata,'//controlfield[@tag=260]/subfield[@code="c"]'),36,3) AS GODINAIZDAVANE,
items.location

FROM aqorders LEFT JOIN biblio ON (aqorders.biblionumber=biblio.biblionumber) LEFT JOIN items ON (biblio.biblionumber=items.biblionumber)  LEFT JOIN biblioitems ON (biblio.biblionumber=biblioitems.biblionumber) LEFT JOIN biblio_metadata ON (biblio.biblionumber=biblio_metadata.biblionumber)
WHERE items.withdrawn !=0
ORDER BY items.dateaccessioned ASC