US Open 1981 Men's Singles (September 1 - September 13)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	John McEnroe
				John McEnroe
2.			Juan Nunez	6-7 6-1 6-3 6-2
					John McEnroe
3.			Tom Gullikson		6-3 6-1 6-3
				Tom Gullikson
4.			Dominique Bedel	6-1 6-4 6-4
						John McEnroe
5.			Patrick Dupre			6-3 6-2 6-3
				Patrick Dupre
6.			Jim Delaney	6-3 6-3 4-6 6-2
					Patrick Dupre
7.			Chip Hooper		6-4 6-2 6-4
				Chip Hooper
8.			Tim Gullikson	7-6 2-6 6-3 3-6 6-1
							John McEnroe
9.			Mark Edmondson				7-5 6-0 6-1
				Mark Edmondson
10.			Ivan Du Pasquier	6-3 6-2 6-1
					Mark Edmondson
11.			Christophe Roger-Vasselin		4-6 3-6 6-1 6-4 6-2
				Christophe Roger-Vasselin
12.			Andy Kohlberg	7-5 6-4 6-4
						Kevin Curren
13.			Jay Lapidus			6-3 7-5 6-2
				Jay Lapidus
14.			Mario Martinez	4-6 4-6 6-4 6-4 6-2
					Kevin Curren
15.			Kevin Curren		4-6 6-3 6-7 6-1 6-3
				Kevin Curren
16.		[14]	Wojtek Fibak	7-6 6-4 7-6
								John McEnroe
17.		[10]	Brian Teacher					6-7 7-6 6-4 6-2
				Brian Teacher
18.			Bill Scanlon	6-3 6-2 7-5
					Marty Davis
19.			Marty Davis		2-6 7-6 6-2 6-4
				Marty Davis
20.			Lloyd Bourne	6-3 7-5 3-6 6-1
						Ramesh Krishnan
21.			Ramesh Krishnan			6-2 7-5 6-7 6-4
				Ramesh Krishnan
22.			Per Hjertquist	6-1 6-1 6-3
					Ramesh Krishnan
23.			Stan Smith		6-4 6-3 6-3
				Stan Smith
24.			John Sadri	5-7 6-7 7-5 6-4 7-6
							Ramesh Krishnan
25.			Dick Stockton				4-6 1-6 7-6(6) 7-5 rtd.
				Dick Stockton
26.			Thierry Tulasne	4-6 6-3 6-4 6-4
					Dick Stockton
27.			Steve Krulevitz		6-4 6-4 6-2
				Steve Krulevitz
28.			Francisco Gonzalez	6-3 6-2 2-6 7-5
						Gene Mayer
29.			Fritz Buehning			6-4 6-4 6-1
				Fritz Buehning
30.			Craig Wittus	7-5 3-6 4-6 6-1 6-3
					Gene Mayer
31.		[7]	Gene Mayer		6-4 6-2 6-3
				Gene Mayer
32.			John Hayes	6-4 6-2 6-2
									John McEnroe
33.		[3]	Ivan Lendl						5-7 6-3 6-2 4-6 6-3
				Ivan Lendl
34.			Hans Simonsson	6-2 6-2 6-2
					Ivan Lendl
35.			Jeff Borowiak		7-6 6-1 7-6
				Jeff Borowiak
36.			Pascal Portes	6-2 6-3 6-1
						Ivan Lendl
37.			Mark Vines			6-4 3-6 6-2 6-3
				Mark Vines
38.			Russell Simpson	6-3 2-6 6-2 6-3
					Mark Vines
39.			Eddie Edwards		6-1 5-7 6-1 6-4
				Eddie Edwards
40.			Eric Fromm	6-3 7-6 6-7 6-4
							Vitas Gerulaitis
41.			Harold Solomon				6-3 6-4 3-6 3-6 6-4
				Harold Solomon
42.			Derek Tarr	6-0 6-1 6-7 6-1
					Harold Solomon
43.			Jimmy Arias		7-6 7-6 3-3 rtd.
				Jimmy Arias
44.			Syd Ball	6-1 7-6 6-2
						Vitas Gerulaitis
45.			Alejandro Cortes			6-3 6-2 6-3
				Alejandro Cortes
46.			Jimmy Brown	6-3 4-6 4-6 7-6 7-5
					Vitas Gerulaitis
47.		[15]	Vitas Gerulaitis		7-6 6-0 6-1
				Vitas Gerulaitis
48.			Terry Moor	4-6 6-3 6-0 3-6 6-2
								Vitas Gerulaitis
49.		[11]	Peter McNamara					6-4 6-2 4-6 6-1
				Peter McNamara
50.			John Fitzgerald	7-6 2-6 6-3 6-3
					Peter McNamara
51.			Peter Fleming		6-4 6-2 5-7 6-3
				Peter Fleming
52.			Mike Fishbach	6-2 6-4 6-2
						Bruce Manson
53.			Bruce Manson			4-6 6-3 6-4 6-2
				Bruce Manson
54.			Danny Saltz	6-0 6-0 6-2
					Bruce Manson
55.			Rick Meyer		6-0 6-2 3-6 4-6 6-2
				Rick Meyer
56.			Bernie Mitton	6-3 6-4 7-6
							Bruce Manson
57.			Mel Purcell				6-3 7-6 6-3
				Mel Purcell
58.			Ilie Nastase	3-6 6-3 6-4 3-6 6-3
					Mel Purcell
59.			Shlomo Glickstein		6-4 6-4 7-5
				Shlomo Glickstein
60.			Jonathan Smith	6-4 6-4 6-2
						Jose-Luis Clerc
61.			Tim Wilkinson			6-3 0-6 0-6 6-4 6-3
				Tim Wilkinson
62.			John Alexander	6-4 2-6 7-6 6-4
					Jose-Luis Clerc
63.		[5]	Jose-Luis Clerc		6-4 5-7 6-4 5-7 7-6
				Jose-Luis Clerc
64.			Brad Drewett	6-4 6-3 6-3
										John McEnroe
65.		[8]	Eliot Teltscher							4-6 6-2 6-4 6-3
				Eliot Teltscher
66.			Victor Amaya	6-2 6-2 6-4
					Eliot Teltscher
67.			John Austin		6-2 6-2 6-2
				John Austin
68.			Nick Saviano	6-2 6-7 6-1 6-4
						Eliot Teltscher
69.			Vijay Amritraj			6-2 6-4 6-0
				Vijay Amritraj
70.			Scott Davis	6-3 6-4 6-2
					Vijay Amritraj
71.			Gilles Moretton		7-5 6-3 6-4
				Gilles Moretton
72.			Ernesto Fernandez	6-3 3-6 4-6 7-6 6-3
							Eliot Teltscher
73.			Tim Mayotte				6-4 6-0 5-7 1-6 6-3
				Tim Mayotte
74.			Steve Denton	6-3 6-4 6-7 6-3
					Tim Mayotte
75.			Scott McCain		6-3 3-6 4-6 6-1 6-2
				Scott McCain
76.			William Cowan	7-5 6-4 6-2
						Brian Gottfried
77.			Butch Walts			6-2 6-3 6-7 7-6
				Butch Walts
78.			Rick Fagel	7-6 6-4 6-7 2-6 6-1
					Brian Gottfried
79.		[16]	Brian Gottfried		7-6 6-4 6-2
				Brian Gottfried
80.			Vincent Van Patten	6-4 6-4 6-1
								Jimmy Connors
81.		[12]	Johan Kriek					6-3 6-1 6-2
				Johan Kriek
82.			Mike De Palmer	6-2 6-3 7-5
					Johan Kriek
83.			Matt Doyle		4-6 6-3 6-3 6-0
				Matt Doyle
84.			Jim Gurfein	6-2 6-2 5-7 6-2
						Mike Cahill
85.			Mike Cahill			4-6 6-2 6-1 6-4
				Mike Cahill
86.			Steve Meister	6-3 6-3 6-4
					Mike Cahill
87.			Andrew Pattison		6-4 6-1 7-6
				Andrew Pattison
88.			Marcel Freeman	7-6 7-5 7-6
							Jimmy Connors
89.			Andres Gomez				6-3 6-3 6-1
				Andres Gomez
90.			Van Winitsky	7-6 6-3 6-2
					Andres Gomez
91.			Chris Lewis		6-4 6-3 6-3
				Chris Lewis
92.			Hank Pfister	7-5 7-6 6-2
						Jimmy Connors
93.			Marko Ostoja			6-7(4) 6-3 6-1 4-6 7-6(5)
				Marko Ostoja
94.			Pedro Rebolledo	6-1 6-2 6-2
					Jimmy Connors
95.		[4]	Jimmy Connors		7-6 6-4 6-3
				Jimmy Connors
96.			John Lloyd	6-0 6-0 6-2
									Bjorn Borg
97.		[6]	Guillermo Vilas						6-2 7-5 6-4
				Guillermo Vilas
98.			Drew Gitlin	6-3 6-7 6-0 6-4
					Guillermo Vilas
99.			Raul Ramirez		6-1 6-3 6-2
				Raul Ramirez
100.			Haroon Ismail	6-3 6-2 6-4
						Guillermo Vilas
101.			Adriano Panatta			6-4 4-6 7-5 6-4
				Adriano Panatta
102.			Ferdi Taygan	7-6 4-6 6-3 6-2
					Adriano Panatta
103.			Roland Stadler		7-5 6-3 6-1
				Roland Stadler
104.			Steve Docherty	6-4 7-5 5-7 6-2
							Roscoe Tanner
105.			Chris Mayotte				6-4 6-2 7-6
				Chris Mayotte
106.			Derek Segal	6-1 6-4 6-4
					Chris Mayotte
107.			John James		6-4 5-7 7-5 4-6 6-0
				John James
108.			Bruce Nichols	6-4 6-4 5-7 6-4
						Roscoe Tanner
109.			Christofer Delaney			7-6 6-1 6-2
				Christofer Delaney
110.			Ross Case	6-2 7-6 6-2
					Roscoe Tanner
111.		[9]	Roscoe Tanner		4-6 6-1 6-4 6-1
				Roscoe Tanner
112.			Craig Edwards	6-3 6-3 6-4
								Bjorn Borg
113.		[13]	Yannick Noah					7-6 6-3 6-7 7-6
				Yannick Noah
114.			Andy Andrews	6-3 6-3 6-7 4-6 6-2
					Yannick Noah
115.			Erik Van Dillen		6-4 6-2 4-6 7-5
				Erik Van Dillen
116.			John Benson	4-6 6-0 4-6 6-1 6-4
						Yannick Noah
117.			Trey Waltke			6-3 6-4 6-4
				Trey Waltke
118.			Sherwood Stewart	7-6 6-4 1-6 4-6 7-5
					Trey Waltke
119.			Bernard Fritz		6-3 6-3 7-6
				Bernard Fritz
120.			Tony Giammalva	6-2 2-6 6-1 7-5
							Bjorn Borg
121.			David Carter				6-7 6-4 6-3 6-3
				David Carter
122.			Jaime Fillol	7-6 2-6 7-6 6-2
					David Carter
123.			Sammy Giammalva Jr.		4-6 6-2 1-6 6-4 6-0
				Sammy Giammalva Jr.
124.			Heinz Gunthardt	6-4 4-6 6-3 1-6 6-1
						Bjorn Borg
125.			Larry Stefanki			6-2 6-2 6-2
				Larry Stefanki
126.			Phil Dent	6-7 7-5 6-4 3-6 6-3
					Bjorn Borg
127.		[2]	Bjorn Borg		6-4 6-4 6-4
				Bjorn Borg
128.			Markus Gunthardt	6-2 6-2 6-0

(default) 17 queries took 22 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	1
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	1
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	1
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	1
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	1
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	2
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` = '1981' 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` = (616) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	127	127	2
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (3753, 3850, 3993, 3792, 3624, 3616, 3837, 3703, 3706, 3851, 3836, 3804, 3803, 3845, 3772, 3685, 3657, 3716, 3852, 3853, 3801, 3854, 3386, 3790, 3490, 3843, 3542, 3758, 3806, 3855, 3744, 3957, 3797, 3856, 3498, 3770, 3857, 3740, 3858, 3805, 3627, 3859, 3828, 3665, 3860, 3861, 3573, 3715, 3825, 3862, 3701, 3748, 3662, 3863, 3839, 3696, 3789, 3527, 3829, 3864, 3746, 3515, 3774, 3796, 3754, 3655, 3810, 3822, 3639, 3849, 3787, 3881, 3809, 3880, 3879, 3878, 3713, 3698, 3612, 3798, 3776, 3877, 3875, 3876, 3750, 3874, 3558, 3914, 3802, 3709, 3771, 3762, 3826, 3873, 3539, 3646, 3618, 3872, 3623, 3871, 3614, 3674, 3870, 3675, 3841, 3869, 3650, 3781, 3868, 3571, 3529, 4204, 3768, 3910, 3502, 3833, 3672, 3451, 3867, 3756, 3791, 3437, 4203, 3765, 3866, 3538, 3647, 3865) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	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` = 616	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 36, 178, 179, 41, 13, 153, 207, 92, 10, 121, 86, 196, 149, 172, 135, 146, 68, 217, 58, 219, 91, 26, 43, 151)	25	25	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 36, 178, 179, 41, 13, 153, 207, 92, 10, 121, 86, 196, 149, 172, 135, 146, 68, 217, 58, 219, 91, 26, 43, 151)	25	25	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3753, 3850, 3993, 3792, 3624, 3616, 3837, 3703, 3706, 3851, 3836, 3804, 3803, 3845, 3772, 3685, 3657, 3716, 3852, 3853, 3801, 3854, 3386, 3790, 3490, 3843, 3542, 3758, 3806, 3855, 3744, 3957, 3797, 3856, 3498, 3770, 3857, 3740, 3858, 3805, 3627, 3859, 3828, 3665, 3860, 3861, 3573, 3715, 3825, 3862, 3701, 3748, 3662, 3863, 3839, 3696, 3789, 3527, 3829, 3864, 3746, 3515, 3774, 3796, 3754, 3655, 3810, 3822, 3639, 3849, 3787, 3881, 3809, 3880, 3879, 3878, 3713, 3698, 3612, 3798, 3776, 3877, 3875, 3876, 3750, 3874, 3558, 3914, 3802, 3709, 3771, 3762, 3826, 3873, 3539, 3646, 3618, 3872, 3623, 3871, 3614, 3674, 3870, 3675, 3841, 3869, 3650, 3781, 3868, 3571, 3529, 4204, 3768, 3910, 3502, 3833, 3672, 3451, 3867, 3756, 3791, 3437, 4203, 3765, 3866, 3538, 3647, 3865)) AND (`Playercontest`.`contest_id` = 616))	128	128	2
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	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1981	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, 18, 13, 23, 4, 14, 24, 25, 26, 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 22 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` = '1981' 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` = (616) 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 (3753, 3850, 3993, 3792, 3624, 3616, 3837, 3703, 3706, 3851, 3836, 3804, 3803, 3845, 3772, 3685, 3657, 3716, 3852, 3853, 3801, 3854, 3386, 3790, 3490, 3843, 3542, 3758, 3806, 3855, 3744, 3957, 3797, 3856, 3498, 3770, 3857, 3740, 3858, 3805, 3627, 3859, 3828, 3665, 3860, 3861, 3573, 3715, 3825, 3862, 3701, 3748, 3662, 3863, 3839, 3696, 3789, 3527, 3829, 3864, 3746, 3515, 3774, 3796, 3754, 3655, 3810, 3822, 3639, 3849, 3787, 3881, 3809, 3880, 3879, 3878, 3713, 3698, 3612, 3798, 3776, 3877, 3875, 3876, 3750, 3874, 3558, 3914, 3802, 3709, 3771, 3762, 3826, 3873, 3539, 3646, 3618, 3872, 3623, 3871, 3614, 3674, 3870, 3675, 3841, 3869, 3650, 3781, 3868, 3571, 3529, 4204, 3768, 3910, 3502, 3833, 3672, 3451, 3867, 3756, 3791, 3437, 4203, 3765, 3866, 3538, 3647, 3865) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC

128

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

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 36, 178, 179, 41, 13, 153, 207, 92, 10, 121, 86, 196, 149, 172, 135, 146, 68, 217, 58, 219, 91, 26, 43, 151)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 36, 178, 179, 41, 13, 153, 207, 92, 10, 121, 86, 196, 149, 172, 135, 146, 68, 217, 58, 219, 91, 26, 43, 151)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3753, 3850, 3993, 3792, 3624, 3616, 3837, 3703, 3706, 3851, 3836, 3804, 3803, 3845, 3772, 3685, 3657, 3716, 3852, 3853, 3801, 3854, 3386, 3790, 3490, 3843, 3542, 3758, 3806, 3855, 3744, 3957, 3797, 3856, 3498, 3770, 3857, 3740, 3858, 3805, 3627, 3859, 3828, 3665, 3860, 3861, 3573, 3715, 3825, 3862, 3701, 3748, 3662, 3863, 3839, 3696, 3789, 3527, 3829, 3864, 3746, 3515, 3774, 3796, 3754, 3655, 3810, 3822, 3639, 3849, 3787, 3881, 3809, 3880, 3879, 3878, 3713, 3698, 3612, 3798, 3776, 3877, 3875, 3876, 3750, 3874, 3558, 3914, 3802, 3709, 3771, 3762, 3826, 3873, 3539, 3646, 3618, 3872, 3623, 3871, 3614, 3674, 3870, 3675, 3841, 3869, 3650, 3781, 3868, 3571, 3529, 4204, 3768, 3910, 3502, 3833, 3672, 3451, 3867, 3756, 3791, 3437, 4203, 3765, 3866, 3538, 3647, 3865)) AND (`Playercontest`.`contest_id` = 616))

128

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` = 1981

SELECT `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'

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