https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21603 Bug ID: 21603 Summary: Remove Group by clause in SearchCourses Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Course reserves Assignee: koha-bugs@lists.koha-community.org Reporter: nick@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org I am not certain we can simply remove here, but the GROUP by seems to stem form adding course instructors, though we fetch the instructors for each course after this query 971 $query .= " 972 LEFT JOIN course_instructors ci 973 ON ( c.course_id = ci.course_id ) 974 LEFT JOIN borrowers b 975 ON ( ci.borrowernumber = b.borrowernumber ) 976 LEFT JOIN authorised_values av 977 ON ( c.department = av.authorised_value ) 978 WHERE 979 ( av.category = 'DEPARTMENT' OR av.category = 'TERM' ) 980 AND 981 ( 982 department LIKE ? OR 983 course_number LIKE ? OR 984 section LIKE ? OR 985 course_name LIKE ? OR 986 term LIKE ? OR 987 public_note LIKE ? OR 988 CONCAT(surname,' ',firstname) LIKE ? OR 989 CONCAT(firstname,' ',surname) LIKE ? OR 990 lib LIKE ? OR 991 lib_opac LIKE ? 992 ) 993 AND 994 c.enabled LIKE ? 995 GROUP BY c.course_id 996 "; -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.