WooCommerce Subscriptions Stats Export

gistfile1.sql

SELECT i.order_id as "Order #", tm.name as "Order Status", pm.meta_value as "Customer", i.order_item_name as "Subscription Type", m3.meta_value as "Subscription Status", m.meta_value as "Start Date", m2.meta_value as "End Date", m4.meta_value as "Expiry Date", m5.meta_value  as "Trial Expiry Date", m6.meta_value  as "Completed Payments"
	FROM wp_woocommerce_order_items i
	INNER JOIN wp_woocommerce_order_itemmeta m
		on m.order_item_id = i.order_item_id
	INNER JOIN wp_woocommerce_order_itemmeta m2
		on m2.order_item_id = i.order_item_id
	INNER JOIN wp_woocommerce_order_itemmeta m3
		on m3.order_item_id = i.order_item_id
	INNER JOIN wp_woocommerce_order_itemmeta m4
		on m4.order_item_id = i.order_item_id
	INNER JOIN wp_woocommerce_order_itemmeta m5
		on m5.order_item_id = i.order_item_id
	INNER JOIN wp_woocommerce_order_itemmeta m6
		on m6.order_item_id = i.order_item_id
	INNER JOIN wp_postmeta pm 
		on pm.post_id = i.order_id
	INNER JOIN wp_term_relationships tr 
		on tr.object_id = i.order_id
	INNER JOIN wp_terms tm 
	WHERE m.meta_key = '_subscription_start_date'
		AND
		m2.meta_key = '_subscription_end_date'
		AND
		m3.meta_key = '_subscription_status'
		AND
		m4.meta_key = '_subscription_expiry_date'
		AND
		m5.meta_key = '_subscription_trial_expiry_date'
		AND
		m6.meta_key = '_subscription_completed_payments'
		AND
		pm.meta_key = '_billing_email'
		AND
		tm.term_id = tr.term_taxonomy_id
	ORDER BY i.order_id