SELECT eventID, eventTitle, occurence, eventDate, startTime, endTime, eventLocation, eventDetails, mapLink, acceptRSVPs, rsvpDeadline, firstname, surname, preferredNumber, mobileNumber, homePhoneValue, businessNumber, faxNumber, eventContact, eventContactPhone, eventContactEmail FROM events LEFT JOIN event_dates ON event_dates.eventIDLookup=events.eventID LEFT JOIN event_recurring_details ON event_recurring_details.eventIDLookup=events.eventID LEFT JOIN members ON events.eventContact=members.memberID LEFT JOIN member_home_phone ON member_home_phone.homePhoneID=members.homePhoneLookup WHERE events.clientID=12 AND event_dates.recordKey='YC8LJJAOVHI8E209YIKQO9HGP4KAJB5M07C05JFORSB11JR1U0EJBW3ZOHCE6F9C'