[Lsb-messages] /var/www/bzr/lsb/devel/dbadmin r259: Fix slow query (bug #3597)

[Denis Silakov]

------------------------------------------------------------
revno: 259
committer: Denis Silakov <denis.silakov at rosalab.ru>
branch nick: dbadmin
timestamp: Wed 2012-06-20 18:35:50 +0400
message:
  Fix slow query (bug #3597)
modified:
  class_single.inc
-------------- next part --------------
=== modified file 'class_single.inc'
--- a/class_single.inc	2012-04-18 08:11:35 +0000
+++ b/class_single.inc	2012-06-20 14:35:50 +0000
@@ -26,7 +26,8 @@
         if( $num_libs == 1 ) {
             $Lname = Query_value("SELECT RLname FROM RawClass
                                     JOIN RLibRClass ON RLRCrcid=RCid
-                                    JOIN RawLibrary ON RLid=RLRCrlid");
+                                    JOIN RawLibrary ON RLid=RLRCrlid
+                                    WHERE RCname='$CIname'");
         }
         else if( $num_libs > 1 ) {
             display_classlib_selection_list($CIname);