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.odate DESC' at line 26
SELECT alp_act_ascents.id AS ascid, alp_act_ascents.page_id AS ascpage_id, alp_act_ascents.position, alp_act_ascents.champ_id, CONCAT(alp_clients.surname, ' ', alp_clients.name) AS chief, alp_clients.sex, alp_clients.birthday, alp_act_ascents.odate AS `date`, fr.real_name AS report, fc.real_name AS critique, alp_routes.num, alp_routes.toponym, alp_routes.track, alp_hardship.name AS hardship, alp_hardship.id AS hardid, alp_subhard.name AS subhard, alp_route_style.style, alp_routes.pioneer, alp_routes.openyear, alp_routes.height, alp_act_ascents.pioneer AS fresh, alp_ref_levels.name AS `level` FROM alp_act_ascents INNER JOIN alp_routes ON alp_act_ascents.route = alp_routes.id LEFT OUTER JOIN alp_accidents ON alp_accidents.host_element_id = alp_act_ascents.id INNER JOIN alp_hardship ON alp_routes.hardship = alp_hardship.id INNER JOIN alp_route_style ON alp_routes.style = alp_route_style.id LEFT OUTER JOIN alp_asc_parties z0 ON z0.host_element_id = alp_act_ascents.id AND z0.chief = true LEFT OUTER JOIN alp_ref_levels ON z0.level = alp_ref_levels.id LEFT OUTER JOIN alp_clients ON z0.party = alp_clients.id LEFT OUTER JOIN alp_subhard ON alp_routes.subhard = alp_subhard.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.hidden = false AND alp_act_ascents.id IN (SELECT z1.host_element_id FROM alp_asc_parties z1 WHERE z1.party = ) ORDER BY alp_act_ascents.odate DESC;