Fix null linkedEvent for some Order routes

[nik-dange]

Changes

• Added a left join in the get single order and get many orders query

Type of Change

• [ ] Patch (non-breaking change/bugfix)
• [x] Minor (non-breaking change which adds functionality)
• [ ] Major (fix or feature that would cause existing functionality to not work as expected)
• [ ] Documentation (A change to a README/description)
• [ ] Continuous Integration/DevOps Change (Related to deployment steps, continuous integration workflows, linting, etc.)
• [ ] Other: (Fill In)

If you've selected Patch, Minor, or Major as your change type, make sure to bump the version before merging in package.json!

Testing

I have tested that my changes fully resolve the linked issue ...

• [x] locally.
• [ ] on the testing API/testing database.
• [x] with appropriate Postman routes. Screenshots are included below.

Checklist

• [x] I have performed a self-review of my own code.
• [x] I have followed the style guidelines of this project.
• [ ] I have appropriately edited the API version in the package.json file.
• [x] My changes produce no new warnings.

Screenshots

Please include a screenshot of your Postman testing passing successfully.

[github-actions[bot]]

Thanks for contributing! If you've made changes to the API's functionality, please make sure to bump the package version—see this guide to semantic versioning for details—and document those changes as appropriate.

[nik-dange]

Don't merge I haven't added this query everywhere it needs to go yet