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

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Lleyton Hewitt
				Lleyton Hewitt
2.			Andre Sa	7-5 6-4 7-5
					Lleyton Hewitt
3.		[LL]	Andrei Stoliarov		4-6 7-6(5) 6-0 7-5
				Andrei Stoliarov
4.			Jonas Bjorkman	1-6 6-4 6-4 7-5
						Lleyton Hewitt
5.		[WC]	Sebastien De Chaunac			6-1 7-5 6-7(3) 6-1
				Sebastien De Chaunac
6.			Michael Chang	4-6 4-6 6-4 6-2 6-4
					Sjeng Schalken
7.		[30]	Sjeng Schalken		6-0 6-2 7-6(3)
				Sjeng Schalken
8.		[Q]	Ivan Miranda	7-6(2) 6-0 6-1
							Guillermo Canas
9.		[17]	Carlos Moya				6-7(1) 7-6(13) 6-4 6-3
				Carlos Moya
10.			Ramon Delgado	6-3 6-3 6-2
					Carlos Moya
11.			Mark Philippoussis		6-2 7-6(7) 7-6(9)
				Mark Philippoussis
12.		[Q]	Julien Varlet	1-6 6-7(5) 6-4 7-6(3) 6-3
						Guillermo Canas
13.			Alex Calatrava			4-6 7-6(1) 6-7(2) 6-1 6-2
				Alex Calatrava
14.			Nicolas Kiefer	6-3 6-0 6-4
					Guillermo Canas
15.		[15]	Guillermo Canas		3-6 6-1 6-2 6-0
				Guillermo Canas
16.			Karol Kucera	6-7(3) 6-4 6-2 6-2
								Albert Costa
17.			Andrea Gaudenzi					7-5 3-6 6-7(3) 6-4 6-0
				Andrea Gaudenzi
18.		[12]	Pete Sampras	3-6 6-4 6-2 7-6(3)
					Andrea Gaudenzi
19.		[Q]	Jack Brasington		6-3 7-6(0) 6-1
				Jack Brasington
20.			Federico Luzzi	6-2 6-2 7-5
						Albert Costa
21.			Nikolay Davydenko			7-6(2) 6-1 7-5
				Nikolay Davydenko
22.		[Q]	Giorgio Galimberti	6-7(4) 6-4 6-1 6-3
					Albert Costa
23.		[20]	Albert Costa		7-5 7-6(4) 6-2
				Albert Costa
24.		[WC]	Richard Gasquet	3-6 6-0 6-4 6-3
							Albert Costa
25.			Fernando Meligeni				6-4 7-5 6-4
				Fernando Meligeni
26.		[27]	Nicolas Escude	6-4 6-2 0-6 6-4
					Fernando Gonzalez
27.			Fernando Gonzalez		6-2 3-6 6-1 6-2
				Fernando Gonzalez
28.		[WC]	Scott Draper	6-2 7-6(9) 6-3
						Gustavo Kuerten
29.			Davide Sanguinetti			6-3 2-6 7-6(6) 6-4
				Davide Sanguinetti
30.			Julian Knowle	6-3 4-6 7-5 6-3
					Gustavo Kuerten
31.		[7]	Gustavo Kuerten		6-7(0) 6-2 4-6 6-4 6-3
				Gustavo Kuerten
32.			Ivo Heuberger	7-5 6-2 6-2
									Albert Costa
33.		[3]	Tommy Haas						6-3 6-4 3-6 6-3
				Tommy Haas
34.			Michal Tabara	6-3 7-5 6-4
					Tommy Haas
35.		[LL]	Feliciano Lopez		6-3 6-4 6-4
				Feliciano Lopez
36.		[Q]	Didac Minarro	4-6 6-4 6-2 4-6 6-4
						Tommy Haas
37.		[Q]	Amir Hadad			6-3 7-5 2-6 6-4
				Amir Hadad
38.			Christophe Rochus	6-1 6-2 6-7(4) 6-2
					Jarkko Nieminen
39.			Jarkko Nieminen		6-7(4) 6-4 6-4 7-5
				Jarkko Nieminen
40.		[28]	Nicolas Lapentti	6-3 6-4 7-6(5)
							Andrei Pavel
41.		[22]	Andrei Pavel				6-1 7-6(9) 6-4
				Andrei Pavel
42.			Martin Lee	6-1 5-4 rtd.
					Andrei Pavel
43.			Michel Kratochvil		6-3 6-1 6-3
				Michel Kratochvil
44.			Dominik Hrbaty	6-0 6-7(6) 6-3 6-3
						Andrei Pavel
45.			Albert Montanes			6-1 1-6 6-4 6-3
				Albert Montanes
46.			Antony Dupuis	6-7(3) 6-4 3-6 6-2 7-5
					Albert Montanes
47.		[16]	Younes El Aynaoui		7-5 7-6(2) 6-4
				Younes El Aynaoui
48.			Jan-Michael Gambill	3-6 6-3 6-4 3-6 6-4
								Alex Corretja
49.		[9]	Thomas Johansson					7-6(5) 7-5 7-5
				Thomas Johansson
50.			Franco Squillari	6-2 7-6(6) 6-2
					Arnaud Clement
51.			Arnaud Clement		7-6(4) 6-1 6-3
				Arnaud Clement
52.		[WC]	Julien Benneteau	6-0 6-1 6-4
						Alex Corretja
53.			Todd Martin			6-1 6-2 4-6 5-7 8-6
				Todd Martin
54.		[Q]	Martin Arguello	6-2 7-5 3-6 4-6 7-5
					Alex Corretja
55.		[18]	Alex Corretja		6-2 6-3 7-5
				Alex Corretja
56.			Bohdan Ulihrach	6-1 6-4 6-1
							Alex Corretja
57.			Fernando Vicente				6-3 6-2 7-5
				Fernando Vicente
58.		[32]	Ivan Ljubicic	4-6 6-1 7-6 4-6 6-3
					Fernando Vicente
59.			Alberto Martin		6-4 6-3 6-3
				Alberto Martin
60.		[Q]	Robby Ginepri	7-6(5) 6-2 6-3
						Mariano Zabaleta
61.			Mariano Zabaleta			4-6 6-3 6-4 6-3
				Mariano Zabaleta
62.			Jan Vacek	6-1 3-6 6-3 6-4
					Mariano Zabaleta
63.		[5]	Yevgeny Kafelnikov		7-6(4) 2-6 6-4 7-6(4)
				Yevgeny Kafelnikov
64.		[Q]	Tomas Behrend	6-3 6-2 3-6 6-7(3) 6-1
										Albert Costa
65.			Hicham Arazi							6-1 6-0 4-6 6-3
				Hicham Arazi
66.		[8]	Roger Federer	6-3 6-2 6-4
					Hicham Arazi
67.		[Q]	Mariano Puerta		6-2 6-1 6-2
				Mariano Puerta
68.			Kristian Pless	6-3 1-6 7-6(5) 5-7 6-3
						Gaston Gaudio
69.			Irakli Labadze			6-2 4-6 6-4 3-1 rtd.
				Irakli Labadze
70.			Julien Boutter	7-6(4) 5-7 6-7(6) 6-3 9-7
					Gaston Gaudio
71.		[31]	Gaston Gaudio		6-1 6-2 6-7(9) 6-4
				Gaston Gaudio
72.			Juan-Manuel Balcells	6-4 6-2 7-5
							Juan Carlos Ferrero
73.		[24]	Rainer Schuettler				6-7(3) 6-1 6-7(5) 6-2 6-4
				Rainer Schuettler
74.		[LL]	Stefano Galvani	7-6(4) 2-6 7-6(3) 6-1
					Guillermo Coria
75.			Guillermo Coria		6-4 6-2 6-3
				Guillermo Coria
76.			Sargis Sargsian	6-2 7-5 6-0
						Juan Carlos Ferrero
77.			Nicolas Coutelot			6-2 6-3 6-3
				Nicolas Coutelot
78.			Stefan Koubek	6-4 6-4 6-4
					Juan Carlos Ferrero
79.		[11]	Juan Carlos Ferrero		6-2 5-7 1-6 6-2 6-0
				Juan Carlos Ferrero
80.		[WC]	Jean-Rene Lisnard	6-1 7-6(1) 6-3
								Juan Carlos Ferrero
81.		[14]	Jiri Novak					6-3 5-7 7-5 6-3
				Jiri Novak
82.			Mikhail Youzhny	6-3 6-4 7-6(5)
					Jiri Novak
83.		[Q]	Jens Knippschild		6-1 6-2 7-5
				Jens Knippschild
84.			Hyung-Taik Lee	6-4 1-6 3-6 7-6(3) 6-1
						Paul-Henri Mathieu
85.		[WC]	Paul-Henri Mathieu			6-4 6-4 6-3
				Paul-Henri Mathieu
86.			Wayne Ferreira	6-4 6-7(1) 5-7 6-2 6-0
					Paul-Henri Mathieu
87.		[23]	Fabrice Santoro		7-5 6-1 1-6 6-4
				Fabrice Santoro
88.			Magnus Norman	6-2 5-7 3-6 6-4 6-4
							Andre Agassi
89.		[25]	Tommy Robredo				4-6 3-6 6-3 6-3 6-3
				Tommy Robredo
90.			Harel Levy	6-1 6-0 1-0 rtd.
					Tommy Robredo
91.		[Q]	Oleg Ogorodov		6-3 4-6 6-1 6-2
				Oleg Ogorodov
92.			Markus Hipfl	6-7(8) 6-1 2-6 7-5 9-7
						Andre Agassi
93.			David Sanchez-Munoz			6-2 6-4 6-2
				David Sanchez-Munoz
94.			Jose Acasuso	6-4 7-5 6-4
					Andre Agassi
95.		[4]	Andre Agassi		4-6 6-2 6-1 rtd.
				Andre Agassi
96.		[Q]	Eric Prodon	6-3 6-3 6-1
									Juan Carlos Ferrero
97.		[6]	Tim Henman						6-3 6-2 6-4
				Tim Henman
98.			Galo Blanco	6-4 6-3 7-6(6)
					Xavier Malisse
99.			Xavier Malisse		6-2 6-3 6-7(4) 6-3
				Xavier Malisse
100.		[Q]	Alexander Popp	6-4 6-1 4-6 6-1
						Xavier Malisse
101.			Albert Portas			6-2 6-3 7-6(3)
				Albert Portas
102.			Andrew Ilie	7-6(4) 6-3 6-4
					Albert Portas
103.			Cecil Mamiit		3-6 6-3 6-4 6-4
				Cecil Mamiit
104.		[26]	Max Mirnyi	6-3 6-4 5-7 6-4
							Sebastien Grosjean
105.			Adrian Voinea				6-2 7-5 6-3
				Adrian Voinea
106.		[21]	Juan Ignacio Chela	7-6(9) 7-5 4-6 7-6(7)
					Vince Spadea
107.			Vince Spadea		6-4 4-6 2-6 7-6(4) 8-6
				Vince Spadea
108.			Cedric Pioline	4-6 6-4 6-4 3-6 6-4
						Sebastien Grosjean
109.			James Blake			6-2 7-6(5) 6-7(5) 6-4
				James Blake
110.			Lars Burgsmuller	6-2 2-1 rtd.
					Sebastien Grosjean
111.		[10]	Sebastien Grosjean		6-4 3-6 6-2 7-5
				Sebastien Grosjean
112.			Francisco Clavet	7-6(0) 7-6(2) 3-6 6-3
								Marat Safin
113.			Wayne Arthurs					6-3 6-2 6-2
				Wayne Arthurs
114.		[13]	Andy Roddick	4-6 7-6(14) 4-6 7-5 6-3
					Arnaud Di Pasquale
115.		[WC]	Arnaud Di Pasquale		7-6(4) 6-3 6-2
				Arnaud Di Pasquale
116.			Michael Russell	6-4 6-0 4-6 6-1
						Arnaud Di Pasquale
117.			Paradorn Srichaphan			6-4 6-3 6-3
				Paradorn Srichaphan
118.			Raemon Sluiter	5-7 6-2 6-7(5) 6-4 6-4
					Paradorn Srichaphan
119.		[19]	Thomas Enqvist		6-4 1-6 7-5 6-3
				Thomas Enqvist
120.		[Q]	Edgardo Massa	4-6 4-6 6-3 6-2 6-4
							Marat Safin
121.		[29]	David Nalbandian				3-6 6-4 6-3 6-2
				David Nalbandian
122.			Agustin Calleri	6-2 5-7 6-2 6-4
					David Nalbandian
123.			Flavio Saretta		6-3 6-4 6-0
				Flavio Saretta
124.		[Q]	Oliver Marach	6-2 6-2 4-6 6-7(5) 6-4
						Marat Safin
125.			Olivier Rochus			6-3 6-3 3-6 6-4
				Olivier Rochus
126.			Attila Savolt	6-4 7-6(0) 6-2
					Marat Safin
127.		[2]	Marat Safin		4-6 6-2 3-6 6-3 6-3
				Marat Safin
128.		[WC]	Michael Llodra	6-4 2-6 7-6(7) 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	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` = '2002' 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` = (380) 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 (65, 7169, 7328, 5726, 7189, 4045, 6188, 7468, 6190, 6253, 5713, 7232, 6224, 6175, 6254, 6168, 5710, 4095, 7338, 7347, 169, 7260, 6178, 75, 4188, 6234, 7327, 6157, 6222, 7217, 6205, 7336, 176, 6292, 171, 8736, 7738, 6290, 166, 6181, 6220, 7343, 7332, 6230, 120, 6293, 5720, 6226, 5723, 6233, 5932, 102, 4142, 7295, 4191, 6195, 6259, 172, 6223, 4776, 6262, 7470, 5702, 6286, 6208, 147, 6257, 7277, 7340, 6275, 6284, 7203, 4209, 8723, 7326, 6213, 8665, 6250, 93, 4924, 6187, 72, 7725, 7266, 3590, 4162, 4129, 6264, 5051, 7258, 6194, 6261, 7329, 7298, 4001, 144, 6197, 6212, 86, 8664, 6231, 6159, 6249, 6295, 6163, 76, 6169, 4163, 3578, 6165, 6256, 4155, 6255, 67, 6247, 77, 6276, 6270, 5671, 7235, 167, 7314, 7250, 7273, 150, 7339, 6260, 88) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	3
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` = 380	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 197, 154, 68, 10, 21, 173, 179, 67, 27, 72, 172, 29, 178, 92, 127, 153, 168, 58, 53, 133, 199, 196, 11, 14, 146, 184, 20, 91, 100, 54, 41, 84, 71, 147)	35	35	5
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 197, 154, 68, 10, 21, 173, 179, 67, 27, 72, 172, 29, 178, 92, 127, 153, 168, 58, 53, 133, 199, 196, 11, 14, 146, 184, 20, 91, 100, 54, 41, 84, 71, 147)	35	35	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (65, 7169, 7328, 5726, 7189, 4045, 6188, 7468, 6190, 6253, 5713, 7232, 6224, 6175, 6254, 6168, 5710, 4095, 7338, 7347, 169, 7260, 6178, 75, 4188, 6234, 7327, 6157, 6222, 7217, 6205, 7336, 176, 6292, 171, 8736, 7738, 6290, 166, 6181, 6220, 7343, 7332, 6230, 120, 6293, 5720, 6226, 5723, 6233, 5932, 102, 4142, 7295, 4191, 6195, 6259, 172, 6223, 4776, 6262, 7470, 5702, 6286, 6208, 147, 6257, 7277, 7340, 6275, 6284, 7203, 4209, 8723, 7326, 6213, 8665, 6250, 93, 4924, 6187, 72, 7725, 7266, 3590, 4162, 4129, 6264, 5051, 7258, 6194, 6261, 7329, 7298, 4001, 144, 6197, 6212, 86, 8664, 6231, 6159, 6249, 6295, 6163, 76, 6169, 4163, 3578, 6165, 6256, 4155, 6255, 67, 6247, 77, 6276, 6270, 5671, 7235, 167, 7314, 7250, 7273, 150, 7339, 6260, 88)) AND (`Playercontest`.`contest_id` = 380))	128	128	3
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	2
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 2002	20	20	2
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` = '2002' 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` = (380) 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 (65, 7169, 7328, 5726, 7189, 4045, 6188, 7468, 6190, 6253, 5713, 7232, 6224, 6175, 6254, 6168, 5710, 4095, 7338, 7347, 169, 7260, 6178, 75, 4188, 6234, 7327, 6157, 6222, 7217, 6205, 7336, 176, 6292, 171, 8736, 7738, 6290, 166, 6181, 6220, 7343, 7332, 6230, 120, 6293, 5720, 6226, 5723, 6233, 5932, 102, 4142, 7295, 4191, 6195, 6259, 172, 6223, 4776, 6262, 7470, 5702, 6286, 6208, 147, 6257, 7277, 7340, 6275, 6284, 7203, 4209, 8723, 7326, 6213, 8665, 6250, 93, 4924, 6187, 72, 7725, 7266, 3590, 4162, 4129, 6264, 5051, 7258, 6194, 6261, 7329, 7298, 4001, 144, 6197, 6212, 86, 8664, 6231, 6159, 6249, 6295, 6163, 76, 6169, 4163, 3578, 6165, 6256, 4155, 6255, 67, 6247, 77, 6276, 6270, 5671, 7235, 167, 7314, 7250, 7273, 150, 7339, 6260, 88) 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` = 380

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 197, 154, 68, 10, 21, 173, 179, 67, 27, 72, 172, 29, 178, 92, 127, 153, 168, 58, 53, 133, 199, 196, 11, 14, 146, 184, 20, 91, 100, 54, 41, 84, 71, 147)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 197, 154, 68, 10, 21, 173, 179, 67, 27, 72, 172, 29, 178, 92, 127, 153, 168, 58, 53, 133, 199, 196, 11, 14, 146, 184, 20, 91, 100, 54, 41, 84, 71, 147)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (65, 7169, 7328, 5726, 7189, 4045, 6188, 7468, 6190, 6253, 5713, 7232, 6224, 6175, 6254, 6168, 5710, 4095, 7338, 7347, 169, 7260, 6178, 75, 4188, 6234, 7327, 6157, 6222, 7217, 6205, 7336, 176, 6292, 171, 8736, 7738, 6290, 166, 6181, 6220, 7343, 7332, 6230, 120, 6293, 5720, 6226, 5723, 6233, 5932, 102, 4142, 7295, 4191, 6195, 6259, 172, 6223, 4776, 6262, 7470, 5702, 6286, 6208, 147, 6257, 7277, 7340, 6275, 6284, 7203, 4209, 8723, 7326, 6213, 8665, 6250, 93, 4924, 6187, 72, 7725, 7266, 3590, 4162, 4129, 6264, 5051, 7258, 6194, 6261, 7329, 7298, 4001, 144, 6197, 6212, 86, 8664, 6231, 6159, 6249, 6295, 6163, 76, 6169, 4163, 3578, 6165, 6256, 4155, 6255, 67, 6247, 77, 6276, 6270, 5671, 7235, 167, 7314, 7250, 7273, 150, 7339, 6260, 88)) AND (`Playercontest`.`contest_id` = 380))

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

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)