Get all product count from a order in Woocommerce
I am having trouble with Woocommerce product details and order details relationship.
I need to get a count of products that have meta_key = ‘porduct_status_in_supplier’ and value of this meta is ‘no’ in order that order_id = ’55’
i try this SQL but not true
select COUNT(*) AS THE_COUNT from oc_posts as p, oc_postmeta as pm, oc_woocommerce_order_items as i, oc_woocommerce_order_itemmeta as im where p.post_type = 'shop_order' and p.ID = pm.post_id and p.ID = i.order_id and pm.meta_key = 'porduct_status_in_supplier' and pm.meta_value = 'no'