US Open 1995 Men's Singles (August 28 - September 10)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Andre Agassi
				Andre Agassi
2.			Bryan Shelton	6-2 6-2 6-2
					Andre Agassi
3.			Alex Corretja		5-7 6-3 5-7 6-0 6-2
				Alex Corretja
4.		[WC]	Alex O'Brien	6-4 6-4 6-3
						Andre Agassi
5.		[Q]	Daniel Nestor			6-4 6-3 6-1
				Daniel Nestor
6.			Andrei Olhovskiy	6-3 6-4 3-6 6-1
					Stefan Edberg
7.			Stefan Edberg		6-1 7-6(4) 2-6 6-1
				Stefan Edberg
8.			Martin Damm	6-0 6-3 7-6(4)
							Andre Agassi
9.		[Q]	Tim Henman				7-5 6-3 6-2
				Tim Henman
10.		[Q]	Juan Viloca-Puig	6-3 4-6 6-3 6-2
					Jared Palmer
11.			Jared Palmer		6-4 6-7(8) 6-3 6-1
				Jared Palmer
12.		[Q]	Leonardo Lavalle	6-4 7-5 6-3
						Jared Palmer
13.		[WC]	Sargis Sargsian			6-3 6-2 6-2
				Sargis Sargsian
14.			Michael Joyce	7-6(1) 2-6 4-6 6-3 6-1
					Sargis Sargsian
15.		[16]	Andriy Medvedev		1-6 4-6 6-3 6-2 6-4
				Andriy Medvedev
16.		[Q]	Hicham Arazi	6-7(5) 6-3 6-4 6-4
								Andre Agassi
17.		[Q]	Jerome Golmard					6-4 6-2 1-6 7-5
				Jerome Golmard
18.		[10]	Wayne Ferreira	7-5 7-6(5) 6-1
					Marcos Ondruska
19.			Marcos Ondruska		6-4 6-4 6-3
				Marcos Ondruska
20.		[Q]	Mark Petchey	7-6(0) 6-1 6-0
						Petr Korda
21.			Petr Korda			6-3 6-2 7-5
				Petr Korda
22.			Shuzo Matsuoka	7-6(4) 6-7(4) 6-7(8) 6-5 rtd.
					Petr Korda
23.			Jacco Eltingh		6-2 6-4 3-6 6-1
				Jacco Eltingh
24.		[Q]	Wayne Black	6-2 6-2 6-4
							Petr Korda
25.			Emilio Sanchez				6-2 7-5 6-4
				Emilio Sanchez
26.			Jeremy Bates	6-2 6-2 6-3
					Vince Spadea
27.			Vince Spadea		6-1 7-6(7) 6-3
				Vince Spadea
28.			Hendrik Dreekmann	6-4 7-5 6-4
						Vince Spadea
29.			Nuno Marques			6-2 6-4 6-4
				Nuno Marques
30.		[Q]	Mahesh Bhupathi	6-7(3) 7-5 6-1 6-3
					Yevgeny Kafelnikov
31.		[7]	Yevgeny Kafelnikov		6-3 6-4 6-4
				Yevgeny Kafelnikov
32.			Jeff Tarango	6-0 6-4 7-5
									Andre Agassi
33.		[4]	Boris Becker						7-6(4) 7-6(2) 4-6 6-4
				Boris Becker
34.			Alex Moron	6-1 6-0 6-3
					Boris Becker
35.			Carsten Arriens		6-1 6-3 7-5
				Carsten Arriens
36.			Karol Kucera	6-4 7-6(3) 6-2
						Boris Becker
37.			Aaron Krickstein			6-2 4-6 6-0 6-4
				Aaron Krickstein
38.			Lionel Roux	3-6 6-3 6-1 3-6 6-4
					Jason Stoltenberg
39.			Jason Stoltenberg		6-2 6-4 2-6 4-6 6-1
				Jason Stoltenberg
40.			Radomir Vasek	6-4 6-4 6-3
							Boris Becker
41.			Renzo Furlan				7-6(4) 6-3 6-3
				Renzo Furlan
42.			Olivier Delaitre	6-3 6-3 6-1
					Renzo Furlan
43.			Derrick Rostagno		6-4 6-2 6-4
				Derrick Rostagno
44.			Jan Siemerink	6-4 6-4 6-4
						Marc Rosset
45.			Patrick Rafter			6-1 7-6(2) 3-6 7-5
				Patrick Rafter
46.			Richey Reneberg	7-6(3) 6-3 6-4
					Marc Rosset
47.		[13]	Marc Rosset		6-4 6-4 3-6 6-3
				Marc Rosset
48.			Andrea Gaudenzi	6-7(3) 6-3 6-1 6-0
								Boris Becker
49.		[11]	Sergi Bruguera					6-4 7-6(2) 6-7(3) 7-6(6)
				Sergi Bruguera
50.			Johan Van Herck	6-3 6-4 6-4
					Daniel Vacek
51.			Daniel Vacek		6-2 6-3 6-4
				Daniel Vacek
52.			Martin Sinner	6-4 6-7(6) 6-3 2-6 7-6(4)
						Daniel Vacek
53.		[Q]	Nicolas Pereira			4-6 7-6(5) 6-2 7-6(3)
				Nicolas Pereira
54.			Fabrice Santoro	2-6 6-4 5-7 7-6(8) 7-6(3)
					Nicolas Pereira
55.		[Q]	Joost Winnink		7-6(4) 6-4 2-6 6-3
				Joost Winnink
56.			Greg Rusedski	7-6(5) 6-4 6-7(6) 6-1
							Patrick McEnroe
57.			Bohdan Ulihrach				7-6(8) 6-3 6-4
				Bohdan Ulihrach
58.			Guillaume Raoux	6-3 6-2 6-1
					Alexander Volkov
59.			Alexander Volkov		6-3 4-6 6-1 6-3
				Alexander Volkov
60.		[WC]	Brett Hansen-Dent	6-2 6-4 6-1
						Patrick McEnroe
61.			Patrick McEnroe			4-6 2-6 6-1 7-6(4) 6-2
				Patrick McEnroe
62.		[Q]	Nicklas Kulti	6-3 3-6 6-3 3-6 6-4
					Patrick McEnroe
63.			Brett Steven		6-2 6-2 6-2
				Brett Steven
64.		[6]	Goran Ivanisevic	4-6 2-6 6-3 3-1 rtd.
										Pete Sampras
65.		[5]	Michael Chang							6-4 6-3 4-6 7-5
				Michael Chang
66.			Gianluca Pozzi	6-0 6-1 6-0
					Michael Chang
67.			Stefano Pescosolido		4-6 6-3 6-4 6-4
				Stefano Pescosolido
68.			Jiri Novak	2-6 6-3 6-4 6-1
						Michael Chang
69.			Todd Woodbridge			6-3 6-2 6-0
				Todd Woodbridge
70.		[WC]	Chris Woodruff	6-4 7-6(5) 6-4
					Todd Woodbridge
71.			Jakob Hlasek		6-3 6-4 3-6 6-2
				Jakob Hlasek
72.			Alexander Mronz	6-3 4-6 6-4 6-2
							Michael Chang
73.			David Wheaton				6-2 6-2 4-6 6-3
				David Wheaton
74.		[Q]	Neville Godwin	7-6(10) 5-7 7-5 6-1
					Michael Tebbutt
75.			Michael Tebbutt		6-3 6-3 6-4
				Michael Tebbutt
76.			Anders Jarryd	6-4 6-3 7-6(4)
						Michael Tebbutt
77.		[WC]	Justin Gimelstob			6-3 3-6 6-7(5) 7-6(4) 7-6(4)
				Justin Gimelstob
78.			David Prinosil	6-4 6-4 4-6 4-6 6-3
					Richard Krajicek
79.		[12]	Richard Krajicek		6-4 6-2 6-4
				Richard Krajicek
80.			Karel Novacek	6-3 6-4 6-4
								Jim Courier
81.		[14]	Jim Courier					7-6(5) 7-6(3) 7-5
				Jim Courier
82.			Bernd Karbacher	6-3 6-4 3-6 6-3
					Jim Courier
83.			Sebastian Lareau		6-3 6-4 6-4
				Sebastian Lareau
84.			Adrian Voinea	6-4 3-6 4-6 6-4 7-5
						Jim Courier
85.			Kenneth Carlsen			6-3 6-4 6-2
				Kenneth Carlsen
86.			Jim Grabb	6-7(6) 7-6(1) 6-2 3-6 6-2
					Kenneth Carlsen
87.		[Q]	Karsten Braasch		6-7(2) 6-7(3) 7-6(4) 6-5 rtd.
				Karsten Braasch
88.		[WC]	Scott Humphries	6-3 6-7(4) 7-6(5) 6-3
							Jim Courier
89.			Cedric Pioline				6-3 6-0 7-6(4)
				Cedric Pioline
90.			Sjeng Schalken	6-4 7-5 6-1
					Francisco Clavet
91.			Francisco Clavet		6-4 5-7 7-5 6-0
				Francisco Clavet
92.			Christian Ruud	6-1 6-4 6-4
						Thomas Muster
93.			Mark Woodforde			0-6 6-4 6-3 7-5
				Mark Woodforde
94.			Kris Goossens	6-3 6-3 6-4
					Thomas Muster
95.		[3]	Thomas Muster		4-6 6-2 6-2 6-4
				Thomas Muster
96.		[WC]	Luke Jensen	7-6(3) 6-3 6-0
									Pete Sampras
97.		[8]	Michael Stich						7-5 4-6 6-4 7-5
				Michael Stich
98.			Javier Sanchez	6-2 6-3 6-0
					Michael Stich
99.			Hernan Gumy		6-3 1-6 6-2 2-6 6-3
				Hernan Gumy
100.			Jonathan Stark	6-4 6-4 6-3
						Michael Stich
101.			Andrei Chesnokov			6-3 6-0 6-3
				Andrei Chesnokov
102.			MaliVai Washington	6-2 6-4 6-4
					Scott Draper
103.			Scott Draper		6-3 4-6 4-6 7-6(3) 6-3
				Scott Draper
104.			Cristiano Caratti	6-2 6-3 3-6 6-3
							Byron Black
105.			Jonas Bjorkman				6-4 6-4 3-6 2-6 6-3
				Jonas Bjorkman
106.		[Q]	Mark Knowles	6-1 7-5 6-1
					Jonas Bjorkman
107.			Paul Haarhuis		6-4 6-4 6-3
				Paul Haarhuis
108.			Gilbert Schaller	6-7(6) 6-1 6-3 6-7(3) 7-5
						Byron Black
109.			Byron Black			6-3 7-6(5) 6-1
				Byron Black
110.			Arnaud Boetsch	7-6(3) 6-3 6-3
					Byron Black
111.		[9]	Thomas Enqvist		6-4 6-4 3-6 6-3
				Thomas Enqvist
112.			Marcelo Rios	2-6 6-2 4-6 6-3 7-6(7)
								Pete Sampras
113.		[15]	Todd Martin					7-6(3) 6-4 6-0
				Todd Martin
114.			Guy Forget	6-3 7-5 4-6 6-4
					Todd Martin
115.			Mats Wilander		6-4 6-2 7-5
				Mats Wilander
116.		[WC]	Steve Campbell	3-6 6-1 3-6 6-4 6-2
						Todd Martin
117.			Frederik Fetterlein			6-2 6-1 6-4
				Frederik Fetterlein
118.			Jordi Burillo	6-2 2-6 6-3 4-6 6-2
					Mauricio Hadad
119.			Mauricio Hadad		6-3 2-6 6-2 7-5
				Mauricio Hadad
120.		[Q]	Jean-Philippe Fleurian	7-5 6-4 6-2
							Pete Sampras
121.			Marc-Kevin Goellner				7-6(4) 6-3 6-4
				Marc-Kevin Goellner
122.			Jan Apell	6-2 7-6(3) 6-1
					Mark Philippoussis
123.			Mark Philippoussis		7-6(5) 6-2 7-5
				Mark Philippoussis
124.			Paul Wekesa	7-6(4) 6-0 1-0 rtd.
						Pete Sampras
125.			Jaime Yzaga			6-7(5) 7-5 7-5 6-3
				Jaime Yzaga
126.			Javier Frana	6-2 5-7 2-6 6-3 6-4
					Pete Sampras
127.		[2]	Pete Sampras		6-1 6-4 6-3
				Pete Sampras
128.			Fernando Meligeni	6-0 6-3 6-4

(default) 17 queries took 24 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` = '1995' 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` = (630) 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 (4001, 4105, 4191, 4336, 5667, 4116, 3933, 4185, 6197, 6214, 4065, 3990, 6213, 4158, 5677, 6208, 6173, 4162, 4168, 7150, 4075, 4094, 4169, 6170, 4017, 3984, 6169, 5718, 4089, 7162, 5702, 4066, 3968, 6287, 8653, 6168, 3934, 6180, 4067, 6158, 4187, 4117, 3980, 4166, 5663, 4040, 4143, 5710, 4120, 6193, 5633, 5635, 4104, 4129, 7144, 5705, 6195, 4154, 4062, 8513, 4148, 4156, 5686, 4108, 4045, 4043, 4164, 6187, 4123, 6204, 3948, 4180, 4061, 6206, 5725, 3924, 6218, 5696, 4176, 4004, 4081, 5692, 5709, 6163, 5679, 3983, 4201, 7196, 4163, 6188, 4155, 4194, 4022, 6174, 4008, 3988, 4098, 4053, 6179, 4199, 4054, 4101, 6157, 4146, 5726, 5712, 4118, 5674, 4337, 4153, 5671, 6182, 4142, 3931, 3894, 6172, 6189, 5721, 6183, 4035, 4197, 5606, 5713, 5616, 3975, 4087, 4095, 4188) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	4
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` = 630	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (178, 68, 197, 179, 72, 147, 196, 121, 14, 53, 173, 13, 92, 154, 10, 150, 94, 201, 50, 133, 172, 29, 139, 207, 97, 36, 194, 54, 135, 16, 153, 168, 21, 41, 43, 127, 11, 86)	38	38	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (178, 68, 197, 179, 72, 147, 196, 121, 14, 53, 173, 13, 92, 154, 10, 150, 94, 201, 50, 133, 172, 29, 139, 207, 97, 36, 194, 54, 135, 16, 153, 168, 21, 41, 43, 127, 11, 86)	38	38	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (4001, 4105, 4191, 4336, 5667, 4116, 3933, 4185, 6197, 6214, 4065, 3990, 6213, 4158, 5677, 6208, 6173, 4162, 4168, 7150, 4075, 4094, 4169, 6170, 4017, 3984, 6169, 5718, 4089, 7162, 5702, 4066, 3968, 6287, 8653, 6168, 3934, 6180, 4067, 6158, 4187, 4117, 3980, 4166, 5663, 4040, 4143, 5710, 4120, 6193, 5633, 5635, 4104, 4129, 7144, 5705, 6195, 4154, 4062, 8513, 4148, 4156, 5686, 4108, 4045, 4043, 4164, 6187, 4123, 6204, 3948, 4180, 4061, 6206, 5725, 3924, 6218, 5696, 4176, 4004, 4081, 5692, 5709, 6163, 5679, 3983, 4201, 7196, 4163, 6188, 4155, 4194, 4022, 6174, 4008, 3988, 4098, 4053, 6179, 4199, 4054, 4101, 6157, 4146, 5726, 5712, 4118, 5674, 4337, 4153, 5671, 6182, 4142, 3931, 3894, 6172, 6189, 5721, 6183, 4035, 4197, 5606, 5713, 5616, 3975, 4087, 4095, 4188)) AND (`Playercontest`.`contest_id` = 630))	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` = 1995	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 24 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` = '1995' 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` = (630) 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 (4001, 4105, 4191, 4336, 5667, 4116, 3933, 4185, 6197, 6214, 4065, 3990, 6213, 4158, 5677, 6208, 6173, 4162, 4168, 7150, 4075, 4094, 4169, 6170, 4017, 3984, 6169, 5718, 4089, 7162, 5702, 4066, 3968, 6287, 8653, 6168, 3934, 6180, 4067, 6158, 4187, 4117, 3980, 4166, 5663, 4040, 4143, 5710, 4120, 6193, 5633, 5635, 4104, 4129, 7144, 5705, 6195, 4154, 4062, 8513, 4148, 4156, 5686, 4108, 4045, 4043, 4164, 6187, 4123, 6204, 3948, 4180, 4061, 6206, 5725, 3924, 6218, 5696, 4176, 4004, 4081, 5692, 5709, 6163, 5679, 3983, 4201, 7196, 4163, 6188, 4155, 4194, 4022, 6174, 4008, 3988, 4098, 4053, 6179, 4199, 4054, 4101, 6157, 4146, 5726, 5712, 4118, 5674, 4337, 4153, 5671, 6182, 4142, 3931, 3894, 6172, 6189, 5721, 6183, 4035, 4197, 5606, 5713, 5616, 3975, 4087, 4095, 4188) 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` = 630

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (178, 68, 197, 179, 72, 147, 196, 121, 14, 53, 173, 13, 92, 154, 10, 150, 94, 201, 50, 133, 172, 29, 139, 207, 97, 36, 194, 54, 135, 16, 153, 168, 21, 41, 43, 127, 11, 86)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (178, 68, 197, 179, 72, 147, 196, 121, 14, 53, 173, 13, 92, 154, 10, 150, 94, 201, 50, 133, 172, 29, 139, 207, 97, 36, 194, 54, 135, 16, 153, 168, 21, 41, 43, 127, 11, 86)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (4001, 4105, 4191, 4336, 5667, 4116, 3933, 4185, 6197, 6214, 4065, 3990, 6213, 4158, 5677, 6208, 6173, 4162, 4168, 7150, 4075, 4094, 4169, 6170, 4017, 3984, 6169, 5718, 4089, 7162, 5702, 4066, 3968, 6287, 8653, 6168, 3934, 6180, 4067, 6158, 4187, 4117, 3980, 4166, 5663, 4040, 4143, 5710, 4120, 6193, 5633, 5635, 4104, 4129, 7144, 5705, 6195, 4154, 4062, 8513, 4148, 4156, 5686, 4108, 4045, 4043, 4164, 6187, 4123, 6204, 3948, 4180, 4061, 6206, 5725, 3924, 6218, 5696, 4176, 4004, 4081, 5692, 5709, 6163, 5679, 3983, 4201, 7196, 4163, 6188, 4155, 4194, 4022, 6174, 4008, 3988, 4098, 4053, 6179, 4199, 4054, 4101, 6157, 4146, 5726, 5712, 4118, 5674, 4337, 4153, 5671, 6182, 4142, 3931, 3894, 6172, 6189, 5721, 6183, 4035, 4197, 5606, 5713, 5616, 3975, 4087, 4095, 4188)) AND (`Playercontest`.`contest_id` = 630))

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

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)