[#33] refactored by_city scope with sql join