SELECT
u.user_email,
CONCAT_WS(‘ ‘,
MAX(CASE WHEN um_name.meta_key = ‘first_name’ THEN um_name.meta_value END),
MAX(CASE WHEN um_surname.meta_key = ‘last_name’ THEN um_surname.meta_value END)
) AS full_name
FROM wp_users u
INNER JOIN wp_usermeta um
ON u.ID = um.user_id
AND um.meta_key = ‘course_29816_access_from’
AND um.meta_value IS NOT NULL
LEFT JOIN wp_usermeta um_name
ON u.ID = um_name.user_id
AND um_name.meta_key = ‘first_name’
LEFT JOIN wp_usermeta um_surname
ON u.ID = um_surname.user_id
AND um_surname.meta_key = ‘last_name’
GROUP BY u.ID, u.user_email
