Hi,
I was just looking for similar code. It works except I need to display the
MAIN category specified for individual product. I'm not a MySQL expert...

something like
category.main eq "Y" and display the product's main category.
Thank you in advance
I'm working with xcart 4.2.