乒乓球赛事
1078 人气 13 参赛者 0 照片

2019.9.22快乐乒乓网青岛国亮乒乓球积分赛

青岛市 2019年09月22日-2019年09月22日

赛事编号  12467
全民皆乒

混合单打0-不限积分赛

姓名 昵称 单位/学校名称 所在城市 积分 联系电话 来源
1 安宁 安宁88 哈尔滨市 1483 133*****855 pc
2 侯晓峰 我和乒乓有个约会 金陵石化 南京市 1603 138*****801 app
3 曹中林 WX_曹中林 青岛市 1468 159*****848 pc
4 孙树峰 孙树峰 青岛市 1544 137*****407 pc
5 雪歌 雪歌 青岛市 1576 136*****555 app
6 吴爱芹 吴爱芹 青岛市 1464 137*****367 pc
7 黄在平 沃伦·巴赫蓝 中国石化股份有限公司 青岛市 1587 138*****632 app
8 张子夜 点心 青岛市 1484 184*****502 pc
9 姜永华 天天好心情 青岛市 1478 137*****555 app
10 杜泉 杜泉 青岛市 1564 135*****675 pc

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

首页上一页12末页

赛事动态

赛事组委会

组织者
侯晓峰
联系人:
雪歌 (13697671555)
主办方:
青岛国亮俱乐部
(default) 34 queries took 81 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` = 20286 LIMIT 1112
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` = (20286) 222
3update games set focus = focus + 1 where id=12467113
4SELECT `SignStatisticsLog`.`user_id` FROM `hpp_game`.`sign_statistics_log` AS `SignStatisticsLog` WHERE `SignStatisticsLog`.`contest_id` = 20286662
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` = 121400 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` = 20286 AND `Enrollment`.`participate_role` = 'player' AND `Enrollment`.`status` <> 'canceled' AND `Enrollment`.`status` = 'approve' AND `Enrollment`.`dtype` <> 'single_team' ORDER BY `Profile`.`city` asc 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 (433876, 433850, 433870, 433880, 433875, 433853, 433871, 433877, 433881, 433879) 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` = 20286 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` = 1309266 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` = 1309266 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` = 121400 LIMIT 1112
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` = 121400 AND `UserRole`.`role_id` = `Role`.`id`) 112
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` = 1307657 LIMIT 1114
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` = 1307657 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` = 1304544 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` = 1304544 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` = 1293213 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` = 1293213 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` = 1290395 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` = 1290395 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` = 1311680 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` = 1311680 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` = 1283174 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` = 1283174 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` = 1306359 LIMIT 1112
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` = 1306359 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` = 1301876 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` = 1301876 AND `UserRole`.`role_id` = `Role`.`id`) 002
29SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 12467 AND NOT (`status` = 'cancel')112
30SELECT `Contest`.`id`, `Contest`.`enroll_count` FROM `hpp_game`.`contests` AS `Contest` WHERE `Contest`.`game_id` = 12467 AND `Contest`.`status` <> 'cancel'112
31SELECT `PingpongContest`.`id`, `PingpongContest`.`mode` FROM `hpp_game`.`pingpong_contests` AS `PingpongContest` WHERE `PingpongContest`.`id` = (20286)112
32SELECT COUNT(*) AS `count` FROM `hpp_game`.`photos` AS `Photo` WHERE `Photo`.`type` = 2 AND `Photo`.`ex_type_id` = 12467112
33SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status`, `Contest`.`published` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 12467112
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` = 12467 ORDER BY `Photo`.`create_time` desc LIMIT 10002