This query is sub-optimal and is frequently reported in the top 15 in
total time taken due to the fact that this is used to count the number
of assigned open issues on header bar which is loaded on every page
load.

Since a common use case is filtering by assigned to self (ie. the count
of assigned issues) we can optimize this query by not bothering to check
for confidentiality as it doesn't affect the outcome as you can see
assigned issues regardless of confidentiality.

More edits for style

See merge request gitlab-org/gitlab!57034

Related to: https://gitlab.com/gitlab-org/gitlab/-/issues/300312

Fixed rubocop offense Layout/RescueEnsureAlignment

See merge request gitlab-org/gitlab!56870

Make group runner CI builds use distinct CTE optimzation [RUN ALL RSPEC] [RUN AS-IF-FOSS]

See merge request gitlab-org/gitlab!57045

Deduplicate SAML docs information

See merge request gitlab-org/gitlab!56595

Resolve "Traversal IDs column sync" [RUN ALL RSPEC] [RUN AS-IF-FOSS]

See merge request gitlab-org/gitlab!52854

Update admin troubleshooting page

See merge request gitlab-org/gitlab!50535

Add troubleshooting tip for pages 404 to admin docs

See merge request gitlab-org/gitlab!56372

Remove controller, actions, and job class fields from Marginalia

See merge request gitlab-org/gitlab!55854

docs: Fix typo in JavaScript style guide

See merge request gitlab-org/gitlab!57022

Signed-off-by: Takuya Noguchi <takninnovationresearch@gmail.com>

Asyncronously import monaco components

See merge request gitlab-org/gitlab!56909

Docs: Add max number of feature flags for all types

See merge request gitlab-org/gitlab!56833

Create new unit test tables

See merge request gitlab-org/gitlab!56137

Add Username to Email From Header in Notifications

See merge request gitlab-org/gitlab!56588

When replying to a notification from GitLab, it can be non-obvious as
to how to ping the person I am responding to without looking for their
username in Gitlab.

By adding the username to the From header in the form of From: User
Name (@user), it is much more clear as to how to ping a person in the
response.

Move from btn-success to btn-confirm in projects/tags directory

See merge request gitlab-org/gitlab!56940

Update occurrences of node to site

See merge request gitlab-org/gitlab!56280

`TodosDestroyer::EntityLeaveWorker` generates expensive SQL queries

See merge request gitlab-org/gitlab!56995

Since the group is private, and we're only looking at it's
descendants, we don't need to consider public/internal groups

Password reset improvements

See merge request gitlab-org/gitlab!56992

Use --local for setting bundle config

See merge request gitlab-org/gitlab!56983

Fix baseurl wordage typo

See merge request gitlab-org/gitlab!55722

Turn on feature flag for the code review aggregated metrics

See merge request gitlab-org/gitlab!56734

Move from btn-success to btn-confirm in registrations directory

See merge request gitlab-org/gitlab!56944

Add recaptcha to group creation [RUN ALL RSPEC] [RUN AS-IF-FOSS]

See merge request gitlab-org/gitlab!56707

Localize assignees and reviewers label

See merge request gitlab-org/gitlab!56473

Apply new GitLab UI for the badge on the starrers page

See merge request gitlab-org/gitlab!56091