back to overall

US Open 1972 Men's Singles  (August 30 - September 10)

NationR256R128R64R32R16QFSFFChampion
1.United States (USA)[1]Stan Smith
Stan Smith
2.bye
Stan Smith
3.United States (USA)Billy Martin5-7 6-1 7-5 6-3
Billy Martin
4.bye
Stan Smith
5.United States (USA)Clark Graebner6-1 6-4 6-7 6-0
Clark Graebner
6.bye
Clark Graebner
7.Italy (ITA)Adriano Panatta4-6 6-3 7-5 6-2
Adriano Panatta
8.bye
Stan Smith
9.Australia (AUS)Allan Stone6-3 7-6 7-5
Allan Stone
10.bye
Allan Stone
11.Chile (CHI)Jaime Pinto6-4 6-4 6-7 6-4
Jaime Pinto
12.bye
Allan Stone
13.Spain (ESP)Antonio Munoz6-1 6-0 6-7 6-0
Antonio Munoz
14.bye
Antonio Munoz
15.United States (USA)Ron Holmberg6-4 6-7 6-3 6-4
Ron Holmberg
16.bye
Stan Smith
17.Spain (ESP)[14]Andres Gimeno2-6 7-6 6-4 1-6 6-3
Andres Gimeno
18.bye
Andres Gimeno
19.Soviet Union (URS)Vladimir Korotkov6-4 7-5 6-4
Vladimir Korotkov
20.bye
Andres Gimeno
21.Australia (AUS)Owen Davidson6-4 4-6 6-4 6-1
Owen Davidson
22.bye
Owen Davidson
23.United States (USA)Charlie Owens6-4 7-6 3-6 4-6 6-3
Charlie Owens
24.bye
Andres Gimeno
25.Australia (AUS)Ray Ruffels5-2 rtd.
Ray Ruffels
26.bye
Ray Ruffels
27.United States (USA)Fred McNair6-2 6-3 6-4
Fred McNair
28.bye
Ray Ruffels
29.United States (USA)William Brown6-3 7-5 6-4
William Brown
30.bye
William Brown
31.United States (USA)Jim Delaney6-7 6-4 6-4 6-4
Jim Delaney
32.bye
Arthur Ashe Jr.
33.United States (USA)[6]Arthur Ashe Jr.7-6 6-4 7-5
Arthur Ashe Jr.
34.bye
Arthur Ashe Jr.
35.Pakistan (PAK)Haroon Rahim6-3 6-3 4-6 7-6
Haroon Rahim
36.bye
Arthur Ashe Jr.
37.South Africa (RSA)Bob Maud6-4 6-4 7-6
Bob Maud
38.bye
Bob Maud
39.Japan (JPN)Jun Kamiwazumi6-2 6-7 6-2 6-4
Jun Kamiwazumi
40.bye
Arthur Ashe Jr.
41.Australia (AUS)Ross Case6-4 6-4 3-6 6-1
Ross Case
42.bye
Ross Case
43.United States (USA)Fritz Schunck6-3 6-2 6-4
Fritz Schunck
44.bye
Ross Case
45.Australia (AUS)John Alexander7-6 7-6 4-6 3-6 6-4
John Alexander
46.bye
John Alexander
47.Australia (AUS)Phil Dent4-6 7-6 6-4 4-6 6-4
Phil Dent
48.bye
Arthur Ashe Jr.
49.United States (USA)[13]Bob Lutz5-7 7-5 6-4 6-3
Bob Lutz
50.bye
Bob Lutz
51.Australia (AUS)Colin Dibley6-4 6-2 6-2
Colin Dibley
52.bye
Bob Lutz
53.Argentina (ARG)Guillermo Vilas6-3 6-3 7-5
Guillermo Vilas
54.bye
Guillermo Vilas
55.India (IND)Sashi Menon7-6 6-4 6-4
Sashi Menon
56.bye
Bob Lutz
57.United States (USA)Eugene Scott7-6 6-2 6-2
Eugene Scott
58.bye
Eugene Scott
59.United States (USA)Robert Kreiss6-3 6-4 6-4
Robert Kreiss
60.bye
Eugene Scott
61.India (IND)Anand Amritraj3-6 6-4 7-6 7-5
Anand Amritraj
62.bye
Anand Amritraj
63.South Africa (RSA)Derek Schroder7-6 6-3 6-4
Derek Schroder
64.bye
Arthur Ashe Jr.
65.Australia (AUS)[3]Rod Laver6-1 6-4 7-6
Rod Laver
66.bye
Rod Laver
67.United Kingdom (GBR)John Paish6-2 6-1 6-3
John Paish
68.bye
Rod Laver
69.United States (USA)Butch Seewagen6-3 6-2 7-5
Butch Seewagen
70.bye
Butch Seewagen
71.United Kingdom (GBR)Stephen Warboys7-6 4-6 7-5 6-2
Stephen Warboys
72.bye
Rod Laver
73.Chile (CHI)Jaime Fillol6-2 4-6 6-7 6-1 7-6
Jaime Fillol
74.bye
Jaime Fillol
75.Czechoslovakia (TCH)Frantisek Pala6-4 6-1 6-2
Frantisek Pala
76.bye
Jaime Fillol
77.New Zealand (NZL)Brian Fairlie6-4 7-5 6-3
Brian Fairlie
78.bye
Brian Fairlie
79.United States (USA)Jeff Austin7-6 6-3 6-2
Jeff Austin
80.bye
Cliff Richey Jr.
81.United States (USA)[12]Cliff Richey Jr.3-6 7-6 7-6 6-3
Cliff Richey Jr.
82.bye
Cliff Richey Jr.
83.United States (USA)Brian Gottfried6-2 7-6 6-2
Brian Gottfried
84.bye
Cliff Richey Jr.
85.United States (USA)Alex Olmedo6-2 6-3 7-6
Alex Olmedo
86.bye
Alex Olmedo
87.United States (USA)Alexander Guerry6-3 7-6 6-7 7-6
Alexander Guerry
88.bye
Cliff Richey Jr.
89.United States (USA)Paul Gerken6-7 6-3 7-6 6-7 6-4
Paul Gerken
90.bye
Paul Gerken
91.United States (USA)Pancho Walthall7-6 6-1 6-2
Pancho Walthall
92.bye
Paul Gerken
93.France (FRA)Georges Goven6-4 6-1 6-7 5-7 7-5
Georges Goven
94.bye
Georges Goven
95.United States (USA)Chico Hagey0-0 rtd.
Chico Hagey
96.bye
Cliff Richey Jr.
97.Czechoslovakia (TCH)[8]Jan Kodes3-6 6-1 6-4 6-2
Jan Kodes
98.bye
Jan Kodes
99.United States (USA)Dan O'Bryant6-2 6-4 6-3
Dan O'Bryant
100.bye
Sandy Mayer
101.United States (USA)Sandy Mayer6-7 3-6 7-6 6-3 6-1
Sandy Mayer
102.bye
Sandy Mayer
103.France (FRA)Jean-Baptiste Chanfreau6-4 6-1 6-3
Jean-Baptiste Chanfreau
104.bye
Sandy Mayer
105.Mexico (MEX)Raul Ramirez6-3 6-3 6-1
Raul Ramirez
106.United States (USA)Sammy Giammalva Sr.4-6 6-2 6-3 6-3
Raul Ramirez
107.India (IND)Jasjit Singh6-4 3-6 6-2 6-1
Jasjit Singh
108.United States (USA)Steve Turner6-3 7-6 6-3
Raul Ramirez
109.France (FRA)Patrick Proisy6-2 2-6 1-6 7-6 6-4
Patrick Proisy
110.bye
Patrick Proisy
111.United States (USA)Patrick Dupre6-1 6-4 6-2
Patrick Dupre
112.bye
Frew McMillan
113.United States (USA)[9]Marty Riessen6-3 6-4 3-6 6-7 6-4
Marty Riessen
114.United States (USA)Brian Teacher6-3 7-5 3-6 6-3
Marty Riessen
115.Australia (AUS)Geoff Masters6-1 6-7 6-3 6-2
Geoff Masters
116.Australia (AUS)Ian Fletcher7-5 7-6 6-7 7-5
Marty Riessen
117.Australia (AUS)Mal Anderson6-3 7-5 6-7 7-5
Mal Anderson
118.United States (USA)Norman Holmes6-1 6-2 7-6
Mal Anderson
119.South Africa (RSA)Ray Moore6-4 7-5 6-7 6-1
Ray Moore
120.United Kingdom (GBR)Graham Stilwell6-3 7-6 6-2
Frew McMillan
121.South Africa (RSA)Frew McMillan6-2 7-6 4-6 6-4
Frew McMillan
122.United States (USA)Erik Van Dillen7-5 7-6 3-6 7-6
Frew McMillan
123.France (FRA)Jean-Loup Rouyer7-5 7-5 7-6
Jean-Loup Rouyer
124.United Kingdom (GBR)Stanley Matthews6-7 6-3 7-6 6-1
Frew McMillan
125.United States (USA)Tom Leonard6-2 6-3 6-4
Tom Leonard
126.United States (USA)Kenneth McMillan4-6 7-6 7-6 6-3
Tom Leonard
127.United States (USA)William Higgins6-3 3-6 6-7 6-4 7-6
William Higgins
128.Brazil (BRA)Thomaz Koch4-6 7-6 7-6 7-6
Ilie Nastase
129.United States (USA)Charlie Pasarell3-6 6-3 6-7 6-4 6-3
Charlie Pasarell
130.Australia (AUS)Terry Addison5-7 6-3 6-4 5-7 6-4
Charlie Pasarell
131.United States (USA)Robert McKinley6-3 6-4 7-6
Robert McKinley
132.South Africa (RSA)Terry Ryan3-6 7-5 7-6 6-3
Charlie Pasarell
133.United States (USA)Vitas Gerulaitis7-6 6-3 6-2
Vitas Gerulaitis
134.United States (USA)Armistead Neely7-5 7-5 6-2
Vitas Gerulaitis
135.India (IND)Vijay Amritraj2-6 6-3 6-2 6-3
Vijay Amritraj
136.Italy (ITA)Corrado Barazzutti6-4 6-4 6-2
Cliff Drysdale
137.France (FRA)Wanaro N'Godrella7-5 4-6 6-4 6-3
Wanaro N'Godrella
138.United States (USA)Steve Krulevitz6-7 7-5 6-4 6-3
Wanaro N'Godrella
139.United States (USA)George Hardie6-2 4-6 6-3 6-4
George Hardie
140.Rhodesia (RHO)Douglas Irvine1-6 6-3 6-1 3-6 6-3
Cliff Drysdale
141.South Africa (RSA)[11]Cliff Drysdale6-3 4-6 6-1 6-4
Cliff Drysdale
142.Australia (AUS)Barry Phillips-Moore6-4 6-1 6-1
Cliff Drysdale
143.Canada (CAN)Michael Belkin5-5 rtd.
Michael Belkin
144.Sweden (SWE)Ove Bengston7-5 6-3 1-6 6-2
Fred Stolle
145.Australia (AUS)Fred Stolle4-6 7-6 6-4 7-6
Fred Stolle
146.United States (USA)Herb Fitzgibbon7-6 6-4 6-2
Fred Stolle
147.Australia (AUS)Roy Emerson6-7 6-4 6-2 6-2
Roy Emerson
148.Sweden (SWE)Bjorn Borg7-5 6-7 6-4 6-4
Fred Stolle
149.United States (USA)Mike Machette6-3 6-4 6-3
Mike Machette
150.bye
Mike Machette
151.Czechoslovakia (TCH)Milan Holecek1-6 7-6 6-4 6-4
Milan Holecek
152.bye
Fred Stolle
153.United States (USA)Eddie Dibbs7-6 6-4 5-7 7-6
Eddie Dibbs
154.bye
Eddie Dibbs
155.United States (USA)Jeff Borowiak6-2 6-7 6-3 7-6
Jeff Borowiak
156.bye
John Newcombe
157.Australia (AUS)[5]John Newcombe6-3 6-4 6-3
John Newcombe
158.bye
John Newcombe
159.Soviet Union (URS)Teimuraz Kakulia6-1 6-2 6-4
Teimuraz Kakulia
160.bye
Ilie Nastase
161.Chile (CHI)Patricio Cornejo6-4 3-6 6-3 6-2
Patricio Cornejo
162.bye
Patricio Cornejo
163.United States (USA)Donald Dell6-4 5-7 6-4 7-6
Donald Dell
164.bye
Patricio Cornejo
165.Czechoslovakia (TCH)Jan Kukal6-3 6-4 6-2
Jan Kukal
166.bye
Jan Kukal
167.Jamaica (JAM)Richard Russell6-4 4-6 3-6 6-3 6-4
Richard Russell
168.bye
Bob Hewitt
169.West Germany (FRG)Jurgen Fassbender6-4 6-4 3-6 6-1
Jurgen Fassbender
170.bye
Jurgen Fassbender
171.Colombia (COL)Ivan Molina6-4 7-6 4-6 6-3
Ivan Molina
172.bye
Bob Hewitt
173.South Africa (RSA)[16]Bob Hewitt7-5 6-3 6-4
Bob Hewitt
174.bye
Bob Hewitt
175.West Germany (FRG)Hans-Jurgen Pohmann6-4 6-2 6-2
Hans-Jurgen Pohmann
176.bye
Ilie Nastase
177.France (FRA)Patrice Dominguez6-4 6-4 6-2
Patrice Dominguez
178.bye
Patrice Dominguez
179.United States (USA)Pancho Gonzalez4-6 6-3 6-2 6-3
Pancho Gonzalez
180.bye
Patrice Dominguez
181.United States (USA)Raz Reid5-7 6-4 7-5 6-4
Raz Reid
182.bye
Raz Reid
183.United States (USA)Jim Osborne6-4 6-2 6-4
Jim Osborne
184.bye
Ilie Nastase
185.United Kingdom (GBR)Roger Taylor6-3 5-7 6-2 6-3
Roger Taylor
186.bye
Roger Taylor
187.Rhodesia (RHO)Andrew Pattison3-6 7-6 6-3 3-6 6-3
Andrew Pattison
188.bye
Ilie Nastase
189.Romania (ROU)[4]Ilie Nastase7-5 6-2 6-7 2-6 7-6
Ilie Nastase
190.bye
Ilie Nastase
191.Spain (ESP)Jairo Velasco Sr.6-0 6-2 6-0
Jairo Velasco Sr.
192.bye
Ilie Nastase
193.Australia (AUS)John Cooper4-6 7-6 6-2 6-1
John Cooper
194.bye
John Cooper
195.United Kingdom (GBR)Gerald Battrick6-3 6-1 6-0
Gerald Battrick
196.bye
John Cooper
197.Japan (JPN)Toshiro Sakai6-3 6-3 6-2
Toshiro Sakai
198.bye
Toshiro Sakai
199.Japan (JPN)Jun Kuki6-2 7-5 6-4
Jun Kuki
200.bye
John Cooper
201.New Zealand (NZL)Onny Parun7-6 6-4 6-4
Onny Parun
202.bye
Onny Parun
203.United States (USA)Frank Froehling III4-6 6-4 6-3 6-2
Frank Froehling III
204.bye
Manuel Orantes
205.Spain (ESP)[10]Manuel Orantes6-1 2-6 3-6 7-5 6-4
Manuel Orantes
206.bye
Manuel Orantes
207.New Zealand (NZL)Jeff Simpson7-5 6-2 6-2
Jeff Simpson
208.bye
Roscoe Tanner
209.United States (USA)Roscoe Tanner6-2 7-6 7-6
Roscoe Tanner
210.bye
Roscoe Tanner
211.Egypt (EGY)Ismail El Shafei7-6 6-4 6-4
Ismail El Shafei
212.bye
Roscoe Tanner
213.Australia (AUS)Bob Carmichael4-6 7-5 6-3 3-6 7-6
Bob Carmichael
214.bye
Bob Carmichael
215.Australia (AUS)Peter Doerner6-4 6-4 7-6
Peter Doerner
216.bye
Roscoe Tanner
217.United States (USA)Harold Solomon6-4 3-6 7-5 6-3
Harold Solomon
218.bye
Harold Solomon
219.Denmark (DEN)Torben Ulrich6-7 7-5 6-1 7-6
Torben Ulrich
220.bye
Tom Okker
221.Netherlands (NED)[7]Tom Okker6-1 6-2 6-2
Tom Okker
222.bye
Tom Okker
223.South Africa (RSA)Pat Cramer6-2 6-3 6-4
Pat Cramer
224.bye
Tom Gorman
225.Yugoslavia (YUG)Niki Pilic7-6 5-7 7-6 5-7 6-4
Niki Pilic
226.bye
Niki Pilic
227.Ecuador (ECU)Eduardo Zuleta6-1 6-3 7-5
Eduardo Zuleta
228.bye
Niki Pilic
229.Romania (ROU)Ion Tiriac6-7 6-4 3-6 7-5 7-6
Ion Tiriac
230.bye
Ion Tiriac
231.Australia (AUS)Ray Keldie6-4 1-0 rtd.
Ray Keldie
232.bye
Tom Gorman
233.United States (USA)Jim McManus6-4 6-4 6-4
Jim McManus
234.bye
Jim McManus
235.United States (USA)Danny Birchmore2-6 4-6 6-1 6-4 6-3
Danny Birchmore
236.bye
Tom Gorman
237.United States (USA)Tom Gorman4-6 6-4 6-1 6-3
Tom Gorman
238.bye
Tom Gorman
239.United States (USA)[15]Jimmy Connors6-1 3-6 6-7 7-5 6-4
Jimmy Connors
240.bye
Tom Gorman
241.United States (USA)Dick Stockton6-4 6-3 6-3
Dick Stockton
242.bye
Dick Stockton
243.United States (USA)Roy Barth6-4 6-2 6-4
Roy Barth
244.bye
Dick Stockton
245.Venezuela (VEN)Humphrey Hose6-2 6-3 3-6 7-6
Humphrey Hose
246.bye
Humphrey Hose
247.United States (USA)Steve Faulk7-5 4-6 7-6 7-6
Steve Faulk
248.bye
Dick Stockton
249.United Kingdom (GBR)Mark Cox6-7 6-2 4-6 6-2 6-2
Mark Cox
250.bye
Mark Cox
251.United States (USA)Mike Estep6-4 6-1 6-3
Mike Estep
252.bye
Mark Cox
253.Australia (AUS)[2]Ken Rosewall1-6 6-3 7-6 7-6
Ken Rosewall
254.bye
Ken Rosewall
255.United Kingdom (GBR)Peter Curtis6-1 7-6 6-2
Peter Curtis
256.bye
(default) 17 queries took 28 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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 1111
2SELECT `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)551
3SELECT `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)331
4SELECT `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)221
5SELECT `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 1111
6SELECT `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` ASC1441443
7SELECT `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` = '1972' LIMIT 1112
8SELECT `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` = (606) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC2552556
9SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (3386, 3613, 3249, 3614, 817, 3514, 3556, 734, 747, 3549, 786, 3615, 3466, 3554, 3497, 3616, 3215, 3509, 3561, 3617, 3571, 3268, 3515, 3538, 3436, 3574, 3618, 3565, 3124, 3564, 3619, 3620, 715, 3559, 2521, 3621, 3437, 3555, 3546, 3552, 3359, 3612, 748, 3479, 3511, 3567, 3495, 3622, 3533, 3609, 3550, 3483, 3623, 2955, 3422, 3668, 3519, 3624, 3168, 3657, 3560, 3643, 684, 3566, 3388, 822, 3382, 3502, 3536, 814, 3494, 8480, 3271, 3344, 3005, 3491, 3459, 3557, 3573, 3391, 3639, 3651, 3638, 3542, 3637, 3562, 3305, 3649, 3289, 3518, 729, 3223, 689, 3647, 3545, 3378, 3636, 3498, 761, 3635, 3385, 3024, 3535, 3596, 3547, 3634, 738, 3633, 3632, 2845, 3631, 3358, 798, 3558, 3527, 3630, 3367, 3528, 3572, 3577, 3517, 3180, 3516, 3629, 3529, 3398, 3531, 3628, 3627, 3014, 3380, 3524, 787, 3239, 3526, 3462, 785, 3626, 3446, 3539, 3490, 3471, 3506, 3569, 818, 3454, 653, 3486) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC1481482
10SELECT `Playercontest`.`id`, `Playercontest`.`player_id`, `Playercontest`.`contest_id`, `Playercontest`.`nat_id`, `Playercontest`.`draw` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE `Playercontest`.`contest_id` = 6061491492
11SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 178, 13, 68, 41, 196, 172, 59, 135, 212, 173, 217, 201, 230, 218, 94, 29, 86, 43, 153, 133, 92, 219, 141, 121, 93, 36, 54, 10, 58)30301
12SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 178, 13, 68, 41, 196, 172, 59, 135, 212, 173, 217, 201, 230, 218, 94, 29, 86, 43, 153, 133, 92, 219, 141, 121, 93, 36, 54, 10, 58)30301
13SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3386, 3613, 3249, 3614, 817, 3514, 3556, 734, 747, 3549, 786, 3615, 3466, 3554, 3497, 3616, 3215, 3509, 3561, 3617, 3571, 3268, 3515, 3538, 3436, 3574, 3618, 3565, 3124, 3564, 3619, 3620, 715, 3559, 2521, 3621, 3437, 3555, 3546, 3552, 3359, 3612, 748, 3479, 3511, 3567, 3495, 3622, 3533, 3609, 3550, 3483, 3623, 2955, 3422, 3668, 3519, 3624, 3168, 3657, 3560, 3643, 684, 3566, 3388, 822, 3382, 3502, 3536, 814, 3494, 8480, 3271, 3344, 3005, 3491, 3459, 3557, 3573, 3391, 3639, 3651, 3638, 3542, 3637, 3562, 3305, 3649, 3289, 3518, 729, 3223, 689, 3647, 3545, 3378, 3636, 3498, 761, 3635, 3385, 3024, 3535, 3596, 3547, 3634, 738, 3633, 3632, 2845, 3631, 3358, 798, 3558, 3527, 3630, 3367, 3528, 3572, 3577, 3517, 3180, 3516, 3629, 3529, 3398, 3531, 3628, 3627, 3014, 3380, 3524, 787, 3239, 3526, 3462, 785, 3626, 3446, 3539, 3490, 3471, 3506, 3569, 818, 3454, 653, 3486)) AND (`Playercontest`.`contest_id` = 606))1481482
14SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 22 ORDER BY `Contest`.`date_from` ASC1441441
15SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 197219191
16SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 3, 1, 12, 17, 22, 18, 13, 23, 4, 14, 24, 25, 26, 19, 15, 16, 20, 21) AND `Category`.`gender` = 'Men' AND `Category`.`type` = 'Singles'441
17SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 3, 4)441