WordPress database error: [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 lname' at line 3]
SELECT fname,lname,event_name FROM aelc_events_attendee join aelc_events_detail on event_id = aelc_events_detail.id WHERE event_id = order by lname;

WordPress database error: [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 lname' at line 3]
SELECT fname,lname,event_name FROM aelc_events_attendee join aelc_events_detail on event_id = aelc_events_detail.id WHERE event_id = order by lname;

The following error was found: