Fix cross-join between sbom_occurrences and projects within BackfillSbomOccurrencesTraversalIdsAndArchived

Problem to solve

All cross-joins arising from decomposing gitlab_sec from gitlab_main should be resolved. See parent epic for context.

1. Remove allowed cross-join for relevant relation using associated documentation for guidance on removing cross-joins or cross-transactions occurrences

In the case of BackfillSbomOccurrencesTraversalIdsAndArchived we join across projects table, which may be fixed by Ensure Sec DB remains in sync with CI mirror ta... (#466288 - closed)