Roland Garros 1996 Men's Singles (May 27 - June 9)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Pete Sampras
				Pete Sampras
2.			Magnus Gustafsson	6-1 7-5 7-6(5)
					Pete Sampras
3.			Sergi Bruguera		6-3 6-4 6-7(2) 2-6 6-3
				Sergi Bruguera
4.			Emilio Sanchez	6-1 7-5 6-4
						Pete Sampras
5.			Todd Martin			3-6 6-4 7-5 4-6 6-2
				Todd Martin
6.			Kenneth Carlsen	6-1 6-1 6-7(5) 6-2
					Todd Martin
7.			Mats Wilander		6-4 7-6(5) 6-2
				Mats Wilander
8.			Jean-Philippe Fleurian	7-5 6-4 6-1
							Pete Sampras
9.			Scott Draper				6-4 7-5 6-2
				Scott Draper
10.			Byron Black	7-5 6-3 6-0
					Scott Draper
11.			Gilbert Schaller		2-6 6-3 6-2 6-4
				Gilbert Schaller
12.		[WC]	Stephane Simian	6-3 6-4 7-5
						Scott Draper
13.			Jeff Tarango			6-1 6-2 6-3
				Jeff Tarango
14.			Martin Damm	4-6 6-2 4-6 6-3 6-4
					Jeff Tarango
15.		[Q]	Franco Squillari		6-4 6-4 6-1
				Franco Squillari
16.		[16]	MaliVai Washington	7-6(4) 6-4 3-0 rtd.
								Pete Sampras
17.		[10]	Wayne Ferreira					6-7(4) 4-6 6-4 6-4 6-4
				Wayne Ferreira
18.		[Q]	Gustavo Kuerten	6-4 7-5 7-6(4)
					Wayne Ferreira
19.			Slava Dosedel		4-6 7-6(7) 6-1 7-6(4)
				Slava Dosedel
20.		[Q]	Gaston Etlis	6-3 6-2 7-6(3)
						Wayne Ferreira
21.			Renzo Furlan			6-7(5) 7-5 6-1 7-5
				Renzo Furlan
22.			Jerome Golmard	6-4 3-6 1-6 7-5 6-4
					Renzo Furlan
23.			Brett Steven		6-0 6-2 6-4
				Brett Steven
24.		[WC]	Gregory Carraz	6-2 6-2 7-6(3)
							Jim Courier
25.			Karol Kucera				4-6 6-1 6-3 6-3
				Karol Kucera
26.		[WC]	Roberto Diaz	3-6 7-6(8) 4-6 6-2 6-2
					Karol Kucera
27.		[LL]	Magnus Norman		7-6(5) 6-4 6-7(5) 4-6 6-2
				Magnus Norman
28.			Amir Hadad	4-6 6-3 6-2 6-0
						Jim Courier
29.			David Rikl			6-7(2) 7-5 6-4 5-4 rtd.
				David Rikl
30.			Shuzo Matsuoka	7-6(2) 7-5 6-7(4) 6-1
					Jim Courier
31.		[7]	Jim Courier		6-3 6-2 6-2
				Jim Courier
32.		[Q]	Andrei Olhovskiy	6-1 3-6 7-6(4) 6-4
									Yevgeny Kafelnikov
33.		[1]	Andre Agassi						7-6(4) 6-0 6-2
				Andre Agassi
34.		[Q]	Jacobo Diaz-Ruiz	6-1 6-7(7) 6-4 6-4
					Chris Woodruff
35.			Chris Woodruff		4-6 6-4 6-7(7) 6-3 6-2
				Chris Woodruff
36.			Vince Spadea	6-2 6-2 3-6 7-6(4)
						Jonas Bjorkman
37.			Jonas Bjorkman			7-6(5) 2-6 4-6 7-5 6-4
				Jonas Bjorkman
38.			Filip Dewulf	6-4 6-4 6-3
					Jonas Bjorkman
39.		[WC]	Thierry Champion		5-7 6-1 6-4 6-0
				Thierry Champion
40.			Sandon Stolle	2-6 6-4 7-6(3) 4-6 7-5
							Richard Krajicek
41.			Todd Woodbridge				6-3 6-2 6-4
				Todd Woodbridge
42.		[LL]	Nicklas Kulti	0-6 6-2 2-6 6-4 6-1
					Todd Woodbridge
43.			Mark Philippoussis		3-6 6-4 7-6(1) 7-6(2)
				Mark Philippoussis
44.			Alexander Volkov	6-3 6-3 6-2
						Richard Krajicek
45.			Tomas Carbonell			7-5 6-2 6-2
				Tomas Carbonell
46.		[Q]	Tamer El Sawy	4-6 6-4 6-4 7-6(5)
					Richard Krajicek
47.		[13]	Richard Krajicek		6-2 4-6 7-6(2) 6-2
				Richard Krajicek
48.			Sandor Noszaly	4-6 7-6(2) 6-1 6-4
								Yevgeny Kafelnikov
49.		[12]	Albert Costa					6-3 6-4 6-7(4) 6-2
				Albert Costa
50.			Fernando Meligeni	3-6 6-4 6-3 7-6(2)
					Francisco Clavet
51.			Francisco Clavet		6-4 6-3 4-6 7-6(6)
				Francisco Clavet
52.			Johan Van Herck	4-6 7-5 7-6(2) 6-3
						Francisco Clavet
53.			Guy Forget			6-3 7-5 6-3
				Guy Forget
54.			Andrei Chesnokov	7-6(5) 7-6(4) 2-6 3-6 6-4
					Guy Forget
55.			Kris Goossens		6-3 6-4 3-6 3-6 6-3
				Kris Goossens
56.			Tim Henman	6-4 6-4 7-5
							Yevgeny Kafelnikov
57.			Felix Mantilla				6-4 6-3 6-3
				Felix Mantilla
58.		[Q]	Dirk Dier	6-4 6-2 5-7 6-4
					Felix Mantilla
59.			Alex Corretja		7-6(2) 6-2 6-4
				Alex Corretja
60.			Mark Woodforde	6-3 6-4 0-6 6-4
						Yevgeny Kafelnikov
61.			Thomas Johansson			6-4 6-2 6-2
				Thomas Johansson
62.		[WC]	Henri Leconte	6-1 6-1 6-4
					Yevgeny Kafelnikov
63.		[6]	Yevgeny Kafelnikov		6-2 7-5 6-3
				Yevgeny Kafelnikov
64.		[Q]	Galo Blanco	6-1 6-3 6-3
										Yevgeny Kafelnikov
65.		[5]	Goran Ivanisevic							7-6(4) 7-5 7-6(4)
				Goran Ivanisevic
66.			Jordi Arrese	6-4 6-4 6-1
					Goran Ivanisevic
67.			David Wheaton		7-5 6-2 6-4
				David Wheaton
68.			Guillaume Raoux	6-7(3) 6-0 6-4 6-4
						Goran Ivanisevic
69.			Bohdan Ulihrach			6-4 6-2 6-2
				Bohdan Ulihrach
70.		[Q]	Francisco Montana	6-2 6-4 6-2
					Bohdan Ulihrach
71.			Andriy Medvedev		6-3 6-7(10) 6-1 6-4
				Andriy Medvedev
72.			Nicolas Lapentti	6-2 6-2 6-3
							Bernd Karbacher
73.			Bernd Karbacher				6-3 6-1 6-2
				Bernd Karbacher
74.			Guillermo Perez Roldan	6-2 6-4 6-4
					Bernd Karbacher
75.			Andrea Gaudenzi		6-3 6-4 6-4
				Andrea Gaudenzi
76.		[Q]	Kim Tiilikainen	6-3 6-1 6-1
						Bernd Karbacher
77.			Paul Haarhuis			2-6 6-4 6-2 6-3
				Paul Haarhuis
78.			Younes El Aynaoui	7-5 7-6(6) 3-0 rtd.
					Paul Haarhuis
79.		[11]	Arnaud Boetsch		7-5 2-6 6-2 6-4
				Arnaud Boetsch
80.		[Q]	Jared Palmer	6-3 6-4 6-3
								Marc Rosset
81.		[14]	Marc Rosset					4-6 4-6 6-3 7-5 6-0
				Marc Rosset
82.			Carl-Uwe Steeb	6-4 6-4 6-0
					Marc Rosset
83.			Jiri Novak		6-2 6-4 6-3
				Jiri Novak
84.			Nicolas Pereira	2-6 4-6 6-2 6-1 6-1
						Marc Rosset
85.			Jakob Hlasek			6-4 6-4 6-1
				Jakob Hlasek
86.			Magnus Larsson	6-1 6-4 4-6 6-3
					Jakob Hlasek
87.			Jan Siemerink		6-2 1-6 6-3 7-6(3)
				Jan Siemerink
88.			Hernan Gumy	7-6(4) 6-3 6-1
							Marc Rosset
89.			Stefan Edberg				7-6(4) 6-3 6-3
				Stefan Edberg
90.			Karim Alami	6-4 6-2 6-4
					Stefan Edberg
91.			Carlos Moya		6-2 6-2 6-1
				Carlos Moya
92.			Patrick Rafter	6-4 7-6(1) 6-2
						Stefan Edberg
93.			Richard Fromberg			4-6 7-5 6-0 7-6(1)
				Richard Fromberg
94.		[WC]	Olivier Delaitre	6-3 6-1 6-3
					Michael Chang
95.		[4]	Michael Chang		6-3 3-6 7-6(5) 6-4
				Michael Chang
96.			David Prinosil	6-1 6-1 6-2
									Michael Stich
97.			Richey Reneberg						6-3 6-4 6-2
				Richey Reneberg
98.		[8]	Thomas Enqvist	6-2 3-6 3-6 6-4 6-4
					Cedric Pioline
99.			Cedric Pioline		7-5 6-2 6-3
				Cedric Pioline
100.			Javier Frana	6-1 6-3 6-2
						Cedric Pioline
101.			Alberto Berasategui			4-6 6-1 6-4 6-0
				Alberto Berasategui
102.			Michael Tebbutt	6-4 6-4 3-6 6-3
					Alberto Berasategui
103.			Hendrik Dreekmann		6-2 6-2 6-3
				Hendrik Dreekmann
104.			Christian Ruud	6-4 6-3 6-0
							Cedric Pioline
105.			Petr Korda				6-4 6-1 6-2
				Petr Korda
106.			Stefano Pescosolido	4-6 6-4 2-6 6-2 6-4
					Petr Korda
107.		[WC]	Lionel Roux		7-5 6-4 6-4
				Lionel Roux
108.		[Q]	Frederic Fontang	3-6 6-4 6-0 6-1
						Marcelo Rios
109.			Jason Stoltenberg			6-3 6-3 6-2
				Jason Stoltenberg
110.		[Q]	Jan Kroslak	6-1 6-2 6-1
					Marcelo Rios
111.		[9]	Marcelo Rios		6-4 6-3 6-3
				Marcelo Rios
112.			Michael Joyce	7-5 6-1 6-4
								Michael Stich
113.		[15]	Michael Stich					6-4 4-6 6-3 6-2
				Michael Stich
114.		[Q]	Patrik Fredriksson	6-4 7-5 6-4
					Michael Stich
115.			Greg Rusedski		6-3 7-5 6-3
				Greg Rusedski
116.		[Q]	Grant Doyle	6-2 1-6 7-5 2-6 7-5
						Michael Stich
117.			Mikael Tillstrom			4-6 6-0 6-4 7-6(3)
				Mikael Tillstrom
118.			Carlos Costa	4-6 2-6 6-1 7-5 6-1
					Mikael Tillstrom
119.			Mark Knowles		5-7 6-3 1-6 6-4 6-3
				Mark Knowles
120.		[Q]	Dick Norman	5-7 6-3 4-6 6-3 6-4
							Michael Stich
121.			Adrian Voinea				4-6 6-4 6-1 7-6(1)
				Adrian Voinea
122.			Marc-Kevin Goellner	3-6 6-3 7-6(5) 5-7 6-2
					Adrian Voinea
123.			Sjeng Schalken		5-7 6-3 6-4 6-2
				Sjeng Schalken
124.			Daniel Vacek	6-3 6-3 1-6 6-3
						Thomas Muster
125.		[WC]	Gerard Solves			6-2 5-2 rtd.
				Gerard Solves
126.			Marcos Ondruska	6-3 6-4 3-6 6-7(4) 9-7
					Thomas Muster
127.		[2]	Thomas Muster		6-1 6-3 6-0
				Thomas Muster
128.			Frederik Fetterlein	6-4 6-2 6-4

(default) 17 queries took 30 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	6
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	2
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	3
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` = '1996' 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` = (374) 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 (4095, 4099, 4120, 4017, 4142, 5679, 3894, 4035, 6157, 4337, 5674, 4161, 4066, 4185, 6233, 4101, 4162, 6205, 4198, 6198, 4187, 6173, 5686, 7155, 6168, 6217, 6264, 7738, 5197, 4094, 4081, 4116, 4001, 6235, 6204, 6169, 5726, 5706, 4018, 4189, 4123, 4156, 5713, 4062, 4092, 8654, 4176, 6185, 6178, 4188, 4155, 6193, 3931, 4054, 6174, 6197, 6227, 8658, 4191, 4022, 5723, 3913, 5702, 6212, 4108, 4124, 4061, 4154, 6195, 4152, 5677, 6181, 5692, 4071, 5710, 8715, 4118, 5720, 4153, 4065, 4143, 4114, 6187, 4104, 3948, 4186, 4166, 6179, 3933, 6162, 6190, 5663, 4131, 4117, 4045, 5696, 4040, 5671, 4163, 4087, 6201, 5725, 5718, 4194, 4075, 4164, 6180, 5188, 4067, 6156, 6182, 4158, 4098, 6191, 5705, 5661, 6192, 4179, 5712, 6186, 6163, 4197, 6188, 5633, 7131, 4168, 4008, 6189) 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` = 374	128	128	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (10, 178, 68, 179, 197, 14, 173, 13, 154, 53, 94, 72, 201, 50, 133, 172, 92, 29, 139, 207, 194, 54, 135, 196, 21, 16, 127, 168, 153, 58, 41, 84, 91, 59, 67)	35	35	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (10, 178, 68, 179, 197, 14, 173, 13, 154, 53, 94, 72, 201, 50, 133, 172, 92, 29, 139, 207, 194, 54, 135, 196, 21, 16, 127, 168, 153, 58, 41, 84, 91, 59, 67)	35	35	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (4095, 4099, 4120, 4017, 4142, 5679, 3894, 4035, 6157, 4337, 5674, 4161, 4066, 4185, 6233, 4101, 4162, 6205, 4198, 6198, 4187, 6173, 5686, 7155, 6168, 6217, 6264, 7738, 5197, 4094, 4081, 4116, 4001, 6235, 6204, 6169, 5726, 5706, 4018, 4189, 4123, 4156, 5713, 4062, 4092, 8654, 4176, 6185, 6178, 4188, 4155, 6193, 3931, 4054, 6174, 6197, 6227, 8658, 4191, 4022, 5723, 3913, 5702, 6212, 4108, 4124, 4061, 4154, 6195, 4152, 5677, 6181, 5692, 4071, 5710, 8715, 4118, 5720, 4153, 4065, 4143, 4114, 6187, 4104, 3948, 4186, 4166, 6179, 3933, 6162, 6190, 5663, 4131, 4117, 4045, 5696, 4040, 5671, 4163, 4087, 6201, 5725, 5718, 4194, 4075, 4164, 6180, 5188, 4067, 6156, 6182, 4158, 4098, 6191, 5705, 5661, 6192, 4179, 5712, 6186, 6163, 4197, 6188, 5633, 7131, 4168, 4008, 6189)) AND (`Playercontest`.`contest_id` = 374))	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` = 1996	20	20	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, 7, 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 30 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` = '1996' 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` = (374) 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 (4095, 4099, 4120, 4017, 4142, 5679, 3894, 4035, 6157, 4337, 5674, 4161, 4066, 4185, 6233, 4101, 4162, 6205, 4198, 6198, 4187, 6173, 5686, 7155, 6168, 6217, 6264, 7738, 5197, 4094, 4081, 4116, 4001, 6235, 6204, 6169, 5726, 5706, 4018, 4189, 4123, 4156, 5713, 4062, 4092, 8654, 4176, 6185, 6178, 4188, 4155, 6193, 3931, 4054, 6174, 6197, 6227, 8658, 4191, 4022, 5723, 3913, 5702, 6212, 4108, 4124, 4061, 4154, 6195, 4152, 5677, 6181, 5692, 4071, 5710, 8715, 4118, 5720, 4153, 4065, 4143, 4114, 6187, 4104, 3948, 4186, 4166, 6179, 3933, 6162, 6190, 5663, 4131, 4117, 4045, 5696, 4040, 5671, 4163, 4087, 6201, 5725, 5718, 4194, 4075, 4164, 6180, 5188, 4067, 6156, 6182, 4158, 4098, 6191, 5705, 5661, 6192, 4179, 5712, 6186, 6163, 4197, 6188, 5633, 7131, 4168, 4008, 6189) 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` = 374

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (10, 178, 68, 179, 197, 14, 173, 13, 154, 53, 94, 72, 201, 50, 133, 172, 92, 29, 139, 207, 194, 54, 135, 196, 21, 16, 127, 168, 153, 58, 41, 84, 91, 59, 67)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (10, 178, 68, 179, 197, 14, 173, 13, 154, 53, 94, 72, 201, 50, 133, 172, 92, 29, 139, 207, 194, 54, 135, 196, 21, 16, 127, 168, 153, 58, 41, 84, 91, 59, 67)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (4095, 4099, 4120, 4017, 4142, 5679, 3894, 4035, 6157, 4337, 5674, 4161, 4066, 4185, 6233, 4101, 4162, 6205, 4198, 6198, 4187, 6173, 5686, 7155, 6168, 6217, 6264, 7738, 5197, 4094, 4081, 4116, 4001, 6235, 6204, 6169, 5726, 5706, 4018, 4189, 4123, 4156, 5713, 4062, 4092, 8654, 4176, 6185, 6178, 4188, 4155, 6193, 3931, 4054, 6174, 6197, 6227, 8658, 4191, 4022, 5723, 3913, 5702, 6212, 4108, 4124, 4061, 4154, 6195, 4152, 5677, 6181, 5692, 4071, 5710, 8715, 4118, 5720, 4153, 4065, 4143, 4114, 6187, 4104, 3948, 4186, 4166, 6179, 3933, 6162, 6190, 5663, 4131, 4117, 4045, 5696, 4040, 5671, 4163, 4087, 6201, 5725, 5718, 4194, 4075, 4164, 6180, 5188, 4067, 6156, 6182, 4158, 4098, 6191, 5705, 5661, 6192, 4179, 5712, 6186, 6163, 4197, 6188, 5633, 7131, 4168, 4008, 6189)) AND (`Playercontest`.`contest_id` = 374))

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

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, 7, 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)