Improve adjustment service stability
What does this MR do and why?
Improve adjustment service stability by replacing usage of LEFT_JOIN with INNER JOIN to make sure we are not trying to insert null value to namespace_id.
Changelog: changed
EE: true
Relates to https://gitlab.com/gitlab-com/request-for-help/-/issues/2784#note_2518330162