[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-cvs] koha/C4 Labels.pm [dev_week]
From: |
Mason James |
Subject: |
[Koha-cvs] koha/C4 Labels.pm [dev_week] |
Date: |
Tue, 28 Aug 2007 12:06:59 +0000 |
CVSROOT: /sources/koha
Module name: koha
Branch: dev_week
Changes by: Mason James <sushi> 07/08/28 12:06:59
Modified files:
C4 : Labels.pm
Log message:
better sql fix in get_label_items()
CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/C4/Labels.pm?cvsroot=koha&only_with_tag=dev_week&r1=1.3.4.44&r2=1.3.4.45
Patches:
Index: Labels.pm
===================================================================
RCS file: /sources/koha/koha/C4/Labels.pm,v
retrieving revision 1.3.4.44
retrieving revision 1.3.4.45
diff -u -b -r1.3.4.44 -r1.3.4.45
--- Labels.pm 27 Aug 2007 22:47:04 -0000 1.3.4.44
+++ Labels.pm 28 Aug 2007 12:06:58 -0000 1.3.4.45
@@ -664,10 +664,9 @@
# lets get some summary info from each item
my $query1 = "
- select * from biblio,bibliosubtitle,biblioitems,items where
itemnumber=? and
+ select * from biblio left join (bibliosubtitle) on
(bibliosubtitle.biblionumber = biblio.biblionumber ) ,biblioitems,items where
itemnumber=? and
items.biblioitemnumber=biblioitems.biblioitemnumber and
- biblioitems.biblionumber=biblio.biblionumber and
- bibliosubtitle.biblionumber = biblio.biblionumber";
+ biblioitems.biblionumber=biblio.biblionumber";
my $sth1 = $dbh->prepare($query1);
$sth1->execute( $data->{'itemnumber'} );