optimize performance of query from GlobalSearchCourses::getSQL(), fixes #1561

assigned to @tleilax

mentioned in issue #1561 (closed)

added 1 commit

• 36b98ae4 - optimize searching by teacher's name, re #1561 (closed)

Compare with previous version

approved this merge request

added 12 commits

• 36b98ae4...bf202778 - 9 commits from branch main
• ba8f8006 - apply join on i18n table only if selected language is not the default language, re #1561 (closed)
• be849d9e - remove join on sem_types, re #1561 (closed)
• 35c3b27a - optimize searching by teacher's name, re #1561 (closed)

Compare with previous version

enabled an automatic merge when the pipeline for 35c3b27a succeeds

merged

mentioned in commit 5761b25d

mentioned in commit tleilax/studip@8c8441ae

mentioned in commit ba41aa5e

mentioned in commit 93bb5200