SELECT eventdate, time_format(start,'%l:%i%p') as starttime, date_format(eventdate,'%e %M') as daymonth, date_format(eventdate,'%W') as weekday, date_format(eventdate,'%Y') as year, title, venue, venue_id, groups.name AS groupname, events.description, tickets, contact,email,website, promoter, promoter_url FROM events LEFT JOIN groups ON groupid = groups.id LEFT JOIN promoter ON events.promoter_id = promoter.id WHERE events.id = '2780'