US Open 1968 Men's Singles (August 29 - September 9)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Rod Laver
				Rod Laver
2.			bye
					Rod Laver
3.			Thomaz Koch		6-8 4-6 6-4 6-4 6-4
				Thomaz Koch
4.			bye
						Rod Laver
5.			Pancho Segura			6-2 6-1 6-1
				Pancho Segura
6.			bye
					Pancho Segura
7.			Ian Crookenden		6-3 6-4 6-1
				Ian Crookenden
8.			bye
							Cliff Drysdale
9.		[16]	Cliff Drysdale				4-6 6-4 3-6 6-1 6-1
				Cliff Drysdale
10.			bye
					Cliff Drysdale
11.			Luis Ayala		6-4 8-10 6-0 6-3
				Luis Ayala
12.			bye
						Cliff Drysdale
13.			Allan Stone			6-3 6-2 6-1
				Allan Stone
14.			bye
					Allan Stone
15.			Lew Gerrard		6-4 9-7 6-2
				Lew Gerrard
16.			bye
								Arthur Ashe Jr.
17.		[5]	Arthur Ashe Jr.					8-10 6-3 9-7 6-4
				Arthur Ashe Jr.
18.			bye
					Arthur Ashe Jr.
19.			Frank Parker		6-3 6-2 6-2
				Frank Parker
20.			bye
						Arthur Ashe Jr.
21.			Paul Hutchins			6-3 6-4 6-1
				Paul Hutchins
22.			bye
					Paul Hutchins
23.			Haroon Rahim		6-3 6-4 4-6 2-6 6-2
				Haroon Rahim
24.			bye
							Arthur Ashe Jr.
25.		[14]	Roy Emerson				6-4 9-7 6-2
				Roy Emerson
26.			bye
					Roy Emerson
27.			Sammy Giammalva Sr.		10-8 6-0 6-3
				Sammy Giammalva Sr.
28.			bye
						Roy Emerson
29.			Jeff Borowiak			6-3 6-4 6-0
				Jeff Borowiak
30.			bye
					Jeff Borowiak
31.			Ned Weld		3-6 6-4 6-4 6-2
				Ned Weld
32.			bye
									Arthur Ashe Jr.
33.		[4]	John Newcombe						4-6 8-6 7-5 6-2
				John Newcombe
34.			Allen Quay	6-1 6-3 6-3
					John Newcombe
35.			Ramanathan Krishnan		6-4 6-4 6-2
				Ramanathan Krishnan
36.			Warren Jacques	14-12 2-6 6-0 6-4
						John Newcombe
37.			Chuck McKinley Jr.			6-3 6-2 6-2
				Chuck McKinley Jr.
38.			William Tym	6-3 8-6 2-6 3-6 6-1
					Chuck McKinley Jr.
39.			Vic Seixas		6-4 6-3 6-3
				Vic Seixas
40.			Tom Gorman	8-6 6-4 6-3
							John Newcombe
41.		[15]	Marty Riessen				5-7 4-6 6-4 10-8 6-4
				Marty Riessen
42.			Zeljko Franulovic	11-9 4-6 6-3 6-4
					Torben Ulrich
43.			Torben Ulrich		3-6 6-2 6-3 6-2
				Torben Ulrich
44.			Cliff Montgomery	6-4 6-3 6-3
						Torben Ulrich
45.			Robert McKinley			6-4 6-4 6-2
				Robert McKinley
46.			Ron Goldman	14-12 9-7 6-2
					Robert McKinley
47.			Jaime Fillol		3-6 6-3 6-4 6-2
				Jaime Fillol
48.			Chris Bovett	6-4 6-1 6-0
								Clark Graebner
49.		[7]	Clark Graebner					5-7 11-9 6-1 6-4
				Clark Graebner
50.			Premjit Lall	6-3 1-6 7-5 6-4
					Clark Graebner
51.			Jim McManus		6-1 6-4 14-12
				Jim McManus
52.			Sherwood Stewart	6-3 6-4 8-6
						Clark Graebner
53.			Thomas Mozur			6-3 6-4 6-4
				Thomas Mozur
54.			Eduardo Zuleta	6-1 6-1 6-3
					George Taylor
55.			George Taylor		7-5 6-3 6-4
				George Taylor
56.			Frank Tutvin	6-3 6-1 6-1
							Clark Graebner
57.			Eugene Scott				7-5 6-0 6-3
				Eugene Scott
58.		[9]	Roger Taylor	11-9 12-10 6-4
					Eugene Scott
59.			Patricio Cornejo		6-3 6-3 6-2
				Patricio Cornejo
60.			Tom Leonard	6-4 6-4 12-10
						Eugene Scott
61.			Paul Gerken			6-2 8-6 6-4
				Paul Gerken
62.			William Harris	6-2 3-6 6-3 6-0
					Paul Gerken
63.			Dan O'Bryant		16-18 6-2 4-6 8-6 6-0
				Dan O'Bryant
64.		[LL]	Paul Cranis	6-2 6-2 6-4
										Arthur Ashe Jr.
65.			Joaquin Loyo-Mayo							14-12 5-7 6-3 3-6 6-3
				Joaquin Loyo-Mayo
66.			Frank Robbins	8-6 16-14 21-19
					Joaquin Loyo-Mayo
67.			John Sharpe		5-7 3-6 6-4 6-3 6-1
				John Sharpe
68.			Armistead Neely	3-6 6-3 6-3 5-7 6-3
						Dennis Ralston
69.			Richard Russell			9-11 6-2 3-6 7-5 6-1
				Richard Russell
70.			Stanley Pasarell	6-1 6-3 6-8 7-5
					Dennis Ralston
71.		[6]	Dennis Ralston		6-1 6-4 6-1
				Dennis Ralston
72.			Chauncey Steele III	6-3 6-0 6-4
							Dennis Ralston
73.			Niki Pilic				2-6 6-2 5-7 13-11 6-3
				Niki Pilic
74.			Butch Seewagen	6-3 6-4 3-6 6-4
					Niki Pilic
75.			Dick Dell		6-1 6-4 6-2
				Dick Dell
76.			Alberto Carrero	6-4 6-3 2-6 2-6 9-7
						Niki Pilic
77.			Tom Edlefsen			6-4 9-7 4-6 6-4
				Tom Edlefsen
78.			William Knight	6-1 6-4 9-7
					Charlie Pasarell
79.		[12]	Charlie Pasarell		6-1 9-7 6-2
				Charlie Pasarell
80.			Karl Coombes	11-9 7-5 6-1
								Ken Rosewall
81.			Marcelo Lara					6-2 6-2 6-3
				Marcelo Lara
82.			Paul Sullivan	9-7 6-1 4-6 8-6
					Marcelo Lara
83.			Dick Stockton		2-6 7-5 7-5 6-2
				Dick Stockton
84.			Robert Perry	4-6 6-0 7-5 7-5
						Ken Rosewall
85.			Tony Palafox			6-1 6-3 6-1
				Tony Palafox
86.			Erik Van Dillen	6-4 4-6 6-2 6-4
					Ken Rosewall
87.		[3]	Ken Rosewall		6-0 6-1 6-0
				Ken Rosewall
88.			James Parker	6-3 6-3 6-4
							Ken Rosewall
89.			Ron Holmberg				6-3 6-3 2-6 8-6
				Ron Holmberg
90.			Humphrey Hose	6-2 6-3 6-4
					Ron Holmberg
91.			Jim Osborne		11-9 7-5 11-9
				Jim Osborne
92.			Barry MacKay	8-6 4-6 7-5 6-3
						Ron Holmberg
93.			Bob Lutz			6-4 11-9 7-5
				Bob Lutz
94.			Peter Burwash	6-1 6-1 6-3
					Bob Lutz
95.			Ray Moore		6-8 8-6 2-6 6-4 7-5
				Ray Moore
96.		[10]	Andres Gimeno	4-6 6-1 6-2 6-1
									Tom Okker
97.			Pierre Barthes						8-6 6-4 6-8 6-1
				Pierre Barthes
98.			bye
					Pierre Barthes
99.			Peter Fishbach		14-12 6-2 9-7
				Peter Fishbach
100.			bye
						Tom Okker
101.			Lenny Schloss			6-2 13-11 7-5
				Lenny Schloss
102.			bye
					Tom Okker
103.		[8]	Tom Okker		6-1 6-0 6-4
				Tom Okker
104.			bye
							Tom Okker
105.			John Brown				8-6 2-6 6-3 6-2
				John Brown
106.			bye
					John Brown
107.			Ingo Buding		6-3 2-6 7-5 6-8 11-9
				Ingo Buding
108.			bye
						Peter Curtis
109.			Peter Curtis			6-4 3-6 4-6 8-6 6-1
				Peter Curtis
110.			bye
					Peter Curtis
111.		[11]	Fred Stolle		6-8 6-2 4-6 6-3 8-6
				Fred Stolle
112.			bye
								Tom Okker
113.			Mal Anderson					14-16 6-3 10-8 6-3
				Mal Anderson
114.			bye
					Mal Anderson
115.			Pancho Guzman		6-1 6-1 6-2
				Pancho Guzman
116.			bye
						Pancho Gonzalez
117.			Colin Stubs			6-4 6-4 6-4
				Colin Stubs
118.			bye
					Pancho Gonzalez
119.		[13]	Pancho Gonzalez		6-2 6-2 6-2
				Pancho Gonzalez
120.			bye
							Pancho Gonzalez
121.			Alex Olmedo				8-6 6-4 6-2
				Alex Olmedo
122.			bye
					Alex Olmedo
123.			Dan Bleckinger		w/o
				Dan Bleckinger
124.			bye
						Tony Roche
125.			Stan Smith			6-2 8-6 6-4
				Stan Smith
126.			bye
					Tony Roche
127.		[2]	Tony Roche		3-6 10-8 3-6 6-4 6-4
				Tony Roche
128.			bye

(default) 17 queries took 70 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Tournament`.`id`, `Tournament`.`name`, `Tournament`.`slug`, `Tournament`.`subtitle`, `Tournament`.`description`, `Tournament`.`surface`, `Tournament`.`venue`, `Tournament`.`eras`, `Tournament`.`history`, `Tournament`.`president`, `Tournament`.`PrizeMoney`, `Tournament`.`grandslam`, `Tournament`.`created`, `Tournament`.`modified` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`slug` = 'us-open' LIMIT 1	1	1	2
2	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`tournament_id` = (4)	5	5	7
3	SELECT `Quote`.`id`, `Quote`.`tournament_id`, `Quote`.`quote`, `Quote`.`by`, `Quote`.`source`, `Quote`.`created`, `Quote`.`created_by`, `Quote`.`modified`, `Quote`.`modified_by` FROM `zavoihu1_db4tennis`.`quotes` AS `Quote` WHERE `Quote`.`tournament_id` = (4)	3	3	2
4	SELECT `Tournamenttotal`.`id`, `Tournamenttotal`.`tournament_id`, `Tournamenttotal`.`year`, `Tournamenttotal`.`price_money`, `Tournamenttotal`.`attendance`, `Tournamenttotal`.`created`, `Tournamenttotal`.`created_by`, `Tournamenttotal`.`modified`, `Tournamenttotal`.`modified_by` FROM `zavoihu1_db4tennis`.`tournamenttotals` AS `Tournamenttotal` WHERE `Tournamenttotal`.`tournament_id` = (4)	2	2	7
5	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by`, `Tournament`.`id`, `Tournament`.`name`, `Tournament`.`slug`, `Tournament`.`subtitle`, `Tournament`.`description`, `Tournament`.`surface`, `Tournament`.`venue`, `Tournament`.`eras`, `Tournament`.`history`, `Tournament`.`president`, `Tournament`.`PrizeMoney`, `Tournament`.`grandslam`, `Tournament`.`created`, `Tournament`.`modified` FROM `zavoihu1_db4tennis`.`categories` AS `Category` LEFT JOIN `zavoihu1_db4tennis`.`tournaments` AS `Tournament` ON (`Category`.`tournament_id` = `Tournament`.`id`) WHERE `Tournament`.`slug` = 'us-open' AND `Category`.`slug` = 'men-singles' LIMIT 1	1	1	9
6	SELECT `Contest`.`id`, `Contest`.`category_id`, `Contest`.`year`, `Contest`.`slug`, `Contest`.`ch`, `Contest`.`date_from`, `Contest`.`date_to`, `Contest`.`book`, `Contest`.`name_of_the_tournament`, `Contest`.`location`, `Contest`.`venue`, `Contest`.`surface`, `Contest`.`participants`, `Contest`.`prize_money`, `Contest`.`attendance`, `Contest`.`misc`, `Contest`.`final_misc`, `Contest`.`created`, `Contest`.`created_by`, `Contest`.`modified`, `Contest`.`modified_by` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = (22) ORDER BY `Contest`.`year` ASC	144	144	7
7	SELECT `Contest`.`id`, `Contest`.`category_id`, `Contest`.`year`, `Contest`.`slug`, `Contest`.`ch`, `Contest`.`date_from`, `Contest`.`date_to`, `Contest`.`book`, `Contest`.`name_of_the_tournament`, `Contest`.`location`, `Contest`.`venue`, `Contest`.`surface`, `Contest`.`participants`, `Contest`.`prize_money`, `Contest`.`attendance`, `Contest`.`misc`, `Contest`.`final_misc`, `Contest`.`created`, `Contest`.`created_by`, `Contest`.`modified`, `Contest`.`modified_by`, `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` LEFT JOIN `zavoihu1_db4tennis`.`categories` AS `Category` ON (`Contest`.`category_id` = `Category`.`id`) WHERE `Category`.`tournament_id` = 4 AND `Contest`.`category_id` = 22 AND `Contest`.`slug` = '1968' LIMIT 1	1	1	2
8	SELECT `Match`.`id`, `Match`.`contest_id`, `Match`.`player_a_id`, `Match`.`player_aa_id`, `Match`.`player_b_id`, `Match`.`player_bb_id`, `Match`.`results`, `Match`.`long`, `Match`.`attendance`, `Match`.`no`, `Match`.`round`, `Match`.`round_id`, `Match`.`note`, `Match`.`created`, `Match`.`created_by`, `Match`.`modified`, `Match`.`modified_by` FROM `zavoihu1_db4tennis`.`matches` AS `Match` WHERE `Match`.`contest_id` = (602) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	127	127	4
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (715, 3344, 2712, 3352, 3305, 2946, 817, 720, 3215, 2443, 3508, 3509, 689, 2955, 3498, 3151, 761, 3040, 3147, 704, 3115, 3364, 675, 3446, 3168, 3510, 3014, 3460, 3459, 3285, 3437, 3444, 3249, 802, 785, 3451, 3489, 3239, 3608, 3421, 3124, 798, 3385, 3494, 3511, 3407, 3609, 3061, 3442, 3500, 823, 3391, 3596, 3504, 3175, 3299, 787, 2521, 3474, 3432, 3335, 3109, 3005, 3513, 3425, 3219, 3490, 683, 3261, 3502, 653, 3403, 734, 3506, 3358, 732, 3436, 3512, 3388, 747, 3376, 3458, 3431, 3380, 3606, 790, 3486, 729, 684, 3396, 765, 2845, 748, 3501, 3386, 3349) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	96	96	2
10	SELECT `Playercontest`.`id`, `Playercontest`.`player_id`, `Playercontest`.`contest_id`, `Playercontest`.`nat_id`, `Playercontest`.`draw` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE `Playercontest`.`contest_id` = 602	96	96	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 13, 135, 173, 219, 212, 196, 86, 58, 41, 54, 121, 172, 151, 68, 133, 29, 201, 141, 36, 93)	21	21	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 13, 135, 173, 219, 212, 196, 86, 58, 41, 54, 121, 172, 151, 68, 133, 29, 201, 141, 36, 93)	21	21	5
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (715, 3344, 2712, 3352, 3305, 2946, 817, 720, 3215, 2443, 3508, 3509, 689, 2955, 3498, 3151, 761, 3040, 3147, 704, 3115, 3364, 675, 3446, 3168, 3510, 3014, 3460, 3459, 3285, 3437, 3444, 3249, 802, 785, 3451, 3489, 3239, 3608, 3421, 3124, 798, 3385, 3494, 3511, 3407, 3609, 3061, 3442, 3500, 823, 3391, 3596, 3504, 3175, 3299, 787, 2521, 3474, 3432, 3335, 3109, 3005, 3513, 3425, 3219, 3490, 683, 3261, 3502, 653, 3403, 734, 3506, 3358, 732, 3436, 3512, 3388, 747, 3376, 3458, 3431, 3380, 3606, 790, 3486, 729, 684, 3396, 765, 2845, 748, 3501, 3386, 3349)) AND (`Playercontest`.`contest_id` = 602))	96	96	15
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 22 ORDER BY `Contest`.`date_from` ASC	144	144	2
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1968	19	19	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 3, 1, 12, 17, 22, 13, 18, 23, 4, 7, 14, 24, 25, 19, 15, 16, 20, 21) AND `Category`.`gender` = 'Men' AND `Category`.`type` = 'Singles'	4	4	1
17	SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 3, 4)	4	4	1

(default) 17 queries took 70 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Tournament`.`id`, `Tournament`.`name`, `Tournament`.`slug`, `Tournament`.`subtitle`, `Tournament`.`description`, `Tournament`.`surface`, `Tournament`.`venue`, `Tournament`.`eras`, `Tournament`.`history`, `Tournament`.`president`, `Tournament`.`PrizeMoney`, `Tournament`.`grandslam`, `Tournament`.`created`, `Tournament`.`modified` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`slug` = 'us-open' LIMIT 1

SELECT `Quote`.`id`, `Quote`.`tournament_id`, `Quote`.`quote`, `Quote`.`by`, `Quote`.`source`, `Quote`.`created`, `Quote`.`created_by`, `Quote`.`modified`, `Quote`.`modified_by` FROM `zavoihu1_db4tennis`.`quotes` AS `Quote` WHERE `Quote`.`tournament_id` = (4)

SELECT `Tournamenttotal`.`id`, `Tournamenttotal`.`tournament_id`, `Tournamenttotal`.`year`, `Tournamenttotal`.`price_money`, `Tournamenttotal`.`attendance`, `Tournamenttotal`.`created`, `Tournamenttotal`.`created_by`, `Tournamenttotal`.`modified`, `Tournamenttotal`.`modified_by` FROM `zavoihu1_db4tennis`.`tournamenttotals` AS `Tournamenttotal` WHERE `Tournamenttotal`.`tournament_id` = (4)

SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by`, `Tournament`.`id`, `Tournament`.`name`, `Tournament`.`slug`, `Tournament`.`subtitle`, `Tournament`.`description`, `Tournament`.`surface`, `Tournament`.`venue`, `Tournament`.`eras`, `Tournament`.`history`, `Tournament`.`president`, `Tournament`.`PrizeMoney`, `Tournament`.`grandslam`, `Tournament`.`created`, `Tournament`.`modified` FROM `zavoihu1_db4tennis`.`categories` AS `Category` LEFT JOIN `zavoihu1_db4tennis`.`tournaments` AS `Tournament` ON (`Category`.`tournament_id` = `Tournament`.`id`) WHERE `Tournament`.`slug` = 'us-open' AND `Category`.`slug` = 'men-singles' LIMIT 1

144

SELECT `Contest`.`id`, `Contest`.`category_id`, `Contest`.`year`, `Contest`.`slug`, `Contest`.`ch`, `Contest`.`date_from`, `Contest`.`date_to`, `Contest`.`book`, `Contest`.`name_of_the_tournament`, `Contest`.`location`, `Contest`.`venue`, `Contest`.`surface`, `Contest`.`participants`, `Contest`.`prize_money`, `Contest`.`attendance`, `Contest`.`misc`, `Contest`.`final_misc`, `Contest`.`created`, `Contest`.`created_by`, `Contest`.`modified`, `Contest`.`modified_by`, `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` LEFT JOIN `zavoihu1_db4tennis`.`categories` AS `Category` ON (`Contest`.`category_id` = `Category`.`id`) WHERE `Category`.`tournament_id` = 4 AND `Contest`.`category_id` = 22 AND `Contest`.`slug` = '1968' LIMIT 1

SELECT `Match`.`id`, `Match`.`contest_id`, `Match`.`player_a_id`, `Match`.`player_aa_id`, `Match`.`player_b_id`, `Match`.`player_bb_id`, `Match`.`results`, `Match`.`long`, `Match`.`attendance`, `Match`.`no`, `Match`.`round`, `Match`.`round_id`, `Match`.`note`, `Match`.`created`, `Match`.`created_by`, `Match`.`modified`, `Match`.`modified_by` FROM `zavoihu1_db4tennis`.`matches` AS `Match` WHERE `Match`.`contest_id` = (602) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC

127

SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (715, 3344, 2712, 3352, 3305, 2946, 817, 720, 3215, 2443, 3508, 3509, 689, 2955, 3498, 3151, 761, 3040, 3147, 704, 3115, 3364, 675, 3446, 3168, 3510, 3014, 3460, 3459, 3285, 3437, 3444, 3249, 802, 785, 3451, 3489, 3239, 3608, 3421, 3124, 798, 3385, 3494, 3511, 3407, 3609, 3061, 3442, 3500, 823, 3391, 3596, 3504, 3175, 3299, 787, 2521, 3474, 3432, 3335, 3109, 3005, 3513, 3425, 3219, 3490, 683, 3261, 3502, 653, 3403, 734, 3506, 3358, 732, 3436, 3512, 3388, 747, 3376, 3458, 3431, 3380, 3606, 790, 3486, 729, 684, 3396, 765, 2845, 748, 3501, 3386, 3349) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC

SELECT `Playercontest`.`id`, `Playercontest`.`player_id`, `Playercontest`.`contest_id`, `Playercontest`.`nat_id`, `Playercontest`.`draw` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE `Playercontest`.`contest_id` = 602

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 13, 135, 173, 219, 212, 196, 86, 58, 41, 54, 121, 172, 151, 68, 133, 29, 201, 141, 36, 93)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 13, 135, 173, 219, 212, 196, 86, 58, 41, 54, 121, 172, 151, 68, 133, 29, 201, 141, 36, 93)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (715, 3344, 2712, 3352, 3305, 2946, 817, 720, 3215, 2443, 3508, 3509, 689, 2955, 3498, 3151, 761, 3040, 3147, 704, 3115, 3364, 675, 3446, 3168, 3510, 3014, 3460, 3459, 3285, 3437, 3444, 3249, 802, 785, 3451, 3489, 3239, 3608, 3421, 3124, 798, 3385, 3494, 3511, 3407, 3609, 3061, 3442, 3500, 823, 3391, 3596, 3504, 3175, 3299, 787, 2521, 3474, 3432, 3335, 3109, 3005, 3513, 3425, 3219, 3490, 683, 3261, 3502, 653, 3403, 734, 3506, 3358, 732, 3436, 3512, 3388, 747, 3376, 3458, 3431, 3380, 3606, 790, 3486, 729, 684, 3396, 765, 2845, 748, 3501, 3386, 3349)) AND (`Playercontest`.`contest_id` = 602))

SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 22 ORDER BY `Contest`.`date_from` ASC

144

SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1968

SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 3, 1, 12, 17, 22, 13, 18, 23, 4, 7, 14, 24, 25, 19, 15, 16, 20, 21) AND `Category`.`gender` = 'Men' AND `Category`.`type` = 'Singles'

SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 3, 4)