I'd like to automatically exclude products from unpublished categories in the Virtuemart Products data source.

I've succeeded in causing the products not to appear by excluding their specific category ID's under Join Table 2, but I think I'd need to be able to join a fourth table, the virtuemart_categories table, in order to exclude items from unpublished categories automatically, and I can't see a way to do that.

Is there a way to specify my own SQL? Or is there something I am missing?

Thank you for your time!