From fc0dff779b344a2e00c8213a8161897a7456a83d Mon Sep 17 00:00:00 2001 From: Henri-Damien LAURENT Date: Wed, 3 Oct 2007 19:01:00 +0200 Subject: [PATCH] History was broken by my correction on SQL for SearchHistory. Corrected. Signed-off-by: Chris Cormack --- C4/Acquisition.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index 201f159302..39218f18e8 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -1073,7 +1073,7 @@ sub GetHistory { aqbooksellers.id as id FROM aqorders LEFT JOIN aqbasket ON aqorders.basketno=aqbasket.basketno - LEFT JOIN aqbooksellers ON aqorders.basketno=aqbasket.basketno + LEFT JOIN aqbooksellers ON aqbasket.booksellerid=aqbooksellers.id LEFT JOIN biblio ON biblio.biblionumber=aqorders.biblionumber"; $query .= " LEFT JOIN borrowers ON aqbasket.authorisedby=borrowers.borrowernumber" -- 2.20.1