Query: SELECT `City`.`id`, `City`.`cityname` FROM `cities` AS `City` WHERE `City`.`status` = 1 ORDER BY `cityname` ASC
Refine your search