An Error Was Encountered
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY alp_act_ascents.date' at line 12
SELECT alp_act_ascents.id AS ascid, alp_act_ascents.page_id AS ascpage_id, alp_act_ascents.pioneer AS fresh, CONCAT(alp_clients.surname, ' ', alp_clients.name) AS chief, alp_clients.sex, alp_clients.birthday, alp_act_ascents.position, alp_act_ascents.champ_id, alp_act_ascents.date, fr.real_name AS report, '' AS num, '' AS toponym, '' AS track, '' AS hardship, 0 AS hardid, '' AS style, '' AS pioneer, '' AS openyear, fc.real_name AS critique, 0 AS height FROM alp_act_ascents LEFT OUTER JOIN alp_asc_parties ON alp_asc_parties.host_element_id = alp_act_ascents.id AND alp_asc_parties.chief = TRUE LEFT OUTER JOIN alp_clients ON alp_asc_parties.party = alp_clients.id LEFT OUTER JOIN alp_accidents ON alp_accidents.host_element_id = alp_act_ascents.id LEFT OUTER JOIN alp_files fr ON alp_act_ascents.report = fr.id LEFT OUTER JOIN alp_files fc ON alp_accidents.critique = fc.id WHERE alp_act_ascents.route = ORDER BY alp_act_ascents.date;