DataMapper ORM v1.8.0

[eluser]rherriman[/eluser]
That's always an option of course, and I could have achieved similar results simply by keeping the select_depth() method and not filtering the results at all (among other solutions). However, this is not always desirable. In this particular instance, I have nodes as deep as five levels, and only need to retrieve two tiers. That's (potentially) a lot of extra data pulled from SQL unnecessarily that PHP will in turn have to loop all the way through. Granted most trees will not be very large, but still.

This behavior still seems incorrect. Shouldn't multiple subqueries be allowed? So long as they are "siblings," at least. I understand the issue with implementing nested subqueries.