According to https://dev.mysql.com/doc/refman/5.7/en/update.html,
"You cannot update a table and select from the same table in a subquery."
Attempting to do so results in the error:

```
Mysql2::Error: Table 'issues' is specified twice, both as a target for 'UPDATE' and as a separate source for data
```

Instead, we can use a LEFT JOIN on the same table to make MySQL do the right
thing.

Closes #41498

Fix Error 500s with anonymous clones for a project that has moved

Closes #41457

See merge request gitlab-org/gitlab-ce!16128

Gracefully handle garbled URIs in Markdown

Closes #41442

See merge request gitlab-org/gitlab-ce!16123

Closes #41457

Update code_climate recommended usage.

See merge request gitlab-org/gitlab-ce!16101

Incorporate Gitaly's RemoteService RPCs

Closes gitaly#852

See merge request gitlab-org/gitlab-ce!16060

Gracefully handle orphaned write deploy keys in /internal/post_receive

Closes #41466

See merge request gitlab-org/gitlab-ce!16127

Fix namespace ambiguity with Kubernetes Pod definitions

Closes #41458

See merge request gitlab-org/gitlab-ce!16130

This was causing a spec failure between Gitlab::Kubernetes::Helm::Pod and
Gitlab::Kubernetes::Helm::Api::Pod if one spec loaded the former
definition first.

Closes #41458

On GitLab.com, there are write deploy keys with no associated users.
Pushes with these deploy keys end with an Error 500 since we attempt
to look up redirect message. If there is no user, don't attempt
to display a redirect message.

Closes #41466

Resolve "Updating Slack Notification not working by API"

Closes #32364 et #22306

See merge request gitlab-org/gitlab-ce!11435

Remove security checks from static analysis and add sast job

See merge request gitlab-org/gitlab-ce!16113

Resolve "lint-changelog-yaml error message is useless"

Closes #41359

See merge request gitlab-org/gitlab-ce!16122

Resolve "Replace '.team << [user, role]' with 'add_role(user)' in specs"

Closes #36782

See merge request gitlab-org/gitlab-ce!16069

Disable /dev/shm in CI

See merge request gitlab-org/gitlab-ce!16105

There are certain inputs that look like valid URIs that are accepted by URI
but not Addressable::URI. Handle the case where the latter fails.

Closes #41442

Add note about using the term GPG for all related implementations

Closes #36970

See merge request gitlab-org/gitlab-ce!14887

Improve performance of DiffDiscussion#truncated_diff_lines and DiffNote#diff_line by removing expensive diff position calculation and comparison

Closes #41406

See merge request gitlab-org/gitlab-ce!16111

Reverted fix https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/15788

See merge request gitlab-org/gitlab-ce!16118

Extend Cluster Applications to allow installation of Prometheus

Closes #41053

See merge request gitlab-org/gitlab-ce!15895

Docs: move article LDAP-CE to its topic-related folder

See merge request gitlab-org/gitlab-ce!16094

Execute project hooks and services after commit when moving an issue

Closes #41324

See merge request gitlab-org/gitlab-ce!16108

Improve performance of DiffDiscussion#truncated_diff_lines and DiffNote#diff_line by removing expensive diff position calculation and comparison

Use relative URLs when linking to uploaded files

Closes #38893

See merge request gitlab-org/gitlab-ce!15751

Use gitlab-styles which provides shared RuboCop config and cops

Closes #37711

See merge request gitlab-org/gitlab-ce!14337

Signed-off-by: Rémy Coutable <remy@rymai.me>

Add index on namespaces lower(name) for UsersController#exists

Closes #41340

See merge request gitlab-org/gitlab-ce!16059