In Symfony1.4, I researched how to use subqueries with Doctrine, so here’s a memo.
・The symfony Cookbook | データをDoctrineで読み取る | symfony | Web PHP Framework
I see, you can use createSubquery().
For MySQL subqueries, refer to this:
・MySQL :: MySQL 5.1 リファレンスマニュアル :: 12.2.8 サブクエリ構文
That’s all from the Gemba.