Roland Garros 1975 Men's Singles (June 2 - June 15)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.			Antonio Zugarelli
				Antonio Zugarelli
2.		[2]	Manuel Orantes	6-3 6-0
					Antonio Zugarelli
3.			Elio Alvarez		6-3 4-6 6-3
				Elio Alvarez
4.			Marcelo Lara	7-5 6-3
						Antonio Zugarelli
5.			Colin Dibley			6-3 6-4 7-5
				Colin Dibley
6.			Jaime Pinto	6-3 5-7 6-3
					Colin Dibley
7.			Joaquin Loyo-Mayo		6-3 6-4
				Joaquin Loyo-Mayo
8.			Graham Stilwell	3-6 6-3 6-2
							Eddie Dibbs
9.		[10]	Eddie Dibbs				6-4 7-5 6-4
				Eddie Dibbs
10.		[Q]	Louis Borfiga	6-3 6-2
					Eddie Dibbs
11.			Balazs Taroczy		6-3 6-4
				Balazs Taroczy
12.			John James	7-5 6-2
						Eddie Dibbs
13.			Niki Pilic			6-2 6-2 3-6 6-4
				Niki Pilic
14.			Denis Naegelen	6-4 6-2
					Niki Pilic
15.			Andrew Pattison		6-4 6-3
				Andrew Pattison
16.			Harald Elschenbroich	7-5 6-4
								Eddie Dibbs
17.		[7]	Raul Ramirez					4-6 7-6 6-1 5-7 6-4
				Raul Ramirez
18.			Mark Farrell	6-4 6-1
					Raul Ramirez
19.		[Q]	Martin Robinson		7-6 6-0
				Martin Robinson
20.			Juan Gisbert	6-1 6-4
						Raul Ramirez
21.			Corrado Barazzutti			4-6 6-4 6-0 6-1
				Corrado Barazzutti
22.			Robert Kreiss	6-7 6-3 6-4
					Corrado Barazzutti
23.			Jairo Velasco Sr.		6-3 6-1
				Jairo Velasco Sr.
24.			Jan Pisecky	6-2 7-5
							Raul Ramirez
25.		[12]	Francois Jauffret				6-2 6-1 6-4
				Francois Jauffret
26.			Dick Crealy	7-5 6-3
					Francois Jauffret
27.			Nikki Spear		6-1 7-5
				Nikki Spear
28.			Thomaz Koch	7-6 5-7 7-5
						Francois Jauffret
29.			Kjell Johansson			1-6 3-6 6-3 6-1 6-4
				Kjell Johansson
30.			Uli Pinner	4-6 6-3 6-4
					Kjell Johansson
31.		[Q]	Ulrich Marten		6-4 6-2
				Ulrich Marten
32.			Patricio Cornejo	7-6 7-6
									Guillermo Vilas
33.		[4]	Guillermo Vilas						6-1 6-4 1-6 6-1
				Guillermo Vilas
34.			Hans-Joachim Ploetz	6-0 6-0
					Guillermo Vilas
35.		[Q]	Juan Muntanola-Vilamela		6-1 6-3
				Juan Muntanola-Vilamela
36.			Tenny Svensson	6-3 6-2
						Guillermo Vilas
37.		[Q]	Ricardo Cano			7-5 6-4 6-2
				Ricardo Cano
38.			Frank Gebert	6-2 6-4
					Ricardo Cano
39.		[Q]	Armistead Neely		6-4 6-3
				Armistead Neely
40.			Rolf Thung	7-6 6-4
							Guillermo Vilas
41.		[14]	Jan Kodes				6-1 6-4 6-2
				Jan Kodes
42.			Wojtek Fibak	2-6 6-3 8-6
					Jan Kodes
43.			Anatoli Volkov		6-3 6-4
				Anatoli Volkov
44.			Jose Mandarino	3-6 7-6 6-3
						Jan Kodes
45.			Paul Kronk			6-3 7-6 6-3
				Paul Kronk
46.		[Q]	Patrice Beust	6-1 6-4
					Paul Kronk
47.			Jun Kamiwazumi		7-5 5-7 6-2
				Jun Kamiwazumi
48.			Bernard Mignot	7-6 7-6
								Guillermo Vilas
49.		[6]	John Alexander					6-2 6-2 7-6
				John Alexander
50.			Jean-Baptiste Chanfreau	6-4 6-2
					John Alexander
51.			Haroon Rahim		7-6 6-0
				Haroon Rahim
52.			Humphrey Hose	6-3 6-2
						John Alexander
53.			Belus Prajoux			6-1 2-6 7-5 7-5
				Belus Prajoux
54.			Teimuraz Kakulia	5-7 6-2 6-1
					Belus Prajoux
55.			Jean-Francois Caujolle		6-1 6-4
				Jean-Francois Caujolle
56.			Frantisek Pala	2-6 7-6 6-3
							Onny Parun
57.		[16]	Onny Parun				6-2 2-6 3-6 6-2 8-6
				Onny Parun
58.		[Q]	Jose Antonio Castanon	6-2 6-3
					Onny Parun
59.			Wanaro N'Godrella		6-4 7-5
				Wanaro N'Godrella
60.		[Q]	Piero Toci	6-4 6-3
						Onny Parun
61.			Patrick Proisy			6-2 6-7 6-2 6-4
				Patrick Proisy
62.			Paul Gerken	6-7 6-1 7-5
					Patrick Proisy
63.		[Q]	Toma Ovici		7-6 6-0
				Toma Ovici
64.			Bob Carmichael	6-3 7-5
										Bjorn Borg
65.			Erik Van Dillen							6-2 6-3 6-4
				Erik Van Dillen
66.			Karl Meiler	6-1 6-2
					Erik Van Dillen
67.		[Q]	Szabolcs Baranyi		6-3 6-3
				Szabolcs Baranyi
68.			Eric Deblicker	6-3 6-4
						Erik Van Dillen
69.		[Q]	Carlos Kirmayr			6-4 6-4 7-6
				Carlos Kirmayr
70.			Gerald Battrick	2-6 6-3 8-6
					Carlos Kirmayr
71.		[9]	Aleksandr Metreveli		2-6 7-5 6-4
				Aleksandr Metreveli
72.			Ove Bengston	6-2 6-4
							John Andrews
73.			John Andrews				6-2 7-5 0-6 2-6 6-3
				John Andrews
74.			Jose Higueras	6-4 6-4
					John Andrews
75.			Mike Estep		6-1 4-6 8-6
				Mike Estep
76.		[Q]	Jean-Claude Barclay	7-5 6-3
						John Andrews
77.			Pierre Barthes			3-6 3-6 6-3 6-4 6-4
				Pierre Barthes
78.		[Q]	Ionel Santeiu	6-4 6-2
					Roscoe Tanner
79.		[5]	Roscoe Tanner		6-4 3-6 6-2
				Roscoe Tanner
80.			John Feaver	6-0 6-4
								Adriano Panatta
81.			Zeljko Franulovic					6-3 5-7 7-6 6-2
				Zeljko Franulovic
82.			Daniel Contet	5-7 6-2 6-4
					Zeljko Franulovic
83.			Antonio Munoz		6-0 6-7 6-2
				Antonio Munoz
84.			Fred McNair	6-3 6-0
						Jaime Fillol
85.			John Yuill			6-4 6-4 7-5
				John Yuill
86.			Rick Fisher	6-2 6-4
					Jaime Fillol
87.		[11]	Jaime Fillol		7-6 6-2
				Jaime Fillol
88.		[Q]	Jacek Niedzwiedzki	6-2 3-6 6-1
							Adriano Panatta
89.			Adriano Panatta				6-3 6-4 6-4
				Adriano Panatta
90.			Rolf Gehring	7-5 6-4
					Adriano Panatta
91.			Doug Crawford		6-2 6-2
				Doug Crawford
92.			Milan Holecek	6-4 5-7 6-4
						Adriano Panatta
93.			Paolo Bertolucci			6-4 3-6 7-6 6-1
				Paolo Bertolucci
94.			Jun Kuki	6-3 6-1
					Ilie Nastase
95.		[3]	Ilie Nastase		3-6 6-3 6-0
				Ilie Nastase
96.			Barry Phillips-Moore	6-3 6-2
									Bjorn Borg
97.			Roger Taylor						6-4 1-6 7-5 6-4
				Roger Taylor
98.		[Q]	Miguel Mir-Rodon	6-3 6-3
					Roger Taylor
99.			Patrice Dominguez		6-4 6-3
				Patrice Dominguez
100.			Sherwood Stewart	6-2 6-4
						Brian Gottfried
101.			Tom Gorman			6-0 6-1 7-5
				Tom Gorman
102.		[Q]	Bob Rheinberger	6-2 6-1
					Brian Gottfried
103.		[13]	Brian Gottfried		7-6 6-4
				Brian Gottfried
104.			Birger Andersson	5-7 6-3 6-4
							Harold Solomon
105.			Georges Goven				5-7 1-6 7-6 7-6 6-4
				Georges Goven
106.		[Q]	Ramiro Benavides	6-3 6-2
					Georges Goven
107.			Hans Kary		6-3 7-5
				Hans Kary
108.			Ismail El Shafei	7-6 6-3
						Harold Solomon
109.			Steve Krulevitz			6-1 3-6 6-1 2-6 6-1
				Steve Krulevitz
110.			Colin Dowdeswell	6-3 6-2
					Harold Solomon
111.		[8]	Harold Solomon		6-2 6-2
				Harold Solomon
112.			Ivan Molina	6-1 6-4
								Bjorn Borg
113.			Ray Moore					6-1 7-5 6-4
				Ray Moore
114.			Phil Dent	6-2 7-5
					Ray Moore
115.			John Lloyd		6-0 3-6 6-3
				John Lloyd
116.			Fernando Gentil	6-4 7-5
						Stan Smith
117.			Julian Ganzabal			6-0 1-6 6-2 6-3
				Julian Ganzabal
118.		[Q]	Jorge Andrew	6-0 7-5
					Stan Smith
119.		[15]	Stan Smith		6-3 6-2
				Stan Smith
120.			Tito Vazquez	6-4 6-4
							Bjorn Borg
121.			Jiri Hrebec				6-1 6-1 6-1
				Jiri Hrebec
122.			Donald Dell	6-3 7-6
					Jiri Hrebec
123.			Trey Waltke		6-3 6-3
				Trey Waltke
124.			Attila Korpas	5-7 6-2 6-3
						Bjorn Borg
125.			Peter Szoke			6-1 6-1 6-1
				Peter Szoke
126.			Roger Dowdeswell	6-3 6-4
					Bjorn Borg
127.		[1]	Bjorn Borg		6-1 6-1
				Bjorn Borg
128.			Norman Holmes	6-2 6-3

(default) 17 queries took 39 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` = '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` = (353) 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 (3648, 3516, 3493, 3425, 3574, 3514, 3442, 822, 3636, 5123, 3661, 3650, 787, 4333, 3558, 815, 3623, 3679, 4814, 3677, 3651, 3564, 3630, 5122, 3699, 808, 3576, 3344, 3700, 4329, 4821, 3385, 3618, 4320, 5133, 3694, 3687, 3737, 3391, 3695, 3533, 3685, 5059, 3328, 3652, 3450, 3617, 3686, 3515, 3483, 3509, 3506, 3654, 3635, 3659, 3555, 3517, 5125, 3638, 4303, 3519, 3511, 3734, 3531, 3502, 3653, 4323, 3714, 3692, 3528, 3318, 3518, 3656, 3689, 3454, 3595, 3376, 6762, 3529, 3640, 3510, 3470, 3556, 3554, 3678, 3786, 3437, 5127, 3614, 3905, 3676, 3378, 3645, 3577, 3527, 3649, 798, 5126, 3632, 3451, 3446, 4312, 3612, 3683, 3495, 3669, 3681, 3398, 3542, 3708, 3627, 3634, 3388, 3538, 3646, 5092, 3702, 3682, 3386, 3488, 3658, 3024, 3672, 5112, 4324, 3680, 3647, 3566) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	6
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` = 353	128	128	4
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (173, 217, 124, 219, 196, 13, 212, 197, 218, 41, 121, 68, 172, 59, 29, 10, 201, 141, 135, 178, 153, 230, 94, 92, 43, 84, 26, 14, 149, 21, 133, 213)	32	32	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (173, 217, 124, 219, 196, 13, 212, 197, 218, 41, 121, 68, 172, 59, 29, 10, 201, 141, 135, 178, 153, 230, 94, 92, 43, 84, 26, 14, 149, 21, 133, 213)	32	32	4
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3648, 3516, 3493, 3425, 3574, 3514, 3442, 822, 3636, 5123, 3661, 3650, 787, 4333, 3558, 815, 3623, 3679, 4814, 3677, 3651, 3564, 3630, 5122, 3699, 808, 3576, 3344, 3700, 4329, 4821, 3385, 3618, 4320, 5133, 3694, 3687, 3737, 3391, 3695, 3533, 3685, 5059, 3328, 3652, 3450, 3617, 3686, 3515, 3483, 3509, 3506, 3654, 3635, 3659, 3555, 3517, 5125, 3638, 4303, 3519, 3511, 3734, 3531, 3502, 3653, 4323, 3714, 3692, 3528, 3318, 3518, 3656, 3689, 3454, 3595, 3376, 6762, 3529, 3640, 3510, 3470, 3556, 3554, 3678, 3786, 3437, 5127, 3614, 3905, 3676, 3378, 3645, 3577, 3527, 3649, 798, 5126, 3632, 3451, 3446, 4312, 3612, 3683, 3495, 3669, 3681, 3398, 3542, 3708, 3627, 3634, 3388, 3538, 3646, 5092, 3702, 3682, 3386, 3488, 3658, 3024, 3672, 5112, 4324, 3680, 3647, 3566)) AND (`Playercontest`.`contest_id` = 353))	128	128	9
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` = 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 39 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` = '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` = (353) 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 (3648, 3516, 3493, 3425, 3574, 3514, 3442, 822, 3636, 5123, 3661, 3650, 787, 4333, 3558, 815, 3623, 3679, 4814, 3677, 3651, 3564, 3630, 5122, 3699, 808, 3576, 3344, 3700, 4329, 4821, 3385, 3618, 4320, 5133, 3694, 3687, 3737, 3391, 3695, 3533, 3685, 5059, 3328, 3652, 3450, 3617, 3686, 3515, 3483, 3509, 3506, 3654, 3635, 3659, 3555, 3517, 5125, 3638, 4303, 3519, 3511, 3734, 3531, 3502, 3653, 4323, 3714, 3692, 3528, 3318, 3518, 3656, 3689, 3454, 3595, 3376, 6762, 3529, 3640, 3510, 3470, 3556, 3554, 3678, 3786, 3437, 5127, 3614, 3905, 3676, 3378, 3645, 3577, 3527, 3649, 798, 5126, 3632, 3451, 3446, 4312, 3612, 3683, 3495, 3669, 3681, 3398, 3542, 3708, 3627, 3634, 3388, 3538, 3646, 5092, 3702, 3682, 3386, 3488, 3658, 3024, 3672, 5112, 4324, 3680, 3647, 3566) 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` = 353

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3648, 3516, 3493, 3425, 3574, 3514, 3442, 822, 3636, 5123, 3661, 3650, 787, 4333, 3558, 815, 3623, 3679, 4814, 3677, 3651, 3564, 3630, 5122, 3699, 808, 3576, 3344, 3700, 4329, 4821, 3385, 3618, 4320, 5133, 3694, 3687, 3737, 3391, 3695, 3533, 3685, 5059, 3328, 3652, 3450, 3617, 3686, 3515, 3483, 3509, 3506, 3654, 3635, 3659, 3555, 3517, 5125, 3638, 4303, 3519, 3511, 3734, 3531, 3502, 3653, 4323, 3714, 3692, 3528, 3318, 3518, 3656, 3689, 3454, 3595, 3376, 6762, 3529, 3640, 3510, 3470, 3556, 3554, 3678, 3786, 3437, 5127, 3614, 3905, 3676, 3378, 3645, 3577, 3527, 3649, 798, 5126, 3632, 3451, 3446, 4312, 3612, 3683, 3495, 3669, 3681, 3398, 3542, 3708, 3627, 3634, 3388, 3538, 3646, 5092, 3702, 3682, 3386, 3488, 3658, 3024, 3672, 5112, 4324, 3680, 3647, 3566)) AND (`Playercontest`.`contest_id` = 353))

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