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

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

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

赛事编号  12282
全民皆乒
第 1 组  共 7 人(共 4 组)
赛程安排
赛程安排
对弈 日期 时间 台号
2-7
3-6
4-5
1-7
2-5
3-4
1-6
7-5
2-3
1-5
6-4
7-3
1-4
5-3
6-2
1-3
4-2
6-7
1-2
4-7
5-6
序号 姓名
1 胡宁 ( 1500 )
2 俞峰 ( 1320 )
3 吴军 ( 1606 )
4 徐国华 ( 1500 )
5 宋起飞 ( 1500 )
6 王瑞南 ( 1162 )
7 王令 ( 1156 )
1234567
弃权w-o:3 弃权w-o:3 弃权w-o:3 弃权w-o:3 弃权w-o:3 弃权w-o:3
3:w-o 弃权w-o:3 弃权w-o:3 弃权w-o:3 弃权w-o:3 弃权w-o:3
3:w-o 3:w-o 3:w-o 3:1 3:0 3:0
3:w-o 3:w-o 弃权w-o:3 弃权w-o:3 弃权w-o:3 弃权w-o:3
3:w-o 3:w-o 1:3 3:w-o 3:0 3:0
3:w-o 3:w-o 0:3 3:w-o 0:3 3:2
3:w-o 3:w-o 0:3 3:w-o 0:3 2:3
组内得分 小组名次
0分

0/6

7
2分

1/5

6
12分

6/0

1
4分

2/4

5
11分

5/1

2
10分

4/2

3
9分

3/3

4
第 2 组  共 6 人(共 4 组)
赛程安排
赛程安排
对弈 日期 时间 台号
1-6
2-5
3-4
1-5
6-4
2-3
1-4
5-3
6-2
1-3
4-2
5-6
1-2
3-6
4-5
序号 姓名
1 张欢 ( 1500 )
2 冯全安 ( 1321 )
3 陈宸 ( 1584 )
4 王司令 ( 1500 )
5 孙鸿建 ( 1498 )
6 田超 ( 1191 )
123456
弃权w-o:3 弃权w-o:3 弃权w-o:3 弃权w-o:3 弃权w-o:3
3:w-o 弃权w-o:3 弃权w-o:3 弃权w-o:3 弃权w-o:3
3:w-o 3:w-o 3:0 3:2 3:1
3:w-o 3:w-o 0:3 0:3 0:3
3:w-o 3:w-o 2:3 3:0 3:0
3:w-o 3:w-o 1:3 3:0 0:3
组内得分 小组名次
0分

0/5

6
2分

1/4

5
10分

5/0

1
7分

2/3

4
9分

4/1

2
8分

3/2

3
第 3 组  共 6 人(共 4 组)
赛程安排
赛程安排
对弈 日期 时间 台号
1-6
2-5
3-4
1-5
6-4
2-3
1-4
5-3
6-2
1-3
4-2
5-6
1-2
3-6
4-5
序号 姓名
1 撼地者 ( 1500 )
2 张琳 ( 1445 )
3 马俊 ( 1566 )
4 胡超 ( 1502 )
5 朱方华 ( 1494 )
6 王成刚 ( 1254 )
123456
弃权w-o:3 弃权w-o:3 弃权w-o:3 弃权w-o:3 弃权w-o:3
3:w-o 弃权w-o:3 弃权w-o:3 弃权w-o:3 弃权w-o:3
3:w-o 3:w-o 3:0 3:1 3:2
3:w-o 3:w-o 0:3 3:2 3:1
3:w-o 3:w-o 1:3 2:3 3:0
3:w-o 3:w-o 2:3 1:3 0:3
组内得分 小组名次
0分

0/5

6
2分

1/4

5
10分

5/0

1
9分

4/1

2
8分

3/2

3
7分

2/3

4
第 4 组  共 6 人(共 4 组)
赛程安排
赛程安排
对弈 日期 时间 台号
1-6
2-5
3-4
1-5
6-4
2-3
1-4
5-3
6-2
1-3
4-2
5-6
1-2
3-6
4-5
序号 姓名
1 黑舟 ( 1500 )
2 谢鸣云 ( 1449 )
3 韩夏 ( 1529 )
4 徐锋 ( 1509 )
5 邬战飞 ( 1275 )
6 王正浩 ( 1274 )
123456
弃权w-o:3 弃权w-o:3 弃权w-o:3 弃权w-o:3 弃权w-o:3
3:w-o 弃权w-o:3 弃权w-o:3 弃权w-o:3 弃权w-o:3
3:w-o 3:w-o 2:3 3:0 3:2
3:w-o 3:w-o 3:2 3:0 2:3
3:w-o 3:w-o 0:3 0:3 3:1
3:w-o 3:w-o 2:3 3:2 1:3
组内得分 小组名次
0分

0/5

6
2分

1/4

5
9分

4/1

0/1

2
9分

4/1

1/0

1
8分

3/2

1/0

3
8分

3/2

0/1

4

积分变化
VS

积分变化
(default) 18 queries took 137 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 `Stage`.`id`, `Stage`.`contest_id`, `Stage`.`scheme`, `Stage`.`serial`, `Stage`.`label`, `Stage`.`start_date`, `Stage`.`end_date`, `Stage`.`start_contest_round`, `Stage`.`end_contest_round`, `Stage`.`is_draw`, `Stage`.`is_group`, `Stage`.`has_pre_level`, `Stage`.`is_ranked_circle`, `Stage`.`default_match_minutes`, `Stage`.`scheduled_group` FROM `hpp_game`.`stages` AS `Stage` WHERE `Stage`.`contest_id` = (20066) ORDER BY `Stage`.`serial` ASC 223
3update games set focus = focus + 1 where id=12282114
4SELECT `Group`.`id`, `Group`.`stage_id`, `Group`.`serial`, `Group`.`grade`, `Group`.`size`, `Group`.`total`, `Group`.`is_set_seed`, `Group`.`is_draw`, `Group`.`rank`, `Group`.`scheme`, `Group`.`circle`, `Group`.`seed_method`, `Group`.`label`, `Group`.`base_rank`, `Group`.`has_pre_level`, `Group`.`scheduled_round`, `Group`.`match_rounds`, `Group`.`mode`, `Group`.`team_scheme`, `Group`.`serial_in_grade` FROM `hpp_game`.`groups` AS `Group` WHERE `stage_id` = 36505 ORDER BY `Group`.`stage_id` asc, `Group`.`serial` asc443
5SELECT `Match`.`id`, `Match`.`number`, `Match`.`contest_id`, `Match`.`venue_id`, `Match`.`status`, `Match`.`scheduled_start_date`, `Match`.`opponent1_id`, `Match`.`opponent2_id`, `Match`.`referee1_id`, `Match`.`referee2_id`, `Match`.`referee3_id`, `Match`.`scheduled_end_date`, `Match`.`group`, `Match`.`group_round`, `Match`.`type`, `Match`.`stage`, `Match`.`label`, `Match`.`placeholder1`, `Match`.`placeholder2`, `Match`.`contest_round`, `Match`.`addition_level`, `Match`.`weight`, `Match`.`dtype`, `Match`.`credit_detail_id`, `Match`.`parent_id`, `Match`.`team_round`, `Match`.`grade`, `Match`.`rounds`, `Match`.`placeholder1_ori`, `Match`.`placeholder2_ori`, `Match`.`home`, `Match`.`opponent1_partner_id`, `Match`.`opponent2_partner_id`, `Match`.`project`, `Match`.`mtype`, `Opponent1`.`id`, `Opponent1`.`user_id`, `Opponent1`.`contest_id`, `Opponent1`.`fullname`, `Opponent1`.`number`, `Opponent1`.`gender`, `Opponent1`.`contact`, `Opponent1`.`company`, `Opponent1`.`card`, `Opponent1`.`dtype`, `Opponent1`.`colony_id`, `Opponent1`.`colony_name`, `Opponent1`.`colony_no`, `Opponent1`.`remark`, `Opponent1`.`parent_id`, `Opponent1`.`is_giveup`, `Opponent1`.`score`, `Opponent1`.`weight`, `Opponent1`.`rank`, `Opponent1`.`credit`, `Opponent1`.`email`, `Opponent1`.`avatar`, `Opponent1`.`username`, `Opponent1`.`enroll_ranking`, `Opponent1`.`created`, `Opponent1`.`assign`, `Opponent1`.`final_credit`, `Opponent1`.`club_id`, `Opponent1`.`credit_is_active`, `Opponent1`.`nickname`, `Opponent1`.`is_single_team`, `Opponent2`.`id`, `Opponent2`.`user_id`, `Opponent2`.`contest_id`, `Opponent2`.`fullname`, `Opponent2`.`number`, `Opponent2`.`gender`, `Opponent2`.`contact`, `Opponent2`.`company`, `Opponent2`.`card`, `Opponent2`.`dtype`, `Opponent2`.`colony_id`, `Opponent2`.`colony_name`, `Opponent2`.`colony_no`, `Opponent2`.`remark`, `Opponent2`.`parent_id`, `Opponent2`.`is_giveup`, `Opponent2`.`score`, `Opponent2`.`weight`, `Opponent2`.`rank`, `Opponent2`.`credit`, `Opponent2`.`email`, `Opponent2`.`avatar`, `Opponent2`.`username`, `Opponent2`.`enroll_ranking`, `Opponent2`.`created`, `Opponent2`.`assign`, `Opponent2`.`final_credit`, `Opponent2`.`club_id`, `Opponent2`.`credit_is_active`, `Opponent2`.`nickname`, `Opponent2`.`is_single_team`, `Opponent1Partner`.`id`, `Opponent1Partner`.`user_id`, `Opponent1Partner`.`contest_id`, `Opponent1Partner`.`fullname`, `Opponent1Partner`.`number`, `Opponent1Partner`.`gender`, `Opponent1Partner`.`contact`, `Opponent1Partner`.`company`, `Opponent1Partner`.`card`, `Opponent1Partner`.`dtype`, `Opponent1Partner`.`colony_id`, `Opponent1Partner`.`colony_name`, `Opponent1Partner`.`colony_no`, `Opponent1Partner`.`remark`, `Opponent1Partner`.`parent_id`, `Opponent1Partner`.`is_giveup`, `Opponent1Partner`.`score`, `Opponent1Partner`.`weight`, `Opponent1Partner`.`rank`, `Opponent1Partner`.`credit`, `Opponent1Partner`.`email`, `Opponent1Partner`.`avatar`, `Opponent1Partner`.`username`, `Opponent1Partner`.`enroll_ranking`, `Opponent1Partner`.`created`, `Opponent1Partner`.`assign`, `Opponent1Partner`.`final_credit`, `Opponent1Partner`.`club_id`, `Opponent1Partner`.`credit_is_active`, `Opponent1Partner`.`nickname`, `Opponent1Partner`.`is_single_team`, `Opponent2Partner`.`id`, `Opponent2Partner`.`user_id`, `Opponent2Partner`.`contest_id`, `Opponent2Partner`.`fullname`, `Opponent2Partner`.`number`, `Opponent2Partner`.`gender`, `Opponent2Partner`.`contact`, `Opponent2Partner`.`company`, `Opponent2Partner`.`card`, `Opponent2Partner`.`dtype`, `Opponent2Partner`.`colony_id`, `Opponent2Partner`.`colony_name`, `Opponent2Partner`.`colony_no`, `Opponent2Partner`.`remark`, `Opponent2Partner`.`parent_id`, `Opponent2Partner`.`is_giveup`, `Opponent2Partner`.`score`, `Opponent2Partner`.`weight`, `Opponent2Partner`.`rank`, `Opponent2Partner`.`credit`, `Opponent2Partner`.`email`, `Opponent2Partner`.`avatar`, `Opponent2Partner`.`username`, `Opponent2Partner`.`enroll_ranking`, `Opponent2Partner`.`created`, `Opponent2Partner`.`assign`, `Opponent2Partner`.`final_credit`, `Opponent2Partner`.`club_id`, `Opponent2Partner`.`credit_is_active`, `Opponent2Partner`.`nickname`, `Opponent2Partner`.`is_single_team`, `OpponentStage1`.`id`, `OpponentStage1`.`opponent_id`, `OpponentStage1`.`stage`, `OpponentStage1`.`group`, `OpponentStage1`.`grade`, `OpponentStage1`.`serial`, `OpponentStage1`.`is_seed`, `OpponentStage1`.`is_giveup`, `OpponentStage1`.`win`, `OpponentStage1`.`lose`, `OpponentStage1`.`score`, `OpponentStage1`.`rank`, `OpponentStage1`.`remark`, `OpponentStage1`.`calculate`, `OpponentStage1`.`is_outlet`, `OpponentStage1`.`seed_reason`, `OpponentStage1`.`win_verify`, `OpponentStage1`.`lose_verify`, `OpponentStage1`.`score_verify`, `OpponentStage1`.`draw`, `OpponentStage1`.`order`, `OpponentStage2`.`id`, `OpponentStage2`.`opponent_id`, `OpponentStage2`.`stage`, `OpponentStage2`.`group`, `OpponentStage2`.`grade`, `OpponentStage2`.`serial`, `OpponentStage2`.`is_seed`, `OpponentStage2`.`is_giveup`, `OpponentStage2`.`win`, `OpponentStage2`.`lose`, `OpponentStage2`.`score`, `OpponentStage2`.`rank`, `OpponentStage2`.`remark`, `OpponentStage2`.`calculate`, `OpponentStage2`.`is_outlet`, `OpponentStage2`.`seed_reason`, `OpponentStage2`.`win_verify`, `OpponentStage2`.`lose_verify`, `OpponentStage2`.`score_verify`, `OpponentStage2`.`draw`, `OpponentStage2`.`order`, `Venue`.`id`, `Venue`.`number`, `Venue`.`location`, `Venue`.`contest_id`, `Venue`.`serial`, `MatchResult`.`id`, `MatchResult`.`match_id`, `MatchResult`.`opponent1_final_score`, `MatchResult`.`opponent2_final_score`, `MatchResult`.`winner_opponent_id`, `MatchResult`.`loser_opponent_id`, `MatchResult`.`is_giveup_1`, `MatchResult`.`is_giveup_2`, `MatchResult`.`is_counted`, `MatchResult`.`time` FROM `hpp_game`.`matches` AS `Match` LEFT JOIN `hpp_game`.`opponents` AS `Opponent1` ON (`Match`.`opponent1_id` = `Opponent1`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent2` ON (`Match`.`opponent2_id` = `Opponent2`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent1Partner` ON (`Match`.`opponent1_partner_id` = `Opponent1Partner`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent2Partner` ON (`Match`.`opponent2_partner_id` = `Opponent2Partner`.`id`) LEFT JOIN `hpp_game`.`opponent_stages` AS `OpponentStage1` ON (`Opponent1`.`id` = `OpponentStage1`.`opponent_id` AND `OpponentStage1`.`stage` = `Match`.`stage`) LEFT JOIN `hpp_game`.`opponent_stages` AS `OpponentStage2` ON (`Opponent2`.`id` = `OpponentStage2`.`opponent_id` AND `OpponentStage2`.`stage` = `Match`.`stage`) LEFT JOIN `hpp_game`.`venues` AS `Venue` ON (`Match`.`venue_id` = `Venue`.`id`) LEFT JOIN `hpp_game`.`match_results` AS `MatchResult` ON (`MatchResult`.`match_id` = `Match`.`id`) WHERE `Match`.`contest_id` = 20066 AND `Match`.`stage` = 0 AND `Match`.`type` = 0 AND `Match`.`group` = 1 ORDER BY `Match`.`group` asc, `Match`.`number` asc212183
6SELECT `MatchResultDetail`.`id`, `MatchResultDetail`.`match_result_id`, `MatchResultDetail`.`description`, `MatchResultDetail`.`stage_name`, `MatchResultDetail`.`opponent1_score`, `MatchResultDetail`.`opponent2_score`, `MatchResultDetail`.`stage_winner` FROM `hpp_game`.`match_result_details` AS `MatchResultDetail` WHERE `MatchResultDetail`.`match_result_id` IN (816011, 816185, 816177, 816001, 816007, 816176, 815997, 816196, 816003, 815996, 816178, 816189, 815994, 816182, 816009, 815993, 816005, 816197, 815991, 816179, 816194) ORDER BY `MatchResultDetail`.`id` asc66665
7SELECT `Match`.`id`, `Match`.`number`, `Match`.`contest_id`, `Match`.`venue_id`, `Match`.`status`, `Match`.`scheduled_start_date`, `Match`.`opponent1_id`, `Match`.`opponent2_id`, `Match`.`referee1_id`, `Match`.`referee2_id`, `Match`.`referee3_id`, `Match`.`scheduled_end_date`, `Match`.`group`, `Match`.`group_round`, `Match`.`type`, `Match`.`stage`, `Match`.`label`, `Match`.`placeholder1`, `Match`.`placeholder2`, `Match`.`contest_round`, `Match`.`addition_level`, `Match`.`weight`, `Match`.`dtype`, `Match`.`credit_detail_id`, `Match`.`parent_id`, `Match`.`team_round`, `Match`.`grade`, `Match`.`rounds`, `Match`.`placeholder1_ori`, `Match`.`placeholder2_ori`, `Match`.`home`, `Match`.`opponent1_partner_id`, `Match`.`opponent2_partner_id`, `Match`.`project`, `Match`.`mtype`, `Opponent1`.`id`, `Opponent1`.`user_id`, `Opponent1`.`contest_id`, `Opponent1`.`fullname`, `Opponent1`.`number`, `Opponent1`.`gender`, `Opponent1`.`contact`, `Opponent1`.`company`, `Opponent1`.`card`, `Opponent1`.`dtype`, `Opponent1`.`colony_id`, `Opponent1`.`colony_name`, `Opponent1`.`colony_no`, `Opponent1`.`remark`, `Opponent1`.`parent_id`, `Opponent1`.`is_giveup`, `Opponent1`.`score`, `Opponent1`.`weight`, `Opponent1`.`rank`, `Opponent1`.`credit`, `Opponent1`.`email`, `Opponent1`.`avatar`, `Opponent1`.`username`, `Opponent1`.`enroll_ranking`, `Opponent1`.`created`, `Opponent1`.`assign`, `Opponent1`.`final_credit`, `Opponent1`.`club_id`, `Opponent1`.`credit_is_active`, `Opponent1`.`nickname`, `Opponent1`.`is_single_team`, `Opponent2`.`id`, `Opponent2`.`user_id`, `Opponent2`.`contest_id`, `Opponent2`.`fullname`, `Opponent2`.`number`, `Opponent2`.`gender`, `Opponent2`.`contact`, `Opponent2`.`company`, `Opponent2`.`card`, `Opponent2`.`dtype`, `Opponent2`.`colony_id`, `Opponent2`.`colony_name`, `Opponent2`.`colony_no`, `Opponent2`.`remark`, `Opponent2`.`parent_id`, `Opponent2`.`is_giveup`, `Opponent2`.`score`, `Opponent2`.`weight`, `Opponent2`.`rank`, `Opponent2`.`credit`, `Opponent2`.`email`, `Opponent2`.`avatar`, `Opponent2`.`username`, `Opponent2`.`enroll_ranking`, `Opponent2`.`created`, `Opponent2`.`assign`, `Opponent2`.`final_credit`, `Opponent2`.`club_id`, `Opponent2`.`credit_is_active`, `Opponent2`.`nickname`, `Opponent2`.`is_single_team`, `Opponent1Partner`.`id`, `Opponent1Partner`.`user_id`, `Opponent1Partner`.`contest_id`, `Opponent1Partner`.`fullname`, `Opponent1Partner`.`number`, `Opponent1Partner`.`gender`, `Opponent1Partner`.`contact`, `Opponent1Partner`.`company`, `Opponent1Partner`.`card`, `Opponent1Partner`.`dtype`, `Opponent1Partner`.`colony_id`, `Opponent1Partner`.`colony_name`, `Opponent1Partner`.`colony_no`, `Opponent1Partner`.`remark`, `Opponent1Partner`.`parent_id`, `Opponent1Partner`.`is_giveup`, `Opponent1Partner`.`score`, `Opponent1Partner`.`weight`, `Opponent1Partner`.`rank`, `Opponent1Partner`.`credit`, `Opponent1Partner`.`email`, `Opponent1Partner`.`avatar`, `Opponent1Partner`.`username`, `Opponent1Partner`.`enroll_ranking`, `Opponent1Partner`.`created`, `Opponent1Partner`.`assign`, `Opponent1Partner`.`final_credit`, `Opponent1Partner`.`club_id`, `Opponent1Partner`.`credit_is_active`, `Opponent1Partner`.`nickname`, `Opponent1Partner`.`is_single_team`, `Opponent2Partner`.`id`, `Opponent2Partner`.`user_id`, `Opponent2Partner`.`contest_id`, `Opponent2Partner`.`fullname`, `Opponent2Partner`.`number`, `Opponent2Partner`.`gender`, `Opponent2Partner`.`contact`, `Opponent2Partner`.`company`, `Opponent2Partner`.`card`, `Opponent2Partner`.`dtype`, `Opponent2Partner`.`colony_id`, `Opponent2Partner`.`colony_name`, `Opponent2Partner`.`colony_no`, `Opponent2Partner`.`remark`, `Opponent2Partner`.`parent_id`, `Opponent2Partner`.`is_giveup`, `Opponent2Partner`.`score`, `Opponent2Partner`.`weight`, `Opponent2Partner`.`rank`, `Opponent2Partner`.`credit`, `Opponent2Partner`.`email`, `Opponent2Partner`.`avatar`, `Opponent2Partner`.`username`, `Opponent2Partner`.`enroll_ranking`, `Opponent2Partner`.`created`, `Opponent2Partner`.`assign`, `Opponent2Partner`.`final_credit`, `Opponent2Partner`.`club_id`, `Opponent2Partner`.`credit_is_active`, `Opponent2Partner`.`nickname`, `Opponent2Partner`.`is_single_team`, `OpponentStage1`.`id`, `OpponentStage1`.`opponent_id`, `OpponentStage1`.`stage`, `OpponentStage1`.`group`, `OpponentStage1`.`grade`, `OpponentStage1`.`serial`, `OpponentStage1`.`is_seed`, `OpponentStage1`.`is_giveup`, `OpponentStage1`.`win`, `OpponentStage1`.`lose`, `OpponentStage1`.`score`, `OpponentStage1`.`rank`, `OpponentStage1`.`remark`, `OpponentStage1`.`calculate`, `OpponentStage1`.`is_outlet`, `OpponentStage1`.`seed_reason`, `OpponentStage1`.`win_verify`, `OpponentStage1`.`lose_verify`, `OpponentStage1`.`score_verify`, `OpponentStage1`.`draw`, `OpponentStage1`.`order`, `OpponentStage2`.`id`, `OpponentStage2`.`opponent_id`, `OpponentStage2`.`stage`, `OpponentStage2`.`group`, `OpponentStage2`.`grade`, `OpponentStage2`.`serial`, `OpponentStage2`.`is_seed`, `OpponentStage2`.`is_giveup`, `OpponentStage2`.`win`, `OpponentStage2`.`lose`, `OpponentStage2`.`score`, `OpponentStage2`.`rank`, `OpponentStage2`.`remark`, `OpponentStage2`.`calculate`, `OpponentStage2`.`is_outlet`, `OpponentStage2`.`seed_reason`, `OpponentStage2`.`win_verify`, `OpponentStage2`.`lose_verify`, `OpponentStage2`.`score_verify`, `OpponentStage2`.`draw`, `OpponentStage2`.`order`, `Venue`.`id`, `Venue`.`number`, `Venue`.`location`, `Venue`.`contest_id`, `Venue`.`serial`, `MatchResult`.`id`, `MatchResult`.`match_id`, `MatchResult`.`opponent1_final_score`, `MatchResult`.`opponent2_final_score`, `MatchResult`.`winner_opponent_id`, `MatchResult`.`loser_opponent_id`, `MatchResult`.`is_giveup_1`, `MatchResult`.`is_giveup_2`, `MatchResult`.`is_counted`, `MatchResult`.`time` FROM `hpp_game`.`matches` AS `Match` LEFT JOIN `hpp_game`.`opponents` AS `Opponent1` ON (`Match`.`opponent1_id` = `Opponent1`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent2` ON (`Match`.`opponent2_id` = `Opponent2`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent1Partner` ON (`Match`.`opponent1_partner_id` = `Opponent1Partner`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent2Partner` ON (`Match`.`opponent2_partner_id` = `Opponent2Partner`.`id`) LEFT JOIN `hpp_game`.`opponent_stages` AS `OpponentStage1` ON (`Opponent1`.`id` = `OpponentStage1`.`opponent_id` AND `OpponentStage1`.`stage` = `Match`.`stage`) LEFT JOIN `hpp_game`.`opponent_stages` AS `OpponentStage2` ON (`Opponent2`.`id` = `OpponentStage2`.`opponent_id` AND `OpponentStage2`.`stage` = `Match`.`stage`) LEFT JOIN `hpp_game`.`venues` AS `Venue` ON (`Match`.`venue_id` = `Venue`.`id`) LEFT JOIN `hpp_game`.`match_results` AS `MatchResult` ON (`MatchResult`.`match_id` = `Match`.`id`) WHERE `Match`.`contest_id` = 20066 AND `Match`.`stage` = 0 AND `Match`.`type` = 0 AND `Match`.`group` = 2 ORDER BY `Match`.`group` asc, `Match`.`number` asc15155
8SELECT `MatchResultDetail`.`id`, `MatchResultDetail`.`match_result_id`, `MatchResultDetail`.`description`, `MatchResultDetail`.`stage_name`, `MatchResultDetail`.`opponent1_score`, `MatchResultDetail`.`opponent2_score`, `MatchResultDetail`.`stage_winner` FROM `hpp_game`.`match_result_details` AS `MatchResultDetail` WHERE `MatchResultDetail`.`match_result_id` IN (816017, 816020, 816208, 816016, 816216, 816018, 816015, 816211, 816021, 816014, 816019, 816220, 816013, 816212, 816215) ORDER BY `MatchResultDetail`.`id` asc48483
9SELECT `Match`.`id`, `Match`.`number`, `Match`.`contest_id`, `Match`.`venue_id`, `Match`.`status`, `Match`.`scheduled_start_date`, `Match`.`opponent1_id`, `Match`.`opponent2_id`, `Match`.`referee1_id`, `Match`.`referee2_id`, `Match`.`referee3_id`, `Match`.`scheduled_end_date`, `Match`.`group`, `Match`.`group_round`, `Match`.`type`, `Match`.`stage`, `Match`.`label`, `Match`.`placeholder1`, `Match`.`placeholder2`, `Match`.`contest_round`, `Match`.`addition_level`, `Match`.`weight`, `Match`.`dtype`, `Match`.`credit_detail_id`, `Match`.`parent_id`, `Match`.`team_round`, `Match`.`grade`, `Match`.`rounds`, `Match`.`placeholder1_ori`, `Match`.`placeholder2_ori`, `Match`.`home`, `Match`.`opponent1_partner_id`, `Match`.`opponent2_partner_id`, `Match`.`project`, `Match`.`mtype`, `Opponent1`.`id`, `Opponent1`.`user_id`, `Opponent1`.`contest_id`, `Opponent1`.`fullname`, `Opponent1`.`number`, `Opponent1`.`gender`, `Opponent1`.`contact`, `Opponent1`.`company`, `Opponent1`.`card`, `Opponent1`.`dtype`, `Opponent1`.`colony_id`, `Opponent1`.`colony_name`, `Opponent1`.`colony_no`, `Opponent1`.`remark`, `Opponent1`.`parent_id`, `Opponent1`.`is_giveup`, `Opponent1`.`score`, `Opponent1`.`weight`, `Opponent1`.`rank`, `Opponent1`.`credit`, `Opponent1`.`email`, `Opponent1`.`avatar`, `Opponent1`.`username`, `Opponent1`.`enroll_ranking`, `Opponent1`.`created`, `Opponent1`.`assign`, `Opponent1`.`final_credit`, `Opponent1`.`club_id`, `Opponent1`.`credit_is_active`, `Opponent1`.`nickname`, `Opponent1`.`is_single_team`, `Opponent2`.`id`, `Opponent2`.`user_id`, `Opponent2`.`contest_id`, `Opponent2`.`fullname`, `Opponent2`.`number`, `Opponent2`.`gender`, `Opponent2`.`contact`, `Opponent2`.`company`, `Opponent2`.`card`, `Opponent2`.`dtype`, `Opponent2`.`colony_id`, `Opponent2`.`colony_name`, `Opponent2`.`colony_no`, `Opponent2`.`remark`, `Opponent2`.`parent_id`, `Opponent2`.`is_giveup`, `Opponent2`.`score`, `Opponent2`.`weight`, `Opponent2`.`rank`, `Opponent2`.`credit`, `Opponent2`.`email`, `Opponent2`.`avatar`, `Opponent2`.`username`, `Opponent2`.`enroll_ranking`, `Opponent2`.`created`, `Opponent2`.`assign`, `Opponent2`.`final_credit`, `Opponent2`.`club_id`, `Opponent2`.`credit_is_active`, `Opponent2`.`nickname`, `Opponent2`.`is_single_team`, `Opponent1Partner`.`id`, `Opponent1Partner`.`user_id`, `Opponent1Partner`.`contest_id`, `Opponent1Partner`.`fullname`, `Opponent1Partner`.`number`, `Opponent1Partner`.`gender`, `Opponent1Partner`.`contact`, `Opponent1Partner`.`company`, `Opponent1Partner`.`card`, `Opponent1Partner`.`dtype`, `Opponent1Partner`.`colony_id`, `Opponent1Partner`.`colony_name`, `Opponent1Partner`.`colony_no`, `Opponent1Partner`.`remark`, `Opponent1Partner`.`parent_id`, `Opponent1Partner`.`is_giveup`, `Opponent1Partner`.`score`, `Opponent1Partner`.`weight`, `Opponent1Partner`.`rank`, `Opponent1Partner`.`credit`, `Opponent1Partner`.`email`, `Opponent1Partner`.`avatar`, `Opponent1Partner`.`username`, `Opponent1Partner`.`enroll_ranking`, `Opponent1Partner`.`created`, `Opponent1Partner`.`assign`, `Opponent1Partner`.`final_credit`, `Opponent1Partner`.`club_id`, `Opponent1Partner`.`credit_is_active`, `Opponent1Partner`.`nickname`, `Opponent1Partner`.`is_single_team`, `Opponent2Partner`.`id`, `Opponent2Partner`.`user_id`, `Opponent2Partner`.`contest_id`, `Opponent2Partner`.`fullname`, `Opponent2Partner`.`number`, `Opponent2Partner`.`gender`, `Opponent2Partner`.`contact`, `Opponent2Partner`.`company`, `Opponent2Partner`.`card`, `Opponent2Partner`.`dtype`, `Opponent2Partner`.`colony_id`, `Opponent2Partner`.`colony_name`, `Opponent2Partner`.`colony_no`, `Opponent2Partner`.`remark`, `Opponent2Partner`.`parent_id`, `Opponent2Partner`.`is_giveup`, `Opponent2Partner`.`score`, `Opponent2Partner`.`weight`, `Opponent2Partner`.`rank`, `Opponent2Partner`.`credit`, `Opponent2Partner`.`email`, `Opponent2Partner`.`avatar`, `Opponent2Partner`.`username`, `Opponent2Partner`.`enroll_ranking`, `Opponent2Partner`.`created`, `Opponent2Partner`.`assign`, `Opponent2Partner`.`final_credit`, `Opponent2Partner`.`club_id`, `Opponent2Partner`.`credit_is_active`, `Opponent2Partner`.`nickname`, `Opponent2Partner`.`is_single_team`, `OpponentStage1`.`id`, `OpponentStage1`.`opponent_id`, `OpponentStage1`.`stage`, `OpponentStage1`.`group`, `OpponentStage1`.`grade`, `OpponentStage1`.`serial`, `OpponentStage1`.`is_seed`, `OpponentStage1`.`is_giveup`, `OpponentStage1`.`win`, `OpponentStage1`.`lose`, `OpponentStage1`.`score`, `OpponentStage1`.`rank`, `OpponentStage1`.`remark`, `OpponentStage1`.`calculate`, `OpponentStage1`.`is_outlet`, `OpponentStage1`.`seed_reason`, `OpponentStage1`.`win_verify`, `OpponentStage1`.`lose_verify`, `OpponentStage1`.`score_verify`, `OpponentStage1`.`draw`, `OpponentStage1`.`order`, `OpponentStage2`.`id`, `OpponentStage2`.`opponent_id`, `OpponentStage2`.`stage`, `OpponentStage2`.`group`, `OpponentStage2`.`grade`, `OpponentStage2`.`serial`, `OpponentStage2`.`is_seed`, `OpponentStage2`.`is_giveup`, `OpponentStage2`.`win`, `OpponentStage2`.`lose`, `OpponentStage2`.`score`, `OpponentStage2`.`rank`, `OpponentStage2`.`remark`, `OpponentStage2`.`calculate`, `OpponentStage2`.`is_outlet`, `OpponentStage2`.`seed_reason`, `OpponentStage2`.`win_verify`, `OpponentStage2`.`lose_verify`, `OpponentStage2`.`score_verify`, `OpponentStage2`.`draw`, `OpponentStage2`.`order`, `Venue`.`id`, `Venue`.`number`, `Venue`.`location`, `Venue`.`contest_id`, `Venue`.`serial`, `MatchResult`.`id`, `MatchResult`.`match_id`, `MatchResult`.`opponent1_final_score`, `MatchResult`.`opponent2_final_score`, `MatchResult`.`winner_opponent_id`, `MatchResult`.`loser_opponent_id`, `MatchResult`.`is_giveup_1`, `MatchResult`.`is_giveup_2`, `MatchResult`.`is_counted`, `MatchResult`.`time` FROM `hpp_game`.`matches` AS `Match` LEFT JOIN `hpp_game`.`opponents` AS `Opponent1` ON (`Match`.`opponent1_id` = `Opponent1`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent2` ON (`Match`.`opponent2_id` = `Opponent2`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent1Partner` ON (`Match`.`opponent1_partner_id` = `Opponent1Partner`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent2Partner` ON (`Match`.`opponent2_partner_id` = `Opponent2Partner`.`id`) LEFT JOIN `hpp_game`.`opponent_stages` AS `OpponentStage1` ON (`Opponent1`.`id` = `OpponentStage1`.`opponent_id` AND `OpponentStage1`.`stage` = `Match`.`stage`) LEFT JOIN `hpp_game`.`opponent_stages` AS `OpponentStage2` ON (`Opponent2`.`id` = `OpponentStage2`.`opponent_id` AND `OpponentStage2`.`stage` = `Match`.`stage`) LEFT JOIN `hpp_game`.`venues` AS `Venue` ON (`Match`.`venue_id` = `Venue`.`id`) LEFT JOIN `hpp_game`.`match_results` AS `MatchResult` ON (`MatchResult`.`match_id` = `Match`.`id`) WHERE `Match`.`contest_id` = 20066 AND `Match`.`stage` = 0 AND `Match`.`type` = 0 AND `Match`.`group` = 3 ORDER BY `Match`.`group` asc, `Match`.`number` asc15156
10SELECT `MatchResultDetail`.`id`, `MatchResultDetail`.`match_result_id`, `MatchResultDetail`.`description`, `MatchResultDetail`.`stage_name`, `MatchResultDetail`.`opponent1_score`, `MatchResultDetail`.`opponent2_score`, `MatchResultDetail`.`stage_winner` FROM `hpp_game`.`match_result_details` AS `MatchResultDetail` WHERE `MatchResultDetail`.`match_result_id` IN (816026, 816029, 816283, 816025, 816313, 816027, 816024, 816266, 816030, 816023, 816028, 816287, 816022, 816260, 816252) ORDER BY `MatchResultDetail`.`id` asc51513
11SELECT `Match`.`id`, `Match`.`number`, `Match`.`contest_id`, `Match`.`venue_id`, `Match`.`status`, `Match`.`scheduled_start_date`, `Match`.`opponent1_id`, `Match`.`opponent2_id`, `Match`.`referee1_id`, `Match`.`referee2_id`, `Match`.`referee3_id`, `Match`.`scheduled_end_date`, `Match`.`group`, `Match`.`group_round`, `Match`.`type`, `Match`.`stage`, `Match`.`label`, `Match`.`placeholder1`, `Match`.`placeholder2`, `Match`.`contest_round`, `Match`.`addition_level`, `Match`.`weight`, `Match`.`dtype`, `Match`.`credit_detail_id`, `Match`.`parent_id`, `Match`.`team_round`, `Match`.`grade`, `Match`.`rounds`, `Match`.`placeholder1_ori`, `Match`.`placeholder2_ori`, `Match`.`home`, `Match`.`opponent1_partner_id`, `Match`.`opponent2_partner_id`, `Match`.`project`, `Match`.`mtype`, `Opponent1`.`id`, `Opponent1`.`user_id`, `Opponent1`.`contest_id`, `Opponent1`.`fullname`, `Opponent1`.`number`, `Opponent1`.`gender`, `Opponent1`.`contact`, `Opponent1`.`company`, `Opponent1`.`card`, `Opponent1`.`dtype`, `Opponent1`.`colony_id`, `Opponent1`.`colony_name`, `Opponent1`.`colony_no`, `Opponent1`.`remark`, `Opponent1`.`parent_id`, `Opponent1`.`is_giveup`, `Opponent1`.`score`, `Opponent1`.`weight`, `Opponent1`.`rank`, `Opponent1`.`credit`, `Opponent1`.`email`, `Opponent1`.`avatar`, `Opponent1`.`username`, `Opponent1`.`enroll_ranking`, `Opponent1`.`created`, `Opponent1`.`assign`, `Opponent1`.`final_credit`, `Opponent1`.`club_id`, `Opponent1`.`credit_is_active`, `Opponent1`.`nickname`, `Opponent1`.`is_single_team`, `Opponent2`.`id`, `Opponent2`.`user_id`, `Opponent2`.`contest_id`, `Opponent2`.`fullname`, `Opponent2`.`number`, `Opponent2`.`gender`, `Opponent2`.`contact`, `Opponent2`.`company`, `Opponent2`.`card`, `Opponent2`.`dtype`, `Opponent2`.`colony_id`, `Opponent2`.`colony_name`, `Opponent2`.`colony_no`, `Opponent2`.`remark`, `Opponent2`.`parent_id`, `Opponent2`.`is_giveup`, `Opponent2`.`score`, `Opponent2`.`weight`, `Opponent2`.`rank`, `Opponent2`.`credit`, `Opponent2`.`email`, `Opponent2`.`avatar`, `Opponent2`.`username`, `Opponent2`.`enroll_ranking`, `Opponent2`.`created`, `Opponent2`.`assign`, `Opponent2`.`final_credit`, `Opponent2`.`club_id`, `Opponent2`.`credit_is_active`, `Opponent2`.`nickname`, `Opponent2`.`is_single_team`, `Opponent1Partner`.`id`, `Opponent1Partner`.`user_id`, `Opponent1Partner`.`contest_id`, `Opponent1Partner`.`fullname`, `Opponent1Partner`.`number`, `Opponent1Partner`.`gender`, `Opponent1Partner`.`contact`, `Opponent1Partner`.`company`, `Opponent1Partner`.`card`, `Opponent1Partner`.`dtype`, `Opponent1Partner`.`colony_id`, `Opponent1Partner`.`colony_name`, `Opponent1Partner`.`colony_no`, `Opponent1Partner`.`remark`, `Opponent1Partner`.`parent_id`, `Opponent1Partner`.`is_giveup`, `Opponent1Partner`.`score`, `Opponent1Partner`.`weight`, `Opponent1Partner`.`rank`, `Opponent1Partner`.`credit`, `Opponent1Partner`.`email`, `Opponent1Partner`.`avatar`, `Opponent1Partner`.`username`, `Opponent1Partner`.`enroll_ranking`, `Opponent1Partner`.`created`, `Opponent1Partner`.`assign`, `Opponent1Partner`.`final_credit`, `Opponent1Partner`.`club_id`, `Opponent1Partner`.`credit_is_active`, `Opponent1Partner`.`nickname`, `Opponent1Partner`.`is_single_team`, `Opponent2Partner`.`id`, `Opponent2Partner`.`user_id`, `Opponent2Partner`.`contest_id`, `Opponent2Partner`.`fullname`, `Opponent2Partner`.`number`, `Opponent2Partner`.`gender`, `Opponent2Partner`.`contact`, `Opponent2Partner`.`company`, `Opponent2Partner`.`card`, `Opponent2Partner`.`dtype`, `Opponent2Partner`.`colony_id`, `Opponent2Partner`.`colony_name`, `Opponent2Partner`.`colony_no`, `Opponent2Partner`.`remark`, `Opponent2Partner`.`parent_id`, `Opponent2Partner`.`is_giveup`, `Opponent2Partner`.`score`, `Opponent2Partner`.`weight`, `Opponent2Partner`.`rank`, `Opponent2Partner`.`credit`, `Opponent2Partner`.`email`, `Opponent2Partner`.`avatar`, `Opponent2Partner`.`username`, `Opponent2Partner`.`enroll_ranking`, `Opponent2Partner`.`created`, `Opponent2Partner`.`assign`, `Opponent2Partner`.`final_credit`, `Opponent2Partner`.`club_id`, `Opponent2Partner`.`credit_is_active`, `Opponent2Partner`.`nickname`, `Opponent2Partner`.`is_single_team`, `OpponentStage1`.`id`, `OpponentStage1`.`opponent_id`, `OpponentStage1`.`stage`, `OpponentStage1`.`group`, `OpponentStage1`.`grade`, `OpponentStage1`.`serial`, `OpponentStage1`.`is_seed`, `OpponentStage1`.`is_giveup`, `OpponentStage1`.`win`, `OpponentStage1`.`lose`, `OpponentStage1`.`score`, `OpponentStage1`.`rank`, `OpponentStage1`.`remark`, `OpponentStage1`.`calculate`, `OpponentStage1`.`is_outlet`, `OpponentStage1`.`seed_reason`, `OpponentStage1`.`win_verify`, `OpponentStage1`.`lose_verify`, `OpponentStage1`.`score_verify`, `OpponentStage1`.`draw`, `OpponentStage1`.`order`, `OpponentStage2`.`id`, `OpponentStage2`.`opponent_id`, `OpponentStage2`.`stage`, `OpponentStage2`.`group`, `OpponentStage2`.`grade`, `OpponentStage2`.`serial`, `OpponentStage2`.`is_seed`, `OpponentStage2`.`is_giveup`, `OpponentStage2`.`win`, `OpponentStage2`.`lose`, `OpponentStage2`.`score`, `OpponentStage2`.`rank`, `OpponentStage2`.`remark`, `OpponentStage2`.`calculate`, `OpponentStage2`.`is_outlet`, `OpponentStage2`.`seed_reason`, `OpponentStage2`.`win_verify`, `OpponentStage2`.`lose_verify`, `OpponentStage2`.`score_verify`, `OpponentStage2`.`draw`, `OpponentStage2`.`order`, `Venue`.`id`, `Venue`.`number`, `Venue`.`location`, `Venue`.`contest_id`, `Venue`.`serial`, `MatchResult`.`id`, `MatchResult`.`match_id`, `MatchResult`.`opponent1_final_score`, `MatchResult`.`opponent2_final_score`, `MatchResult`.`winner_opponent_id`, `MatchResult`.`loser_opponent_id`, `MatchResult`.`is_giveup_1`, `MatchResult`.`is_giveup_2`, `MatchResult`.`is_counted`, `MatchResult`.`time` FROM `hpp_game`.`matches` AS `Match` LEFT JOIN `hpp_game`.`opponents` AS `Opponent1` ON (`Match`.`opponent1_id` = `Opponent1`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent2` ON (`Match`.`opponent2_id` = `Opponent2`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent1Partner` ON (`Match`.`opponent1_partner_id` = `Opponent1Partner`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent2Partner` ON (`Match`.`opponent2_partner_id` = `Opponent2Partner`.`id`) LEFT JOIN `hpp_game`.`opponent_stages` AS `OpponentStage1` ON (`Opponent1`.`id` = `OpponentStage1`.`opponent_id` AND `OpponentStage1`.`stage` = `Match`.`stage`) LEFT JOIN `hpp_game`.`opponent_stages` AS `OpponentStage2` ON (`Opponent2`.`id` = `OpponentStage2`.`opponent_id` AND `OpponentStage2`.`stage` = `Match`.`stage`) LEFT JOIN `hpp_game`.`venues` AS `Venue` ON (`Match`.`venue_id` = `Venue`.`id`) LEFT JOIN `hpp_game`.`match_results` AS `MatchResult` ON (`MatchResult`.`match_id` = `Match`.`id`) WHERE `Match`.`contest_id` = 20066 AND `Match`.`stage` = 0 AND `Match`.`type` = 0 AND `Match`.`group` = 4 ORDER BY `Match`.`group` asc, `Match`.`number` asc15154
12SELECT `MatchResultDetail`.`id`, `MatchResultDetail`.`match_result_id`, `MatchResultDetail`.`description`, `MatchResultDetail`.`stage_name`, `MatchResultDetail`.`opponent1_score`, `MatchResultDetail`.`opponent2_score`, `MatchResultDetail`.`stage_winner` FROM `hpp_game`.`match_result_details` AS `MatchResultDetail` WHERE `MatchResultDetail`.`match_result_id` IN (816035, 816038, 816225, 816034, 816317, 816036, 816033, 816315, 816039, 816032, 816037, 816243, 816031, 816229, 816240) ORDER BY `MatchResultDetail`.`id` asc52523
13SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 12282222
14SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status`, `Contest`.`published` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 12282222
15SELECT `PingpongContest`.`id`, `PingpongContest`.`mode`, `PingpongContest`.`category` FROM `hpp_game`.`pingpong_contests` AS `PingpongContest` WHERE id IN (20066, 20124)222
16SELECT `Contest`.`id`, `Contest`.`enroll_count` FROM `hpp_game`.`contests` AS `Contest` WHERE `Contest`.`game_id` = 12282 AND `Contest`.`status` <> 'cancel'222
17SELECT `PingpongContest`.`id`, `PingpongContest`.`mode` FROM `hpp_game`.`pingpong_contests` AS `PingpongContest` WHERE `PingpongContest`.`id` IN (20066, 20124)222
18SELECT COUNT(*) AS `count` FROM `hpp_game`.`photos` AS `Photo` WHERE `Photo`.`type` = 2 AND `Photo`.`ex_type_id` = 12282112