http://www.smartdatinguk.comen-gbSpeed dating, singles events, singles parties, singles holidaysSQLchkV = SELECT tblAdvertiserEvents.AdvertiserEventPKID, tblEventTypes.EventName, tblEventTypes.EventTypeEventDetailsPage, tblAdvertiserEvents.AdvertiserEventPrice, tblAdvertiserEvents.AdvertiserEventFemaleAgeRange, tblAdvertiserEvents.AdvertiserEventMaleAgeRange, tblAdvertiserEvents.AdvertiserEventDetailsURL, tblAdvertiserEvents.AdvertiserEventDescription, tblAdvertiserEvents.AdvertiserEventStartDate, tblAdvertiserEvents.AdvertiserEventEndDate, tblvenueregions.RegionName, tblAdvertiserEvents.AdvertiserEventVenueName, tblAdvertiserEvents.AdvertiserEventVenueAddress, tblAdvertiserEvents.AdvertiserEventTime, tblAdvertiserEvents.AdvertiserEventTitle, tblAdvertiserEvents.AdvertiserEventIsFeedData, tblEventAdvertisers.EventAdvertiserCompany, tblEventAdvertisers.EventAdvertiserPassToFrameset, bd.FeedDetailsSendToPageURL, tblAdvertiserEvents.AdvertiserEventAdvertiserFKID, tblAdvertiserEvents.AdvertiserEventPostcode FROM tblAdvertiserEvents INNER JOIN tblEventTypes ON tblAdvertiserEvents.AdvertiserEventTypeFKID = tblEventTypes.EventTypePKID INNER JOIN tblEventAdvertisers ON tblAdvertiserEvents.AdvertiserEventAdvertiserFKID = tblEventAdvertisers.EventAdvertiserPKID INNER JOIN tblvenueregions ON tblAdvertiserEvents.AdvertiserEventNearestCityFKID = tblvenueregions.ID LEFT OUTER JOIN (SELECT DISTINCT (FeedDetailsEventAdvertiserFKID), FeedDetailsSendToPageURL FROM tblFeedDetails) bd ON tblAdvertiserEvents.AdvertiserEventAdvertiserFKID = bd.FeedDetailsEventAdvertiserFKID WHERE (tblAdvertiserEvents.AdvertiserEventStatusFKID = 4) AND (tblvenueregions.RegionName = 'Newcastle') AND (tblAdvertiserEvents.AdvertiserEventTypeFKID = 1) ORDER BY tblAdvertiserEvents.AdvertiserEventStartDatehttp://www.smartdatinguk.com/speed-dating/newcastle/ditch-or-date-event-740628.asp20GBP2010-09-15Newcastle38-49NE1 6AEDitch or Date740628http://www.smartdatinguk.com/speed-dating/newcastle/ditch-or-date-event-742430.asp20GBP2010-09-22Newcastle22-34NE1 6AEDitch or Date742430http://www.smartdatinguk.com/speed-dating/newcastle/speed-dater-event-739161.asp19.95GBP2010-09-30Newcastle24-38NE1 5RESpeed Dater739161http://www.smartdatinguk.com/speed-dating/newcastle/slow-dating-event-741759.asp22GBP2010-09-30Newcastle28-38NE1 5RESlow Dating741759http://www.smartdatinguk.com/speed-dating/newcastle/slow-dating-event-742985.asp22GBP2010-10-21Newcastle23-34NE1 5RESlow Dating742985http://www.smartdatinguk.com/speed-dating/newcastle/speed-dater-event-742422.asp19.95GBP2010-11-11Newcastle24-38NE1 5RESpeed Dater742422