[Koha] Report help needed

[Elaine Bradtke]

I imported the following report from Mana, but it doesn't work as is.  I
tried changing `marcxml` to `metadata` but it still didn't work. The error
message (You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
'' at line 1) isn't specific enough for my limited abilities.  I'd be
grateful for your help.

Here's the original:
SELECT authid, datecreated, authtypecode,
concat(ExtractValue(`marcxml`,'//datafield[@tag="100"]/*'), --
PERSO_NAMEExtractValue(`marcxml`,'//datafield[@tag="110"]/*'), --
CORPO_NAMEExtractValue(`marcxml`,'//datafield[@tag="111"]/*'), --
MEETI_NAMEExtractValue(`marcxml`,'//datafield[@tag="130"]/*'), --
UNIF_TITLEExtractValue(`marcxml`,'//datafield[@tag="148"]/*'), --
CHRON_TERMExtractValue(`marcxml`,'//datafield[@tag="150"]/*'), --
TOPIC_TERMExtractValue(`marcxml`,'//datafield[@tag="151"]/*'), --
GEOGR_NAMEExtractValue(`marcxml`,'//datafield[@tag="155"]/*')  --
GENRE/FORM) main_headingFROM `auth_header`WHERE datecreated BETWEEN <<(from
yyyy-mm-dd)>> AND <<(to yyyy-mm-dd)>>ORDER BY datecreated, authtypecode,
main_heading

Elaine Bradtke
VWML <https://www.vwml.org>
English Folk Dance and Song Society <https://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