SELECT mp_player_id AS mp_pl_id
					,mp_sts,mp_notes,mp_class
					,ps.su_score
					,ps.su_to_par
					,ps.su_rank,ps.su_rank_code
					,ps.su_rd_id
					,ps.su_sts
					,ps.su_new_total
					,ps.su_hdcp
					,( SELECT sum(player_summary.su_net) FROM player_summary WHERE player_summary.su_rd_id <= ps.su_rd_id AND player_summary.su_mt_id = ps.su_mt_id AND player_summary.su_pl_id = ps.su_pl_id ) AS su_net
					,( SELECT sum(player_summary.su_to_par) FROM player_summary WHERE player_summary.su_rd_id <= ps.su_rd_id AND player_summary.su_mt_id = ps.su_mt_id AND player_summary.su_pl_id = ps.su_pl_id ) AS totalto_par
					,( SELECT sum(sc_score) FROM player_score WHERE player_score.sc_mt_id=ps.su_mt_id AND player_score.sc_rd_id=ps.su_rd_id AND player_score.sc_pl_id=ps.su_pl_id AND player_score.sc_ho_id>9) as inscore
					,case when ps.su_net=0 then 1000.0 else ps.su_net end as su_net123
					,(SELECT sc_score FROM player_score WHERE player_score.sc_mt_id=ps.su_mt_id AND player_score.sc_rd_id=ps.su_rd_id AND player_score.sc_pl_id=ps.su_pl_id AND player_score.sc_ho_id=18 and sc_type='M') as score18,(SELECT sc_score FROM player_score WHERE player_score.sc_mt_id=ps.su_mt_id AND player_score.sc_rd_id=ps.su_rd_id AND player_score.sc_pl_id=ps.su_pl_id AND player_score.sc_ho_id=17 and sc_type='M') as score17,(SELECT sc_score FROM player_score WHERE player_score.sc_mt_id=ps.su_mt_id AND player_score.sc_rd_id=ps.su_rd_id AND player_score.sc_pl_id=ps.su_pl_id AND player_score.sc_ho_id=16 and sc_type='M') as score16,(SELECT sc_score FROM player_score WHERE player_score.sc_mt_id=ps.su_mt_id AND player_score.sc_rd_id=ps.su_rd_id AND player_score.sc_pl_id=ps.su_pl_id AND player_score.sc_ho_id=15 and sc_type='M') as score15,(SELECT sc_score FROM player_score WHERE player_score.sc_mt_id=ps.su_mt_id AND player_score.sc_rd_id=ps.su_rd_id AND player_score.sc_pl_id=ps.su_pl_id AND player_score.sc_ho_id=14 and sc_type='M') as score14,(SELECT sc_score FROM player_score WHERE player_score.sc_mt_id=ps.su_mt_id AND player_score.sc_rd_id=ps.su_rd_id AND player_score.sc_pl_id=ps.su_pl_id AND player_score.sc_ho_id=13 and sc_type='M') as score13,(SELECT sc_score FROM player_score WHERE player_score.sc_mt_id=ps.su_mt_id AND player_score.sc_rd_id=ps.su_rd_id AND player_score.sc_pl_id=ps.su_pl_id AND player_score.sc_ho_id=12 and sc_type='M') as score12,(SELECT sc_score FROM player_score WHERE player_score.sc_mt_id=ps.su_mt_id AND player_score.sc_rd_id=ps.su_rd_id AND player_score.sc_pl_id=ps.su_pl_id AND player_score.sc_ho_id=11 and sc_type='M') as score11,(SELECT sc_score FROM player_score WHERE player_score.sc_mt_id=ps.su_mt_id AND player_score.sc_rd_id=ps.su_rd_id AND player_score.sc_pl_id=ps.su_pl_id AND player_score.sc_ho_id=10 and sc_type='M') as score10,(SELECT sc_score FROM player_score WHERE player_score.sc_mt_id=ps.su_mt_id AND player_score.sc_rd_id=ps.su_rd_id AND player_score.sc_pl_id=ps.su_pl_id AND player_score.sc_ho_id=9 and sc_type='M') as score9,(SELECT sc_score FROM player_score WHERE player_score.sc_mt_id=ps.su_mt_id AND player_score.sc_rd_id=ps.su_rd_id AND player_score.sc_pl_id=ps.su_pl_id AND player_score.sc_ho_id=8 and sc_type='M') as score8,(SELECT sc_score FROM player_score WHERE player_score.sc_mt_id=ps.su_mt_id AND player_score.sc_rd_id=ps.su_rd_id AND player_score.sc_pl_id=ps.su_pl_id AND player_score.sc_ho_id=7 and sc_type='M') as score7,(SELECT sc_score FROM player_score WHERE player_score.sc_mt_id=ps.su_mt_id AND player_score.sc_rd_id=ps.su_rd_id AND player_score.sc_pl_id=ps.su_pl_id AND player_score.sc_ho_id=6 and sc_type='M') as score6,(SELECT sc_score FROM player_score WHERE player_score.sc_mt_id=ps.su_mt_id AND player_score.sc_rd_id=ps.su_rd_id AND player_score.sc_pl_id=ps.su_pl_id AND player_score.sc_ho_id=5 and sc_type='M') as score5,(SELECT sc_score FROM player_score WHERE player_score.sc_mt_id=ps.su_mt_id AND player_score.sc_rd_id=ps.su_rd_id AND player_score.sc_pl_id=ps.su_pl_id AND player_score.sc_ho_id=4 and sc_type='M') as score4,(SELECT sc_score FROM player_score WHERE player_score.sc_mt_id=ps.su_mt_id AND player_score.sc_rd_id=ps.su_rd_id AND player_score.sc_pl_id=ps.su_pl_id AND player_score.sc_ho_id=3 and sc_type='M') as score3,(SELECT sc_score FROM player_score WHERE player_score.sc_mt_id=ps.su_mt_id AND player_score.sc_rd_id=ps.su_rd_id AND player_score.sc_pl_id=ps.su_pl_id AND player_score.sc_ho_id=2 and sc_type='M') as score2,(SELECT sc_score FROM player_score WHERE player_score.sc_mt_id=ps.su_mt_id AND player_score.sc_rd_id=ps.su_rd_id AND player_score.sc_pl_id=ps.su_pl_id AND player_score.sc_ho_id=1 and sc_type='M') as score1
					,CASE WHEN ps.su_rank is null  OR ps.su_rank=0 THEN 0 ELSE 1 END AS is_null
					,gm.`name`
			        ,gm.id  ,(SELECT count(1) FROM player_score WHERE  sc_type = 'M' AND sc_pl_id=ps.su_pl_id and sc_mt_id='' and sc_rd_id=''  ) as completedholes  FROM match_player LEFT JOIN player_summary ps
				ON mp_player_id = ps.su_pl_id AND mp_match = ps.su_mt_id AND ps.su_rd_id = '' LEFT JOIN player_net_summary pns ON mp_player_id = pns.su_pl_id AND mp_match = pns.su_mt_id AND pns.su_rd_id = '' LEFT JOIN gp_manage gm ON gm.id = mp_class
				 LEFT JOIN player ON mp_player_id=pl_id WHERE mp_match = ''  AND mp_notes not in ('R1','R2','R3','R4') ORDER BY  is_null DESC,  ps.su_rank  ,totalto_par asc  ,completedholes desc  ,su_score,inscore,ps.su_to_par ,case when score18>0 then score18 else 99 end asc,case when score17>0 then score17 else 99 end asc,case when score16>0 then score16 else 99 end asc,case when score15>0 then score15 else 99 end asc,case when score14>0 then score14 else 99 end asc,case when score13>0 then score13 else 99 end asc,case when score12>0 then score12 else 99 end asc,case when score11>0 then score11 else 99 end asc,case when score10>0 then score10 else 99 end asc,case when score9>0 then score9 else 99 end asc,case when score8>0 then score8 else 99 end asc,case when score7>0 then score7 else 99 end asc,case when score6>0 then score6 else 99 end asc,case when score5>0 then score5 else 99 end asc,case when score4>0 then score4 else 99 end asc,case when score3>0 then score3 else 99 end asc,case when score2>0 then score2 else 99 end asc,case when score1>0 then score1 else 99 end asc