US Open 1980 Men's Singles (August 26 - September 7)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Bjorn Borg
				Bjorn Borg
2.			Guillermo Aubone	6-1 6-4 6-1
					Bjorn Borg
3.			John Sadri		7-5 6-2 2-6 6-0
				John Sadri
4.			Joao Soares	6-2 4-6 6-4 6-4
						Bjorn Borg
5.			Peter McNamara			7-6 1-6 6-2 6-0
				Peter McNamara
6.			Marko Ostoja	6-1 6-1 6-0
					Peter McNamara
7.			Bill Scanlon		3-6 6-0 7-5 6-2
				Bill Scanlon
8.			John Feaver	2-6 4-6 6-3 6-3 7-6
							Bjorn Borg
9.			Mel Purcell				6-3 6-3 6-0
				Mel Purcell
10.			Stan Smith	7-6 6-4 6-0
					Mel Purcell
11.			Andres Gomez		6-3 7-5 2-6 3-6 6-4
				Andres Gomez
12.			Nick Saviano	6-3 6-3 4-0 rtd.
						Yannick Noah
13.			Bruce Manson			4-6 6-2 6-4 6-4
				Bruce Manson
14.			Sashi Menon	6-1 6-2 7-5
					Yannick Noah
15.		[15]	Yannick Noah		6-7 7-6 6-0 6-2
				Yannick Noah
16.			David Schneider	6-1 6-0 6-3
								Bjorn Borg
17.		[11]	Roscoe Tanner					6-4 3-6 4-6 7-5 6-3
				Roscoe Tanner
18.			Ray Moore	6-3 6-4 6-1
					Roscoe Tanner
19.			Jimmy Arias		6-3 6-3 6-0
				Jimmy Arias
20.			Freddie Sauer	6-2 6-7 6-2 6-2
						Roscoe Tanner
21.			Erik Van Dillen			7-6 6-1 6-2
				Erik Van Dillen
22.			Gene Malin	7-6 6-2 6-3
					Erik Van Dillen
23.			Ramesh Krishnan		6-4 6-3 1-6 7-6
				Ramesh Krishnan
24.			John Austin	6-4 6-4 3-6 6-1
							Roscoe Tanner
25.			Brian Teacher				6-3 6-4 5-7 6-2
				Brian Teacher
26.			Raul Ramirez	7-6 6-1 6-2
					Brian Teacher
27.			Shlomo Glickstein		6-4 3-6 6-3 4-6 6-3
				Shlomo Glickstein
28.			Marty Riessen	7-5 6-1 6-1
						Brian Teacher
29.			Vijay Amritraj			6-7 6-4 7-6 6-2
				Vijay Amritraj
30.			Harry Fritz	7-5 6-2 6-3
					Vijay Amritraj
31.		[8]	Eddie Dibbs		7-5 0-6 4-6 6-2 6-1
				Eddie Dibbs
32.			Bob Lutz	5-7 2-6 7-5 6-0 6-2
									Bjorn Borg
33.		[4]	Guillermo Vilas						4-6 4-6 6-1 6-1 6-1
				Guillermo Vilas
34.			Warren Maher	6-0 6-1 6-2
					Guillermo Vilas
35.			John Hayes		6-2 6-4 6-4
				John Hayes
36.			John James	7-5 2-6 3-6 6-2 6-1
						Guillermo Vilas
37.			Francisco Gonzalez			3-6 3-6 6-4 6-4 6-2
				Francisco Gonzalez
38.			Terry Rocavert	6-2 7-6 6-2
					Francisco Gonzalez
39.			Robert Van't Hof		7-6 7-5 6-3
				Robert Van't Hof
40.			George Hardie	6-3 6-3 7-5
							Wojtek Fibak
41.			Van Winitsky				3-6 6-3 6-4 6-3
				Van Winitsky
42.			Jaime Fillol	5-7 7-5 3-6 6-3 7-6
					Van Winitsky
43.			Robert Trogolo		6-3 6-4 6-1
				Robert Trogolo
44.			Fernando Maynetto	7-5 6-1 3-6 6-4
						Wojtek Fibak
45.			Peter Feigl			3-6 6-1 6-1 7-6
				Peter Feigl
46.			Dominique Bedel	6-4 4-6 6-7 7-6 7-6
					Wojtek Fibak
47.		[14]	Wojtek Fibak		6-4 2-6 3-6 6-4 6-3
				Wojtek Fibak
48.			John Benson	6-4 0-6 6-3 6-4
								Johan Kriek
49.		[9]	Peter Fleming					4-6 6-2 3-6 6-1 7-6
				Peter Fleming
50.			Bill Nealon	6-4 6-1 3-6 6-2
					Johan Kriek
51.			Johan Kriek		6-4 6-2 6-0
				Johan Kriek
52.			Stanislav Birner	7-5 6-4 6-0
						Johan Kriek
53.			Tony Giammalva			w/o
				Tony Giammalva
54.			Tom Okker	6-2 7-6 6-3
					Tony Giammalva
55.			Leo Palin		6-4 6-2 7-5
				Leo Palin
56.			Andy Kohlberg	6-7 7-5 6-2 6-4
							Johan Kriek
57.			Christopher Mottram				6-4 5-7 6-3 6-4
				Christopher Mottram
58.			Tim Garcia	6-0 6-3 6-2
					Christopher Mottram
59.			Heinz Gunthardt		7-6 6-2 6-4
				Heinz Gunthardt
60.			Onny Parun	6-4 6-2 6-3
						Christopher Mottram
61.			Hank Pfister			7-6 4-6 6-4 3-6 6-4
				Hank Pfister
62.			Tom Cain	7-5 2-6 7-5 6-3
					Hank Pfister
63.		[5]	Vitas Gerulaitis		6-3 6-2 3-6 1-6 7-6
				Vitas Gerulaitis
64.			Vincent Van Patten	6-3 6-4 6-0
										John McEnroe
65.			Gianni Ocleppo							7-6(4) 6-1 6-7(5) 5-7 6-4
				Gianni Ocleppo
66.		[6]	Gene Mayer	2-6 1-6 7-6 4-2 rtd.
					Gianni Ocleppo
67.			Mike Shore		6-4 6-0 6-3
				Mike Shore
68.			Steve Docherty	7-6 7-6 6-4
						Eliot Teltscher
69.			Eliot Teltscher			7-5 6-0 6-2
				Eliot Teltscher
70.			Scott Davis	6-2 6-4 6-4
					Eliot Teltscher
71.			Victor Pecci		6-4 6-1 6-3
				Victor Pecci
72.			Greg Whitecross	4-6 6-2 6-2 6-2
							Eliot Teltscher
73.			Ross Case				6-4 6-2 6-1
				Ross Case
74.			Byron Bertram	5-7 6-4 6-1 6-3
					Ross Case
75.			Blaine Willenborg		6-3 6-2 6-4
				Blaine Willenborg
76.			Paul McNamee	6-7 6-3 6-3 5-7 7-5
						Brian Gottfried
77.			Tim Gullikson			6-0 6-7 6-2 6-4
				Tim Gullikson
78.			Tony Graham	6-3 6-4 6-4
					Brian Gottfried
79.		[13]	Brian Gottfried		6-3 6-2 7-6
				Brian Gottfried
80.			David Carter	6-7 6-2 6-1 6-3
								Jimmy Connors
81.			Bernie Mitton					6-1 3-6 6-3 6-0
				Bernie Mitton
82.		[12]	Jose-Luis Clerc	6-3 6-2 4-6 2-6 7-5
					Bernie Mitton
83.			Juan-Carlos Ayala		6-3 6-1 6-3
				Juan-Carlos Ayala
84.			William Maze	6-4 3-6 6-3 3-6 6-3
						Bernie Mitton
85.			Sammy Giammalva Jr.			6-3 2-6 6-2 6-3
				Sammy Giammalva Jr.
86.			Rick Fisher	3-6 6-1 6-2 6-2
					Sammy Giammalva Jr.
87.			Fritz Buehning		6-2 4-6 6-4 6-4
				Fritz Buehning
88.			Mario Martinez	6-2 3-6 6-7 7-5 6-4
							Jimmy Connors
89.			Terry Moor				7-6 6-4 6-4
				Terry Moor
90.			Dick Stockton	4-6 7-6 7-6 3-6 7-6
					Terry Moor
91.			Sherwood Stewart		6-2 7-6 6-4
				Sherwood Stewart
92.			Ferdi Taygan	7-6 6-2 6-4
						Jimmy Connors
93.			Butch Walts			6-4 6-1 6-1
				Butch Walts
94.			Brad Drewett	6-4 6-2 4-6 6-4
					Jimmy Connors
95.		[3]	Jimmy Connors		6-3 6-1 6-3
				Jimmy Connors
96.			Marcel Freeman	6-2 6-2 6-2
									John McEnroe
97.		[7]	Harold Solomon						6-4 5-7 0-6 6-3 7-6
				Harold Solomon
98.			Jan Norback	6-2 6-4 6-4
					Harold Solomon
99.			Ilie Nastase		6-2 6-2 6-2
				Ilie Nastase
100.			Patrice Dominguez	6-4 6-1 4-6 6-2
						Harold Solomon
101.			Russell Simpson			6-7 6-3 4-6 6-0 6-2
				Russell Simpson
102.			Mike Leach	6-3 6-3 2-6 7-6
					Russell Simpson
103.			Peter Rennert		6-4 0-6 7-6 6-3
				Peter Rennert
104.			Mike Gandolfo	7-5 6-2 6-1
							Ivan Lendl
105.			Thierry Tulasne				6-1 6-0 6-0
				Thierry Tulasne
106.			Tom Leonard	2-6 6-6 rtd.
					Thierry Tulasne
107.			Michael Grant		6-3 6-2 5-7 0-6 6-3
				Michael Grant
108.			Ricardo Ycaza	7-5 6-1 7-6
						Ivan Lendl
109.			Chris Mayotte			6-2 6-0 6-1
				Chris Mayotte
110.			Matt Mitchell	6-3 6-1 6-1
					Ivan Lendl
111.		[10]	Ivan Lendl		6-4 6-4 6-4
				Ivan Lendl
112.			Tim Mayotte	6-4 6-3 7-6
								John McEnroe
113.		[16]	Victor Amaya					4-6 6-3 6-2 7-5
				Victor Amaya
114.			Larry Davidson	6-4 6-2 7-6
					Victor Amaya
115.			Rick Fagel		7-5 7-5 6-1
				Rick Fagel
116.			Cary Leeds	6-4 6-2 6-0
						Pascal Portes
117.			Pascal Portes			6-3 2-6 7-6 6-3
				Pascal Portes
118.			John Yuill	6-2 6-4 6-2
					Pascal Portes
119.			Tim Wilkinson		7-5 6-2 3-6 6-3
				Tim Wilkinson
120.			Tom Gullikson	4-6 6-0 6-2 7-5
							John McEnroe
121.			Rick Meyer				6-2 6-4 6-2
				Rick Meyer
122.			Trey Waltke	6-4 6-2 3-6 6-3
					Rick Meyer
123.			Chip Hooper		6-3 6-3 6-4
				Chip Hooper
124.			Leif Shiras	6-2 6-1 6-3
						John McEnroe
125.			Steve Krulevitz			6-1 6-1 4-6 6-2
				Steve Krulevitz
126.			Andrew Pattison	7-6 7-6 1-6 6-2
					John McEnroe
127.		[2]	John McEnroe		7-6 6-0 6-2
				John McEnroe
128.			Christophe Roger-Vasselin	6-3 6-4 6-1

(default) 17 queries took 25 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	3
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` = '1980' 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` = (615) 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 (3647, 3823, 3790, 3824, 3825, 3826, 3716, 3640, 3789, 3386, 3802, 3822, 3662, 3565, 3768, 3705, 3529, 3388, 3828, 3827, 3502, 3769, 3801, 3810, 3657, 3623, 3829, 3168, 3639, 3996, 3636, 3436, 3618, 3830, 3957, 3650, 3758, 3814, 3795, 3637, 3709, 3437, 3799, 3832, 3778, 3792, 3685, 3833, 3701, 3834, 3776, 3766, 3756, 3380, 3742, 3804, 3641, 3784, 3765, 3517, 3762, 3835, 3573, 3798, 3767, 3744, 3808, 3675, 3754, 3849, 3684, 3848, 3571, 3821, 3847, 3751, 3703, 3846, 3612, 3791, 3696, 3774, 3997, 3755, 4203, 3786, 3806, 3845, 3715, 3490, 3451, 3674, 3713, 3796, 3539, 3914, 3627, 3745, 3527, 3632, 3740, 3884, 3793, 3844, 3843, 3494, 3842, 3749, 3841, 3752, 3797, 3809, 3655, 3998, 3698, 3840, 3770, 3678, 3746, 3993, 3839, 3672, 3837, 3838, 3542, 3558, 3753, 3836) 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` = 615	128	128	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 41, 133, 172, 135, 153, 207, 86, 13, 10, 121, 68, 196, 178, 146, 149, 67, 58, 179, 217, 92, 14, 29, 219, 91, 147, 26, 36)	28	28	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 41, 133, 172, 135, 153, 207, 86, 13, 10, 121, 68, 196, 178, 146, 149, 67, 58, 179, 217, 92, 14, 29, 219, 91, 147, 26, 36)	28	28	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3647, 3823, 3790, 3824, 3825, 3826, 3716, 3640, 3789, 3386, 3802, 3822, 3662, 3565, 3768, 3705, 3529, 3388, 3828, 3827, 3502, 3769, 3801, 3810, 3657, 3623, 3829, 3168, 3639, 3996, 3636, 3436, 3618, 3830, 3957, 3650, 3758, 3814, 3795, 3637, 3709, 3437, 3799, 3832, 3778, 3792, 3685, 3833, 3701, 3834, 3776, 3766, 3756, 3380, 3742, 3804, 3641, 3784, 3765, 3517, 3762, 3835, 3573, 3798, 3767, 3744, 3808, 3675, 3754, 3849, 3684, 3848, 3571, 3821, 3847, 3751, 3703, 3846, 3612, 3791, 3696, 3774, 3997, 3755, 4203, 3786, 3806, 3845, 3715, 3490, 3451, 3674, 3713, 3796, 3539, 3914, 3627, 3745, 3527, 3632, 3740, 3884, 3793, 3844, 3843, 3494, 3842, 3749, 3841, 3752, 3797, 3809, 3655, 3998, 3698, 3840, 3770, 3678, 3746, 3993, 3839, 3672, 3837, 3838, 3542, 3558, 3753, 3836)) AND (`Playercontest`.`contest_id` = 615))	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` = 1980	19	19	2
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 25 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` = '1980' 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` = (615) 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 (3647, 3823, 3790, 3824, 3825, 3826, 3716, 3640, 3789, 3386, 3802, 3822, 3662, 3565, 3768, 3705, 3529, 3388, 3828, 3827, 3502, 3769, 3801, 3810, 3657, 3623, 3829, 3168, 3639, 3996, 3636, 3436, 3618, 3830, 3957, 3650, 3758, 3814, 3795, 3637, 3709, 3437, 3799, 3832, 3778, 3792, 3685, 3833, 3701, 3834, 3776, 3766, 3756, 3380, 3742, 3804, 3641, 3784, 3765, 3517, 3762, 3835, 3573, 3798, 3767, 3744, 3808, 3675, 3754, 3849, 3684, 3848, 3571, 3821, 3847, 3751, 3703, 3846, 3612, 3791, 3696, 3774, 3997, 3755, 4203, 3786, 3806, 3845, 3715, 3490, 3451, 3674, 3713, 3796, 3539, 3914, 3627, 3745, 3527, 3632, 3740, 3884, 3793, 3844, 3843, 3494, 3842, 3749, 3841, 3752, 3797, 3809, 3655, 3998, 3698, 3840, 3770, 3678, 3746, 3993, 3839, 3672, 3837, 3838, 3542, 3558, 3753, 3836) 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` = 615

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3647, 3823, 3790, 3824, 3825, 3826, 3716, 3640, 3789, 3386, 3802, 3822, 3662, 3565, 3768, 3705, 3529, 3388, 3828, 3827, 3502, 3769, 3801, 3810, 3657, 3623, 3829, 3168, 3639, 3996, 3636, 3436, 3618, 3830, 3957, 3650, 3758, 3814, 3795, 3637, 3709, 3437, 3799, 3832, 3778, 3792, 3685, 3833, 3701, 3834, 3776, 3766, 3756, 3380, 3742, 3804, 3641, 3784, 3765, 3517, 3762, 3835, 3573, 3798, 3767, 3744, 3808, 3675, 3754, 3849, 3684, 3848, 3571, 3821, 3847, 3751, 3703, 3846, 3612, 3791, 3696, 3774, 3997, 3755, 4203, 3786, 3806, 3845, 3715, 3490, 3451, 3674, 3713, 3796, 3539, 3914, 3627, 3745, 3527, 3632, 3740, 3884, 3793, 3844, 3843, 3494, 3842, 3749, 3841, 3752, 3797, 3809, 3655, 3998, 3698, 3840, 3770, 3678, 3746, 3993, 3839, 3672, 3837, 3838, 3542, 3558, 3753, 3836)) AND (`Playercontest`.`contest_id` = 615))

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

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)