Query
SELECT * FROM event_result WHERE event_id='185' AND event_result.result_status = 'RES' ORDER by member.firstname ASC
throws error
Unknown column 'member.firstname' in 'order clause'