Roland Garros 1971 Men's Singles (May 24 - June 6)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[2]	Arthur Ashe Jr.
				Arthur Ashe Jr.
2.			Geza Varga	6-2 6-1 5-7 6-1
					Arthur Ashe Jr.
3.			Vyacheslav Egorov		3-6 6-4 6-0 7-5
				Vyacheslav Egorov
4.		[Q]	Robert Machan	6-4 1-6 3-6 6-4 8-6
						Arthur Ashe Jr.
5.			Jean-Loup Rouyer			6-2 6-3 7-5
				Jean-Loup Rouyer
6.		[Q]	Stepan Koudelka	6-1 2-6 6-1 7-9 6-4
					Jean-Loup Rouyer
7.			Patrick Hombergen		6-2 6-4 7-5
				Patrick Hombergen
8.			Byron Bertram	6-2 6-2 6-3
							Arthur Ashe Jr.
9.		[15]	Georges Goven				6-4 6-4 7-5
				Georges Goven
10.		[Q]	Syd Ball	6-1 6-1 6-1
					Georges Goven
11.			Daniel Contet		5-7 6-3 6-2 7-5
				Daniel Contet
12.			Ian Fletcher	3-6 6-3 2-6 6-4 6-4
						Georges Goven
13.			Nicola Pietrangeli			6-4 6-4 3-6 6-1
				Nicola Pietrangeli
14.			Charlie Pasarell	6-0 8-6 6-2
					Nicola Pietrangeli
15.			Peter Pokorny		6-4 2-6 6-2 6-3
				Peter Pokorny
16.			Bob Giltinan	6-3 6-3 1-6 6-1
								Frank Froehling III
17.		[7]	Marty Riessen					6-4 4-6 6-3 8-6
				Marty Riessen
18.			Sergio Palmieri	7-5 6-1 6-1
					Marty Riessen
19.			John Alexander		0-6 6-4 5-7 6-4 6-3
				John Alexander
20.			Ray Moore	7-5 6-3 8-6
						Marty Riessen
21.			Jean-Claude Barclay			3-6 6-1 6-3 13-11
				Jean-Claude Barclay
22.			Dimitri Sturdza	6-0 6-1 6-2
					Jean-Claude Barclay
23.			Bernard Montrenaud		6-1 9-7 6-0
				Bernard Montrenaud
24.			Peter Lamp	9-7 6-0 4-6 3-6 7-5
							Frank Froehling III
25.			John Cooper				1-6 2-6 6-3 6-4 6-2
				John Cooper
26.		[10]	Roger Taylor	6-8 6-2 6-3 5-7 rtd.
					Frank Froehling III
27.			Frank Froehling III		6-2 6-2 6-3
				Frank Froehling III
28.		[Q]	Rainer Kuhlmey	6-4 6-3 6-3
						Frank Froehling III
29.			Jan Leschly			4-6 6-3 8-6 7-5
				Jan Leschly
30.			Franco Bartoni	7-5 2-6 6-4 6-3
					Jan Leschly
31.			Jose Arilla		3-2 rtd.
				Jose Arilla
32.			Mieczyslaw Rybarczyk	w/o
									Ilie Nastase
33.		[3]	Ilie Nastase						6-0 2-6 6-4 6-3
				Ilie Nastase
34.			Thomaz Koch	6-2 6-2 6-4
					Ilie Nastase
35.			Szabolcs Baranyi		6-1 6-3 3-6 6-1
				Szabolcs Baranyi
36.		[Q]	Hendrick Sepp	6-1 4-6 5-7 6-0 6-0
						Ilie Nastase
37.			Ray Ruffels			4-6 6-2 6-2 6-2
				Ray Ruffels
38.			Patricio Rodriguez	6-0 6-4 6-2
					Ray Ruffels
39.			Ross Case		6-1 6-1 6-0
				Ross Case
40.			Jose Mandarino	6-4 10-8 7-5
							Ilie Nastase
41.			Frew McMillan				6-1 6-1 3-6 7-5
				Frew McMillan
42.		[14]	Niki Pilic	w/o
					Frew McMillan
43.			Brian Fairlie		6-2 6-2 6-2
				Brian Fairlie
44.			Jan Kukal	10-8 6-0 6-3
						Tadeusz Nowicki
45.			Tadeusz Nowicki			3-6 6-1 8-6 6-2
				Tadeusz Nowicki
46.			Jim McManus	6-3 6-0 6-2
					Tadeusz Nowicki
47.			Vladimir Korotkov		6-3 6-4 6-3
				Vladimir Korotkov
48.			Allan Stone	1-6 6-1 6-3 6-3
								Ilie Nastase
49.		[6]	Stan Smith					6-1 3-6 6-3 6-4
				Stan Smith
50.			Nicky Kalogeropoulos	6-3 6-2 8-6
					Stan Smith
51.			Jose Guerrero		6-4 6-1 6-1
				Jose Guerrero
52.			William Freer	6-0 6-3 6-2
						Stan Smith
53.			Graham Stilwell			6-1 6-1 6-3
				Graham Stilwell
54.		[Q]	Corrado Barazzutti	6-4 3-6 6-3 6-0
					Graham Stilwell
55.			Toshiro Sakai		7-5 12-10 6-4
				Toshiro Sakai
56.		[Q]	Bernard Paul	3-6 2-6 7-5 8-6 6-3
							Stan Smith
57.		[Q]	Teimuraz Kakulia				6-4 2-6 8-6 6-2
				Teimuraz Kakulia
58.		[11]	Manuel Orantes	w/o
					Patrice Dominguez
59.			Patrice Dominguez		1-6 6-4 6-2 9-7
				Patrice Dominguez
60.			Frank Sedgman	6-3 6-1 6-4
						Patrice Dominguez
61.			Adriano Panatta			6-4 8-6 3-6 4-6 9-7
				Adriano Panatta
62.			Stanley Matthews	6-3 6-3 7-5
					Adriano Panatta
63.		[Q]	Wanaro N'Godrella		6-2 6-4 6-1
				Wanaro N'Godrella
64.			Hans Kary	6-3 4-6 6-4 7-5
										Jan Kodes
65.			Terry Ryan							8-6 6-2 2-6 7-5
				Terry Ryan
66.			Eric Drossart	6-2 2-6 6-4 6-2
					Terry Ryan
67.		[Q]	Eduardo Zuleta		7-5 6-3 6-3
				Eduardo Zuleta
68.			Pancho Guzman	w/o
						Pierre Barthes
69.			Dick Crealy			9-7 6-1 6-2
				Dick Crealy
70.			Jaidip Mukerjea	w/o
					Pierre Barthes
71.		[12]	Pierre Barthes		6-2 6-1 6-4
				Pierre Barthes
72.			Vladimir Zednik	6-4 3-6 6-3 6-1
							Zeljko Franulovic
73.			Tom Gorman				6-4 4-6 4-6 6-2 6-4
				Tom Gorman
74.			Andrew Pattison	2-6 2-6 8-6 6-3 6-4
					Tom Gorman
75.			Jean-Paul Meyer		10-12 6-2 6-2 6-1
				Jean-Paul Meyer
76.			Boro Jovanovic	4-6 8-6 6-2 2-0 rtd.
						Zeljko Franulovic
77.			Antonio Munoz			6-3 6-1 7-5
				Antonio Munoz
78.			John Clifton	6-4 6-4 6-4
					Zeljko Franulovic
79.		[5]	Zeljko Franulovic		6-2 6-3 6-3
				Zeljko Franulovic
80.			Pat Cramer	6-2 6-2 2-6 10-8
								Zeljko Franulovic
81.			Istvan Gulyas					6-3 6-2 4-6 6-2
				Istvan Gulyas
82.			Juan Gisbert	4-6 7-5 11-9 6-2
					Istvan Gulyas
83.			Nikki Spear		6-0 6-3 6-0
				Nikki Spear
84.		[Q]	Vincenzo Franchitti	6-2 7-5 6-3
						Istvan Gulyas
85.			Barry Phillips-Moore			6-2 6-2 6-2
				Barry Phillips-Moore
86.			Patricio Cornejo	6-1 6-4 3-6 3-6 6-1
					Bill Bowrey
87.			Bill Bowrey		6-1 6-3 3-6 1-6 8-6
				Bill Bowrey
88.		[13]	Ion Tiriac	6-3 6-2 8-6
							Istvan Gulyas
89.			Colin Dibley				6-4 7-5 4-6 6-2
				Colin Dibley
90.		[Q]	Pierre Joly	6-1 6-4 6-1
					Colin Dibley
91.			Michel Leclercq		6-1 6-3 7-5
				Michel Leclercq
92.		[Q]	William Alvarez	6-4 7-5 6-4
						Cliff Richey Jr.
93.			Terry Addison			6-1 6-3 8-6
				Terry Addison
94.			Peter Szoke	6-1 4-6 6-0 7-5
					Cliff Richey Jr.
95.		[4]	Cliff Richey Jr.		6-1 6-2 6-0
				Cliff Richey Jr.
96.			Massimo Di Domenico	6-2 6-4 6-2
									Jan Kodes
97.			Jun Kuki						6-4 6-2 7-5
				Jun Kuki
98.			Phil Dent	6-0 6-3 11-9
					Jun Kuki
99.			Petre Marmureanu		6-0 6-3 6-4
				Petre Marmureanu
100.			Bob Maud	6-4 4-6 6-2 4-6 8-6
						Bob Lutz
101.			Gerald Battrick			6-1 5-7 5-7 6-4 6-4
				Gerald Battrick
102.			Frantisek Pala	6-3 6-8 0-6 6-2 7-5
					Bob Lutz
103.		[9]	Bob Lutz		4-6 6-1 1-6 6-2 6-2
				Bob Lutz
104.			Jiri Hrebec	6-2 6-4 6-1
							Patrick Proisy
105.			Jaime Pinto				6-4 9-7 7-5
				Jaime Pinto
106.			Ezio Di Matteo	4-6 6-2 6-1 6-2
					Jaime Pinto
107.			Jairo Velasco Sr.		6-8 6-4 3-6 6-1 5-4 rtd.
				Jairo Velasco Sr.
108.			David Lloyd	7-5 6-2 6-3
						Patrick Proisy
109.			Patrick Proisy			6-1 6-0 6-3
				Patrick Proisy
110.			Toomas Leius	6-2 6-4 6-1
					Patrick Proisy
111.		[8]	Aleksandr Metreveli		6-4 6-4 7-5
				Aleksandr Metreveli
112.		[Q]	Antonio Zugarelli	6-1 6-2 7-5
								Jan Kodes
113.			Francois Jauffret					6-4 8-6 1-6 6-1
				Francois Jauffret
114.			Atet Wijono	6-3 6-1 6-1
					Francois Jauffret
115.			Milan Holecek		4-6 6-4 6-3 6-1
				Milan Holecek
116.		[Q]	Zlatko Ivancic	6-4 6-3 6-3
						Francois Jauffret
117.			Jean-Baptiste Chanfreau			6-3 7-5 6-1
				Jean-Baptiste Chanfreau
118.		[Q]	Ivan Molina	6-4 6-4 2-6 6-8 6-3
					Jean-Baptiste Chanfreau
119.			Anatoli Volkov		6-3 6-4 6-2
				Anatoli Volkov
120.		[16]	Jaime Fillol	6-3 9-7 6-3
							Jan Kodes
121.			Bob Carmichael				4-6 6-2 5-7 6-0 6-4
				Bob Carmichael
122.			Patrice Beust	6-2 6-0 6-1
					Bob Carmichael
123.			Geoff Masters		6-2 4-6 6-3 6-2
				Geoff Masters
124.			Onny Parun	6-4 6-2 6-2
						Jan Kodes
125.			Jean-Pierre Courcol			6-4 9-7 6-2
				Jean-Pierre Courcol
126.		[LL]	Sever Muresan	6-3 4-6 6-3 6-3
					Jan Kodes
127.		[1]	Jan Kodes		6-3 6-0 7-5
				Jan Kodes
128.			Wieslaw Gasiorek	6-1 6-1 6-3

(default) 17 queries took 18 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` = '1971' 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` = (349) 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 (3215, 5032, 5089, 4319, 3536, 5031, 4269, 3821, 3495, 3665, 3470, 3643, 722, 3005, 5034, 3788, 3168, 5096, 3515, 3388, 3595, 3394, 5029, 5104, 3367, 798, 3180, 5105, 3327, 5106, 3383, 5036, 3527, 3344, 4323, 5107, 3466, 3146, 3571, 3328, 3382, 787, 3546, 3535, 5086, 785, 3549, 817, 3386, 5035, 5108, 5060, 822, 3651, 3572, 4306, 3635, 3516, 3632, 594, 3614, 814, 3638, 3681, 3557, 810, 3239, 3396, 808, 805, 3376, 3563, 3446, 3558, 4316, 793, 3556, 3730, 3510, 3524, 3347, 3677, 3576, 5110, 3649, 3385, 799, 3526, 3574, 4331, 5025, 4978, 3491, 4324, 3359, 4297, 3577, 3538, 3522, 3561, 3528, 3555, 3436, 3658, 3514, 5065, 3630, 3611, 3519, 3303, 3318, 3648, 3699, 3544, 3378, 5080, 3483, 3634, 5059, 3437, 3531, 3450, 3560, 3517, 3520, 5109, 3533, 3312) 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` = 349	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (196, 173, 218, 68, 13, 92, 197, 219, 86, 21, 41, 58, 149, 217, 172, 179, 84, 29, 54, 135, 153, 87, 230, 94, 43, 14, 212, 74)	28	28	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (196, 173, 218, 68, 13, 92, 197, 219, 86, 21, 41, 58, 149, 217, 172, 179, 84, 29, 54, 135, 153, 87, 230, 94, 43, 14, 212, 74)	28	28	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3215, 5032, 5089, 4319, 3536, 5031, 4269, 3821, 3495, 3665, 3470, 3643, 722, 3005, 5034, 3788, 3168, 5096, 3515, 3388, 3595, 3394, 5029, 5104, 3367, 798, 3180, 5105, 3327, 5106, 3383, 5036, 3527, 3344, 4323, 5107, 3466, 3146, 3571, 3328, 3382, 787, 3546, 3535, 5086, 785, 3549, 817, 3386, 5035, 5108, 5060, 822, 3651, 3572, 4306, 3635, 3516, 3632, 594, 3614, 814, 3638, 3681, 3557, 810, 3239, 3396, 808, 805, 3376, 3563, 3446, 3558, 4316, 793, 3556, 3730, 3510, 3524, 3347, 3677, 3576, 5110, 3649, 3385, 799, 3526, 3574, 4331, 5025, 4978, 3491, 4324, 3359, 4297, 3577, 3538, 3522, 3561, 3528, 3555, 3436, 3658, 3514, 5065, 3630, 3611, 3519, 3303, 3318, 3648, 3699, 3544, 3378, 5080, 3483, 3634, 5059, 3437, 3531, 3450, 3560, 3517, 3520, 5109, 3533, 3312)) AND (`Playercontest`.`contest_id` = 349))	128	128	1
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` = 1971	19	19	0
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	0

(default) 17 queries took 18 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` = '1971' 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` = (349) 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 (3215, 5032, 5089, 4319, 3536, 5031, 4269, 3821, 3495, 3665, 3470, 3643, 722, 3005, 5034, 3788, 3168, 5096, 3515, 3388, 3595, 3394, 5029, 5104, 3367, 798, 3180, 5105, 3327, 5106, 3383, 5036, 3527, 3344, 4323, 5107, 3466, 3146, 3571, 3328, 3382, 787, 3546, 3535, 5086, 785, 3549, 817, 3386, 5035, 5108, 5060, 822, 3651, 3572, 4306, 3635, 3516, 3632, 594, 3614, 814, 3638, 3681, 3557, 810, 3239, 3396, 808, 805, 3376, 3563, 3446, 3558, 4316, 793, 3556, 3730, 3510, 3524, 3347, 3677, 3576, 5110, 3649, 3385, 799, 3526, 3574, 4331, 5025, 4978, 3491, 4324, 3359, 4297, 3577, 3538, 3522, 3561, 3528, 3555, 3436, 3658, 3514, 5065, 3630, 3611, 3519, 3303, 3318, 3648, 3699, 3544, 3378, 5080, 3483, 3634, 5059, 3437, 3531, 3450, 3560, 3517, 3520, 5109, 3533, 3312) 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` = 349

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (196, 173, 218, 68, 13, 92, 197, 219, 86, 21, 41, 58, 149, 217, 172, 179, 84, 29, 54, 135, 153, 87, 230, 94, 43, 14, 212, 74)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (196, 173, 218, 68, 13, 92, 197, 219, 86, 21, 41, 58, 149, 217, 172, 179, 84, 29, 54, 135, 153, 87, 230, 94, 43, 14, 212, 74)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3215, 5032, 5089, 4319, 3536, 5031, 4269, 3821, 3495, 3665, 3470, 3643, 722, 3005, 5034, 3788, 3168, 5096, 3515, 3388, 3595, 3394, 5029, 5104, 3367, 798, 3180, 5105, 3327, 5106, 3383, 5036, 3527, 3344, 4323, 5107, 3466, 3146, 3571, 3328, 3382, 787, 3546, 3535, 5086, 785, 3549, 817, 3386, 5035, 5108, 5060, 822, 3651, 3572, 4306, 3635, 3516, 3632, 594, 3614, 814, 3638, 3681, 3557, 810, 3239, 3396, 808, 805, 3376, 3563, 3446, 3558, 4316, 793, 3556, 3730, 3510, 3524, 3347, 3677, 3576, 5110, 3649, 3385, 799, 3526, 3574, 4331, 5025, 4978, 3491, 4324, 3359, 4297, 3577, 3538, 3522, 3561, 3528, 3555, 3436, 3658, 3514, 5065, 3630, 3611, 3519, 3303, 3318, 3648, 3699, 3544, 3378, 5080, 3483, 3634, 5059, 3437, 3531, 3450, 3560, 3517, 3520, 5109, 3533, 3312)) AND (`Playercontest`.`contest_id` = 349))

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

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)