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