Roland Garros 1977 Men's Singles (May 23 - June 5)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Ilie Nastase
				Ilie Nastase
2.			Elio Alvarez	7-6 6-3 6-2
					Ilie Nastase
3.			Tom Gullikson		6-3 3-6 4-6 6-2 6-1
				Tom Gullikson
4.		[Q]	Robin Drysdale	7-6 6-3 0-6 6-3
						Ilie Nastase
5.			Karl Meiler			7-6 3-6 6-1 6-7 6-1
				Karl Meiler
6.			Jim Delaney	6-1 6-2 6-2
					Karl Meiler
7.			Jorge Andrew		4-6 6-3 6-4 6-2
				Jorge Andrew
8.			Juan Muntanola-Vilamela	6-2 6-2 6-1
							Ilie Nastase
9.			Jaime Pinto				6-4 7-5 6-3
				Jaime Pinto
10.			Gene Mayer	4-6 6-4 6-4 2-0 rtd.
					Jaime Pinto
11.			Peter Fleming		6-7 6-3 6-0 6-2
				Peter Fleming
12.			Sashi Menon	6-4 7-6 6-1
						Jan Kodes
13.			Jan Norback			6-3 6-3 6-3
				Jan Norback
14.			Russell Simpson	6-2 6-2 6-2
					Jan Kodes
15.		[13]	Jan Kodes		6-3 6-2 6-3
				Jan Kodes
16.			Jun Kuki	6-1 6-3 6-1
								Brian Gottfried
17.		[5]	Brian Gottfried					4-6 3-6 6-2 6-2 6-3
				Brian Gottfried
18.			Ivan Molina	6-3 6-2 6-1
					Brian Gottfried
19.			Trey Waltke		6-3 7-5 6-4
				Trey Waltke
20.		[Q]	Gianni Ocleppo	6-3 5-7 7-6 6-2
						Brian Gottfried
21.			Eric Deblicker			7-5 6-4 6-4
				Eric Deblicker
22.			Henry Bunis	7-5 6-1 6-2
					Eric Deblicker
23.			Christophe Casa		4-6 6-3 7-5 7-5
				Christophe Casa
24.			Bob Carmichael	1-6 7-6 6-2 7-5
							Brian Gottfried
25.			Tim Gullikson				6-4 6-1 7-5
				Tim Gullikson
26.			Ray Moore	6-4 6-1 6-7 5-7 6-1
					Tom Gullikson
27.			Thomaz Koch		6-1 6-3 6-7 6-3
				Thomaz Koch
28.			Victor Pecci	3-6 5-7 6-3 6-4 6-3
						Patrice Dominguez
29.			Patrice Dominguez			6-3 6-1 6-1
				Patrice Dominguez
30.			Victor Amaya	7-5 6-2 6-4
					Patrice Dominguez
31.			Vladimir Zednik		7-6 7-5 3-6 3-6 7-5
				Vladimir Zednik
32.		[14]	Jaime Fillol	6-4 6-3 4-6 6-3
									Brian Gottfried
33.		[15]	Balazs Taroczy						7-5 6-3 7-5
				Balazs Taroczy
34.			Nikki Spear	6-2 6-4 6-4
					Balazs Taroczy
35.			Barry Phillips-Moore		3-6 7-5 7-5 6-3
				Barry Phillips-Moore
36.			Patricio Cornejo	6-4 6-4 6-0
						Phil Dent
37.			Phil Dent			3-6 7-6 6-2 6-4
				Phil Dent
38.			Niki Pilic	1-6 4-6 7-6 6-4 6-4
					Phil Dent
39.		[Q]	John McEnroe		4-6 6-2 4-6 6-3 6-3
				John McEnroe
40.			Alvin Gardiner	6-3 6-4 6-0
							Phil Dent
41.			Brian Fairlie				6-0 6-2 6-4
				Brian Fairlie
42.			Yannick Noah	6-1 6-3 6-7 6-7 6-2
					Brian Fairlie
43.			Emilio Montano		6-3 4-6 6-0 6-2
				Emilio Montano
44.			Werner Zirngibl	6-1 6-1 6-3
						Brian Fairlie
45.			Rolf Norberg			6-4 6-1 6-0
				Rolf Norberg
46.		[Q]	Pavel Slozil	6-2 6-3 6-7 6-7 7-5
					Rolf Norberg
47.		[4]	Eddie Dibbs		6-3 3-6 7-5 6-4
				Eddie Dibbs
48.			Martin Robinson	6-1 6-0 6-0
								Phil Dent
49.			Hans Gildemeister					6-1 6-3 3-6 6-7 6-3
				Hans Gildemeister
50.		[11]	Corrado Barazzutti	6-4 6-3 6-3
					Hans Gildemeister
51.			Jean-Francois Caujolle		6-3 6-3 7-5
				Jean-Francois Caujolle
52.		[Q]	Terry Rocavert	6-1 4-6 6-1 6-4
						Jose Higueras
53.			Jose Higueras			6-3 5-7 7-6 6-4
				Jose Higueras
54.			Colin Dibley	3-6 2-6 7-6 6-0 8-6
					Jose Higueras
55.			Christophe Roger-Vasselin		5-7 6-3 6-3 6-1
				Christophe Roger-Vasselin
56.			Dick Bohrnstedt	4-6 6-2 6-7 7-5 6-1
							Jose Higueras
57.		[Q]	Peter Elter				6-4 7-5 2-6 6-3
				Peter Elter
58.			John Lloyd	7-6 6-4 6-4
					Peter Elter
59.			Bill Scanlon		4-6 7-6 6-4 6-4
				Bill Scanlon
60.			Chris Kachel	6-3 1-6 6-4 6-1
						Harold Solomon
61.			Andrew Pattison			6-4 6-4 6-1
				Andrew Pattison
62.			Nick Saviano	7-6 7-6 3-6 6-2
					Harold Solomon
63.		[7]	Harold Solomon		6-2 6-4 6-2
				Harold Solomon
64.			John Feaver	6-3 6-4 3-6 6-2
										Guillermo Vilas
65.		[8]	Antonio Munoz							6-0 6-3 6-0
				Antonio Munoz
66.			Tomas Smid	3-6 6-1 4-6 6-1 6-1
					Rolf Gehring
67.			Rolf Gehring		6-3 6-3 6-1
				Rolf Gehring
68.			Jean-Louis Haillet	6-0 6-7 7-6 5-7 6-1
						Rolf Gehring
69.		[Q]	Pavel Hutka			7-6 6-3 6-1
				Pavel Hutka
70.		[Q]	Jan Simbera	6-4 4-6 5-7 6-1 6-0
					Pavel Hutka
71.			Brian Teacher		7-6 6-4 6-7 6-4
				Brian Teacher
72.			Alvaro Betancur	7-6 6-4 4-6 6-0
							Wojtek Fibak
73.			Chris Lewis				6-7 6-2 6-4 3-6 6-4
				Chris Lewis
74.		[Q]	Ricardo Ycaza	6-2 6-2 6-2
					Chris Lewis
75.			Ismail El Shafei		6-3 3-6 6-1 6-1
				Ismail El Shafei
76.			Chico Hagey	6-4 6-2 6-2
						Wojtek Fibak
77.			Mark Edmondson			6-2 6-3 3-6 6-3
				Mark Edmondson
78.			Steve Krulevitz	6-4 6-2 6-3
					Wojtek Fibak
79.		[9]	Wojtek Fibak		6-2 6-4 6-4
				Wojtek Fibak
80.			Sherwood Stewart	6-3 6-2 7-5
								Guillermo Vilas
81.		[10]	Stan Smith					6-4 6-0 6-4
				Stan Smith
82.			Dick Crealy	7-6 6-4 6-2
					Stan Smith
83.			Jurgen Fassbender		6-4 6-3 7-5
				Jurgen Fassbender
84.			Fred McNair	6-4 7-6 3-6 1-6 6-4
						Stan Smith
85.			Jiri Hrebec			6-4 6-2 5-7 7-6
				Jiri Hrebec
86.			Onny Parun	2-6 6-2 6-3 6-4
					Jiri Hrebec
87.		[Q]	Dominique Bedel		6-3 6-2 6-4
				Dominique Bedel
88.			Mike Machette	6-2 6-1 6-2
							Guillermo Vilas
89.			Bernie Mitton				6-1 6-2 6-1
				Bernie Mitton
90.			Patrick Dupre	6-0 6-1 6-2
					Bernie Mitton
91.			Colin Dowdeswell		6-7 5-7 7-6 7-5 6-3
				Colin Dowdeswell
92.			Herve Gauvain	6-4 6-3 6-7 6-4
						Guillermo Vilas
93.			Belus Prajoux			6-1 6-4 6-2
				Belus Prajoux
94.			Ramiro Benavides	6-0 6-2 7-6
					Guillermo Vilas
95.		[3]	Guillermo Vilas		2-6 6-0 6-3 6-0
				Guillermo Vilas
96.			Zeljko Franulovic	6-1 6-2 6-4
									Guillermo Vilas
97.		[16]	Francois Jauffret						6-2 6-0 6-3
				Francois Jauffret
98.			Frank Gebert	2-6 0-6 6-2 7-6 6-2
					John Yuill
99.			John Yuill		6-4 7-6 2-6 6-7 6-4
				John Yuill
100.		[Q]	Jose Moreno-Tallada	6-4 6-1 6-2
						John Yuill
101.			Antonio Zugarelli			w/o
				Antonio Zugarelli
102.			Willem Prinsloo	6-1 6-1 6-4
					Antonio Zugarelli
103.			Frantisek Pala		6-4 2-6 6-3 6-4
				Frantisek Pala
104.			Jairo Velasco Sr.	6-3 6-2 3-6 6-4
							Raul Ramirez
105.			Uli Pinner				6-2 6-4 6-3
				Uli Pinner
106.			David Schneider	6-0 6-4 6-2
					Uli Pinner
107.			Byron Bertram		6-2 7-5 6-1
				Byron Bertram
108.			John Whitlinger	6-2 6-1 6-2
						Raul Ramirez
109.			Jeff Borowiak			7-6 6-1 5-7 6-1
				Jeff Borowiak
110.			Bob Hewitt	6-4 5-1 rtd.
					Raul Ramirez
111.		[6]	Raul Ramirez		6-3 6-3 6-2
				Raul Ramirez
112.			Georges Goven	6-4 6-1 7-5
								Raul Ramirez
113.			Patrick Proisy					7-6 6-3 7-5
				Patrick Proisy
114.		[12]	Bob Lutz	6-1 6-3 7-6
					Christopher Mottram
115.			Christopher Mottram		6-3 6-3 1-6 6-3
				Christopher Mottram
116.			Javier Soler	6-3 6-4 6-3
						Christopher Mottram
117.			Paolo Bertolucci			0-6 6-3 7-6 7-5
				Paolo Bertolucci
118.			Ricardo Cano	6-1 6-0 6-3
					Paolo Bertolucci
119.			Hans Kary		6-3 6-0 6-2
				Hans Kary
120.			Richard Lewis	3-6 7-6 6-2 6-2
							Adriano Panatta
121.			Paul McNamee				2-6 4-6 6-3 6-4 6-4
				Paul McNamee
122.			Kjell Johansson	6-3 6-4 1-6 2-6 6-2
					Paul McNamee
123.			Kim Warwick		6-3 7-6 6-4
				Kim Warwick
124.			Christophe Freyss	7-5 6-3 1-6 2-6 6-1
						Adriano Panatta
125.			Julian Ganzabal			6-4 6-2 6-2
				Julian Ganzabal
126.			Billy Martin	6-4 7-6 2-6 3-6 6-3
					Adriano Panatta
127.		[2]	Adriano Panatta		6-2 2-6 6-4 6-1
				Adriano Panatta
128.		[Q]	Patrice Beust	7-5 6-4 5-7 6-2

(default) 17 queries took 20 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` = '1977' 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` = (355) 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 (3527, 3493, 3993, 3994, 3653, 3616, 3682, 5133, 3514, 3744, 3701, 3565, 3745, 3740, 3533, 3577, 3612, 3634, 3672, 3767, 3714, 3663, 4836, 3531, 3703, 3388, 3344, 3684, 3632, 3655, 3563, 3437, 3661, 3576, 3649, 3385, 3538, 787, 3753, 3807, 3546, 3768, 5113, 4830, 3644, 3812, 3636, 4814, 3690, 3651, 3659, 3814, 3689, 3574, 3836, 3660, 5135, 3646, 3716, 3761, 3558, 3822, 3627, 3640, 3556, 3743, 3905, 3704, 5128, 5137, 3657, 3691, 3771, 3749, 3398, 3622, 3706, 3542, 3685, 3451, 3386, 808, 3547, 3554, 3658, 3517, 3792, 3545, 3696, 3624, 3708, 4808, 3654, 3669, 3618, 3510, 3699, 3737, 3678, 5136, 3648, 3736, 3555, 3630, 4329, 3705, 3821, 3664, 3498, 738, 3623, 3495, 3519, 3436, 3641, 3735, 3645, 3687, 3681, 3741, 3751, 3700, 3666, 3780, 3702, 3613, 3614, 3450) 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` = 355	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (41, 173, 217, 172, 219, 13, 197, 68, 59, 29, 10, 135, 153, 212, 230, 86, 94, 92, 121, 43, 196, 178, 84, 26, 14, 201, 146, 149, 58, 213)	30	30	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (41, 173, 217, 172, 219, 13, 197, 68, 59, 29, 10, 135, 153, 212, 230, 86, 94, 92, 121, 43, 196, 178, 84, 26, 14, 201, 146, 149, 58, 213)	30	30	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3527, 3493, 3993, 3994, 3653, 3616, 3682, 5133, 3514, 3744, 3701, 3565, 3745, 3740, 3533, 3577, 3612, 3634, 3672, 3767, 3714, 3663, 4836, 3531, 3703, 3388, 3344, 3684, 3632, 3655, 3563, 3437, 3661, 3576, 3649, 3385, 3538, 787, 3753, 3807, 3546, 3768, 5113, 4830, 3644, 3812, 3636, 4814, 3690, 3651, 3659, 3814, 3689, 3574, 3836, 3660, 5135, 3646, 3716, 3761, 3558, 3822, 3627, 3640, 3556, 3743, 3905, 3704, 5128, 5137, 3657, 3691, 3771, 3749, 3398, 3622, 3706, 3542, 3685, 3451, 3386, 808, 3547, 3554, 3658, 3517, 3792, 3545, 3696, 3624, 3708, 4808, 3654, 3669, 3618, 3510, 3699, 3737, 3678, 5136, 3648, 3736, 3555, 3630, 4329, 3705, 3821, 3664, 3498, 738, 3623, 3495, 3519, 3436, 3641, 3735, 3645, 3687, 3681, 3741, 3751, 3700, 3666, 3780, 3702, 3613, 3614, 3450)) AND (`Playercontest`.`contest_id` = 355))	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` = 1977	23	23	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 2, 3, 3, 1, 1, 12, 17, 22, 18, 13, 23, 4, 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 20 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` = '1977' 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` = (355) 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 (3527, 3493, 3993, 3994, 3653, 3616, 3682, 5133, 3514, 3744, 3701, 3565, 3745, 3740, 3533, 3577, 3612, 3634, 3672, 3767, 3714, 3663, 4836, 3531, 3703, 3388, 3344, 3684, 3632, 3655, 3563, 3437, 3661, 3576, 3649, 3385, 3538, 787, 3753, 3807, 3546, 3768, 5113, 4830, 3644, 3812, 3636, 4814, 3690, 3651, 3659, 3814, 3689, 3574, 3836, 3660, 5135, 3646, 3716, 3761, 3558, 3822, 3627, 3640, 3556, 3743, 3905, 3704, 5128, 5137, 3657, 3691, 3771, 3749, 3398, 3622, 3706, 3542, 3685, 3451, 3386, 808, 3547, 3554, 3658, 3517, 3792, 3545, 3696, 3624, 3708, 4808, 3654, 3669, 3618, 3510, 3699, 3737, 3678, 5136, 3648, 3736, 3555, 3630, 4329, 3705, 3821, 3664, 3498, 738, 3623, 3495, 3519, 3436, 3641, 3735, 3645, 3687, 3681, 3741, 3751, 3700, 3666, 3780, 3702, 3613, 3614, 3450) 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` = 355

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3527, 3493, 3993, 3994, 3653, 3616, 3682, 5133, 3514, 3744, 3701, 3565, 3745, 3740, 3533, 3577, 3612, 3634, 3672, 3767, 3714, 3663, 4836, 3531, 3703, 3388, 3344, 3684, 3632, 3655, 3563, 3437, 3661, 3576, 3649, 3385, 3538, 787, 3753, 3807, 3546, 3768, 5113, 4830, 3644, 3812, 3636, 4814, 3690, 3651, 3659, 3814, 3689, 3574, 3836, 3660, 5135, 3646, 3716, 3761, 3558, 3822, 3627, 3640, 3556, 3743, 3905, 3704, 5128, 5137, 3657, 3691, 3771, 3749, 3398, 3622, 3706, 3542, 3685, 3451, 3386, 808, 3547, 3554, 3658, 3517, 3792, 3545, 3696, 3624, 3708, 4808, 3654, 3669, 3618, 3510, 3699, 3737, 3678, 5136, 3648, 3736, 3555, 3630, 4329, 3705, 3821, 3664, 3498, 738, 3623, 3495, 3519, 3436, 3641, 3735, 3645, 3687, 3681, 3741, 3751, 3700, 3666, 3780, 3702, 3613, 3614, 3450)) AND (`Playercontest`.`contest_id` = 355))

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

SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 2, 3, 3, 1, 1, 12, 17, 22, 18, 13, 23, 4, 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)