乒乓球赛事
3242 人气 36 参赛者 0 照片

快乐51周周赛六月第二周

苏州市 2019年06月16日-2019年06月16日

赛事编号  12305
全民皆乒

混合单打1100-1749积分赛

姓名 昵称 单位/学校名称 所在城市 积分 联系电话 来源
1 张良 张良888 昆山泓益电镀设备 苏州市 1461 158*****444 app
2 邓国锋 邓国锋 苏州市 1429 138*****095 pc
3 王均福 王均福 1500
188*****520 pc
4 田伟 田伟_0585 1474 186*****585 pc
5 顾荣根 顾荣根 苏州建华混凝土公司 苏州市 1478 138*****363 app
6 杨大康 杨大康 1510 139*****148 pc
7 任林 266993 苏州市 1526 139*****993 pc
8 陈昭庆 老陈sh 苏州市 1460 136*****526 app
9 陈冬冬 大宝T^T小宝 苏州市 1428 187*****510 pc
10 朱珠 13402665161 苏州市 1520 134*****161 pc

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

首页上一页1234末页

赛事动态

赛事组委会

组织者
方春晖
联系人:
方春晖 (15370755827)
主办方:
开发区乒协
(default) 34 queries took 85 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` = 20103 LIMIT 1113
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` = (20103) 222
3update games set focus = focus + 1 where id=12305114
4SELECT `SignStatisticsLog`.`user_id` FROM `hpp_game`.`sign_statistics_log` AS `SignStatisticsLog` WHERE `SignStatisticsLog`.`contest_id` = 20103992
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`.`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` = 318353 LIMIT 1112
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` = 20103 AND `Enrollment`.`participate_role` = 'player' AND `Enrollment`.`status` <> 'canceled' AND `Enrollment`.`status` = 'approve' AND `Enrollment`.`dtype` <> 'single_team' ORDER BY `Enrollment`.`created` asc LIMIT 1010104
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 (430242, 430284, 430392, 430402, 430439, 430441, 430442, 430444, 430449, 430450) 002
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` = 20103 AND `Enrollment`.`participate_role` = 'player' AND `Enrollment`.`status` <> 'canceled' AND `Enrollment`.`status` = 'approve' AND `Enrollment`.`dtype` <> 'single_team'113
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`.`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` = 1313005 LIMIT 1113
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` = 1313005 AND `UserRole`.`role_id` = `Role`.`id`) 002
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`.`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` = 1306203 LIMIT 1114
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` = 1306203 AND `UserRole`.`role_id` = `Role`.`id`) 002
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`.`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` = 1312355 LIMIT 1113
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` = 1312355 AND `UserRole`.`role_id` = `Role`.`id`) 002
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`.`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` = 1315571 LIMIT 1113
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` = 1315571 AND `UserRole`.`role_id` = `Role`.`id`) 002
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`.`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` = 1635 LIMIT 1113
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` = 1635 AND `UserRole`.`role_id` = `Role`.`id`) 002
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`.`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` = 1315506 LIMIT 1113
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` = 1315506 AND `UserRole`.`role_id` = `Role`.`id`) 002
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`.`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` = 1317354 LIMIT 1113
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` = 1317354 AND `UserRole`.`role_id` = `Role`.`id`) 002
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`.`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` = 1300811 LIMIT 1113
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` = 1300811 AND `UserRole`.`role_id` = `Role`.`id`) 002
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`.`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` = 542511 LIMIT 1113
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` = 542511 AND `UserRole`.`role_id` = `Role`.`id`) 002
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`.`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` = 559961 LIMIT 1113
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` = 559961 AND `UserRole`.`role_id` = `Role`.`id`) 002
29SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 12305 AND NOT (`status` = 'cancel')112
30SELECT `Contest`.`id`, `Contest`.`enroll_count` FROM `hpp_game`.`contests` AS `Contest` WHERE `Contest`.`game_id` = 12305 AND `Contest`.`status` <> 'cancel'112
31SELECT `PingpongContest`.`id`, `PingpongContest`.`mode` FROM `hpp_game`.`pingpong_contests` AS `PingpongContest` WHERE `PingpongContest`.`id` = (20103)112
32SELECT COUNT(*) AS `count` FROM `hpp_game`.`photos` AS `Photo` WHERE `Photo`.`type` = 2 AND `Photo`.`ex_type_id` = 12305112
33SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status`, `Contest`.`published` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 12305112
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` = 12305 ORDER BY `Photo`.`create_time` desc LIMIT 10002