select Namespace, e.*, v.Name as VenueName, v.Address, v.City, v.Region, v.PostalCode, v.Country, v.Latitude, v.Longitude, v.Source as VenueSource, v.SourceURL as VenueSourceUrl, (select count(*) from tickets where EventID = e.EventID) as Tickets from data_events e inner join data_venues v on e.VenueID = v.VenueID inner join data_event_categories ec on e.EventID = ec.EventID where e.Status = 3 and Namespace in ('164.html') and StartTime > NOW() order by e.StartTime Limit 50