{"flag":true,"single":true,"pageTitle":"WooCommerce Order Items and Meta Data extract using SQL Command","post":{"id":241,"user_id":"1","slug":"woocommerce-order-items-and-meta-data-extract-using-sql-command-s36j","title":"WooCommerce Order Items and Meta Data extract using SQL Command","body":"<pre class=\"language-markup\"><code>SELECT * FROM `wp_posts` where ID='123';\r\nSELECT * FROM `wp_postmeta` where post_id='123';\r\nSELECT * FROM `wp_woocommerce_order_items` where order_id=123; \/\/ it will return meta id use in below query\r\nSELECT * FROM `wp_woocommerce_order_itemmeta` where order_item_id=456;<\/code><\/pre>\r\n<p>https:\/\/stackoverflow.com\/questions\/38743011\/sql-select-query-for-retrieving-woocommerce-order-items-and-meta-data<\/p>","category_id":"23","is_private":"0","created_at":"2024-05-18T11:20:48.000000Z","updated_at":"2024-05-18T11:20:48.000000Z","category":{"id":23,"user_id":"1","name":"DATABASE","slug":"database-j4ss","parent_id":null,"created_at":"2023-05-26T03:25:05.000000Z","updated_at":"2023-05-26T03:25:05.000000Z"},"user":{"id":1,"name":"R GONDAL","email":"rizikmw@gmail.com","email_verified_at":null,"two_factor_confirmed_at":null,"current_team_id":"1","profile_photo_path":null,"created_at":"2023-03-12T10:49:33.000000Z","updated_at":"2025-01-10T12:59:00.000000Z","profile_photo_url":"https:\/\/ui-avatars.com\/api\/?name=R+G&color=7F9CF5&background=EBF4FF"}},"pageDesc":"SELECT * FROM `wp_posts` where ID='123'; SELECT * FROM `wp_postmeta` where post_id='123'; SELECT * FROM `wp_woocommerce_order_items` where o - WooCommerce Order Items and Meta Data extract using SQL Command (Updated: May 18, 2024) - Read more about WooCommerce Order Items and Meta Data extract using SQL Command at my programming site [SITE]","categories":[]}