XF 2.1 Struggling with an SQL Query

[Graham Smith]

Am trying to download data from people who have joined.

Username, Email and usergroups all come down fine.

However, the f.field_id "forename" and "surname" doesn't give the data I expected.

Can anyone suggest anything?

Cheers

SELECT u.username as
"username", u.email as "email", f.field_id "forename", f.field_id "surname", u.user_group_id as "primary usergroup", u.secondary_group_ids as "secondary usergroups"
FROM xf_user_field_value f
RIGHT JOIN xf_user u ON (u.user_id = f.user_id)
GROUP BY u.user_id