Bug 21612: Remove incorrect GROUP BY's from Koha::VirtualShelves
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Thu, 18 Oct 2018 20:37:35 +0000 (17:37 -0300)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Tue, 6 Nov 2018 11:55:18 +0000 (11:55 +0000)
commita23f610fc2a8283b12cd8af4832dc34eb493004b
tree255f30248954952d086620cdefe2dcaa4c8d734f
parent41f1cf664337602f6543642236b913eafab02711
Bug 21612: Remove incorrect GROUP BY's from Koha::VirtualShelves

'koha_kohadev.me.shelfname' isn't in GROUP BY

Same as
  commit 7e220e0d8f107cce63f32bfaa1919c04b4dea6e2
  Bug 20179: [sql_modes] Remove GROUP BY in get_shelves_containing_record

Test plan:
- Add public and privates shelves
- Shares some of them
- List them
=> The correct numbers of shelves must be displayed

Signed-off-by: Andrew Isherwood <andrew.isherwood@ptfs-europe.com>
Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
(cherry picked from commit b106ddb96b21a78559d7a60057e94024e7db4a16)
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Koha/Virtualshelves.pm