[wp-hackers] User Meta Query Assistance

[Otto]

Haven't tried it, but wouldn't this work without a subselect?

SELECT ID, user_login, first.meta_value AS fname, last.meta_value AS lname
FROM wp_users
LEFT JOIN wp_usermeta AS first ON
(wp_users.ID = first.ID AND
first.meta_key = 'first_name')
LEFT JOIN wp_usermeta AS last ON
(wp_users.ID = last.ID AND
last.meta_key = 'last_name')