Query: SELECT `Consumer`.`id`, `Consumer`.`username`, `Consumer`.`password`, `Consumer`.`first_name`, `Consumer`.`middle_name`, `Consumer`.`last_name`, `Consumer`.`gender`, `Consumer`.`carrier`, `Consumer`.`cellphonenumber`, `Consumer`.`email`, `Consumer`.`birthday`, `Consumer`.`marriage`, `Consumer`.`children`, `Consumer`.`education`, `Consumer`.`occupation`, `Consumer`.`addresstype`, `Consumer`.`address`, `Consumer`.`state`, `Consumer`.`state_full`, `Consumer`.`city_id`, `Consumer`.`city_name`, `Consumer`.`zipcode`, `Consumer`.`country`, `Consumer`.`created`, `Consumer`.`modified`, `Consumer`.`introduction`, `Consumer`.`avatar` FROM `consumers` AS `Consumer` WHERE `Consumer`.`city_id` = LIMIT 0, 10
MOBOUP - : profile, store directory, newsletter, coupons and sales from mall retailers.
