Replace DQL (Doctrine Query Language) - LIMIT and OFFSET clauses - The limit-subquery-algorithm.php