mehrshaddarzi · February 4, 2025 10:42
diff --git a/join_meta_query.php b/join_meta_query.php
 ```
 SELECT p.ID, p.user_login, p.user_email, p.display_name, phone.meta_value AS phone,
 	(SELECT SUM(CASE WHEN t.type = 'credit' THEN t.amount ELSE -t.amount END) as balance FROM wp_woo_wallet_transactions AS t WHERE t.user_id=p.ID AND t.deleted=0) as balance
 	FROM wp_users AS p LEFT JOIN wp_usermeta AS phone ON p.ID = phone.user_id AND 'billing_phone' = phone.meta_key;

 ```

 // More:
 https://stackoverflow.com/questions/26319613/improving-a-query-using-a-lot-of-inner-joins-to-wp-postmeta-a-key-value-table
	```
	SELECT p.ID, p.user_login, p.user_email, p.display_name, phone.meta_value AS phone,
	(SELECT SUM(CASE WHEN t.type = 'credit' THEN t.amount ELSE -t.amount END) as balance FROM wp_woo_wallet_transactions AS t WHERE t.user_id=p.ID AND t.deleted=0) as balance
	FROM wp_users AS p LEFT JOIN wp_usermeta AS phone ON p.ID = phone.user_id AND 'billing_phone' = phone.meta_key;

	```

	// More:
	https://stackoverflow.com/questions/26319613/improving-a-query-using-a-lot-of-inner-joins-to-wp-postmeta-a-key-value-table