SELECT tournament_results_sumary.*, players.name as playerName, players.meno as playerMeno, players.priezvisko as playerPriezvisko, players.home_club as playerClub, players.reg_no as playerRegNo, players.hcp as playerHCPStart from `tournament_results_sumary` LEFT JOIN players ON (players.id = tournament_results_sumary.player_id) WHERE ((tournament_results_sumary.tournament_id = '177') AND (tournament_results_sumary.player_type = 'MA') ) ORDER BY result_order ASC, to_par_netto ASC, to_par_netto_druha9 ASC

#		Jméno	ČGF	HCP/HHCP	STB	BODY	TOTAL	Sum
1		NETOLICKÝ Tomáš	12400235	11.3 / 15.0	34	40000	2	89
2		PAVLÍK Jan	18500133	8.4 / 12.0	33	31167	4	88
2		KUPKA Jan	18003059	9.0 / 13.0	32	31167	4	89
2		ZELENKA Petr	09200338	8.8 / 13.0	33	31167	4	89
5		PALKA Peter	SK17631	7.1 / 11.0	31	26000	5	88
6		VALDAUF Karel	01007948	10.5 / 15.0	31	24000	6	93
7		ČERVINKA Adolf	22000046	7.7 / 11.0	31	22500	7	90
8		SCIRANKA Milan	SK12316	4.0 / 7.0	27	20250	8	87
8		VODSEĎÁLEK Tomáš	22000063	3.5 / 6.0	29	20250	8	86
10		PAVLICA Martin	06801154	8.0 / 12.0	30	16125	9	93
10		HYSKÝ Jan	20800041	5.9 / 9.0	28	16125	9	90
10		HAVELKA Miroslav	22000009	4.0 / 7.0	29	16125	9	88
10		BAUDIS Jiří	02401560	9.2 / 13.0	29	16125	9	94
14		SRB David	07801270	4.7 / 8.0	27	12750	10	90
14		BERAN Aleš	09200490	2.0 / 4.0	26	12750	10	86
14		KRŠŇÁK Vít	14300427	5.0 / 8.0	28	12750	10	90
14		KARAS Miroslav	19600121	13.6 / 15.0	31	12750	10	97
18		BŘEZINA Jiří	22000041	4.2 / 7.0	25	11500	11	90
19		HANZL Robert	22000027	8.2 / 12.0	20	10750	15	99
19		HEIDENREICH Petr	11200583	16.0 / 15.0	28	10750	15	102
21		VODSEĎÁLEK Adam	22000064	9.0 / 13.0	24	9500	16	101
21		SYNEK Radim	15400029	10.2 / 14.0	24	9500	16	102
21		KAFKA Marek	06700520	8.4 / 12.0	24	9500	16	100
24		DĚDEK Petr	20800001	6.2 / 9.0	21	8500	17	98
25		BÍLEK Luboš	04400586	2.1 / 4.0	24	7250	18	94
25		JAROŠ Zdeněk	16401187	3.2 / 6.0	21	7250	18	96
25		BABČÁK Peter	16402613	15.0 / 15.0	27	7250	18	105
25		ROUDENSKÝ Petr	14401064	17.3 / 15.0	29	7250	18	105
29		HLAVÁČ Jan	16403104	13.5 / 15.0	28	6000	19	106
30		KAMENÍČEK Jan	18000448	14.8 / 15.0	24	5000	20	107
30		STŘÍLKA Jan	10301112	15.1 / 15.0	25	5000	20	107
30		VODIČKA Petr	14800552	17.8 / 15.0	30	5000	20	107
33		FOLTÁN Jiří	12400664	8.5 / 12.0	22	4000	23	107
34		FIALA Richard	22000026	8.9 / 13.0	19	3250	25	110
34		BALARIA Abhishek	16401896	13.8 / 15.0	18	3250	25	112
36		KONEČNÝ Jiří	05700315	22.9 / 15.0	27	2500	28	115
DSQ	DSQ	ČERVENÝ Josef	12503400	7.5 / 11.0	20	0	3	56