US Open 1975 Men's Singles (August 27 - September 7)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Jimmy Connors
				Jimmy Connors
2.			Geoff Masters	6-3 6-3
					Jimmy Connors
3.			Roger Taylor		6-2 6-0
				Roger Taylor
4.			Jiri Hrebec	7-6 1-6 6-4
						Jimmy Connors
5.			Georges Goven			6-3 6-1
				Georges Goven
6.			Birger Andersson	6-2 6-3
					Georges Goven
7.			Nikki Spear		3-6 7-5 6-0
				Nikki Spear
8.			Fred McNair	7-5 6-0
							Jimmy Connors
9.		[13]	Harold Solomon				6-4 6-2 5-7 6-3
				Harold Solomon
10.			Victor Pecci	3-6 6-2 6-2
					Harold Solomon
11.			Ivan Molina		6-2 6-2
				Ivan Molina
12.			Steve Docherty	6-1 6-1
						Harold Solomon
13.			Wojtek Fibak			4-6 6-0 7-6
				Wojtek Fibak
14.			John Yuill	6-3 6-0
					Wojtek Fibak
15.			Jeff Austin		7-6 7-5
				Jeff Austin
16.			Steve Krulevitz	3-6 6-4 6-3
								Jimmy Connors
17.		[6]	Tom Okker					6-2 6-1 6-2
				Tom Okker
18.			Jurgen Fassbender	6-4 6-2
					Balazs Taroczy
19.			Balazs Taroczy		6-3 6-4
				Balazs Taroczy
20.			Bernard Mignot	6-4 6-4
						Bob Hewitt
21.			Bob Hewitt			6-2 6-1
				Bob Hewitt
22.			Fred Stolle	6-2 7-6
					Bob Hewitt
23.			John Lloyd		6-0 7-6
				John Lloyd
24.			Clark Graebner	6-7 6-2 6-3
							Andrew Pattison
25.		[12]	John Alexander				6-4 6-2 1-6 6-2
				John Alexander
26.			Marty Riessen	7-6 6-1
					Andrew Pattison
27.			Andrew Pattison		6-1 7-5
				Andrew Pattison
28.			Patrick Proisy	6-4 6-2
						Andrew Pattison
29.			Ricardo Cano			5-7 6-4 7-5
				Ricardo Cano
30.			Patricio Cornejo	2-6 6-0 7-6
					Ricardo Cano
31.			Cliff Drysdale		6-4 3-6 7-5
				Cliff Drysdale
32.			John Feaver	6-4 6-4
									Jimmy Connors
33.		[4]	Arthur Ashe Jr.						7-5 7-5 7-5
				Arthur Ashe Jr.
34.			Victor Amaya	6-3 7-6
					Arthur Ashe Jr.
35.			Vijay Amritraj		6-3 6-1
				Vijay Amritraj
36.			Jun Kamiwazumi	7-5 5-7 7-5
						Arthur Ashe Jr.
37.			Zeljko Franulovic			6-2 6-0
				Zeljko Franulovic
38.			Ray Moore	6-2 3-6 6-1
					Zeljko Franulovic
39.			Antonio Munoz		5-7 7-5 6-1
				Antonio Munoz
40.			Howard Schoenfield	7-5 3-6 7-6
							Eddie Dibbs
41.		[16]	Cliff Richey Jr.				6-4 6-2 6-3
				Cliff Richey Jr.
42.			Marcelo Lara	7-6 6-0
					Eddie Dibbs
43.			Eddie Dibbs		6-1 6-0
				Eddie Dibbs
44.			Charlie Owens	7-5 6-7 6-2
						Eddie Dibbs
45.			Jose Higueras			6-3 6-0
				Jose Higueras
46.			Peter Fishbach	6-3 6-4
					Jose Higueras
47.			Jairo Velasco Sr.		6-4 2-6 6-1
				Jairo Velasco Sr.
48.			Roger Dowdeswell	4-6 6-4 6-4
								Bjorn Borg
49.		[5]	Bjorn Borg					6-4 7-6 4-6 7-6
				Bjorn Borg
50.			Sandy Mayer	6-2 6-2
					Bjorn Borg
51.			Mike Estep		6-0 6-2
				Mike Estep
52.			Ramiro Benavides	6-3 6-4
						Bjorn Borg
53.			Ross Case			6-3 6-3
				Ross Case
54.			Bruce Manson	6-2 6-4
					Ross Case
55.			William Lloyd		6-4 6-1
				William Lloyd
56.			William Brown	6-3 6-7 6-3
							Bjorn Borg
57.		[9]	Rod Laver				6-1 6-4 2-6 6-2
				Rod Laver
58.			Juan Gisbert	7-5 6-4
					Rod Laver
59.			Alvaro Fillol		7-6 6-4
				Alvaro Fillol
60.			Dennis Ralston	7-6 6-7 7-5
						Rod Laver
61.			John Andrews			6-2 6-3
				John Andrews
62.			John Whitlinger	6-2 6-0
					John Andrews
63.			Milan Holecek		7-5 5-7 7-6
				Milan Holecek
64.			Raz Reid	6-4 6-2
										Manuel Orantes
65.			Onny Parun							6-4 6-3 6-3
				Onny Parun
66.			Stan Smith	6-4 6-2
					Onny Parun
67.			Kim Warwick		7-5 6-3
				Kim Warwick
68.			Barry Phillips-Moore	6-2 7-6
						Raul Ramirez
69.			Frantisek Pala			1-6 6-3 6-3
				Frantisek Pala
70.			Anand Amritraj	6-4 7-6
					Raul Ramirez
71.		[11]	Raul Ramirez		6-4 6-4
				Raul Ramirez
72.			Erik Van Dillen	6-2 6-7 7-5
							Ilie Nastase
73.			Mark Cox				6-4 5-7 6-0 6-7 6-3
				Mark Cox
74.			Robert Kreiss	6-2 6-4
					Mark Cox
75.			Armistead Neely		6-4 6-1
				Armistead Neely
76.			Tom Gorman	6-3 7-6
						Ilie Nastase
77.			Allan Stone			6-0 6-4
				Allan Stone
78.			Bob Carmichael	6-4 7-6
					Ilie Nastase
79.		[8]	Ilie Nastase		6-2 6-3
				Ilie Nastase
80.			Bob Lutz	6-2 6-1
								Manuel Orantes
81.			Kjell Johansson					6-2 6-4 3-6 6-3
				Kjell Johansson
82.			Vladimir Zednik	6-7 6-3 7-6
					Kjell Johansson
83.			Steve Turner		6-1 6-2
				Steve Turner
84.			Eugene Scott	6-1 6-2
						Francois Jauffret
85.			Francois Jauffret			7-5 6-4
				Francois Jauffret
86.			Rick Fagel	6-4 6-2
					Francois Jauffret
87.		[14]	Vitas Gerulaitis		7-6 7-5
				Vitas Gerulaitis
88.			Joaquim Rasgado	5-7 6-3 6-2
							Manuel Orantes
89.			Hans-Jurgen Pohmann				6-4 3-6 6-3 6-4
				Hans-Jurgen Pohmann
90.			Belus Prajoux	3-6 6-4 6-2
					Hans-Jurgen Pohmann
91.			Elio Alvarez		6-1 6-1
				Elio Alvarez
92.			Brian Teacher	6-3 6-2
						Manuel Orantes
93.			Sashi Menon			6-2 3-6 6-1
				Sashi Menon
94.			Paul Gerken	6-4 7-5
					Manuel Orantes
95.		[3]	Manuel Orantes		6-2 6-2
				Manuel Orantes
96.			Bernie Mitton	6-3 6-2
									Manuel Orantes
97.			Karl Meiler						4-6 1-6 6-2 7-5 6-4
				Karl Meiler
98.			Jun Kuki	7-5 6-3
					Karl Meiler
99.			Brian Gottfried		6-4 6-3
				Brian Gottfried
100.			Aleksandr Metreveli	6-7 6-2 6-1
						Karl Meiler
101.			Phil Dent			6-7 6-4 6-4
				Phil Dent
102.			Jeff Borowiak	6-3 6-0
					Roscoe Tanner
103.		[10]	Roscoe Tanner		6-2 6-1
				Roscoe Tanner
104.			David Schneider	7-5 4-6 6-1
							Jaime Fillol
105.			Charlie Pasarell				6-1 6-1 6-2
				Charlie Pasarell
106.			Christopher Mottram	5-7 6-3 7-5
					Charlie Pasarell
107.			Frew McMillan		7-5 6-2
				Frew McMillan
108.			Rolf Thung	6-0 6-3
						Jaime Fillol
109.			Jaime Fillol			6-3 7-5
				Jaime Fillol
110.			Tenny Svensson	6-1 6-2
					Jaime Fillol
111.		[7]	Tony Roche		6-0 6-2
				Tony Roche
112.			David Kanter	6-1 7-5
								Guillermo Vilas
113.			Syd Ball					6-4 6-0 6-1
				Syd Ball
114.			Joaquin Loyo-Mayo	6-4 7-5
					Syd Ball
115.			Trey Waltke		6-2 6-3
				Trey Waltke
116.			Carlos Kirmayr	6-7 6-1 6-1
						Jan Kodes
117.			Hans Kary			6-2 6-0
				Hans Kary
118.			Norman Holmes	6-4 7-5
					Jan Kodes
119.		[15]	Jan Kodes		6-1 5-7 7-5
				Jan Kodes
120.			Graham Stilwell	6-3 6-1
							Guillermo Vilas
121.			Dick Stockton				6-2 6-0 6-0
				Dick Stockton
122.			Gerald Battrick	6-3 3-6 6-3
					Dick Stockton
123.			Gene Mayer		6-4 6-4
				Gene Mayer
124.			Sherwood Stewart	3-6 6-4 6-3
						Guillermo Vilas
125.			Alvaro Betancur			6-1 6-4
				Alvaro Betancur
126.			Billy Martin	2-6 6-4 6-1
					Guillermo Vilas
127.		[2]	Guillermo Vilas		6-1 6-1
				Guillermo Vilas
128.			Hans Gildemeister	6-2 6-2

(default) 17 queries took 21 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` = '1975' 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` = (610) 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 (3539, 3560, 798, 3658, 3495, 3683, 3576, 3554, 3627, 3684, 3634, 3675, 3685, 3678, 3552, 3542, 3380, 3547, 3661, 3686, 738, 729, 3646, 3249, 3515, 3168, 3558, 3519, 3687, 3385, 3305, 3640, 3215, 3655, 3639, 3617, 3510, 3388, 3556, 3688, 3359, 3425, 3636, 3615, 3689, 3458, 3630, 3680, 3647, 3550, 3454, 3669, 3571, 3662, 3818, 3497, 715, 3677, 3763, 3175, 3656, 3664, 3378, 3631, 3517, 3386, 3666, 3649, 3555, 3619, 3623, 3502, 818, 3564, 3391, 3446, 817, 3531, 3527, 3436, 3700, 3563, 3668, 3124, 3699, 3698, 3573, 3697, 3633, 3654, 3493, 3657, 3565, 3511, 3516, 3696, 3653, 3577, 3612, 3318, 3538, 3498, 3529, 3705, 3005, 3641, 3382, 3695, 3437, 3694, 3349, 3693, 3665, 3442, 3672, 3692, 3681, 3566, 3533, 822, 3490, 3528, 3744, 3451, 3691, 3613, 3618, 3690) 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` = 610	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 173, 41, 13, 172, 196, 218, 121, 217, 133, 10, 68, 219, 135, 153, 212, 230, 86, 94, 43, 178, 84, 26, 14, 146, 149, 21, 29)	28	28	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 173, 41, 13, 172, 196, 218, 121, 217, 133, 10, 68, 219, 135, 153, 212, 230, 86, 94, 43, 178, 84, 26, 14, 146, 149, 21, 29)	28	28	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3539, 3560, 798, 3658, 3495, 3683, 3576, 3554, 3627, 3684, 3634, 3675, 3685, 3678, 3552, 3542, 3380, 3547, 3661, 3686, 738, 729, 3646, 3249, 3515, 3168, 3558, 3519, 3687, 3385, 3305, 3640, 3215, 3655, 3639, 3617, 3510, 3388, 3556, 3688, 3359, 3425, 3636, 3615, 3689, 3458, 3630, 3680, 3647, 3550, 3454, 3669, 3571, 3662, 3818, 3497, 715, 3677, 3763, 3175, 3656, 3664, 3378, 3631, 3517, 3386, 3666, 3649, 3555, 3619, 3623, 3502, 818, 3564, 3391, 3446, 817, 3531, 3527, 3436, 3700, 3563, 3668, 3124, 3699, 3698, 3573, 3697, 3633, 3654, 3493, 3657, 3565, 3511, 3516, 3696, 3653, 3577, 3612, 3318, 3538, 3498, 3529, 3705, 3005, 3641, 3382, 3695, 3437, 3694, 3349, 3693, 3665, 3442, 3672, 3692, 3681, 3566, 3533, 822, 3490, 3528, 3744, 3451, 3691, 3613, 3618, 3690)) AND (`Playercontest`.`contest_id` = 610))	128	128	1
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` = 1975	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 21 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` = '1975' 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` = (610) 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 (3539, 3560, 798, 3658, 3495, 3683, 3576, 3554, 3627, 3684, 3634, 3675, 3685, 3678, 3552, 3542, 3380, 3547, 3661, 3686, 738, 729, 3646, 3249, 3515, 3168, 3558, 3519, 3687, 3385, 3305, 3640, 3215, 3655, 3639, 3617, 3510, 3388, 3556, 3688, 3359, 3425, 3636, 3615, 3689, 3458, 3630, 3680, 3647, 3550, 3454, 3669, 3571, 3662, 3818, 3497, 715, 3677, 3763, 3175, 3656, 3664, 3378, 3631, 3517, 3386, 3666, 3649, 3555, 3619, 3623, 3502, 818, 3564, 3391, 3446, 817, 3531, 3527, 3436, 3700, 3563, 3668, 3124, 3699, 3698, 3573, 3697, 3633, 3654, 3493, 3657, 3565, 3511, 3516, 3696, 3653, 3577, 3612, 3318, 3538, 3498, 3529, 3705, 3005, 3641, 3382, 3695, 3437, 3694, 3349, 3693, 3665, 3442, 3672, 3692, 3681, 3566, 3533, 822, 3490, 3528, 3744, 3451, 3691, 3613, 3618, 3690) 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` = 610

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 173, 41, 13, 172, 196, 218, 121, 217, 133, 10, 68, 219, 135, 153, 212, 230, 86, 94, 43, 178, 84, 26, 14, 146, 149, 21, 29)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 173, 41, 13, 172, 196, 218, 121, 217, 133, 10, 68, 219, 135, 153, 212, 230, 86, 94, 43, 178, 84, 26, 14, 146, 149, 21, 29)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3539, 3560, 798, 3658, 3495, 3683, 3576, 3554, 3627, 3684, 3634, 3675, 3685, 3678, 3552, 3542, 3380, 3547, 3661, 3686, 738, 729, 3646, 3249, 3515, 3168, 3558, 3519, 3687, 3385, 3305, 3640, 3215, 3655, 3639, 3617, 3510, 3388, 3556, 3688, 3359, 3425, 3636, 3615, 3689, 3458, 3630, 3680, 3647, 3550, 3454, 3669, 3571, 3662, 3818, 3497, 715, 3677, 3763, 3175, 3656, 3664, 3378, 3631, 3517, 3386, 3666, 3649, 3555, 3619, 3623, 3502, 818, 3564, 3391, 3446, 817, 3531, 3527, 3436, 3700, 3563, 3668, 3124, 3699, 3698, 3573, 3697, 3633, 3654, 3493, 3657, 3565, 3511, 3516, 3696, 3653, 3577, 3612, 3318, 3538, 3498, 3529, 3705, 3005, 3641, 3382, 3695, 3437, 3694, 3349, 3693, 3665, 3442, 3672, 3692, 3681, 3566, 3533, 822, 3490, 3528, 3744, 3451, 3691, 3613, 3618, 3690)) AND (`Playercontest`.`contest_id` = 610))

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

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)