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