Send the following on WhatsApp
Continue to ChatSubQuery in Doctrine 2.x using getDQL() https://shyammakwana.me/php/subquery-in-doctrine-2-x-using-getdql.html
SubQuery in Doctrine 2.x using getDQL() https://shyammakwana.me/php/subquery-in-doctrine-2-x-using-getdql.html