From 77e809f2fb0fbac06080a205aee46f7bf6732320 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Tue, 6 Feb 2018 11:04:50 -0300
Subject: [PATCH] Bug 20179: [sql_modes] Remove GROUP BY in
 get_shelves_containing_record

Is that right?

Fix for:
'koha_kohadev.me.shelfname' isn't in GROUP BY

t/db_dependent/Virtualshelves.t

Signed-off-by: Josef Moravec <josef.moravec@gmail.com>
---
 Koha/Virtualshelves.pm | 1 -
 1 file changed, 1 deletion(-)

diff --git a/Koha/Virtualshelves.pm b/Koha/Virtualshelves.pm
index 195376ce35..2e00fd855d 100644
--- a/Koha/Virtualshelves.pm
+++ b/Koha/Virtualshelves.pm
@@ -154,7 +154,6 @@ sub get_shelves_containing_record {
         },
         {
             join     => [ 'virtualshelfcontents', 'virtualshelfshares' ],
-            group_by => 'shelfnumber',
             order_by => { -asc => 'shelfname' },
         }
     );
-- 
2.14.2