Wordpress SQL query the user's first & last name for product X? Wordpress SQL query the user's first & last name for product X? wordpress wordpress

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).