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