[eluser]Derek Jones[/eluser]
Subqueries are something we have planned for the future for Active Record, but seeing ways that developers are commonly using them in real world apps is beneficial, which is one of the reason Derek asked you to post the query. I'm sure you have a good reason for keeping it "secret", but you must understand how difficult this makes it for us to develop solutions that accommodate the widest range of implementations, and prevents us from getting valuable feedback from the talented members of the community. And besides, you needn't show your exact query with field and table names, reduced anonymous samples are often better when demonstrating a bug or feature request.