Roland Garros 1980 Men's Singles (May 26 - June 8)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Bjorn Borg
				Bjorn Borg
2.			Alvaro Fillol	6-3 6-1 6-4
					Bjorn Borg
3.			Andres Gomez		6-2 6-2 6-1
				Andres Gomez
4.			Francisco Gonzalez	3-6 6-3 6-1 6-3
						Bjorn Borg
5.			Pascal Portes			6-3 6-0 6-1
				Pascal Portes
6.			Alejandro Cortes	6-4 6-3 3-6 6-3
					Pascal Portes
7.			Marko Ostoja		6-1 6-3 6-4
				Marko Ostoja
8.			Thierry Stevaux	3-6 6-3 6-3 6-3
							Bjorn Borg
9.			Balazs Taroczy				6-2 6-2 6-0
				Balazs Taroczy
10.			Scott Davis	6-2 6-0 6-4
					Balazs Taroczy
11.			Trey Waltke		6-3 6-3 6-3
				Trey Waltke
12.			Gilles Moretton	7-5 3-6 6-4 6-3
						Balazs Taroczy
13.			Heinz Gunthardt			6-2 6-3 6-4
				Heinz Gunthardt
14.			Bernard Fritz	4-6 6-3 1-6 6-0 6-1
					Heinz Gunthardt
15.		[14]	Victor Amaya		7-6 4-6 6-3 6-4
				Victor Amaya
16.			Christophe Freyss	6-3 7-5 7-5
								Bjorn Borg
17.			Peter McNamara					6-0 6-3 6-3
				Peter McNamara
18.		[11]	Jose Higueras	6-2 6-4 6-4
					Peter McNamara
19.			Haroon Ismail		6-4 6-1 6-2
				Haroon Ismail
20.			Ivan Molina	3-6 0-6 6-3 6-4 6-4
						Peter McNamara
21.			Christophe Roger-Vasselin			6-7 6-2 7-6 6-4
				Christophe Roger-Vasselin
22.			Eric Deblicker	4-6 6-4 6-1 5-7 6-4
					Christophe Roger-Vasselin
23.			Tomas Smid		3-6 6-0 6-4 3-6 6-3
				Tomas Smid
24.			Mike Cahill	7-5 6-2 6-3
							Corrado Barazzutti
25.			Corrado Barazzutti				6-4 6-2 7-6
				Corrado Barazzutti
26.			Ross Case	6-2 6-4 6-1
					Corrado Barazzutti
27.			Tom Gullikson		6-3 6-2 6-1
				Tom Gullikson
28.			Herve Gauvain	6-1 6-2 6-3
						Corrado Barazzutti
29.			Belus Prajoux			6-2 6-4 6-3
				Belus Prajoux
30.			Zeljko Franulovic	1-6 6-2 6-4 4-6 6-2
					Belus Prajoux
31.		[8]	Victor Pecci		7-5 6-4 6-7 7-6
				Victor Pecci
32.			Ray Moore	6-2 4-6 6-2 6-0
									Bjorn Borg
33.		[4]	Guillermo Vilas						6-2 6-2 6-0
				Guillermo Vilas
34.			Jose Luis Damiani	6-2 6-2 6-0
					Guillermo Vilas
35.			Thomaz Koch		6-2 6-2 6-3
				Thomaz Koch
36.			Cassio Motta	6-7 6-3 4-6 6-2 6-3
						Guillermo Vilas
37.			Christopher Mottram			6-2 6-2 6-3
				Christopher Mottram
38.			Angel Gimenez	6-2 6-3 6-2
					Christopher Mottram
39.			Louk Sanders		6-3 6-4 6-1
				Louk Sanders
40.			Russell Simpson	6-1 6-7 6-7 6-4 6-4
							Guillermo Vilas
41.			Bruce Manson				w/o
				Bruce Manson
42.			Kjell Johansson	6-1 6-2 3-6 6-3
					Bruce Manson
43.			Dominique Bedel		7-5 7-5 6-3
				Dominique Bedel
44.			Billy Martin	6-4 6-0 6-0
						Manuel Orantes
45.			Pavel Slozil			7-6 6-0 6-3
				Pavel Slozil
46.			Bruce Foxworth	6-4 7-5 7-5
					Manuel Orantes
47.		[15]	Manuel Orantes		6-4 6-2 6-1
				Manuel Orantes
48.			William Maze	7-5 1-6 7-5 6-2
								Harold Solomon
49.		[9]	Ivan Lendl					1-6 6-4 7-6 7-5
				Ivan Lendl
50.			Sandy Mayer	7-6 6-2 6-3
					Ivan Lendl
51.			Klaus Eberhard		6-4 3-6 6-4 7-6
				Klaus Eberhard
52.			Jose Lopez-Maeso	6-4 7-6 6-2
						Brian Gottfried
53.			Brian Gottfried			2-6 7-6 1-6 7-5 6-3
				Brian Gottfried
54.			Miguel Mir-Rodon	6-4 6-0 6-4
					Brian Gottfried
55.			Fernando Luna		6-3 7-5 6-1
				Fernando Luna
56.			Sammy Giammalva Jr.	6-3 6-2 6-2
							Harold Solomon
57.			Van Winitsky				6-0 6-1 6-3
				Van Winitsky
58.			John Sadri	6-4 6-4 6-4
					Van Winitsky
59.			Christophe Casa		4-6 6-7 7-5 6-2 6-2
				Christophe Casa
60.			Jean-Louis Haillet	6-1 6-4 6-2
						Harold Solomon
61.			Chris Lewis			6-7 6-4 7-5 6-4
				Chris Lewis
62.			Andreas Maurer	4-6 7-6 7-5 6-2
					Harold Solomon
63.		[6]	Harold Solomon		6-3 6-3 6-3
				Harold Solomon
64.			Geoff Masters	7-6 6-3 6-4
										Bjorn Borg
65.		[7]	Eddie Dibbs							6-4 6-1 6-2
				Eddie Dibbs
66.			Carlos Gattiker	6-2 6-1 6-2
					Eddie Dibbs
67.			Thierry Tulasne		6-4 6-2 7-5
				Thierry Tulasne
68.			Bernard Boileau	7-5 7-5 4-3 rtd.
						Raul Ramirez
69.			Raul Ramirez			6-3 7-5 6-2
				Raul Ramirez
70.			Gianni Ocleppo	5-2 rtd.
					Raul Ramirez
71.			John Yuill		6-4 7-5 6-0
				John Yuill
72.			Stefan Simonsson	6-2 6-1 6-1
							Hans Gildemeister
73.			Rolf Gehring				3-6 6-3 3-6 6-3 10-8
				Rolf Gehring
74.			Erik Van Dillen	4-6 7-6 6-4 6-4
					Rolf Gehring
75.			Joao Soares		4-6 4-6 6-3 6-1 6-2
				Joao Soares
76.			Florin Segarceanu	6-4 6-2 6-4
						Hans Gildemeister
77.			Bob Lutz			3-6 6-1 6-2 6-1
				Bob Lutz
78.			Colin Dowdeswell	6-3 6-2 6-1
					Hans Gildemeister
79.		[12]	Hans Gildemeister		3-6 6-7 7-6 7-6 5-3 rtd.
				Hans Gildemeister
80.			David Carter	6-4 6-1 6-2
								Jimmy Connors
81.		[16]	Jose-Luis Clerc					6-4 6-0 6-0
				Jose-Luis Clerc
82.			Alejandro Pierola	6-1 6-0 7-5
					Yannick Noah
83.			Yannick Noah		6-4 6-7 6-4 1-6 6-3
				Yannick Noah
84.			Roberto Vizcaino-Mallol	6-0 7-5 7-5
						Yannick Noah
85.			Eliot Teltscher			6-3 6-0 7-6
				Eliot Teltscher
86.			Mark Edmondson	6-4 3-6 6-3 6-0
					Eliot Teltscher
87.			Kim Warwick		6-4 5-7 6-4 7-6
				Kim Warwick
88.			Francois Jauffret	6-2 6-1 6-2
							Jimmy Connors
89.			Antonio Zugarelli				7-5 6-4 rtd.
				Antonio Zugarelli
90.			John James	6-2 6-4 6-2
					Antonio Zugarelli
91.			Hans Simonsson		7-5 3-0 rtd.
				Hans Simonsson
92.			Henri Leconte	6-0 3-6 7-6 6-0
						Jimmy Connors
93.			Jean-Francois Caujolle			7-5 6-4 7-5
				Jean-Francois Caujolle
94.			Marcos Hocevar	6-1 6-4 6-4
					Jimmy Connors
95.		[3]	Jimmy Connors		3-6 2-6 7-5 6-1 6-1
				Jimmy Connors
96.			Adriano Panatta	6-4 4-6 6-2 7-6
									Vitas Gerulaitis
97.		[5]	Vitas Gerulaitis						6-1 3-6 6-7 6-2 6-4
				Vitas Gerulaitis
98.			Peter Elter	1-6 6-1 5-7 6-2 6-2
					Vitas Gerulaitis
99.			Fritz Buehning		6-1 6-2 6-1
				Fritz Buehning
100.			George Hardie	6-7 2-6 6-2 7-6 6-3
						Vitas Gerulaitis
101.			Stanislav Birner			6-1 4-6 6-2 6-1
				Stanislav Birner
102.			Shlomo Glickstein	6-2 6-2 6-2
					Stanislav Birner
103.			Jan Kodes		6-2 6-2 6-3
				Jan Kodes
104.			Chris Mayotte	4-6 6-4 6-4 6-4
							Vitas Gerulaitis
105.			Denis Naegelen				6-3 7-5 6-1
				Denis Naegelen
106.			Jiri Hrebec	7-6 7-5 6-1
					Denis Naegelen
107.			Terry Rocavert		6-4 6-4 2-6 6-0
				Terry Rocavert
108.			Fred McNair	6-1 6-3 4-6 4-6 6-2
						Ferdi Taygan
109.			Ferdi Taygan			4-6 3-6 6-2 6-4 11-9
				Ferdi Taygan
110.			Georges Goven	6-3 7-5 6-4
					Ferdi Taygan
111.		[10]	Peter Fleming		6-3 3-6 6-3 7-5
				Peter Fleming
112.			Byron Bertram	6-3 6-3 6-2
								Vitas Gerulaitis
113.		[13]	Wojtek Fibak					6-3 5-7 6-4 3-6 6-3
				Wojtek Fibak
114.			Zoltan Ilin	6-2 7-6 6-0
					Wojtek Fibak
115.			Tim Gullikson		6-3 6-4 6-1
				Tim Gullikson
116.			Terry Moor	6-3 6-3 6-1
						Wojtek Fibak
117.			Paolo Bertolucci			6-1 7-5 7-5
				Paolo Bertolucci
118.			Hank Pfister	6-4 6-4 6-7 6-7 7-5
					Paolo Bertolucci
119.			Bernie Mitton		5-7 6-3 7-6 3-6 6-3
				Bernie Mitton
120.			Onny Parun	6-3 5-7 7-5 6-0
							Wojtek Fibak
121.			Paul McNamee				6-4 6-4 6-7 6-3
				Paul McNamee
122.			Patrick Proisy	7-6 6-2 7-6
					Paul McNamee
123.			Michael Grant		6-3 6-4 6-1
				Michael Grant
124.			Jim Delaney	6-4 3-6 6-4 6-2
						Paul McNamee
125.			Per Hjertquist			7-6 6-7 7-6 7-6
				Per Hjertquist
126.			Warren Maher	5-7 6-4 7-5 6-2
					John McEnroe
127.		[2]	John McEnroe		6-4 7-6 6-0
				John McEnroe
128.			Patrice Dominguez	7-6 6-0 6-0

(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` = '1980' 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` = (358) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	127	127	1
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (3647, 3763, 3802, 3758, 3770, 3860, 3826, 5141, 3661, 3849, 3672, 3787, 3765, 3867, 3655, 3780, 3825, 3689, 3871, 3634, 3836, 3714, 3743, 3750, 3651, 3571, 3993, 4808, 3654, 3510, 3684, 3388, 3618, 3811, 3344, 3911, 3641, 5134, 5138, 3740, 3662, 3700, 3792, 3613, 3812, 3794, 3516, 3755, 3797, 3550, 5149, 3909, 3612, 5126, 5142, 4203, 3709, 3790, 4836, 3704, 3771, 4921, 3627, 3560, 3636, 5145, 3843, 5158, 3623, 3767, 3678, 3892, 3905, 3502, 3824, 3926, 3436, 3708, 3690, 3791, 3774, 5157, 3768, 5144, 3754, 3706, 3666, 3699, 3648, 3650, 3856, 3913, 3659, 3908, 3539, 3614, 3573, 5135, 3806, 3637, 3766, 3829, 3533, 3841, 4333, 3658, 3814, 3554, 3674, 3495, 3701, 3821, 3685, 5143, 3703, 3715, 3645, 3762, 3696, 3517, 3751, 3519, 3842, 3616, 3854, 3830, 3753, 3632) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	1
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` = 358	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (41, 197, 178, 172, 29, 68, 219, 173, 135, 217, 13, 92, 10, 121, 43, 196, 84, 146, 149, 179, 58, 198, 91, 207, 212, 153, 133, 21)	28	28	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (41, 197, 178, 172, 29, 68, 219, 173, 135, 217, 13, 92, 10, 121, 43, 196, 84, 146, 149, 179, 58, 198, 91, 207, 212, 153, 133, 21)	28	28	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3647, 3763, 3802, 3758, 3770, 3860, 3826, 5141, 3661, 3849, 3672, 3787, 3765, 3867, 3655, 3780, 3825, 3689, 3871, 3634, 3836, 3714, 3743, 3750, 3651, 3571, 3993, 4808, 3654, 3510, 3684, 3388, 3618, 3811, 3344, 3911, 3641, 5134, 5138, 3740, 3662, 3700, 3792, 3613, 3812, 3794, 3516, 3755, 3797, 3550, 5149, 3909, 3612, 5126, 5142, 4203, 3709, 3790, 4836, 3704, 3771, 4921, 3627, 3560, 3636, 5145, 3843, 5158, 3623, 3767, 3678, 3892, 3905, 3502, 3824, 3926, 3436, 3708, 3690, 3791, 3774, 5157, 3768, 5144, 3754, 3706, 3666, 3699, 3648, 3650, 3856, 3913, 3659, 3908, 3539, 3614, 3573, 5135, 3806, 3637, 3766, 3829, 3533, 3841, 4333, 3658, 3814, 3554, 3674, 3495, 3701, 3821, 3685, 5143, 3703, 3715, 3645, 3762, 3696, 3517, 3751, 3519, 3842, 3616, 3854, 3830, 3753, 3632)) AND (`Playercontest`.`contest_id` = 358))	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` = 1980	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 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` = '1980' 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` = (358) 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 (3647, 3763, 3802, 3758, 3770, 3860, 3826, 5141, 3661, 3849, 3672, 3787, 3765, 3867, 3655, 3780, 3825, 3689, 3871, 3634, 3836, 3714, 3743, 3750, 3651, 3571, 3993, 4808, 3654, 3510, 3684, 3388, 3618, 3811, 3344, 3911, 3641, 5134, 5138, 3740, 3662, 3700, 3792, 3613, 3812, 3794, 3516, 3755, 3797, 3550, 5149, 3909, 3612, 5126, 5142, 4203, 3709, 3790, 4836, 3704, 3771, 4921, 3627, 3560, 3636, 5145, 3843, 5158, 3623, 3767, 3678, 3892, 3905, 3502, 3824, 3926, 3436, 3708, 3690, 3791, 3774, 5157, 3768, 5144, 3754, 3706, 3666, 3699, 3648, 3650, 3856, 3913, 3659, 3908, 3539, 3614, 3573, 5135, 3806, 3637, 3766, 3829, 3533, 3841, 4333, 3658, 3814, 3554, 3674, 3495, 3701, 3821, 3685, 5143, 3703, 3715, 3645, 3762, 3696, 3517, 3751, 3519, 3842, 3616, 3854, 3830, 3753, 3632) 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` = 358

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (41, 197, 178, 172, 29, 68, 219, 173, 135, 217, 13, 92, 10, 121, 43, 196, 84, 146, 149, 179, 58, 198, 91, 207, 212, 153, 133, 21)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (41, 197, 178, 172, 29, 68, 219, 173, 135, 217, 13, 92, 10, 121, 43, 196, 84, 146, 149, 179, 58, 198, 91, 207, 212, 153, 133, 21)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (3647, 3763, 3802, 3758, 3770, 3860, 3826, 5141, 3661, 3849, 3672, 3787, 3765, 3867, 3655, 3780, 3825, 3689, 3871, 3634, 3836, 3714, 3743, 3750, 3651, 3571, 3993, 4808, 3654, 3510, 3684, 3388, 3618, 3811, 3344, 3911, 3641, 5134, 5138, 3740, 3662, 3700, 3792, 3613, 3812, 3794, 3516, 3755, 3797, 3550, 5149, 3909, 3612, 5126, 5142, 4203, 3709, 3790, 4836, 3704, 3771, 4921, 3627, 3560, 3636, 5145, 3843, 5158, 3623, 3767, 3678, 3892, 3905, 3502, 3824, 3926, 3436, 3708, 3690, 3791, 3774, 5157, 3768, 5144, 3754, 3706, 3666, 3699, 3648, 3650, 3856, 3913, 3659, 3908, 3539, 3614, 3573, 5135, 3806, 3637, 3766, 3829, 3533, 3841, 4333, 3658, 3814, 3554, 3674, 3495, 3701, 3821, 3685, 5143, 3703, 3715, 3645, 3762, 3696, 3517, 3751, 3519, 3842, 3616, 3854, 3830, 3753, 3632)) AND (`Playercontest`.`contest_id` = 358))

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

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)