SELECT events.*,
       venues.vName,
       venues.regionId,
       venues_data.url,
       venues_data.nsurl,
       venues_data.latitude,
       venues_data.longitude,
       venues.timezone,
       IF(
               events_performers.master = 1,
               events_performers.performerId,
               (SELECT performerId FROM events_performers WHERE eventId = events.eventId AND master = 1)
           ) AS masterPerformerId
FROM venues,
     venues_data,
     events,
     events_performers
WHERE serverTime > DATE_ADD(NOW(), INTERVAL 0 HOUR)
  AND events.venueId = venues.venueId
  AND venues.venueId = venues_data.venueId
  AND events.eventId = events_performers.eventId
  AND events.isHidden = 0
  AND venues_data.isRemoved = 0
  AND events_performers.master = 1
  AND venues.regionId = '7'
  AND eventType = 'CONCERT'
  AND YEARWEEK(events.eventDateTime, 1) = YEARWEEK(CURDATE(), 1)
ORDER BY events.ticketCount DESC, serverTime
LIMIT 1