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

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Lleyton Hewitt
				Lleyton Hewitt
2.			Brian Vahaly	6-4 6-1 6-7(6) 6-3
					Lleyton Hewitt
3.			Nikolay Davydenko		6-3 4-6 6-3 7-6(5)
				Nikolay Davydenko
4.			Greg Rusedski	6-3 7-5 6-2
						Tommy Robredo
5.			Jonas Bjorkman			4-6 1-6 6-3 6-2 6-3
				Jonas Bjorkman
6.			Max Mirnyi	6-1 6-2 6-4
					Tommy Robredo
7.		[28]	Tommy Robredo		7-6(2) 6-3 6-4
				Tommy Robredo
8.		[Q]	Giovanni Lapentti	3-6 7-6(3) 3-6 3-1 rtd.
							Tommy Robredo
9.		[21]	Gaston Gaudio				6-4 1-6 7-6(2) 6-4
				Gaston Gaudio
10.			Paul-Henri Mathieu	7-5 6-3 6-3
					Gaston Gaudio
11.			Olivier Mutis		6-2 1-6 6-2 6-2
				Olivier Mutis
12.		[WC]	Jerome Golmard	6-2 6-7(5) 6-2 6-3
						Gustavo Kuerten
13.			Hicham Arazi			7-6(1) 7-5 5-7 6-3
				Hicham Arazi
14.			Raemon Sluiter	6-2 7-6(3) 2-6 6-0
					Gustavo Kuerten
15.		[15]	Gustavo Kuerten		6-1 6-0 6-1
				Gustavo Kuerten
16.			Marc Rosset	6-2 6-7(3) 6-3 7-6(3)
								Albert Costa
17.		[9]	Albert Costa					2-6 3-6 6-4 7-5 6-2
				Albert Costa
18.		[LL]	Sergio Roitman	6-7(3) 2-6 7-5 6-2 6-2
					Albert Costa
19.			Radek Stepanek		6-3 5-7 6-4 3-6 6-4
				Radek Stepanek
20.			Wayne Arthurs	6-1 4-6 6-1 7-6(2)
						Albert Costa
21.			Nicolas Lapentti			4-6 4-6 6-3 6-4 6-4
				Nicolas Lapentti
22.		[WC]	Richard Gasquet	6-3 7-6(4) 3-0 rtd.
					Nicolas Lapentti
23.			Franco Squillari		4-6 6-1 6-4 6-3
				Franco Squillari
24.		[18]	Agustin Calleri	7-5 7-6(2) 6-3
							Albert Costa
25.		[32]	Arnaud Clement				6-2 7-5 7-5
				Arnaud Clement
26.			Thomas Enqvist	6-3 6-4 6-2
					Arnaud Clement
27.			Lars Burgsmuller		6-3 6-3 6-3
				Lars Burgsmuller
28.			Mardy Fish	7-6(3) 6-2 4-6 6-1
						Arnaud Clement
29.		[Q]	Nicolas Coutelot			6-4 6-3 6-2
				Nicolas Coutelot
30.			Davide Sanguinetti	6-3 6-3 6-4
					Nicolas Coutelot
31.		[8]	David Nalbandian		6-3 6-3 4-6 2-6 6-1
				David Nalbandian
32.			Albert Montanes	6-4 6-3 3-6 7-5
									Juan Carlos Ferrero
33.		[3]	Juan Carlos Ferrero						6-3 7-6(5) 6-4
				Juan Carlos Ferrero
34.			Michel Kratochvil	7-5 7-5 6-4
					Juan Carlos Ferrero
35.			Nicolas Massu		6-2 3-0 rtd.
				Nicolas Massu
36.			Magnus Norman	6-4 6-1 6-3
						Juan Carlos Ferrero
37.			Todd Martin			4-6 6-2 6-4 6-2
				Todd Martin
38.			Jose Acasuso	4-6 6-3 6-4 6-2
					Tim Henman
39.		[25]	Tim Henman		7-6(5) 5-7 6-1 7-5
				Tim Henman
40.			Vladimir Voltchkov	6-2 6-3 6-1
							Juan Carlos Ferrero
41.		[20]	Felix Mantilla				6-2 6-1 6-1
				Felix Mantilla
42.			Hyung-Taik Lee	7-6(3) 6-4 7-6(4)
					Felix Mantilla
43.		[Q]	Federico Browne		6-3 4-6 6-3 6-1
				Federico Browne
44.			Olivier Rochus	4-6 2-6 6-1 6-1 6-3
						Felix Mantilla
45.			Fernando Vicente			7-6(3) 6-3 6-3
				Fernando Vicente
46.		[Q]	Alexander Waske	3-6 6-2 7-5 1-6 6-3
					Fernando Vicente
47.		[14]	Sebastien Grosjean		7-6(3) 6-3 6-3
				Sebastien Grosjean
48.			Adrian Voinea	6-4 7-6(3) 3-6 6-3
								Juan Carlos Ferrero
49.		[12]	Sjeng Schalken					6-1 3-6 6-1 5-7 6-4
				Sjeng Schalken
50.		[WC]	Scott Draper	6-2 6-4 3-6 6-4
					Sjeng Schalken
51.			Fabrice Santoro		6-1 6-3 6-4
				Fabrice Santoro
52.		[WC]	Michael Chang	7-5 6-1 6-1
						Fernando Gonzalez
53.			Albert Portas			7-6(4) 6-3 3-1 rtd.
				Albert Portas
54.		[WC]	Thierry Ascione	3-6 6-2 6-4 6-4
					Fernando Gonzalez
55.		[19]	Fernando Gonzalez		6-3 4-6 6-4 6-2
				Fernando Gonzalez
56.			Jan-Michael Gambill	6-0 6-2 6-3
							Fernando Gonzalez
57.		[30]	Jarkko Nieminen				6-3 6-3 6-2
				Jarkko Nieminen
58.			Nicolas Escude	7-6(3) 6-7(4) 6-3 6-1
					Jarkko Nieminen
59.		[Q]	Julien Varlet		1-6 1-6 7-6(4) 6-2 6-4
				Julien Varlet
60.			Kenneth Carlsen	6-1 4-6 6-3 7-6(5)
						Jarkko Nieminen
61.		[Q]	Victor Hanescu			6-7(1) 6-4 6-2 3-6 6-3
				Victor Hanescu
62.			Michael Llodra	6-4 6-3 6-2
					Victor Hanescu
63.			Sargis Sargsian		6-3 7-5 3-6 6-2
				Sargis Sargsian
64.		[6]	Andy Roddick	6-7(3) 6-1 6-2 6-4
										Juan Carlos Ferrero
65.			Luis Horna							6-1 6-3 6-2
				Luis Horna
66.		[5]	Roger Federer	7-6(6) 6-2 7-6(3)
					Martin Verkerk
67.			Martin Verkerk		4-6 6-4 4-6 7-5 6-2
				Martin Verkerk
68.			Zeljko Krajan	6-3 6-4 6-4
						Martin Verkerk
69.			John Van Lottum			5-7 6-4 6-2 7-5
				John Van Lottum
70.		[Q]	Dick Norman	6-3 3-6 2-6 6-3 6-4
					Vince Spadea
71.		[29]	Vince Spadea		7-5 6-1 2-6 6-1
				Vince Spadea
72.			Irakli Labadze	6-1 3-6 5-7 6-4 6-1
							Martin Verkerk
73.		[22]	Wayne Ferreira				6-3 6-3 7-5
				Wayne Ferreira
74.			Tomas Behrend	6-4 6-2 6-3
					Wayne Ferreira
75.			David Ferrer		4-6 6-4 6-1 6-3
				David Ferrer
76.			Jurgen Melzer	6-2 6-2 7-6
						Rainer Schuettler
77.			Jean-Rene Lisnard			6-3 1-6 7-6(3) 2-3 rtd.
				Jean-Rene Lisnard
78.		[Q]	Mariano Delfino	6-1 6-4 4-6 6-4
					Rainer Schuettler
79.		[11]	Rainer Schuettler		4-6 6-2 6-4 6-0
				Rainer Schuettler
80.			Cecil Mamiit	6-1 2-6 6-4 6-2
								Martin Verkerk
81.		[13]	Jiri Novak					6-3 6-4 5-7 4-6 8-6
				Jiri Novak
82.		[WC]	Julien Benneteau	6-2 6-3 6-2
					Jiri Novak
83.		[Q]	Marc Lopez		6-4 3-6 0-6 6-1 6-3
				Marc Lopez
84.		[WC]	Nicolas Mahut	7-5 6-1 7-6(5)
						Jiri Novak
85.			Ivan Ljubicic			6-4 7-5 3-6 6-2
				Ivan Ljubicic
86.			Karol Kucera	6-2 6-3 6-2
					Ivan Ljubicic
87.		[24]	James Blake		6-3 4-6 7-6(2) 6-4
				James Blake
88.			Taylor Dent	6-4 6-3 7-6(3)
							Carlos Moya
89.		[31]	Juan Ignacio Chela				7-5 6-3 6-2
				Juan Ignacio Chela
90.		[WC]	Cyril Saulnier	3-6 7-6(3) 6-3 7-5
					Juan Ignacio Chela
91.		[LL]	Giorgio Galimberti		6-2 5-7 6-2 6-1
				Giorgio Galimberti
92.		[LL]	Ivo Heuberger	7-6(5) 4-6 6-2 6-2
						Carlos Moya
93.			Mark Philippoussis			6-2 6-3 3-6 2-6 6-3
				Mark Philippoussis
94.		[Q]	Alex Kim	2-6 6-7(1) 7-5 6-2 6-2
					Carlos Moya
95.		[4]	Carlos Moya		6-2 6-4 7-6(7)
				Carlos Moya
96.		[LL]	Filippo Volandri	7-6(7) 4-6 6-2 6-3
									Martin Verkerk
97.		[7]	Guillermo Coria						7-6(4) 6-4 7-6(0)
				Guillermo Coria
98.			Andre Sa	6-3 6-1 6-1
					Guillermo Coria
99.			Nicolas Kiefer		6-3 5-7 6-3 6-1
				Nicolas Kiefer
100.		[Q]	Todd Larkham	6-3 6-3 4-6 2-6 6-3
						Guillermo Coria
101.		[Q]	Attila Savolt			6-4 6-1 6-1
				Attila Savolt
102.			Andreas Vinciguerra	7-5 7-6(4) 4-6 6-0
					Attila Savolt
103.		[27]	Mikhail Youzhny		3-6 6-4 5-7 6-2 6-4
				Mikhail Youzhny
104.			David Sanchez-Munoz	6-3 6-0 6-0
							Guillermo Coria
105.		[23]	Younes El Aynaoui				6-4 7-6(4) 5-7 6-7(4) 6-3
				Younes El Aynaoui
106.			Antony Dupuis	6-4 6-4 6-4
					Younes El Aynaoui
107.		[Q]	Christophe Rochus		6-4 6-4 6-3
				Christophe Rochus
108.		[Q]	Hermes Gamonal	7-5 6-3 6-3
						Mariano Zabaleta
109.			Mariano Zabaleta			6-2 6-4 3-6 7-6(2)
				Mariano Zabaleta
110.			Feliciano Lopez	6-2 7-6(8) 6-0
					Mariano Zabaleta
111.			Dominik Hrbaty		6-2 6-4 6-2
				Dominik Hrbaty
112.		[10]	Paradorn Srichaphan	6-4 3-6 6-0 7-5
								Guillermo Coria
113.		[Q]	Galo Blanco					4-6 6-3 6-2 6-4
				Galo Blanco
114.		[16]	Alex Corretja	5-7 6-3 6-0 7-5
					Galo Blanco
115.			Mariano Puerta		6-2 6-2 6-4
				Mariano Puerta
116.			Justin Gimelstob	6-2 4-6 7-6(1) 6-1
						Flavio Saretta
117.			Flavio Saretta			7-6(3) 6-2 2-2 rtd.
				Flavio Saretta
118.			Alberto Martin	7-6(4) 6-0 6-0
					Flavio Saretta
119.		[17]	Yevgeny Kafelnikov		6-4 3-6 6-0 6-7(0) 6-4
				Yevgeny Kafelnikov
120.			Julien Boutter	6-1 6-2 6-4
							Andre Agassi
121.		[26]	Xavier Malisse				6-2 6-1 7-5
				Xavier Malisse
122.		[Q]	Alex Calatrava	7-5 6-4 6-2
					Xavier Malisse
123.			Stefan Koubek		3-6 4-6 6-4 7-5 8-6
				Stefan Koubek
124.			Alexander Popp	7-5 6-2 6-3
						Andre Agassi
125.			Mario Ancic			6-4 7-5 7-5
				Mario Ancic
126.			Marcelo Rios	6-1 1-0 rtd.
					Andre Agassi
127.		[2]	Andre Agassi		5-7 1-6 6-4 6-2 7-5
				Andre Agassi
128.			Karol Beck	6-2 6-3 6-3

(default) 17 queries took 24 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	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	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` = '2003' 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` = (381) 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, 7246, 169, 5705, 5726, 6295, 5051, 8691, 6284, 3590, 7159, 6173, 6208, 6270, 6205, 4143, 6178, 7209, 59, 6255, 6181, 75, 6233, 7314, 5932, 5671, 6165, 116, 8665, 6222, 167, 120, 93, 7332, 7292, 6264, 4142, 7298, 6197, 6251, 6227, 7266, 8604, 150, 6259, 7261, 6256, 6163, 6188, 6157, 4129, 4045, 6231, 7231, 7327, 6226, 166, 6234, 7232, 5679, 135, 88, 6213, 67, 7247, 147, 7242, 7464, 6265, 6186, 6169, 7340, 4162, 6286, 83, 140, 4924, 8724, 4209, 6249, 6187, 102, 8636, 58, 172, 6168, 3578, 7348, 76, 7200, 7260, 7336, 5713, 7344, 6190, 61, 7326, 7169, 6175, 7345, 7339, 6273, 72, 7329, 5720, 6293, 6290, 8913, 6262, 171, 6230, 6276, 6212, 4191, 6257, 6218, 7250, 6223, 5702, 6275, 86, 6224, 6250, 8664, 7255, 6182, 4001, 103) 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` = 381	128	128	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (68, 53, 92, 13, 197, 154, 10, 173, 21, 168, 153, 14, 179, 67, 27, 172, 72, 178, 54, 196, 127, 58, 41, 133, 29, 11, 20, 184, 147, 50, 100, 84, 71)	33	33	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (68, 53, 92, 13, 197, 154, 10, 173, 21, 168, 153, 14, 179, 67, 27, 172, 72, 178, 54, 196, 127, 58, 41, 133, 29, 11, 20, 184, 147, 50, 100, 84, 71)	33	33	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (65, 7246, 169, 5705, 5726, 6295, 5051, 8691, 6284, 3590, 7159, 6173, 6208, 6270, 6205, 4143, 6178, 7209, 59, 6255, 6181, 75, 6233, 7314, 5932, 5671, 6165, 116, 8665, 6222, 167, 120, 93, 7332, 7292, 6264, 4142, 7298, 6197, 6251, 6227, 7266, 8604, 150, 6259, 7261, 6256, 6163, 6188, 6157, 4129, 4045, 6231, 7231, 7327, 6226, 166, 6234, 7232, 5679, 135, 88, 6213, 67, 7247, 147, 7242, 7464, 6265, 6186, 6169, 7340, 4162, 6286, 83, 140, 4924, 8724, 4209, 6249, 6187, 102, 8636, 58, 172, 6168, 3578, 7348, 76, 7200, 7260, 7336, 5713, 7344, 6190, 61, 7326, 7169, 6175, 7345, 7339, 6273, 72, 7329, 5720, 6293, 6290, 8913, 6262, 171, 6230, 6276, 6212, 4191, 6257, 6218, 7250, 6223, 5702, 6275, 86, 6224, 6250, 8664, 7255, 6182, 4001, 103)) AND (`Playercontest`.`contest_id` = 381))	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` = 2003	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 24 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` = '2003' 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` = (381) 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, 7246, 169, 5705, 5726, 6295, 5051, 8691, 6284, 3590, 7159, 6173, 6208, 6270, 6205, 4143, 6178, 7209, 59, 6255, 6181, 75, 6233, 7314, 5932, 5671, 6165, 116, 8665, 6222, 167, 120, 93, 7332, 7292, 6264, 4142, 7298, 6197, 6251, 6227, 7266, 8604, 150, 6259, 7261, 6256, 6163, 6188, 6157, 4129, 4045, 6231, 7231, 7327, 6226, 166, 6234, 7232, 5679, 135, 88, 6213, 67, 7247, 147, 7242, 7464, 6265, 6186, 6169, 7340, 4162, 6286, 83, 140, 4924, 8724, 4209, 6249, 6187, 102, 8636, 58, 172, 6168, 3578, 7348, 76, 7200, 7260, 7336, 5713, 7344, 6190, 61, 7326, 7169, 6175, 7345, 7339, 6273, 72, 7329, 5720, 6293, 6290, 8913, 6262, 171, 6230, 6276, 6212, 4191, 6257, 6218, 7250, 6223, 5702, 6275, 86, 6224, 6250, 8664, 7255, 6182, 4001, 103) 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` = 381

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (65, 7246, 169, 5705, 5726, 6295, 5051, 8691, 6284, 3590, 7159, 6173, 6208, 6270, 6205, 4143, 6178, 7209, 59, 6255, 6181, 75, 6233, 7314, 5932, 5671, 6165, 116, 8665, 6222, 167, 120, 93, 7332, 7292, 6264, 4142, 7298, 6197, 6251, 6227, 7266, 8604, 150, 6259, 7261, 6256, 6163, 6188, 6157, 4129, 4045, 6231, 7231, 7327, 6226, 166, 6234, 7232, 5679, 135, 88, 6213, 67, 7247, 147, 7242, 7464, 6265, 6186, 6169, 7340, 4162, 6286, 83, 140, 4924, 8724, 4209, 6249, 6187, 102, 8636, 58, 172, 6168, 3578, 7348, 76, 7200, 7260, 7336, 5713, 7344, 6190, 61, 7326, 7169, 6175, 7345, 7339, 6273, 72, 7329, 5720, 6293, 6290, 8913, 6262, 171, 6230, 6276, 6212, 4191, 6257, 6218, 7250, 6223, 5702, 6275, 86, 6224, 6250, 8664, 7255, 6182, 4001, 103)) AND (`Playercontest`.`contest_id` = 381))

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

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)