Query
SELECT * FROM event_result WHERE event_id='143' AND event_result.result_status = 'RES' ORDER by event_age_category_detail.age_category ASC
throws error
Unknown column 'event_age_category_detail.age_category' in 'order clause'