Mike, this is a start. I'm interested in running this by category instead of by course. If I run it by course, I have to run this about 110 different times. If I run it by category then I only have to run it once and it will return 110 different courses and their discussion forums.
Do you know how to get this to work?
I usually type in something such as:
AND category = '$category_ID'