[Koha] SQL help

[Elaine Bradtke]

I've been going through our reports, and updating them. I've fixed all the
old marcxml issues.  But I have a new error message with a report that used
to work:
"Unknown column 'place' in 'field list'"
Here's the report - what field name do I need to replace place?:
select
  b.biblionumber, author, title,
  ExtractValue(metadata, '//datafield[@tag="245"]/subfield[@code="b"]') as
subtitle,
  ExtractValue(metadata, '//datafield[@tag="250"]/subfield[@code="a"]') as
edition,
  copyrightdate, place, publishercode, isbn
from
  items as a
left join
  biblio_metadata as b on (a.biblioitemnumber = b.biblioitemnumber)
left join
  biblio as c on (b.biblionumber = c.biblionumber)
where
  itype = 'BK' and holdingbranch = 'VWML'
order by author asc


Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--------------------------------------------------------------------------
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
---------------------------------------------------------------------------
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)