Extracting info on individual purchases

We are using HikaShop to sell tickets for Jubilee functions. When I export the sales I get everything in one spreadsheet which is difficult to extract data from.

I am needing a method of pulling a list of who purchased a particular product e.g. a list of all people who bought dinner tickets or a list of all people who purchased Jubilee booklets. At the very least I need the MySQL code to do this.

Thanks for that, I did the following:

SELECT d.name FROM jos_hikashop_order_product AS a LEFT JOIN jos_hikashop_order AS b ON a.order_id=b.order_id LEFT JOIN jos_hikashop_user AS c ON b.order_user_id=c.user_id LEFT JOIN jos_users AS d ON c.user_cms_id=d.id WHERE a.order_product_code = 'Jubilee Dinner'

Oops... yes I used the description