From e29d767039eb8967c2dca4719324e126ea919093 Mon Sep 17 00:00:00 2001 From: rych Date: Mon, 29 Jan 2007 03:45:37 +0000 Subject: [PATCH] mysql 5 syntax change --- C4/SearchMarc.pm | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/C4/SearchMarc.pm b/C4/SearchMarc.pm index 0970aa379f..d438327e88 100644 --- a/C4/SearchMarc.pm +++ b/C4/SearchMarc.pm @@ -381,9 +381,9 @@ if (C4::Context->preference("sortbynonfiling")) { # HINT : biblionumber as bn is important. The hash is fills biblionumber with items.biblionumber. # so if you dont' has an item, you get a not nice empty value. $sth = $dbh->prepare("SELECT biblio.biblionumber as bn,biblioitems.*,biblio.*, marc_biblio.bibid,itemtypes.notforloan,itemtypes.description - FROM biblio, marc_biblio - LEFT JOIN biblioitems on biblio.biblionumber = biblioitems.biblionumber - LEFT JOIN itemtypes on itemtypes.itemtype=biblioitems.itemtype + FROM marc_biblio , biblio + LEFT JOIN biblioitems on ( biblio.biblionumber = biblioitems.biblionumber ) + LEFT JOIN itemtypes on (itemtypes.itemtype=biblioitems.itemtype) WHERE biblio.biblionumber = marc_biblio.biblionumber AND bibid = ?"); my $sth_subtitle = $dbh->prepare("SELECT subtitle FROM bibliosubtitle WHERE biblionumber=?"); # Added BY JF for Subtitles my @finalresult = (); -- 2.39.5