WooCommerce Order Items and Meta Data extract using SQL Command
SELECT * FROM `wp_posts` where ID='123';
SELECT * FROM `wp_postmeta` where post_id='123';
SELECT * FROM `wp_woocommerce_order_items` where order_id=123; // it will return meta id use in below query
SELECT * FROM `wp_woocommerce_order_itemmeta` where order_item_id=456;
https://stackoverflow.com/questions/38743011/sql-select-query-for-retrieving-woocommerce-order-items-and-meta-data