El clasificado no es valido
SELECT ap.*, CONCAT(a.firstname,' ',a.lastname) username, a.subdomain, CONCAT(aau.firstname,' ',aau.lastname) anonymous_username, a.seekemploy, a.regsess, a.hide_profile, DATE_FORMAT(ap.publish_date,'%b %e, %Y at %H:%s') formated_publish_date FROM events_post ap LEFT JOIN assistants a ON a.assist_id=ap.user_id LEFT JOIN events_anonymous_user aau ON aau.user_id=ap.anonymous_user_id WHERE id=400