Get all WooCommerce orders from Wordpress that have a Local Pickup Plus appointment

get_orders_with_appointment.php

function get_orders_with_pickup_appointment() {

	global $wpdb;
  
  	$sql = "
        SELECT
          `items`.`order_id`
        FROM
          `{$wpdb->prefix}woocommerce_order_items` AS `items`
        INNER JOIN
          `{$wpdb->prefix}woocommerce_order_itemmeta` AS `itemmeta`
        ON
          `items`.`order_item_id` = `itemmeta`.`order_item_id`
        WHERE
          `items`.`order_item_name` IN('Local Pickup')
        AND
          `itemmeta`.`meta_key` IN('_pickup_appointment_start')
        GROUP BY
          `items`.`order_item_id`
        ";

    return array_map(function ( $data ) {
        return wc_get_order( $data->order_id );
    }, $wpdb->get_results( $sql ) );

}

$orders = get_orders_with_pickup_appointment();