I get Error# 1064 when i execute this sql statement below, how can i fix?

I get Error# 1064 when i execute this sql statement below, how can i fix?

Error:

Error in query: Error# 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 ') as rep, ticket.timestamp as open_time, (select max(timestamp) from ticket_answ' at line 1
Error in query: Error# 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 ') as rep, ticket.timestamp as open_time, (select max(timestamp) from ticket_answ' at line 1

SELECT ticket.ID, ticket.Subject, ticket.Name, ticket.Status, 
	(SELECT name FROM ticket_reps WHERE ID = ticket.rep) AS Rep, 
	DATE_FORMAT(CONVERT_TZ(ticket.timestamp, '+00:00', '-5:00'),"%M %d, %Y %h:%i%p") AS Open_Ticket_Time,
	(SELECT DATE_FORMAT(CONVERT_TZ(Max(timestamp), '+00:00', '-5:00'),"%M %d, %Y %h:%i%p")  FROM ticket_answers WHERE ticket = ticket.ID) AS Last_Time_Messaged
FROM tickets AS ticket 
ORDER BY ticket.timestamp DESC

Select allOpen in new window