we need a separate index here to support V3 queries:
KEY by_city_id ( `city_id`, `hub_date`, `module_id` )