[eluser]TheJim[/eluser]
Yeah, DMZ provides a lot of magic, but with many deep relationships, there are still considerations and trade-offs, and as you noted, even with hand-crafted SQL it's not entirely simple to take care of everything all in one query.
