To help with the problem, I will reformat the code and provide additional context as needed.

Understanding Left Joins in Doctrine QueryBuilder: Avoiding the Cartesian Product Problem with Pagination

Improving Query Performance with Composite Primary Keys in T-SQL