List of customers who ordered a product - MySQL

Hi there,

I did try to purchase a plugin that could generate such a report, however, it conflicted with other plugins, so it didn't work as it should have. This is only a one time thing, so a plugin is not really necessary...

I am trying to find out what customers ordered a particular product, how many they ordered and what their contact information is. I know this can be done through a MySQL query - I can easily get the list of orders IDs containing the product, but I don't know how to then join that to getting the actual order so I could export the file. Is someone able to help me with this?

Thank you!

This will give you the relevant order details, filtered by a specific product ID. There, you will have the customer ID as well