marcxml moved to biblio_metadata
authorDobrica Pavlinusic <dpavlin@rot13.org>
Wed, 20 Sep 2017 10:41:28 +0000 (12:41 +0200)
committerDobrica Pavlinusic <dpavlin@rot13.org>
Wed, 20 Sep 2017 10:41:28 +0000 (12:41 +0200)
html.pl

diff --git a/html.pl b/html.pl
index cc3a3ce..f23e38b 100755 (executable)
--- a/html.pl
+++ b/html.pl
@@ -128,10 +128,11 @@ my $marcxml;
 
 my $sth_select_authors  = $dbh->prepare(q{
 select
-       biblionumber,
+       biblioitems.biblionumber,
        itemtype,
-       marcxml
+       metadata as marcxml
 from biblioitems
+join biblio_metadata on (biblio_metadata.biblionumber = biblioitems.biblionumber)
 where
        agerestriction > 0
 });