乒乓球赛事
3778 人气 39 参赛者 0 照片

苏州全爱俱乐部第七届快乐乒乓网积分赛

苏州市 2018年12月02日-2018年12月02日

赛事编号  11816
全民皆乒
第 1 组  共 5 人(共 4 组)
赛程安排
赛程安排
对弈 日期 时间 台号
2-5
3-4
1-5
2-3
1-4
5-3
1-3
4-2
1-2
4-5
序号 姓名
1 周成龙 ( 1609 )
2 果果 ( 1569 )
3 彭福祥 ( 1481 )
4 阿炳 ( 1477 )
5 锁永红 ( 1472 )
12345
2:0 0:2 2:0 2:0
0:2 2:0 2:0 2:0
2:0 0:2 2:0 1:2
0:2 0:2 0:2 2:0
0:2 0:2 2:1 0:2
组内得分 小组名次
7分

3/1

1/0

1
7分

3/1

0/1

2
6分

2/2

3
5分

1/3

1/0

4
5分

1/3

0/1

5
第 2 组  共 5 人(共 4 组)
赛程安排
赛程安排
对弈 日期 时间 台号
2-5
3-4
1-5
2-3
1-4
5-3
1-3
4-2
1-2
4-5
序号 姓名
1 陈大禄 ( 1500 )
2 王念科 ( 1623 )
3 薛峰 ( 1561 )
4 朱刚 ( 1500 )
5 丁杰 ( 1476 )
12345
弃权w-o:2 弃权w-o:2 弃权w-o:2 弃权w-o:2
2:w-o 2:1 2:0 2:0
2:w-o 1:2 2:0 2:0
2:w-o 0:2 0:2 2:0
2:w-o 0:2 0:2 0:2
组内得分 小组名次
0分

0/4

5
8分

4/0

1
7分

3/1

2
6分

2/2

3
5分

1/3

4
第 3 组  共 5 人(共 4 组)
赛程安排
赛程安排
对弈 日期 时间 台号
2-5
3-4
1-5
2-3
1-4
5-3
1-3
4-2
1-2
4-5
序号 姓名
1 吴军 ( 1679 )
2 沈卫东 ( 1630 )
3 王猛 ( 1556 )
4 陈文松 ( 1500 )
5 吕卢山 ( 1475 )
12345
2:0 2:1 2:0 2:0
0:2 0:2 0:2 2:0
1:2 2:0 2:1 2:0
0:2 2:0 1:2 2:0
0:2 0:2 0:2 0:2
组内得分 小组名次
8分

4/0

1
5分

1/3

4
7分

3/1

2
6分

2/2

3
4分

0/4

5
第 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 张安苏 ( 1646 )
3 施鸿 ( 1641 )
4 戴玉祥 ( 1541 )
5 陈宸 ( 1533 )
6 徐锋 ( 1473 )
123456
弃权w-o:2 弃权w-o:2 弃权w-o:2 弃权w-o:2 弃权w-o:2
2:w-o 1:2 2:1 2:0 2:0
2:w-o 2:1 0:2 0:2 2:0
2:w-o 1:2 2:0 1:2 2:1
2:w-o 0:2 2:0 2:1 2:1
2:w-o 0:2 0:2 1:2 1:2
组内得分 小组名次
0分

0/5

6
9分

4/1

1/0

1
8分

3/2

0/1

4
8分

3/2

1/0

3
9分

4/1

0/1

2
6分

1/4

5

积分变化
VS

积分变化
(default) 18 queries took 57 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` = 19615 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` = (19615) ORDER BY `Stage`.`serial` ASC 223
3update games set focus = focus + 1 where id=11816114
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` = 35717 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` = 19615 AND `Match`.`stage` = 0 AND `Match`.`type` = 0 AND `Match`.`group` = 1 ORDER BY `Match`.`group` asc, `Match`.`number` asc10109
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 (797993, 797994, 797990, 797991, 797989, 797995, 797987, 797992, 797985, 797996) ORDER BY `MatchResultDetail`.`id` asc21213
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` = 19615 AND `Match`.`stage` = 0 AND `Match`.`type` = 0 AND `Match`.`group` = 2 ORDER BY `Match`.`group` asc, `Match`.`number` asc10104
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 (797765, 797766, 797762, 797763, 797761, 797769, 797760, 797764, 797759, 797771) ORDER BY `MatchResultDetail`.`id` asc21213
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` = 19615 AND `Match`.`stage` = 0 AND `Match`.`type` = 0 AND `Match`.`group` = 3 ORDER BY `Match`.`group` asc, `Match`.`number` asc10105
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 (798032, 798054, 798028, 798029, 798027, 798056, 798026, 798030, 798025, 798064) ORDER BY `MatchResultDetail`.`id` asc22222
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` = 19615 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 (798002, 798007, 798012, 798000, 798020, 798003, 797999, 798014, 798009, 797998, 798004, 798022, 797997, 798016, 798018) ORDER BY `MatchResultDetail`.`id` asc35352
13SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 11816222
14SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status`, `Contest`.`published` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 11816222
15SELECT `PingpongContest`.`id`, `PingpongContest`.`mode`, `PingpongContest`.`category` FROM `hpp_game`.`pingpong_contests` AS `PingpongContest` WHERE id IN (19614, 19615)222
16SELECT `Contest`.`id`, `Contest`.`enroll_count` FROM `hpp_game`.`contests` AS `Contest` WHERE `Contest`.`game_id` = 11816 AND `Contest`.`status` <> 'cancel'222
17SELECT `PingpongContest`.`id`, `PingpongContest`.`mode` FROM `hpp_game`.`pingpong_contests` AS `PingpongContest` WHERE `PingpongContest`.`id` IN (19614, 19615)222
18SELECT COUNT(*) AS `count` FROM `hpp_game`.`photos` AS `Photo` WHERE `Photo`.`type` = 2 AND `Photo`.`ex_type_id` = 11816112