Solved - Using SQL Query to output custom Member Field data

Today I managed to (just about) figure out how to use an SQL Query in a Template, output custom Member Field data.

In the following example, I’m outputting the First Name and Surname custom Member Fields, for all Members whose Role ID is 6, in the date order in which they registered (join_date). For me, these are customers registered on an ecommerce site.

{exp:query sql="SELECT * FROM exp_members
INNER JOIN exp_member_data_field_1 ON exp_members.member_id = exp_member_data_field_1.member_id
INNER JOIN exp_member_data_field_2 ON exp_members.member_id = exp_member_data_field_2.member_id
WHERE role_id=6 ORDER BY exp_members.join_date DESC"}
 {m_field_id_1} {m_field_id_2} {join_date format="%j/%m/%Y"}
{/exp:query}

The First Name values are stored in the database table called exp_member_data_field_1 and the Surname values are stored in exp_member_data_field_2.