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 = '54') 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		VODSEĎÁLEK Tomáš	22000063	5.7 / 8.0	37	0	-1	78
2		ČERVINKA Adolf	22000046	7.8 / 10.0	35	0	1	82
3		ŠMÍDA Jan	16401023	2.6 / 4.0	34	0	2	77
3		CHARVÁT Martin	11900017	7.5 / 10.0	34	0	2	83
5		SVĚCENÝ Petr	22000038	12.6 / 15.0	33	0	3	89
6		BÍLEK Petr	22000003	2.3 / 4.0	32	0	4	79
6		KMENT Miloslav	19900292	6.1 / 8.0	32	0	4	83
6		DĚDEK Petr	20800001	10.7 / 14.0	33	0	4	89
9		ČERMÁK Patrik	10000107	5.2 / 7.0	32	0	5	83
9		PALKA Peter	SK17631	10.3 / 13.0	32	0	5	89
11		MACHÁČEK Vladimír	11900011	3.3 / 5.0	30	0	6	82
12		MRÁKOTA David	16401024	2.6 / 4.0	29	0	7	82
12		KAFKA Marek	06700520	8.8 / 11.0	29	0	7	89
14		HAVELKA Miroslav	22000009	6.1 / 8.0	28	0	8	87
15		HRUBÝ Václav	01007079	6.9 / 9.0	30	0	9	89
15		BŘEZINA Jiří	22000041	2.9 / 5.0	27	0	9	85
15		KAMENÍČEK Jan	18000448	12.0 / 15.0	28	0	9	95
18		VALDAUF Karel	01007948	9.1 / 12.0	25	0	14	97
19		BÍLEK Luboš	04400586	4.7 / 7.0	22	0	15	93
20		ČERVENÝ Josef	12503400	5.3 / 7.0	22	0	16	94
20		KALHOUS Richard	05000797	9.5 / 12.0	27	0	16	114