X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=Koha%2FVirtualshelves.pm;h=d465ba8a7fab1a59d658909399ed7f3e8a1fdffa;hb=4c2b4011d46414dbbb75e18e6572ebc33af8a1eb;hp=bb7db677898c2154359fb14e261ea2edfa27d028;hpb=7e220e0d8f107cce63f32bfaa1919c04b4dea6e2;p=koha.git

diff --git a/Koha/Virtualshelves.pm b/Koha/Virtualshelves.pm
index bb7db67789..d465ba8a7f 100644
--- a/Koha/Virtualshelves.pm
+++ b/Koha/Virtualshelves.pm
@@ -55,7 +55,7 @@ sub get_private_shelves {
         },
         {
             join => [ 'virtualshelfshares' ],
-            group_by => 'shelfnumber',
+            distinct => 'shelfnumber',
             order_by => 'shelfname',
             ( ( $page and $rows ) ? ( page => $page, rows => $rows ) : () ),
         }
@@ -73,7 +73,7 @@ sub get_public_shelves {
             category => 2,
         },
         {
-            group_by => 'shelfnumber',
+            distinct => 'shelfnumber',
             order_by => 'shelfname',
             ( ( $page and $rows ) ? ( page => $page, rows => $rows ) : () ),
         }
@@ -116,7 +116,7 @@ sub get_some_shelves {
         },
         {
             join => [ 'virtualshelfshares' ],
-            group_by => 'shelfnumber',
+            distinct => 'shelfnumber',
             order_by => { -desc => 'lastmodified' },
         }
     );