EE Tip: Counting the results of a nested query

Nested loops in ExpressionEngine can cause all sorts of headaches, especially when it comes to dealing with "magic" variables like {count}. Thankfully, MySQL can help.