data from wp/woocommerce database

Hello

At first I thought that I have quite an easy task to complete, but as it turned out, still too difficult. Maybe somebody can help:

I need to create query in phpMyAdmin that gives me a following result:
Show products that are in orders (all states) list by category. Like if I insert category “cars” then i see a result of orders that has category as cars.

• This topic was modified 5 years, 10 months ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Developing with WordPress topic