Title: data from wp/woocommerce database
Last modified: July 20, 2020

---

# data from wp/woocommerce database

 *  Resolved [booklysql](https://wordpress.org/support/users/booklysql/)
 * (@booklysql)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/data-from-wp-woocommerce-database-2/)
 * Hello
 * At first I thought that I have quite an easy task to complete, but as it turned
   out, still too difficult. Maybe somebody can help:
 * I need to create query in phpMyAdmin that gives me a following result:
    Show 
   products that are in orders (all states) list by category. Like if I insert category“
   cars” then i see a result of orders that has category as cars.

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Support [Riaan K.](https://wordpress.org/support/users/riaanknoetze/)
 * (@riaanknoetze)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/data-from-wp-woocommerce-database-2/#post-13148654)
 * This is a fairly complex development topic. I’m going to leave it open for a 
   bit to see if anyone is able to chime in to help you out.
 * I can also recommend the following places for more development-oriented questions:
    1. WooCommerce Slack Community: [https://woocommerce.com/community-slack/](https://woocommerce.com/community-slack/)
    2. WooCommerce FB group: [https://www.facebook.com/groups/advanced.woocommerce/](https://www.facebook.com/groups/advanced.woocommerce/)
 *  Thread Starter [booklysql](https://wordpress.org/support/users/booklysql/)
 * (@booklysql)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/data-from-wp-woocommerce-database-2/#post-13148997)
 * Now I have had some progress, I can get object_ID from orders list, searching
   by category. Now I need additional data:
    order number; Object_ID; object name;
   description; rented from date; rented to date; order status; client name; client
   aadress
 * I would really appreciate if someone could help me 🙂
 * MySQL ia have now:
 * SELECT DISTINCT tr.object_id
    FROM iqpe_term_relationships tr INNER JOIN iqpe_term_taxonomy
   tt ON tr.term_taxonomy_id = tt.term_taxonomy_id INNER JOIN iqpe_terms t ON tt.
   term_id = t.term_id INNER JOIN iqpe_woocommerce_order_itemmeta oim ON tr.object_id
   = oim.meta_value INNER JOIN iqpe_woocommerce_order_items oi ON oim.order_item_id
   = oi.order_item_id INNER JOIN iqpe_posts as o ON oi.order_id = o.ID WHERE tt.
   taxonomy = ‘product_cat’ AND t.slug = ‘jaana-ou’ AND oim.meta_key = ‘_product_id’
   AND o.post_type = ‘shop_order’ AND o.post_status IN (‘wc-completed’,’wc-processing’)
    -  This reply was modified 6 years, 1 month ago by [booklysql](https://wordpress.org/support/users/booklysql/).

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘data from wp/woocommerce database’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3640790)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [booklysql](https://wordpress.org/support/users/booklysql/)
 * Last activity: [6 years, 1 month ago](https://wordpress.org/support/topic/data-from-wp-woocommerce-database-2/#post-13148997)
 * Status: resolved