Query
SELECT * FROM event_result WHERE event_id='3010' AND event_result.result_status = 'RES' ORDER by organiser.name ASC
throws error
Unknown column 'organiser.name' in 'order clause'