bug_7458: Correct existing existing call numbers retrieval

[koha.git] / cataloguing / value_builder / callnumber-KU.pl

diff --git a/cataloguing/value_builder/callnumber-KU.pl b/cataloguing/value_builder/callnumber-KU.pl
index e0fa444..201f9c8 100755 (executable)
--- a/cataloguing/value_builder/callnumber-KU.pl
+++ b/cataloguing/value_builder/callnumber-KU.pl
@@ -104,7 +104,7 @@ sub plugin {
             if ( my $first = $dbh->selectrow_array("SELECT itemcallnumber
                                                     FROM items
                                                     WHERE itemcallnumber = ?", undef, $padded) ) {
-                my $icn = $dbh->selectcol_arrayref("SELECT itemcallnumber
+                my $icn = $dbh->selectcol_arrayref("SELECT DISTINCT itemcallnumber
                                                     FROM items
                                                     WHERE itemcallnumber LIKE ?
                                                       AND itemcallnumber >   ?