COUNT(*) AS cities from `events` where (`publish` = 1 and `status` = 1) and