Roland Garros 1974 Men's Singles (June 3 - June 16)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[2]	Jan Kodes
				Jan Kodes
2.			Robert Kreiss	6-2 6-2
					Jan Kodes
3.			Jean-Baptiste Chanfreau		7-5 6-3
				Jean-Baptiste Chanfreau
4.			Harald Elschenbroich	6-3 6-4
						Jan Kodes
5.			Vijay Amritraj			6-2 6-2 6-2
				Vijay Amritraj
6.			Belus Prajoux	5-7 7-5 6-3
					Vijay Amritraj
7.			Fred McNair		7-5 3-6 6-3
				Fred McNair
8.			Patrick Hombergen	6-7 6-2 6-3
							Francois Jauffret
9.		[10]	Francois Jauffret				7-6 7-5 7-5
				Francois Jauffret
10.			Tadeusz Nowicki	3-6 6-4 7-5
					Francois Jauffret
11.			Julian Ganzabal		6-2 6-2
				Julian Ganzabal
12.			Patricio Rodriguez	6-3 6-1
						Francois Jauffret
13.			Balazs Taroczy			6-2 6-1 6-4
				Balazs Taroczy
14.			Jeff Simpson	6-4 6-4
					Balazs Taroczy
15.			Tito Vazquez		6-3 6-2
				Tito Vazquez
16.			Jorge Andrew	2-6 6-4 6-4
								Francois Jauffret
17.		[7]	Adriano Panatta					7-6 6-3 6-2
				Adriano Panatta
18.			Boro Jovanovic	6-4 2-1 rtd.
					Hans-Jurgen Pohmann
19.			Hans-Jurgen Pohmann		5-7 6-3 6-0
				Hans-Jurgen Pohmann
20.			Keith Hancock	7-5 7-5
						Hans-Jurgen Pohmann
21.			John Yuill			6-2 4-6 6-4 7-6
				John Yuill
22.			Gavorielle-Traian Marcu	6-3 6-2
					John Yuill
23.			Jean Lovera		6-2 2-6 6-4
				Jean Lovera
24.			Donald Dell	6-2 6-2
							Hans-Jurgen Pohmann
25.		[12]	Eddie Dibbs				6-3 6-3 4-6 6-4
				Eddie Dibbs
26.			Patrice Dominguez	6-3 6-2
					Eddie Dibbs
27.			Hans-Joachim Ploetz		6-2 6-3
				Hans-Joachim Ploetz
28.			Bernard Mignot	6-4 6-4
						Eddie Dibbs
29.			Corrado Barazzutti			6-0 6-1 7-6
				Corrado Barazzutti
30.			Frantisek Pala	6-7 7-5 6-2
					Corrado Barazzutti
31.			Paul Kronk		6-3 6-4
				Paul Kronk
32.			Michel Leclercq	6-3 6-0
									Manuel Orantes
33.		[4]	Arthur Ashe Jr.						6-2 6-4 6-4
				Arthur Ashe Jr.
34.			Ivan Molina	7-5 3-6 6-3
					Arthur Ashe Jr.
35.			Jun Kuki		6-2 6-1
				Jun Kuki
36.			Sherwood Stewart	6-2 6-3
						Arthur Ashe Jr.
37.			Antonio Munoz			4-6 6-1 6-3 6-4
				Antonio Munoz
38.			Szabolcs Baranyi	6-3 6-4
					Antonio Munoz
39.			Colin Dibley		7-6 6-4
				Colin Dibley
40.			Uli Pinner	6-4 6-2
							Manuel Orantes
41.		[14]	Manuel Orantes				6-1 6-2 6-2
				Manuel Orantes
42.			Jaime Pinto	6-2 6-0
					Manuel Orantes
43.			Antonio Zugarelli		6-4 6-1
				Antonio Zugarelli
44.			Anand Amritraj	6-1 6-4
						Manuel Orantes
45.			Guillermo Vilas			3-6 3-6 7-6 6-3 6-2
				Guillermo Vilas
46.			Milan Holecek	6-1 6-3
					Guillermo Vilas
47.			Dick Crealy		6-4 6-4
				Dick Crealy
48.			Steve Faulk	6-1 7-5
								Manuel Orantes
49.			Jun Kamiwazumi					6-3 6-3 6-1
				Jun Kamiwazumi
50.		[6]	Stan Smith	3-6 6-4 8-6
					Jurgen Fassbender
51.			Jurgen Fassbender		6-2 7-6
				Jurgen Fassbender
52.			Munawar Iqbal	6-2 6-1
						Patricio Cornejo
53.			Patricio Cornejo			6-1 6-2 6-4
				Patricio Cornejo
54.			John Feaver	6-7 6-1 6-2
					Patricio Cornejo
55.			Kjell Johansson		6-3 6-1
				Kjell Johansson
56.			Thierry Bernasconi	6-4 4-6 6-3
							Patricio Cornejo
57.		[16]	Jaime Fillol				6-2 7-6 4-6 5-7 6-4
				Jaime Fillol
58.			Herve Gauvain	5-7 6-4 6-1
					Jaime Fillol
59.			Charlie Pasarell		6-1 6-1
				Charlie Pasarell
60.			Anatoli Volkov	7-6 7-6
						Jaime Fillol
61.			Attila Korpas			6-1 7-6 6-1
				Attila Korpas
62.			Peter Szoke	6-4 6-2
					Attila Korpas
63.			Eric Deblicker		6-2 7-5
				Eric Deblicker
64.			Colin Dowdeswell	6-3 7-6
										Bjorn Borg
65.			Patrick Proisy							2-6 6-7 6-0 6-1 6-1
				Patrick Proisy
66.			John Lloyd	6-2 7-5
					Patrick Proisy
67.			Ismail El Shafei		6-4 6-0
				Ismail El Shafei
68.			Bob Lutz	7-5 6-2
						Raul Ramirez
69.			Petr Kanderal			w/o
				Petr Kanderal
70.			Pat Cramer	3-6 6-2 9-7
					Raul Ramirez
71.		[9]	Raul Ramirez		6-3 6-2
				Raul Ramirez
72.			Vincenzo Franchitti	6-0 6-0
							Raul Ramirez
73.			Toshiro Sakai				6-3 6-1 4-6 7-5
				Toshiro Sakai
74.			Ramiro Benavides	6-3 3-6 6-0
					Toshiro Sakai
75.			Vladimir Zednik		6-4 6-3
				Vladimir Zednik
76.			Graeme Thomson	6-4 6-1
						Thomaz Koch
77.			Thomaz Koch			6-1 6-7 4-6 6-4 6-4
				Thomaz Koch
78.			Wanaro N'Godrella	6-4 6-2
					Thomaz Koch
79.		[5]	Tom Gorman		6-2 4-6 6-4
				Tom Gorman
80.			Jairo Velasco Sr.	6-3 7-6
								Bjorn Borg
81.			Erik Van Dillen					6-2 5-7 4-6 6-2 6-3
				Erik Van Dillen
82.			Piero Toci	6-2 6-2
					Erik Van Dillen
83.			Jan Pisecky		7-6 7-6
				Jan Pisecky
84.			Daniel Contet	6-4 6-4
						Erik Van Dillen
85.			Barry Phillips-Moore			3-6 6-2 6-0 6-4
				Barry Phillips-Moore
86.			Marcelo Lara	6-1 6-0
					Barry Phillips-Moore
87.			William Brown		6-1 4-6 6-1
				William Brown
88.		[11]	Paolo Bertolucci	6-4 5-7 6-2
							Bjorn Borg
89.			Jean-Loup Rouyer				0-6 6-3 6-3 5-7 6-3
				Jean-Loup Rouyer
90.			Pierre Joly	6-3 6-4
					Jean-Loup Rouyer
91.			Teimuraz Kakulia		2-6 6-2 6-1
				Teimuraz Kakulia
92.			Patrice Hagelauer	6-3 7-5
						Bjorn Borg
93.			Toma Ovici			6-4 6-2 6-0
				Toma Ovici
94.			Elio Alvarez	6-2 6-3
					Bjorn Borg
95.		[3]	Bjorn Borg		6-1 6-1
				Bjorn Borg
96.			Jean-Francois Caujolle	4-6 6-0 6-4
									Bjorn Borg
97.			Jose Higueras						6-4 2-6 6-2 6-1
				Jose Higueras
98.			Jose Mandarino	6-4 6-4
					Jose Higueras
99.			Jean-Claude Barclay		6-1 3-6 6-3
				Jean-Claude Barclay
100.			Jim McManus	6-0 2-0 rtd.
						Marty Riessen
101.			Jeff Borowiak			6-1 6-3 7-5
				Jeff Borowiak
102.			Steve Krulevitz	6-3 6-2
					Marty Riessen
103.		[13]	Marty Riessen		6-4 6-0
				Marty Riessen
104.			Hans Kary	1-6 6-4 6-3
							Harold Solomon
105.			Harold Solomon				6-2 6-1 6-1
				Harold Solomon
106.			Robert Machan	1-6 6-4 6-2
					Harold Solomon
107.			Paul Gerken		6-2 6-2
				Paul Gerken
108.			Victor Pecci	7-6 6-4
						Harold Solomon
109.			Zeljko Franulovic			5-7 7-6 4-6 6-3 6-2
				Zeljko Franulovic
110.			Omar Laimina	4-6 7-5 7-5
					Zeljko Franulovic
111.		[8]	Aleksandr Metreveli		6-4 2-6 6-1
				Aleksandr Metreveli
112.			Juan Gisbert	6-3 7-6
								Harold Solomon
113.			Pierre Barthes					6-4 6-4 0-6 3-6 6-4
				Pierre Barthes
114.			Terry Ryan	6-2 6-1
					Pierre Barthes
115.			Jiri Hrebec		6-2 6-1
				Jiri Hrebec
116.			Karl Meiler	6-4 6-1
						Onny Parun
117.			Onny Parun			2-6 3-6 6-1 6-2 6-4
				Onny Parun
118.			Ezio Di Matteo	6-2 1-6 6-4
					Onny Parun
119.		[15]	Brian Gottfried		1-6 7-6 6-4
				Brian Gottfried
120.			Tenny Svensson	4-6 6-1 6-2
							Ilie Nastase
121.			Georges Goven				6-4 6-2 7-6
				Georges Goven
122.			Roscoe Tanner	7-5 4-6 9-7
					Georges Goven
123.			Richard Russell		6-3 6-3
				Richard Russell
124.			John Paish	6-4 5-7 6-4
						Ilie Nastase
125.			Leif Johansson			6-4 6-2 7-6
				Leif Johansson
126.			Ray Keldie	w/o
					Ilie Nastase
127.		[1]	Ilie Nastase		6-0 6-1
				Ilie Nastase
128.			Maurice Claitte	6-0 6-2

(default) 17 queries took 34 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` = 'roland-garros' 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` = (2)	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` = (2)	5	5	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` = (2)	5	5	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` = 'roland-garros' 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` = (12) ORDER BY `Contest`.`year` ASC	123	123	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` = 2 AND `Contest`.`category_id` = 12 AND `Contest`.`slug` = '1974' LIMIT 1	1	1	1
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` = (352) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	127	127	7
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (3533, 3564, 3483, 815, 3639, 3654, 3554, 4269, 3699, 5086, 3702, 3146, 3661, 3629, 3488, 3682, 3614, 793, 3633, 4315, 3678, 5116, 5117, 3024, 3636, 3632, 4320, 3686, 3651, 3555, 3652, 5025, 3215, 3634, 3577, 3451, 3556, 4323, 3574, 4329, 3516, 3514, 3648, 3619, 3618, 3378, 808, 3569, 3617, 3386, 3547, 5118, 3385, 3640, 3700, 4321, 3437, 4808, 3005, 5059, 5112, 4324, 3714, 3708, 3519, 3646, 3398, 3436, 4326, 3524, 3623, 5110, 3572, 3669, 3563, 4314, 3344, 3638, 3446, 3630, 3502, 4303, 5122, 3470, 3649, 3425, 3497, 3645, 3536, 4331, 3635, 4826, 3734, 3493, 3647, 3659, 3689, 3328, 3595, 785, 3498, 3542, 3168, 3681, 3627, 4319, 3511, 3684, 3510, 5121, 3318, 3677, 3376, 3557, 3658, 3653, 3517, 5065, 3612, 3694, 3495, 3529, 3596, 3559, 5120, 3462, 3527, 5119) 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` = 352	128	128	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (173, 13, 153, 68, 217, 197, 219, 212, 41, 218, 59, 121, 29, 10, 135, 172, 196, 94, 93, 92, 86, 43, 178, 84, 26, 14, 201, 146, 21, 149, 141, 127, 179, 213)	34	34	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (173, 13, 153, 68, 217, 197, 219, 212, 41, 218, 59, 121, 29, 10, 135, 172, 196, 94, 93, 92, 86, 43, 178, 84, 26, 14, 201, 146, 21, 149, 141, 127, 179, 213)	34	34	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3533, 3564, 3483, 815, 3639, 3654, 3554, 4269, 3699, 5086, 3702, 3146, 3661, 3629, 3488, 3682, 3614, 793, 3633, 4315, 3678, 5116, 5117, 3024, 3636, 3632, 4320, 3686, 3651, 3555, 3652, 5025, 3215, 3634, 3577, 3451, 3556, 4323, 3574, 4329, 3516, 3514, 3648, 3619, 3618, 3378, 808, 3569, 3617, 3386, 3547, 5118, 3385, 3640, 3700, 4321, 3437, 4808, 3005, 5059, 5112, 4324, 3714, 3708, 3519, 3646, 3398, 3436, 4326, 3524, 3623, 5110, 3572, 3669, 3563, 4314, 3344, 3638, 3446, 3630, 3502, 4303, 5122, 3470, 3649, 3425, 3497, 3645, 3536, 4331, 3635, 4826, 3734, 3493, 3647, 3659, 3689, 3328, 3595, 785, 3498, 3542, 3168, 3681, 3627, 4319, 3511, 3684, 3510, 5121, 3318, 3677, 3376, 3557, 3658, 3653, 3517, 5065, 3612, 3694, 3495, 3529, 3596, 3559, 5120, 3462, 3527, 5119)) AND (`Playercontest`.`contest_id` = 352))	128	128	2
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 12 ORDER BY `Contest`.`date_from` ASC	123	123	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1974	19	19	7
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	2

(default) 17 queries took 34 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` = 'roland-garros' 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` = (2)

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` = (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`, `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` = 'roland-garros' AND `Category`.`slug` = 'men-singles' LIMIT 1

123

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` = 2 AND `Contest`.`category_id` = 12 AND `Contest`.`slug` = '1974' 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` = (352) 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 (3533, 3564, 3483, 815, 3639, 3654, 3554, 4269, 3699, 5086, 3702, 3146, 3661, 3629, 3488, 3682, 3614, 793, 3633, 4315, 3678, 5116, 5117, 3024, 3636, 3632, 4320, 3686, 3651, 3555, 3652, 5025, 3215, 3634, 3577, 3451, 3556, 4323, 3574, 4329, 3516, 3514, 3648, 3619, 3618, 3378, 808, 3569, 3617, 3386, 3547, 5118, 3385, 3640, 3700, 4321, 3437, 4808, 3005, 5059, 5112, 4324, 3714, 3708, 3519, 3646, 3398, 3436, 4326, 3524, 3623, 5110, 3572, 3669, 3563, 4314, 3344, 3638, 3446, 3630, 3502, 4303, 5122, 3470, 3649, 3425, 3497, 3645, 3536, 4331, 3635, 4826, 3734, 3493, 3647, 3659, 3689, 3328, 3595, 785, 3498, 3542, 3168, 3681, 3627, 4319, 3511, 3684, 3510, 5121, 3318, 3677, 3376, 3557, 3658, 3653, 3517, 5065, 3612, 3694, 3495, 3529, 3596, 3559, 5120, 3462, 3527, 5119) 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` = 352

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3533, 3564, 3483, 815, 3639, 3654, 3554, 4269, 3699, 5086, 3702, 3146, 3661, 3629, 3488, 3682, 3614, 793, 3633, 4315, 3678, 5116, 5117, 3024, 3636, 3632, 4320, 3686, 3651, 3555, 3652, 5025, 3215, 3634, 3577, 3451, 3556, 4323, 3574, 4329, 3516, 3514, 3648, 3619, 3618, 3378, 808, 3569, 3617, 3386, 3547, 5118, 3385, 3640, 3700, 4321, 3437, 4808, 3005, 5059, 5112, 4324, 3714, 3708, 3519, 3646, 3398, 3436, 4326, 3524, 3623, 5110, 3572, 3669, 3563, 4314, 3344, 3638, 3446, 3630, 3502, 4303, 5122, 3470, 3649, 3425, 3497, 3645, 3536, 4331, 3635, 4826, 3734, 3493, 3647, 3659, 3689, 3328, 3595, 785, 3498, 3542, 3168, 3681, 3627, 4319, 3511, 3684, 3510, 5121, 3318, 3677, 3376, 3557, 3658, 3653, 3517, 5065, 3612, 3694, 3495, 3529, 3596, 3559, 5120, 3462, 3527, 5119)) AND (`Playercontest`.`contest_id` = 352))

128

SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 12 ORDER BY `Contest`.`date_from` ASC

123

SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1974

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)