Can anyone figure out how to make a SQL for listing all the courses found within a category, which INCLUDES courses found in any subcategories? It shouldn't list the subcategories - just the courses.
I can't seem to make mine work - the whole path-thing has me confused :-s