We also use NOT EXISTS query instead of LEFT JOIN
to avoid query timeout

Changelog: performance
MR: https://gitlab.com/gitlab-org/gitlab/-/merge_requests/56959