This benefits the projects API for unauthenticated calls.

Relevant query:

```sql
SELECT
    "projects".*
FROM
    "projects"
WHERE
    "projects"."visibility_level" = 20
    AND "projects"."pending_delete" = FALSE
ORDER BY
    "projects"."last_activity_at" ASC,
    "projects"."id" DESC
LIMIT 20 OFFSET 0
```

Plan without index: https://explain.depesz.com/s/t73N
Plan with index: https://explain.depesz.com/s/V45y

Very similar for the `last_activity_at DESC` sort order.

Relevant issue: https://gitlab.com/gitlab-org/gitlab/issues/36390

Related MR with more explanation:
https://gitlab.com/gitlab-org/gitlab/merge_requests/22623

Fix discarding renamed directories in Web IDE

See merge request gitlab-org/gitlab!22943

Fix 'qa/specs/features/browser_ui/6_release/deploy_key/add_deploy_key_spec.rb'

Closes #196608

See merge request gitlab-org/gitlab!22975

Fix tests failing in headed mode

See merge request gitlab-org/gitlab!21992

Resolve "WebIDE doesn't work on empty repositories again"

See merge request gitlab-org/gitlab!22950

Split up RelativeLinkFilter into UploadLinkFilter and RepositoryLinkFilter

See merge request gitlab-org/gitlab!22631

Create API for GeoNode

Closes #118843

See merge request gitlab-org/gitlab!22392

Refactor spec to use symbolic HTTP statuses

Also consolidates very similar message in modal.vue so that
there is only one gitlab.pot entry.

Allow administrators to force access control for gitlab pages (disable public pages)

See merge request gitlab-org/gitlab!22003

Add force_pages_access_control to application_settings
Add force_pages_access_control to settings form
Make pages private if it's forced on an instance level
Pass forced pages access control param to frontend
Show proper options for pages access when control is forced
Refactor and fix false-negative specs for project_feature
Move private_pages? specs to a separate describe block
Make pages private to public projects on creation if forced
Add specs for forced pages access control

Add information about epic to Issue list csv export

See merge request gitlab-org/gitlab!22662

Fix search limits when ES search isn't enabled globally

See merge request gitlab-org/gitlab!22661

Document :release_evidence_collection feature flag

Closes gitlab-com/support/docs#50

See merge request gitlab-org/gitlab!22855

Split Secure MR E2E files and reuse test setup

Closes gitlab-org/quality/team-tasks#266

See merge request gitlab-org/gitlab!22929

Remove enable_cluster_application_crossplane FF

See merge request gitlab-org/gitlab!22141

Update auto-deploy-image to v0.8.3 for DAST default branch deploy

See merge request gitlab-org/gitlab!22227

Update container registry removal success notification

See merge request gitlab-org/gitlab!22890

- new copy
- interpolate with repo name
- unit test
- pot file

Merge branch '118627-delete-selected-button-is-incorrectly-active-after-uploading-designs-immediately-after-a' into 'master'

Replace v-show on Designs toolbar with d-none class

See merge request gitlab-org/gitlab!22963

Application Limits development documentation

Closes #38250

See merge request gitlab-org/gitlab!21949

PlanLimits already supports PlanLimits#exceeded? to ensure that the
count of the records for a relation does not exceed the defined limit.

This adds PlanLimits#exceeded_value? to ensures that a value does not
exceed the defined limit.

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

Merge branch '11824-extend-issues-epics-counter-tooltip-to-include-number-of-open-closed-items-2' into 'master'

Added opened and closed descendant counts in epic

See merge request gitlab-org/gitlab!21278

Pass log source to the frontend

See merge request gitlab-org/gitlab!22694

And vary UI based on it

Preload data before Vue route navigation

See merge request gitlab-org/gitlab!19754

Extract api urls from Sentry Client

See merge request gitlab-org/gitlab!22790

Move sentry api urls to a ApiUrl class so that
they can be used outside of the client

DRY User scopes for bots/humans

See merge request gitlab-org/gitlab!22976

Upgrade octokit and its dependencies

See merge request gitlab-org/gitlab!22946

Use rules for `qa-frontend-node-*` and `webpack-dev-server`, and only run the `qa-frontend-node-*` jobs on `master`

Closes #42682

See merge request gitlab-org/gitlab!22538

Destroy user associations in batches

See merge request gitlab-org/gitlab!22894

Fixed GitLab admin not seeing merge requests

See merge request gitlab-org/gitlab!21467

Fixes #196172: manual IID should render conflict

Closes #196172

See merge request gitlab-org/gitlab!22788

When creating an issue via the API with a manual IID which is already
in use, the server would send a server error response instead of a
conflict response.