[Koha] SQL query help

[Melissa Haig]

Hello all,

My SQL is very rusty, and I'm trying to write a query to find records where
there are multiple 650 fields with the same 650a subfield.

For example:
*650* *#0**$a*Real property*$z*Tippah County*$v*Maps.
*650* *#0**$a*Real property*$z*Mississippi*$v*Maps.

Here is the query I've written so far and the error I get. I will admit I'm
very rusty at SQL and if this is the wrong way to go about it I'm happy to
try a different tactic.

SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=
',biblionumber,'\">',biblionumber,'</a>')
AS bibnumber
FROM
(SELECT biblionumber,
ExtractValue(marcxml,'//datafield[@tag="650"]/subfield[@code>="a"]')
AS subjects
HAVING
COUNT(ExtractValue(marcxml,'//datafield[@tag="650"]/subfield[@code>="a"]) >
1

And the error:
*The following error was encountered:*
The database returned the following error:
called with 2 bind variables when 0 are needed
Please check the log for further details.

Thanks for any help!

Melissa Haig


Research Librarian

Association of State Floodplain Managers

575 D’Onofrio Drive, Suite 200 | Madison, WI  53719

tel:* 608-828- <608-828-3000>6342 * | melissa at floods.org