From 491978abc3f2f40696cdaf4b9591fe62d4ef7456 Mon Sep 17 00:00:00 2001 From: Andreas Jonsson Date: Tue, 16 Mar 2021 10:21:19 +0000 Subject: [PATCH] Bug 27964: Don't use wildcards for subscriptionhistory table in subscription queries --- C4/Serials.pm | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) diff --git a/C4/Serials.pm b/C4/Serials.pm index 35983d67db..3a14a0e1eb 100644 --- a/C4/Serials.pm +++ b/C4/Serials.pm @@ -254,13 +254,14 @@ sub GetSubscription { my ($subscriptionid) = @_; my $dbh = C4::Context->dbh; my $query = qq( - SELECT subscription.*, - subscriptionhistory.*, + SELECT + subscription.*, + histstartdate, histenddate, missinglist, recievedlist, opacnote, librariannote, aqbooksellers.name AS aqbooksellername, biblio.title AS bibliotitle, subscription.biblionumber as bibnum FROM subscription - LEFT JOIN subscriptionhistory ON subscription.subscriptionid=subscriptionhistory.subscriptionid + LEFT JOIN subscriptionhistory USING(subscriptionid) LEFT JOIN aqbooksellers ON subscription.aqbooksellerid=aqbooksellers.id LEFT JOIN biblio ON biblio.biblionumber=subscription.biblionumber WHERE subscription.subscriptionid = ? @@ -408,11 +409,11 @@ sub GetSubscriptionsFromBiblionumber { my $query = qq( SELECT subscription.*, branches.branchname, - subscriptionhistory.*, + histstartdate, histenddate, missinglist, recievedlist, opacnote, librariannote, aqbooksellers.name AS aqbooksellername, biblio.title AS bibliotitle FROM subscription - LEFT JOIN subscriptionhistory ON subscription.subscriptionid=subscriptionhistory.subscriptionid + LEFT JOIN subscriptionhistory USING(subscriptionid) LEFT JOIN aqbooksellers ON subscription.aqbooksellerid=aqbooksellers.id LEFT JOIN biblio ON biblio.biblionumber=subscription.biblionumber LEFT JOIN branches ON branches.branchcode=subscription.branchcode -- 2.11.0