Dan, sorry for not giving you a direct answer but have you tried
using the debug feature Kentico offers? This will give you exactly what is queried, rendered or how a macro's results are determined along with about a million other things for every page. You might check that out as well.
Its been a huge time saver for me when it comes to queries and complex macros.
Brenden