Wordpress SQL query the user's first & last name for product X?
Try this:
SELECT DISTINCT pp.user_id, first.meta_value AS 'first_name', last.meta_value AS 'last_name', pp.user_email AS 'email', oi.order_item_name AS 'order'FROM Wp_woocommerce_order_items oiINNER JOIN Wp_woocommerce_downloadable_product_permissions pp ON pp.order_id = oi.order_idINNER JOIN wp_usermeta first ON first.user_id = pp.user_idINNER JOIN wp_usermeta last ON last.user_id = pp.user_idWHERE first.meta_key = 'first_name'AND last.meta_key = 'last_name'AND oi.order_item_type = 'line_item'
add this join
INNER JOIN wp_usermeta AS last ON Wp_woocommerce_downloadable_product_permissions_1.user_id = last.user_id AND last.meta_key = 'last_name'
and the column
last.meta_value AS 'last_name',
You probably don't need to go so crazy with the ()
-- order does not matter unless you are doing a sub query (which you aren't) or are mixing left and right joins (which you aren't).