Events
: SELECT Events.EventID, EventDate, DATE_FORMAT(EventDate, '%D %M %Y') AS EventStartDate, DATE_FORMAT(EventEndDate, '%D %M %Y') AS EventEndDate, EventTitle, EventShortDescription, EventDescription, EventCapacity, VenueName, VenueWebAddress, Venues.VenueID, EventTypeDescription, EventTypes.EventTypeID, EvTypeColour , Colour, DATE_FORMAT(Time, '%l:%i %p') AS Time FROM Events
LEFT JOIN Venues ON Events.VenueID = Venues.VenueID
LEFT JOIN EventTypes ON Events.EventTypeID = EventTypes.EventTypeID
LEFT JOIN EventTalks ON Events.EventID= EventTalks.EventID
LEFT JOIN EventTypeColour on EventTypes.EvTypeColour = EventTypeColour.ColourID
WHERE Events.EventID = LIMIT 1