select `cities`.`id` as `cityRowId`, `cities`.`name` as `cityName`, `cities`.`slug` as `citySlug` from `cities` innerjoin `vendor_package_cities` on `cities`.`id` = `vendor_package_cities`.`city_id` groupby `vendor_package_cities`.`city_id` orderby `cities`.`name` asc
select `cities`.`id` as `cityRowId`, `cities`.`name` as `cityName`, `cities`.`slug` as `citySlug` from `cities` innerjoin `vendor_package_cities` on `cities`.`id` = `vendor_package_cities`.`city_id` groupby `vendor_package_cities`.`city_id` orderby `cities`.`name` asc