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 = '16') 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		HAVELKA Miroslav	22000009	7.2 / 10.0	33	67500	-13	86
1		BÍLEK Luboš	04400586	3.4 / 6.0	42	67600	-13	72
2		VALDAUF Karel	01007948	9.4 / 13.0	32	47500	-10	89
2		ŠMÍDA Jan	16401023	2.0 / 4.0	36	47600	-10	77
3		DĚDEK Petr	20800001	10.0 / 14.0	34	37600	-8	88
3		ČERVINKA Adolf	22000046	6.2 / 9.0	27	37500	-8	90
4		BROŽ Jiří	13800050	12.8 / 15.0	33	28500	-7	90
4		ČERMÁK Patrik	10000107	5.5 / 8.0	36	28600	-7	80
5		KALHOUS Richard	05000797	9.0 / 13.0	31	22500	-6	90
5		KMENT Miloslav	19900292	7.9 / 11.0	39	22600	-6	80
6		ŠLÉGR Lukáš	18005067	15.9 / 15.0	25	17000	-6	100
6		KAREL Libor	09802578	12.2 / 15.0	37	17100	-6	86
7		VAGNER Karel	15400283	9.5 / 13.0	36	13100	-6	85
7		KAMENÍČEK Jan	18000448	11.6 / 15.0	25	13000	-6	101
8		NOVÁK Vladimír	22000034	8.2 / 12.0	34	9100	-6	86
8		BŘEZINA Jiří	22000041	3.8 / 6.0	31	9000	-6	84
9		KARAS Miroslav	19600121	13.8 / 15.0	28	5000	-6	95
9		BERAN Aleš	09200490	3.2 / 6.0	35	5100	-6	80
10		FIALA Richard	22000026	11.6 / 15.0	32	2500	-6	96
10		HANZL Robert	22000027	9.7 / 14.0	34	2600	-6	88
11		KUDERA Tomáš	12500104	11.3 / 15.0	29	0	-6	96
11		MRÁKOTA David	16401024	0.9 / 3.0	34	0	-6	80
12		MÍKA Pavel	15400382	11.2 / 15.0	32	0	-6	94
12		FOLTÁN Jiří	12400664	7.9 / 11.0	32	0	-6	89
13		SVĚCENÝ Petr	22000038	12.8 / 15.0	33	0	-5	90
13		ŠMICER Vladimír	13300262	7.0 / 10.0	36	0	-5	82
14		CHARVÁT Martin	11900017	9.1 / 13.0	39	0	-5	86
14		MACHÁČEK Vladimír	11900011	3.9 / 6.0	24	0	-5	91
15		FLÉGL Vojtěch	11900016	5.2 / 8.0	28	0	-5	91
15		PAVLICA Martin	06801154	10.1 / 14.0	34	0	-5	88
16		BÍLEK Petr	22000003	2.2 / 4.0	28	0	-5	86
16		HRUBÝ Václav	01007079	7.6 / 11.0	32	0	-5	87
17		VODSEĎÁLEK Adam	22000064	17.5 / 15.0	24	0	-4	99
17		HYSKÝ Jan	20800041	6.7 / 10.0	35	0	-4	83
18		PALKA Peter	SK17631	12.8 / 15.0	30	0	-3	93
18		VODSEĎÁLEK Tomáš	22000063	6.4 / 9.0	32	0	-3	85
19		NETOLICKÝ Tomáš	12400235	9.5 / 13.0	33	0	-2	91
19		KVERKA Zdeněk	14300285	8.7 / 12.0	22	0	-2	105
20		KOBÁSKO Roman	09200706	8.7 / 12.0	27	0	-1	97
20		HOŘEJŠÍ Miroslav	16400734	8.1 / 12.0	28	0	-1	94
21		BARTOŇ Petr	01000291	7.0 / 10.0	34	0	0	84
21		FATKA Ondřej	05001157	15.4 / 15.0	18	0	0	107
22		POTOCKÝ Robert	SK11238	13.4 / 15.0	27	0	0	99
22		JANOŠ Martin	19600075	8.2 / 12.0	25	0	0	103
23		JAROŠ Zdeněk	16401187	5.4 / 8.0	23	0	1	94
23		ČERVENÝ Josef	12503400	3.6 / 6.0	31	0	1	83
24		ŽIŽKA Petr	15400080	11.3 / 15.0	29	0	2	99
24		POLÁK Jiří	09800080	3.0 / 5.0	23	0	2	94
25		VYMETÁLEK Petr	11900076	18.6 / 15.0	19	0	4	112
25		KRÁL Martin	01901452	10.6 / 15.0	26	0	4	98
26		CULEK Jan	06800175	14.4 / 15.0	22	0	5	104
26		CULEK Adam	06800199	3.1 / 5.0	26	0	5	92
27		BŘEZINA Karel	20500299	22.4 / 15.0	12	0	9	118
27		KESZELI Štěpán	09807761	14.2 / 15.0	29	0	9	97
28		KEŠNER Josef	04400926	10.5 / 15.0	37	0	0	88
28		KUPKA Jan	18003059	9.8 / 14.0	27	0	0	107