Sem categoria

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’ […]