Select all orders for a product with MySql

example.sql

SELECT
  `items`.`order_id`,
  MAX(CASE WHEN `itemmeta`.`meta_key` = '_product_id' THEN `itemmeta`.`meta_value` END) AS `product_id`
FROM
  `wp_woocommerce_order_items` AS `items`
  INNER JOIN
  `wp_woocommerce_order_itemmeta` AS `itemmeta`
ON
  `items`.`order_item_id` = `itemmeta`.`order_item_id`
WHERE
  `items`.`order_item_type` IN('line_item')
AND
  `itemmeta`.`meta_key` IN('_product_id')
GROUP BY
  `items`.`order_item_id`
HAVING
  `product_id` = 8 # Product ID