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 \') GROUP BY s.session_id ORDER BY title ASC\' at line 1 SQL=SELECT s.session_id, s.title, s.text, s.session_up, s.session_down, s.registration_up, s.registration_down, s.status, s.access, s.published, s.maxregistrations, COUNT(r.registration_id) AS numregistrations, s.maxregistrations - COUNT(r.registration_id) AS numavailable, CASE LENGTH( s.host_alias ) WHEN 0 THEN host.name ELSE s.host_alias END as host_name, s.checked_out, s.checked_out_time, u.name AS editor, g.name AS groupname, v.name AS venue_name, v.address AS venue_address, v.city AS venue_city, v.state AS venue_state, v.postalcode AS venue_postalcode, v.country AS venue_country, v.webaddress AS venue_webaddress FROM jos_events_sessions AS s LEFT JOIN jos_users AS u ON (s.checked_out=u.id) LEFT JOIN jos_users AS host ON ( s.host_id = host.id ) LEFT JOIN jos_groups AS g ON (g.id=s.access) LEFT JOIN jos_events_registrations AS r ON ( ( s.session_id = r.session_id ) AND ( r.cancel_date = \'0000-00-00 00:00:00\' ) ) LEFT JOIN jos_events_venues AS v ON ( s.venue_id = v.venue_id ) WHERE (1=1) AND (s.published = \'1\') AND ( 1 = 1 ) AND ( ) GROUP BY s.session_id ORDER BY title ASC
|
|
