乒乓球赛事
2118 人气 31 参赛者 0 照片

苏州全爱体育“美格尔橄榄油杯”第十三届快乐乒乓网单打积分赛

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

赛事编号  12282
全民皆乒

混合单打0-1799积分赛

姓名 昵称 单位/学校名称 所在城市 积分 联系电话 来源
1 徐国华 徐国华2 苏州华鸿纺织配件有限公司 苏州市 1500 137*****885 pc
2 俞峰 俞峰 苏州松下系统科技有限公司 苏州市 1320 139*****980 pc
3 陈宸 陈宸(小陈) 江苏省电影家协会 苏州市 1584 186*****861 pc
4 王令 王令 苏州运管处 苏州市 1156 189*****621 pc
5 邬战飞 独自等待 苏州市 1275 188*****783 pc
6 孙鸿建 孙鸿建 苏州宏丰物业管理有限公司 苏州市 1498 131*****118 app
7 王成刚 wcheng121@sina.com 苏州市 1254 136*****107 app
8 王正浩 gameboy 苏州市 1274 155*****966 pc
9 吴军 QQ_小吴 泰兴华泰驾校 泰州市 1606 158*****931 pc
10 田超 博得鸟 苏州市 1191 186*****196 pc

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

首页上一页123末页

赛事动态

赛事组委会

组织者
徐锋
联系人:
徐锋 (15962616296)
主办方:
全爱体育
协办方:
爱动俱乐部
承办方:
爱动乒乓馆
赞助商:
美格尔橄榄油
(default) 34 queries took 80 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` = 20066 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` = (20066) 222
3update games set focus = focus + 1 where id=12282114
4SELECT `SignStatisticsLog`.`user_id` FROM `hpp_game`.`sign_statistics_log` AS `SignStatisticsLog` WHERE `SignStatisticsLog`.`contest_id` = 2006613132
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` = 1304356 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` = 20066 AND `Enrollment`.`participate_role` = 'player' AND `Enrollment`.`status` <> 'canceled' AND `Enrollment`.`status` = 'approve' AND `Enrollment`.`dtype` <> 'single_team' LIMIT 1010103
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 (430143, 429824, 429821, 430808, 430910, 430899, 431015, 429823, 431048, 429822) 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` = 20066 AND `Enrollment`.`participate_role` = 'player' AND `Enrollment`.`status` <> 'canceled' AND `Enrollment`.`status` = 'approve' AND `Enrollment`.`dtype` <> 'single_team'112
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` = 1139 LIMIT 1112
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` = 1139 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` = 1644 LIMIT 1113
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` = 1644 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` = 2121 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` = 2121 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` = 2722 LIMIT 1112
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` = 2722 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` = 3743 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` = 3743 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` = 3944 LIMIT 1112
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` = 3944 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` = 4753 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` = 4753 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` = 81788 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` = 81788 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` = 124624 LIMIT 1114
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` = 124624 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` = 231478 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` = 231478 AND `UserRole`.`role_id` = `Role`.`id`) 002
29SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 12282 AND NOT (`status` = 'cancel')222
30SELECT `Contest`.`id`, `Contest`.`enroll_count` FROM `hpp_game`.`contests` AS `Contest` WHERE `Contest`.`game_id` = 12282 AND `Contest`.`status` <> 'cancel'222
31SELECT `PingpongContest`.`id`, `PingpongContest`.`mode` FROM `hpp_game`.`pingpong_contests` AS `PingpongContest` WHERE `PingpongContest`.`id` IN (20066, 20124)222
32SELECT COUNT(*) AS `count` FROM `hpp_game`.`photos` AS `Photo` WHERE `Photo`.`type` = 2 AND `Photo`.`ex_type_id` = 12282112
33SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status`, `Contest`.`published` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 12282222
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` = 12282 ORDER BY `Photo`.`create_time` desc LIMIT 10002