[Koha-cvs] koha/C4 Labels.pm [dev_week]

[Mason James]

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'} );