Understanding and Resolving the "DATE" Key Issue with Doctrine Query Language in Symfony 5

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