Notice (8): Undefined variable: topics [APP/Controller/Game/EnrollmentsController.php, line 159]
Warning (2): Invalid argument supplied for foreach() [APP/Controller/Game/EnrollmentsController.php, line 159]
【全民皆乒】2016中国体育彩票江西省乒协会员直通南昌积分大赛-景德镇分站赛参赛者信息【快乐乒乓网】
我的首页
聊吧
相册
帖子
赛事
视频
俱乐部
应用入口
首页
Notice (8): Use of undefined constant DAKA_DOMAIN - assumed 'DAKA_DOMAIN' [CORE/Cake/View/Elements/header_photo.ctp, line 48]DAKA_DOMAIN?n=my">签到中心
兑换中心
砸金蛋
乒乓球赛事
291587 人气 236 参赛者 0 照片

2016中国体育彩票江西省乒协会员直通南昌积分大赛-景德镇分站赛

2016年10月15日-2016年10月16日

赛事编号  6416
全民皆乒

初段组(混合单打800-999积分赛)

姓名 单位/学校名称 所在城市 积分 联系电话 缴费情况
1 吴家华 800
139*****431 无需缴费
2 汪欣文 904 133*****887 无需缴费
3 邵金凤 877 139*****649 无需缴费
4 周文波 916 135*****178 无需缴费
5 吴亚平 800
159*****910 无需缴费
6 巢继孙 800
131*****923 无需缴费
7 梁以宏 908 135*****089 无需缴费
8 陈健 800
139*****987 无需缴费
9 顾泽宏 800
182*****602 无需缴费
10 李志宣 800
189*****662 无需缴费

注:未激活表示该运动员未参加过积分赛,参加过一次积分赛后,积分自动激活。

首页上一页12345末页

赛事动态

赛事组委会

组织者
江西省乒协
联系人:
江西省乒协 (13907980032)
主办方:
江西省乒乓球协会
承办方:
景德镇市乒协
赞助商:
江西省体育彩票发行中心 新余市乒乓球协会 快乐乒乓网(www.horseguild.com) 河北银河体育用品有限公司
(default) 34 queries took 204 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT *, `Contest`.`id` FROM `hpp_game`.`contests` AS `Contest` LEFT JOIN `hpp_game`.`games` AS `Game` ON (`Contest`.`game_id` = `Game`.`id`) LEFT JOIN `hpp_game`.`pingpong_contests` AS `PingpongContest` ON (`PingpongContest`.`id` = `Contest`.`id`) WHERE `Contest`.`id` = 13715 LIMIT 1116
2SELECT `Rule`.`id`, `Rule`.`name`, `Rule`.`contest_id`, `Rule`.`type`, `Rule`.`description`, `Rule`.`expression`, `Rule`.`active`, `Rule`.`apply_to`, `Rule`.`params`, `Rule`.`render`, `Rule`.`options` FROM `hpp_game`.`rules` AS `Rule` WHERE `Rule`.`contest_id` = (13715) 226
3update games set focus = focus + 1 where id=6416116
4SELECT `SignStatisticsLog`.`user_id` FROM `hpp_game`.`sign_statistics_log` AS `SignStatisticsLog` WHERE `SignStatisticsLog`.`contest_id` = 13715226
5SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`open_id`, `Profile`.`open_name`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 325936 LIMIT 1116
6SELECT `Enrollment`.`id`, `Enrollment`.`user_id`, `Enrollment`.`contest_id`, `Enrollment`.`participate_role`, `Enrollment`.`status`, `Enrollment`.`created`, `Enrollment`.`group`, `Enrollment`.`is_seed`, `Enrollment`.`serial`, `Enrollment`.`credit`, `Enrollment`.`remark`, `Enrollment`.`dtype2`, `Enrollment`.`colony_id`, `Enrollment`.`colony_name`, `Enrollment`.`colony_no`, `Enrollment`.`serial1`, `Enrollment`.`serial2`, `Enrollment`.`group1`, `Enrollment`.`group2`, `Enrollment`.`realname`, `Enrollment`.`contact`, `Enrollment`.`company`, `Enrollment`.`gender`, `Enrollment`.`member_no`, `Enrollment`.`card`, `Enrollment`.`dtype`, `Enrollment`.`email`, `Enrollment`.`avatar`, `Enrollment`.`city`, `Enrollment`.`club_id`, `Enrollment`.`credit_is_active`, `Enrollment`.`leader_user_id`, `Enrollment`.`leader_user`, `Enrollment`.`nickname`, `Enrollment`.`ip`, `Enrollment`.`enroll_cost`, `Enrollment`.`payment_type`, `Enrollment`.`trade_no`, `Enrollment`.`pay_time`, `Enrollment`.`enroll_type` FROM `hpp_game`.`enrollments` AS `Enrollment` INNER JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `Enrollment`.`user_id`) WHERE `Enrollment`.`contest_id` = 13715 AND `Enrollment`.`participate_role` = 'player' AND `Enrollment`.`status` <> 'canceled' AND `Enrollment`.`status` = 'approve' AND `Enrollment`.`dtype` <> 'single_team' ORDER BY `Enrollment`.`created` asc LIMIT 1010106
7SELECT `TeamEnrollment`.`id`, `TeamEnrollment`.`enrollment_id`, `TeamEnrollment`.`user_id`, `TeamEnrollment`.`credit`, `TeamEnrollment`.`realname`, `TeamEnrollment`.`contact`, `TeamEnrollment`.`company`, `TeamEnrollment`.`gender`, `TeamEnrollment`.`card`, `TeamEnrollment`.`participate_role`, `TeamEnrollment`.`status`, `TeamEnrollment`.`email`, `TeamEnrollment`.`avatar`, `TeamEnrollment`.`credit_is_active`, `TeamEnrollment`.`nickname` FROM `hpp_game`.`team_enrollments` AS `TeamEnrollment` WHERE `TeamEnrollment`.`enrollment_id` IN (346777, 348471, 348753, 349345, 350370, 350433, 357318, 358920, 358921, 358922) 006
8SELECT COUNT(*) AS `count` FROM `hpp_game`.`enrollments` AS `Enrollment` INNER JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `Enrollment`.`user_id`) WHERE `Enrollment`.`contest_id` = 13715 AND `Enrollment`.`participate_role` = 'player' AND `Enrollment`.`status` <> 'canceled' AND `Enrollment`.`status` = 'approve' AND `Enrollment`.`dtype` <> 'single_team'116
9SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`open_id`, `Profile`.`open_name`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish`, `Credit`.`id`, `Credit`.`user_id`, `Credit`.`sport_id`, `Credit`.`amount`, `Credit`.`is_active`, `Credit`.`last_self_testing`, `Credit`.`active_question_count`, `Credit`.`last_amount`, `Credit`.`operator_id`, `Credit`.`fc`, `Credit`.`master_point` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `hpp_game`.`credits` AS `Credit` ON (`Credit`.`user_id` = `User`.`id` AND `Credit`.`sport_id` = 1) WHERE `User`.`id` = 1263464 LIMIT 1116
10SELECT *, `UserRole`.`id`, `UserRole`.`user_id`, `UserRole`.`role_id`, `UserRole`.`note`, `UserRole`.`created`, `UserRole`.`modified`, `UserRole`.`type` FROM `hpp_game`.`roles` AS `Role` JOIN `hpp_game`.`users_roles` AS `UserRole` ON (`UserRole`.`user_id` = 1263464 AND `UserRole`.`role_id` = `Role`.`id`) 006
11SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`open_id`, `Profile`.`open_name`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish`, `Credit`.`id`, `Credit`.`user_id`, `Credit`.`sport_id`, `Credit`.`amount`, `Credit`.`is_active`, `Credit`.`last_self_testing`, `Credit`.`active_question_count`, `Credit`.`last_amount`, `Credit`.`operator_id`, `Credit`.`fc`, `Credit`.`master_point` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `hpp_game`.`credits` AS `Credit` ON (`Credit`.`user_id` = `User`.`id` AND `Credit`.`sport_id` = 1) WHERE `User`.`id` = 1064912 LIMIT 1116
12SELECT *, `UserRole`.`id`, `UserRole`.`user_id`, `UserRole`.`role_id`, `UserRole`.`note`, `UserRole`.`created`, `UserRole`.`modified`, `UserRole`.`type` FROM `hpp_game`.`roles` AS `Role` JOIN `hpp_game`.`users_roles` AS `UserRole` ON (`UserRole`.`user_id` = 1064912 AND `UserRole`.`role_id` = `Role`.`id`) 006
13SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`open_id`, `Profile`.`open_name`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish`, `Credit`.`id`, `Credit`.`user_id`, `Credit`.`sport_id`, `Credit`.`amount`, `Credit`.`is_active`, `Credit`.`last_self_testing`, `Credit`.`active_question_count`, `Credit`.`last_amount`, `Credit`.`operator_id`, `Credit`.`fc`, `Credit`.`master_point` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `hpp_game`.`credits` AS `Credit` ON (`Credit`.`user_id` = `User`.`id` AND `Credit`.`sport_id` = 1) WHERE `User`.`id` = 1064916 LIMIT 1116
14SELECT *, `UserRole`.`id`, `UserRole`.`user_id`, `UserRole`.`role_id`, `UserRole`.`note`, `UserRole`.`created`, `UserRole`.`modified`, `UserRole`.`type` FROM `hpp_game`.`roles` AS `Role` JOIN `hpp_game`.`users_roles` AS `UserRole` ON (`UserRole`.`user_id` = 1064916 AND `UserRole`.`role_id` = `Role`.`id`) 006
15SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`open_id`, `Profile`.`open_name`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish`, `Credit`.`id`, `Credit`.`user_id`, `Credit`.`sport_id`, `Credit`.`amount`, `Credit`.`is_active`, `Credit`.`last_self_testing`, `Credit`.`active_question_count`, `Credit`.`last_amount`, `Credit`.`operator_id`, `Credit`.`fc`, `Credit`.`master_point` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `hpp_game`.`credits` AS `Credit` ON (`Credit`.`user_id` = `User`.`id` AND `Credit`.`sport_id` = 1) WHERE `User`.`id` = 1064955 LIMIT 1116
16SELECT *, `UserRole`.`id`, `UserRole`.`user_id`, `UserRole`.`role_id`, `UserRole`.`note`, `UserRole`.`created`, `UserRole`.`modified`, `UserRole`.`type` FROM `hpp_game`.`roles` AS `Role` JOIN `hpp_game`.`users_roles` AS `UserRole` ON (`UserRole`.`user_id` = 1064955 AND `UserRole`.`role_id` = `Role`.`id`) 006
17SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`open_id`, `Profile`.`open_name`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish`, `Credit`.`id`, `Credit`.`user_id`, `Credit`.`sport_id`, `Credit`.`amount`, `Credit`.`is_active`, `Credit`.`last_self_testing`, `Credit`.`active_question_count`, `Credit`.`last_amount`, `Credit`.`operator_id`, `Credit`.`fc`, `Credit`.`master_point` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `hpp_game`.`credits` AS `Credit` ON (`Credit`.`user_id` = `User`.`id` AND `Credit`.`sport_id` = 1) WHERE `User`.`id` = 1264740 LIMIT 1116
18SELECT *, `UserRole`.`id`, `UserRole`.`user_id`, `UserRole`.`role_id`, `UserRole`.`note`, `UserRole`.`created`, `UserRole`.`modified`, `UserRole`.`type` FROM `hpp_game`.`roles` AS `Role` JOIN `hpp_game`.`users_roles` AS `UserRole` ON (`UserRole`.`user_id` = 1264740 AND `UserRole`.`role_id` = `Role`.`id`) 006
19SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`open_id`, `Profile`.`open_name`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish`, `Credit`.`id`, `Credit`.`user_id`, `Credit`.`sport_id`, `Credit`.`amount`, `Credit`.`is_active`, `Credit`.`last_self_testing`, `Credit`.`active_question_count`, `Credit`.`last_amount`, `Credit`.`operator_id`, `Credit`.`fc`, `Credit`.`master_point` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `hpp_game`.`credits` AS `Credit` ON (`Credit`.`user_id` = `User`.`id` AND `Credit`.`sport_id` = 1) WHERE `User`.`id` = 1266706 LIMIT 1116
20SELECT *, `UserRole`.`id`, `UserRole`.`user_id`, `UserRole`.`role_id`, `UserRole`.`note`, `UserRole`.`created`, `UserRole`.`modified`, `UserRole`.`type` FROM `hpp_game`.`roles` AS `Role` JOIN `hpp_game`.`users_roles` AS `UserRole` ON (`UserRole`.`user_id` = 1266706 AND `UserRole`.`role_id` = `Role`.`id`) 006
21SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`open_id`, `Profile`.`open_name`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish`, `Credit`.`id`, `Credit`.`user_id`, `Credit`.`sport_id`, `Credit`.`amount`, `Credit`.`is_active`, `Credit`.`last_self_testing`, `Credit`.`active_question_count`, `Credit`.`last_amount`, `Credit`.`operator_id`, `Credit`.`fc`, `Credit`.`master_point` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `hpp_game`.`credits` AS `Credit` ON (`Credit`.`user_id` = `User`.`id` AND `Credit`.`sport_id` = 1) WHERE `User`.`id` = 253161 LIMIT 1116
22SELECT *, `UserRole`.`id`, `UserRole`.`user_id`, `UserRole`.`role_id`, `UserRole`.`note`, `UserRole`.`created`, `UserRole`.`modified`, `UserRole`.`type` FROM `hpp_game`.`roles` AS `Role` JOIN `hpp_game`.`users_roles` AS `UserRole` ON (`UserRole`.`user_id` = 253161 AND `UserRole`.`role_id` = `Role`.`id`) 006
23SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`open_id`, `Profile`.`open_name`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish`, `Credit`.`id`, `Credit`.`user_id`, `Credit`.`sport_id`, `Credit`.`amount`, `Credit`.`is_active`, `Credit`.`last_self_testing`, `Credit`.`active_question_count`, `Credit`.`last_amount`, `Credit`.`operator_id`, `Credit`.`fc`, `Credit`.`master_point` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `hpp_game`.`credits` AS `Credit` ON (`Credit`.`user_id` = `User`.`id` AND `Credit`.`sport_id` = 1) WHERE `User`.`id` = 1274077 LIMIT 1116
24SELECT *, `UserRole`.`id`, `UserRole`.`user_id`, `UserRole`.`role_id`, `UserRole`.`note`, `UserRole`.`created`, `UserRole`.`modified`, `UserRole`.`type` FROM `hpp_game`.`roles` AS `Role` JOIN `hpp_game`.`users_roles` AS `UserRole` ON (`UserRole`.`user_id` = 1274077 AND `UserRole`.`role_id` = `Role`.`id`) 006
25SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`open_id`, `Profile`.`open_name`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish`, `Credit`.`id`, `Credit`.`user_id`, `Credit`.`sport_id`, `Credit`.`amount`, `Credit`.`is_active`, `Credit`.`last_self_testing`, `Credit`.`active_question_count`, `Credit`.`last_amount`, `Credit`.`operator_id`, `Credit`.`fc`, `Credit`.`master_point` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `hpp_game`.`credits` AS `Credit` ON (`Credit`.`user_id` = `User`.`id` AND `Credit`.`sport_id` = 1) WHERE `User`.`id` = 1274078 LIMIT 1116
26SELECT *, `UserRole`.`id`, `UserRole`.`user_id`, `UserRole`.`role_id`, `UserRole`.`note`, `UserRole`.`created`, `UserRole`.`modified`, `UserRole`.`type` FROM `hpp_game`.`roles` AS `Role` JOIN `hpp_game`.`users_roles` AS `UserRole` ON (`UserRole`.`user_id` = 1274078 AND `UserRole`.`role_id` = `Role`.`id`) 006
27SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`open_id`, `Profile`.`open_name`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish`, `Credit`.`id`, `Credit`.`user_id`, `Credit`.`sport_id`, `Credit`.`amount`, `Credit`.`is_active`, `Credit`.`last_self_testing`, `Credit`.`active_question_count`, `Credit`.`last_amount`, `Credit`.`operator_id`, `Credit`.`fc`, `Credit`.`master_point` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `hpp_game`.`credits` AS `Credit` ON (`Credit`.`user_id` = `User`.`id` AND `Credit`.`sport_id` = 1) WHERE `User`.`id` = 1274079 LIMIT 1116
28SELECT *, `UserRole`.`id`, `UserRole`.`user_id`, `UserRole`.`role_id`, `UserRole`.`note`, `UserRole`.`created`, `UserRole`.`modified`, `UserRole`.`type` FROM `hpp_game`.`roles` AS `Role` JOIN `hpp_game`.`users_roles` AS `UserRole` ON (`UserRole`.`user_id` = 1274079 AND `UserRole`.`role_id` = `Role`.`id`) 006
29SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 6416 AND NOT (`status` = 'cancel')776
30SELECT `Contest`.`id`, `Contest`.`enroll_count` FROM `hpp_game`.`contests` AS `Contest` WHERE `Contest`.`game_id` = 6416 AND `Contest`.`status` <> 'cancel'776
31SELECT `PingpongContest`.`id`, `PingpongContest`.`mode` FROM `hpp_game`.`pingpong_contests` AS `PingpongContest` WHERE `PingpongContest`.`id` IN (13715, 13716, 13717, 13718, 13719, 13720, 13721)776
32SELECT COUNT(*) AS `count` FROM `hpp_game`.`photos` AS `Photo` WHERE `Photo`.`type` = 2 AND `Photo`.`ex_type_id` = 6416116
33SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status`, `Contest`.`published` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 6416776
34SELECT `Photo`.`id`, `Photo`.`user_id`, `Photo`.`type_id`, `Photo`.`ex_type_id`, `Photo`.`type`, `Photo`.`url`, `Photo`.`create_time`, `Photo`.`description` FROM `hpp_game`.`photos` AS `Photo` WHERE `Photo`.`type` = 2 AND `Photo`.`ex_type_id` = 6416 ORDER BY `Photo`.`create_time` desc LIMIT 10006