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 = '78') 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		BARTOŇ Tobiáš	01006225	7.8 / 11.0	42	60500	-6	77
2		HAVELKA Miroslav	22000009	5.4 / 11.0	38	44167	-2	81
2		ČERVENÝ Josef	12503400	6.0 / 12.0	38	44167	-2	82
2		BÍLEK Petr	22000003	1.6 / 6.0	38	44167	-2	76
5		NETOLICKÝ Tomáš	12400235	11.4 / 15.0	38	34000	-1	86
5		KMENT Miloslav	19900292	7.0 / 10.0	37	34000	-1	81
7		DĚDEK Petr	20800001	10.2 / 14.0	36	28750	0	86
7		HYSKÝ Jan	20800041	7.3 / 10.0	36	28750	0	82
9		VODSEĎÁLEK Tomáš	22000063	4.7 / 10.0	35	22375	1	83
9		SCIRANKA Milan	SK12316	7.3 / 10.0	35	22375	1	83
9		VALDAUF Karel	01007948	8.1 / 11.0	35	22375	1	84
9		ZNOJIL Michal	04800216	11.0 / 15.0	35	22375	1	88
13		PAVLÍK Jan	18500133	10.6 / 14.0	34	18000	2	88
13		SLAVÍČEK Martin	12502165	5.4 / 11.0	36	18000	2	85
13		KALHOUS Richard	05000797	10.6 / 14.0	34	18000	2	88
13		FOLTÁN Jiří	12400664	9.2 / 13.0	34	18000	2	87
17		HANZL Robert	22000027	8.2 / 11.0	32	14000	4	87
17		PAVLICA Martin	06801154	10.2 / 14.0	34	14000	4	90
17		KAMENÍČEK Jan	18000448	12.5 / 15.0	32	14000	4	91
17		ŠPILÁČEK Dominik	18002389	14.9 / 15.0	33	14000	4	91
21		JAROŠ Zdeněk	16401187	2.1 / 7.0	32	11450	5	84
21		VODSEĎÁLEK Adam	22000064	9.0 / 12.0	31	36450	5	89
23		MRÁZIK Martin	SK04314	12.6 / 15.0	31	9000	6	93
23		KARAS Miroslav	19600121	13.8 / 15.0	30	9000	6	93
23		KUPKA Jan	18003059	8.3 / 11.0	32	9000	6	89
23		PALKA Peter	SK17631	9.5 / 13.0	35	9000	6	91
23		HABURA Jiří	19400290	3.2 / 8.0	31	9000	6	86
28		BŘEZINA Jiří	22000041	3.0 / 8.0	29	6200	7	87
28		HRUBÝ Václav	01007079	8.2 / 11.0	31	6200	7	90
28		ČERVINKA Adolf	22000046	8.4 / 12.0	34	6200	7	91
31		BARTOŇ Petr	01000291	6.8 / 13.0	31	4750	8	93
31		BÍLEK Luboš	04400586	6.4 / 12.0	28	4750	8	92
33		KONEČNÝ Jiří	05700315	23.5 / 15.0	26	4000	10	97
34		PLECHLO Juraj	SK07682	13.1 / 15.0	25	3500	11	98
35		NOVÁK Vladimír	22000034	8.2 / 11.0	23	3000	13	96
36		STŘÍLKA Jan	10301112	18.6 / 15.0	24	2500	14	101
37		SYNEK Radim	15400029	7.8 / 11.0	22	2000	16	99
38		MAKOVSKÝ Petr	01004938	2.6 / 7.0	20	1500	17	96
39		SVĚCENÝ Petr	22000038	13.0 / 15.0	18	1000	22	109
40		CHARVÁT Martin	11900017	6.6 / 13.0	14	500	39	124