[Koha] SQL help request

[Kerrie Stevens]

How would I insert another column in the results table of this report to show the biblio number as well? I keep getting syntax errors with everything I try.

SELECT barcode, itemcallnumber
FROM items
WHERE datelastseen < CAST(<<Date of stocktake (YYYY-MM-DD)>> AS DATETIME)
AND homebranch = <<Choose branch|branches>>
AND itemnumber NOT IN
          (SELECT itemnumber FROM issues)
ORDER BY barcode

Thank you for your help,

Kerrie