When searching for issues within a project or group, `IssuableFinder`
has an optimization that uses a CTE to filter the list of authorized
issues before searching within the list for text. This CTE optimization
fence is currently only used when the user specifies a simple sorting
parameter, such as `created_at`, and not popularity. These attributes
are generally stored directly with the model, so the CTE can easily do
an `ORDER BY` without joining another table (e.g. `award_emoji` for
popularity).

In EE, `weight` is another simple sorting parameter, and we should take
advantage of the CTE for that. This commit adds `weight` to
`Issue.simple_sorts`. When a user sorts by weight, this should help
speed up the search query and avoid a database statement timeout.

Improves https://gitlab.com/gitlab-org/gitlab/issues/34661

Update reference architecture section title in the docs

See merge request gitlab-org/gitlab!24195

Make Explore Projects default to All

Closes #19165

See merge request gitlab-org/gitlab!23811

For instances without public projects or much activity, there can be no
trending projects. Because the Explore item in the navbar led to the
Trending tab by default, some users were being confused by the lack of
data. This changes the Explore feature to default to the All tab
instead.

Reverse actions for ignoring/resolving errors

See merge request gitlab-org/gitlab!23516

Adds reverse actions for status update, removes redirect

Update QA delete_subgroups task to skip marked

Closes #199279

See merge request gitlab-org/gitlab!24174

Task now ignores subgroups already marked for deletion.
Soft deletion was added earlier this week:
https://gitlab.com/gitlab-org/gitlab/-/merge_requests/19430

Remove Ignore Column Token on Operations::FeatureFlagsClient

See merge request gitlab-org/gitlab!24107

Add Sentry error stack trace to GraphQL API

Closes #35896

See merge request gitlab-org/gitlab!23750

Update crass and i18n gems

See merge request gitlab-org/gitlab!24123

Handle errors in GraphQL mutations within Design Management

See merge request gitlab-org/gitlab!23491

Adds error fields to the follow .mutation.graphql mutations:

- createImageDiffNote
- createNote
- destroyDesign
- uploadDesign

Separate snippet entities into own class files

See merge request gitlab-org/gitlab!24183

Fetch incoming emails from multiple addresses

See merge request gitlab-org/gitlab!23524

This is the first step toward having a separate incoming email
address for service desk. It allows to configure mail_room to
listen on multiple email addresses (but we don't add
`service_desk_email` address into config file yet).

Fix database permission check for triggers on Amazon RDS

Closes #199468

See merge request gitlab-org/gitlab!24035

Stretch functions list to full container width

Closes #197476

See merge request gitlab-org/gitlab!24186

Remove duplicated information from alerting page

Closes #199710

See merge request gitlab-org/gitlab!24115

A user identified several subheadings on this page were duplicated,
possibly as part of a bad merge. This commit strips out the duplicated
information.

Update links to lists of Gitlab project maintainers

See merge request gitlab-org/gitlab!24116

Merge branch '119347-all-fields-in-the-trial-sign-up-form-should-indicate-they-are-required' into 'master'

All fields in the trial sign up form should indicate they are required

See merge request gitlab-org/gitlab!22716

Remove unused images from labels docs

See merge request gitlab-org/gitlab!24141

Add documentation for column panel types

See merge request gitlab-org/gitlab!23907

Docs - style: clarify GL version for screenshots

See merge request gitlab-org/gitlab!24156

Update docs with newer version of Prometheus manual configuration

See merge request gitlab-org/gitlab!24184

Move NotificationPayloadParser out of EE domain

Closes #200007

See merge request gitlab-org/gitlab!23860

crass 1.0.6 has a minor fix:
https://github.com/rgrove/crass/blob/master/HISTORY.md

i18n v1.8.2 has some other fixes:
https://github.com/ruby-i18n/i18n/releases

Move PrometheusMetric out of EE

Closes #199995

See merge request gitlab-org/gitlab!23864

Access policy check for new snippet button

See merge request gitlab-org/gitlab!23560

When there are snippets to show, the New Snippet button uses
new_project_snippet_path for the button. However, the empty snippets
state partial was using new_namespace_project_snippet_path.

There are no other usages of new_namespace_project_snippet_path in the
codebase so making them both use the same new_project_snippet path.

Convert project CI/CD Analytics Overall statistics section to ECharts

See merge request gitlab-org/gitlab!23840

On some instances of Amazon RDS, running a SELECT against
`'information_schema.role_table_grants'` fails with a `permission denied
for relation pg_authid` error. This happens because `role_table_grants`
is a PostgreSQL view that ultimately accesses the `pg_authid` table.

The PostgreSQL system function `has_table_privileges` doesn't actually
need a FROM clause. We can simplify the query to just call:

SELECT has_table_privilege('projects', 'TRIGGER')

Closes https://gitlab.com/gitlab-org/gitlab/issues/199468

Explicitly add erubi to Gemfile and unquarantine elasticsearch_reindexing_spec test

Closes #199911 and #197207

See merge request gitlab-org/gitlab!23700

Fix task lists on closed merge request pages

See merge request gitlab-org/gitlab!23714

Actually increment the PageLimiter counter

See merge request gitlab-org/gitlab!23778