US Open 1988 Men's Singles (August 29 - September 11)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Ivan Lendl
				Ivan Lendl
2.			Amos Mansdorf	6-2 6-7 6-1 5-7 6-0
					Ivan Lendl
3.			Jay Berger		6-2 6-4 6-1
				Jay Berger
4.		[Q]	Dan Cassidy	6-4 6-0 6-2
						Ivan Lendl
5.		[Q]	Jimmy Brown			6-1 6-4 6-3
				Jimmy Brown
6.			Dan Goldie	6-4 4-6 6-3 7-6
					Scott Davis
7.		[WC]	Scott Davis		4-6 7-5 6-4 6-2
				Scott Davis
8.			Jeremy Bates	6-4 6-3 6-1
							Ivan Lendl
9.			Wally Masur				6-4 5-7 6-2 6-4
				Wally Masur
10.		[Q]	Roger Smith	6-2 6-3 6-4
					Jakob Hlasek
11.			Jakob Hlasek		6-3 6-3 3-6 6-3
				Jakob Hlasek
12.			Claudio Pistolesi	6-2 6-2 4-6 6-3
						Jakob Hlasek
13.			Richey Reneberg			6-2 6-4 6-2
				Richey Reneberg
14.			Marian Vajda	6-3 4-6 6-4 6-0
					Anders Jarryd
15.		[15]	Anders Jarryd		6-0 6-3 6-0
				Anders Jarryd
16.			Joakim Nystrom	6-3 4-6 6-3 6-2
								Ivan Lendl
17.		[9]	Tim Mayotte					6-2 6-2 6-0
				Tim Mayotte
18.			Jim Pugh	6-3 6-4 4-6 5-7 6-3
					Tim Mayotte
19.		[Q]	Gianluca Pozzi		6-3 7-5 6-4
				Gianluca Pozzi
20.			Peter Lundgren	3-6 6-3 6-2 6-3
						Derrick Rostagno
21.			Marty Davis			6-3 6-4 6-2
				Marty Davis
22.			Cassio Motta	5-7 3-6 6-3 6-4 6-4
					Derrick Rostagno
23.			Derrick Rostagno		7-6 6-4 6-3
				Derrick Rostagno
24.			Yahiya Doumbia	6-3 6-7 6-3 7-6
							Derrick Rostagno
25.		[Q]	Jared Palmer				6-2 3-6 6-1 6-3
				Jared Palmer
26.		[WC]	Jeff Tarango	2-6 4-6 6-2 6-4 6-0
					Ronald Agenor
27.			Ronald Agenor		6-4 6-4 6-3
				Ronald Agenor
28.			Kelly Evernden	6-1 3-6 6-3 3-6 6-1
						Ronald Agenor
29.			Jason Stoltenberg			6-3 2-6 6-4 4-6 6-3
				Jason Stoltenberg
30.			Matt Anger	6-7 4-6 6-3 6-4 6-4
					Jason Stoltenberg
31.		[7]	Yannick Noah		6-2 6-7 5-1 rtd.
				Yannick Noah
32.		[Q]	Kelly Jones	7-6 6-4 6-1
									Ivan Lendl
33.		[4]	Andre Agassi						4-6 6-2 6-3 6-4
				Andre Agassi
34.		[Q]	Philip Johnson	7-6 6-3 6-3
					Andre Agassi
35.		[WC]	Rick Leach		4-6 6-2 6-3 6-4
				Rick Leach
36.		[WC]	Scott Melville	6-7 7-5 6-1 7-6
						Andre Agassi
37.			Martin Jaite			6-3 6-1 2-6 6-0
				Martin Jaite
38.			Thierry Champion	6-1 6-4 1-6 6-0
					Johan Kriek
39.			Johan Kriek		6-4 6-2 3-6 7-6
				Johan Kriek
40.		[WC]	Tommy Ho	6-4 7-6 7-6
							Andre Agassi
41.			Claudio Mezzadri				7-5 6-3 6-2
				Claudio Mezzadri
42.			Andrew Castle	6-1 5-7 6-2 7-5
					Tim Wilkinson
43.			Tim Wilkinson		7-6 6-2 6-2
				Tim Wilkinson
44.			Ricki Osterthun	3-6 6-2 6-1 6-2
						Michael Chang
45.			Michael Chang			4-6 3-6 6-3 6-4 7-5
				Michael Chang
46.			Luiz Mattar	6-4 6-3 7-5
					Michael Chang
47.		[13]	Jonas Svensson		5-7 6-4 2-6 6-1 6-4
				Jonas Svensson
48.			Todd Witsken	6-3 6-3 6-4
								Andre Agassi
49.		[12]	Guillermo Perez Roldan					6-2 7-6 6-1
				Guillermo Perez Roldan
50.			Ken Flach	6-7 7-6 3-6 6-1 7-6
					Guillermo Perez Roldan
51.		[WC]	John Ross		6-4 6-4 5-7 6-7 6-3
				John Ross
52.			Jean-Philippe Fleurian	7-6 6-4 4-6 6-1
						Jorge Lozano
53.			Jorge Lozano			6-4 6-4 5-7 7-6
				Jorge Lozano
54.			Jim Grabb	6-2 7-5 3-6 7-5
					Jorge Lozano
55.			Robert Seguso		7-5 6-0 2-6 6-7 6-4
				Robert Seguso
56.			Michael Kures	6-3 6-4 6-3
							Jimmy Connors
57.			Pieter Aldrich				6-1 6-2 6-0
				Pieter Aldrich
58.			Wojtek Kowalski	7-5 6-3 6-4
					Pieter Aldrich
59.		[Q]	Grant Connell		7-6 6-4 6-3
				Grant Connell
60.			Christian Bergstrom	3-6 6-3 6-2 3-6 6-4
						Jimmy Connors
61.			Gilad Bloom			6-3 6-2 6-3
				Gilad Bloom
62.			Petr Korda	4-6 6-4 3-0 rtd.
					Jimmy Connors
63.		[6]	Jimmy Connors		6-0 6-3 3-6 6-1
				Jimmy Connors
64.			Agustin Moreno	6-3 6-2 6-2
										Mats Wilander
65.		[5]	Boris Becker							6-4 4-6 6-3 5-7 6-4
				Boris Becker
66.			Todd Nelson	6-3 6-0 7-6
					Darren Cahill
67.			Darren Cahill		6-3 6-3 6-2
				Darren Cahill
68.			Lawson Duncan	6-0 6-0 6-2
						Darren Cahill
69.			Marcelo Ingaramo			w/o
				Marcelo Ingaramo
70.			Horacio De La Pena	6-3 3-6 3-6 7-6 6-2
					Marcelo Ingaramo
71.		[Q]	Andrew Burrow		7-6 6-1 3-6 6-2
				Andrew Burrow
72.			Udo Riglewski	6-2 4-6 7-6 6-2
							Darren Cahill
73.			Menno Oosting				6-4 6-4 6-3
				Menno Oosting
74.		[Q]	Michael Robertson	6-3 7-6 6-3
					Martin Laurendeau
75.		[Q]	Martin Laurendeau		6-3 6-3 6-2
				Martin Laurendeau
76.			Jimmy Arias	2-6 6-4 7-6 7-6
						Martin Laurendeau
77.			Jaime Yzaga			4-6 6-2 6-4 7-5
				Jaime Yzaga
78.		[WC]	Pete Sampras	6-7 6-7 6-4 7-5 6-2
					Jaime Yzaga
79.		[11]	Brad Gilbert		1-6 6-0 6-4 6-2
				Brad Gilbert
80.			Milan Srejber	6-3 6-3 6-2
								Darren Cahill
81.		[14]	Andres Gomez					6-2 5-7 7-6 5-7 6-3
				Andres Gomez
82.			Javier Sanchez	6-4 6-2 6-2
					Andres Gomez
83.			Shuzo Matsuoka		7-6 2-6 6-4 2-6 6-2
				Shuzo Matsuoka
84.			Simon Youl	3-6 6-4 6-3 6-2
						Aaron Krickstein
85.			Aaron Krickstein			6-4 4-6 6-4 6-4
				Aaron Krickstein
86.			Michiel Schapers	7-5 6-3 6-2
					Aaron Krickstein
87.			David Pate		3-6 6-2 6-4 6-3
				David Pate
88.			Eric Jelen	4-6 6-1 6-4 6-2
							Aaron Krickstein
89.			Tobias Svantesson				5-7 7-6 7-6 4-6 7-5
				Tobias Svantesson
90.			Tomas Carbonell	0-6 4-6 6-1 7-6 6-4
					Johan Carlsson
91.		[Q]	Johan Carlsson		6-2 6-3 6-0
				Johan Carlsson
92.			Slobodan Zivojinovic	6-0 6-4 6-4
						Stefan Edberg
93.			Guy Forget			6-0 7-5 6-2
				Guy Forget
94.			Thierry Tulasne	5-7 6-4 6-3 6-4
					Stefan Edberg
95.		[3]	Stefan Edberg		7-5 6-1 6-3
				Stefan Edberg
96.		[Q]	Libor Pimek	6-2 6-2 6-4
									Mats Wilander
97.		[8]	Miloslav Mecir Sr.						6-4 6-4 6-2
				Miloslav Mecir Sr.
98.			Tomas Smid	7-5 6-4 6-0
					Miloslav Mecir Sr.
99.			Sammy Giammalva Jr.		6-4 6-1 7-6
				Sammy Giammalva Jr.
100.		[Q]	Miguel Nido	6-4 6-3 7-6
						Emilio Sanchez
101.			Emilio Sanchez			6-3 3-6 7-6 6-1
				Emilio Sanchez
102.			Sergio Casal	6-3 6-4 6-2
					Emilio Sanchez
103.			Ramesh Krishnan		6-2 7-5 6-2
				Ramesh Krishnan
104.		[Q]	Nuno Marques	6-4 5-7 3-6 7-5 6-1
							Emilio Sanchez
105.			Paul Annacone				6-2 6-3 6-4
				Paul Annacone
106.			Massimiliano Narducci	6-4 6-3 2-6 6-3
					John Frawley
107.			John Frawley		6-4 3-6 4-6 6-3 7-6
				John Frawley
108.			Joey Rive	5-7 6-3 6-0 6-3
						John Frawley
109.		[LL]	Barry Moir			6-3 6-4 6-3
				Barry Moir
110.			Leif Shiras	6-3 6-4 5-7 0-6 6-2
					Henri Leconte
111.		[10]	Henri Leconte		6-0 6-4 6-4
				Henri Leconte
112.			Javier Frana	6-4 3-6 6-3 6-4
								Mats Wilander
113.		[16]	John McEnroe					3-6 7-6 6-0 6-4
				John McEnroe
114.		[Q]	Leonardo Lavalle	6-3 6-4 6-4
					Mark Woodforde
115.			Mark Woodforde		7-5 4-6 6-7 6-3 6-1
				Mark Woodforde
116.			Eduardo Masso	6-3 6-0 6-7 1-6 6-3
						Mark Woodforde
117.			Patrick Kuehnen			6-1 5-7 6-3 6-0
				Patrick Kuehnen
118.			Niclas Kroon	6-4 2-6 7-5 6-2
					Diego Nargiso
119.			Diego Nargiso		6-3 7-5 6-4
				Diego Nargiso
120.			Chris Pridham	7-5 7-6 7-6
							Mats Wilander
121.			Mikael Pernfors				6-3 6-2 6-2
				Mikael Pernfors
122.			Thomas Muster	7-6 6-2 3-6 6-1
					Mikael Pernfors
123.			Jim Courier		6-3 6-4 6-4
				Jim Courier
124.			Horst Skoff	7-5 6-4 6-3
						Mats Wilander
125.			Kevin Curren			6-4 6-0 7-5
				Kevin Curren
126.		[WC]	Robbie Weiss	6-4 6-4 6-4
					Mats Wilander
127.		[2]	Mats Wilander		3-6 6-3 6-2 3-6 6-3
				Mats Wilander
128.			Greg Holmes	6-2 6-1 6-4

(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` = '1988' 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` = (623) 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 (3797, 3962, 3981, 3973, 3861, 3950, 3849, 3984, 3938, 4047, 3948, 4033, 4040, 3965, 3924, 3936, 3809, 4019, 4043, 3986, 3852, 3911, 3980, 4064, 4065, 4066, 3964, 3966, 4067, 3919, 3768, 4056, 4001, 4068, 4122, 4069, 3991, 4018, 3776, 4070, 3941, 4042, 3746, 4013, 4045, 4016, 4000, 4032, 4071, 3953, 4055, 4035, 4039, 3983, 3929, 3956, 4073, 4072, 4074, 4029, 4076, 4075, 3539, 4077, 3968, 3930, 4060, 3949, 4015, 3972, 4038, 4079, 4078, 4097, 4096, 3828, 3975, 4095, 3897, 4031, 3802, 4053, 4094, 4093, 3934, 4037, 3893, 4021, 4091, 4092, 4057, 3969, 3931, 3843, 3933, 3932, 3977, 3743, 4203, 4090, 4017, 4026, 3801, 4089, 3946, 4088, 3952, 4049, 4010, 3838, 3913, 4087, 3753, 3990, 4022, 4086, 4085, 4084, 4083, 4082, 3943, 4008, 4081, 4014, 3772, 4080, 3894, 4020) 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` = 623	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 10, 217, 68, 86, 58, 178, 29, 21, 13, 179, 91, 81, 135, 212, 219, 147, 196, 121, 14, 172, 173, 92, 133, 16, 163, 149, 36, 150, 151, 94)	31	31	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 10, 217, 68, 86, 58, 178, 29, 21, 13, 179, 91, 81, 135, 212, 219, 147, 196, 121, 14, 172, 173, 92, 133, 16, 163, 149, 36, 150, 151, 94)	31	31	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3797, 3962, 3981, 3973, 3861, 3950, 3849, 3984, 3938, 4047, 3948, 4033, 4040, 3965, 3924, 3936, 3809, 4019, 4043, 3986, 3852, 3911, 3980, 4064, 4065, 4066, 3964, 3966, 4067, 3919, 3768, 4056, 4001, 4068, 4122, 4069, 3991, 4018, 3776, 4070, 3941, 4042, 3746, 4013, 4045, 4016, 4000, 4032, 4071, 3953, 4055, 4035, 4039, 3983, 3929, 3956, 4073, 4072, 4074, 4029, 4076, 4075, 3539, 4077, 3968, 3930, 4060, 3949, 4015, 3972, 4038, 4079, 4078, 4097, 4096, 3828, 3975, 4095, 3897, 4031, 3802, 4053, 4094, 4093, 3934, 4037, 3893, 4021, 4091, 4092, 4057, 3969, 3931, 3843, 3933, 3932, 3977, 3743, 4203, 4090, 4017, 4026, 3801, 4089, 3946, 4088, 3952, 4049, 4010, 3838, 3913, 4087, 3753, 3990, 4022, 4086, 4085, 4084, 4083, 4082, 3943, 4008, 4081, 4014, 3772, 4080, 3894, 4020)) AND (`Playercontest`.`contest_id` = 623))	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` = 1988	20	20	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, 7, 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` = '1988' 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` = (623) 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 (3797, 3962, 3981, 3973, 3861, 3950, 3849, 3984, 3938, 4047, 3948, 4033, 4040, 3965, 3924, 3936, 3809, 4019, 4043, 3986, 3852, 3911, 3980, 4064, 4065, 4066, 3964, 3966, 4067, 3919, 3768, 4056, 4001, 4068, 4122, 4069, 3991, 4018, 3776, 4070, 3941, 4042, 3746, 4013, 4045, 4016, 4000, 4032, 4071, 3953, 4055, 4035, 4039, 3983, 3929, 3956, 4073, 4072, 4074, 4029, 4076, 4075, 3539, 4077, 3968, 3930, 4060, 3949, 4015, 3972, 4038, 4079, 4078, 4097, 4096, 3828, 3975, 4095, 3897, 4031, 3802, 4053, 4094, 4093, 3934, 4037, 3893, 4021, 4091, 4092, 4057, 3969, 3931, 3843, 3933, 3932, 3977, 3743, 4203, 4090, 4017, 4026, 3801, 4089, 3946, 4088, 3952, 4049, 4010, 3838, 3913, 4087, 3753, 3990, 4022, 4086, 4085, 4084, 4083, 4082, 3943, 4008, 4081, 4014, 3772, 4080, 3894, 4020) 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` = 623

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 10, 217, 68, 86, 58, 178, 29, 21, 13, 179, 91, 81, 135, 212, 219, 147, 196, 121, 14, 172, 173, 92, 133, 16, 163, 149, 36, 150, 151, 94)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 10, 217, 68, 86, 58, 178, 29, 21, 13, 179, 91, 81, 135, 212, 219, 147, 196, 121, 14, 172, 173, 92, 133, 16, 163, 149, 36, 150, 151, 94)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3797, 3962, 3981, 3973, 3861, 3950, 3849, 3984, 3938, 4047, 3948, 4033, 4040, 3965, 3924, 3936, 3809, 4019, 4043, 3986, 3852, 3911, 3980, 4064, 4065, 4066, 3964, 3966, 4067, 3919, 3768, 4056, 4001, 4068, 4122, 4069, 3991, 4018, 3776, 4070, 3941, 4042, 3746, 4013, 4045, 4016, 4000, 4032, 4071, 3953, 4055, 4035, 4039, 3983, 3929, 3956, 4073, 4072, 4074, 4029, 4076, 4075, 3539, 4077, 3968, 3930, 4060, 3949, 4015, 3972, 4038, 4079, 4078, 4097, 4096, 3828, 3975, 4095, 3897, 4031, 3802, 4053, 4094, 4093, 3934, 4037, 3893, 4021, 4091, 4092, 4057, 3969, 3931, 3843, 3933, 3932, 3977, 3743, 4203, 4090, 4017, 4026, 3801, 4089, 3946, 4088, 3952, 4049, 4010, 3838, 3913, 4087, 3753, 3990, 4022, 4086, 4085, 4084, 4083, 4082, 3943, 4008, 4081, 4014, 3772, 4080, 3894, 4020)) AND (`Playercontest`.`contest_id` = 623))

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

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, 7, 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)