Debug Call No. 1:
string(193) "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
icon2004_event.begin_time' at line 33"
Debug Call No. 2:
string(1641) "
SELECT
icon2004_event.id,
icon2004_event.inactive,
icon2004_activity.id AS activity,
icon2004_activity.title,
icon2004_activity.category,
icon2004_activity.description,
icon2004_activity.requires_registration,
icon2004_activity.max_registrations,
icon2004_activity.properties,
icon2004_activity_category.host_title,
icon2004_event_location.title AS location,
icon2004_user.guild_nick,
icon2004_user.email,
CONCAT(icon2004_user.first_name, " ", icon2004_user.last_name) AS host,
UNIX_TIMESTAMP(icon2004_event.begin_time) AS begin_time,
UNIX_TIMESTAMP(icon2004_event.end_time) AS end_time,
icon2004_event.age_min,
icon2004_event.age_max,
COUNT(icon2004_registration.user) AS num_registrations
FROM
((((icon2004_event LEFT JOIN icon2004_activity ON icon2004_event.activity = icon2004_activity.id) LEFT JOIN
icon2004_activity_category ON icon2004_activity.category = icon2004_activity_category.id) LEFT JOIN
icon2004_user ON icon2004_event.host_user = icon2004_user.id) LEFT JOIN
icon2004_event_location ON icon2004_event.location = icon2004_event_location.id) LEFT JOIN
icon2004_registration ON icon2004_event.id = icon2004_registration.event
GROUP BY
id,
activity,
inactive
HAVING
NOT inactive AND icon2004_event.id =
ORDER BY
icon2004_event.begin_time"