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

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Roger Federer
				Roger Federer
2.			Sam Querrey	6-4 6-4 6-3
					Roger Federer
3.			Albert Montanes		6-7(5) 6-1 6-0 6-4
				Albert Montanes
4.			Kristof Vliegen	7-6(5) 7-6(2) 7-6(3)
						Roger Federer
5.		[Q]	David Marrero			6-3 6-4 6-2
				David Marrero
6.		[Q]	Victor Crivoi	6-3 6-3 5-7 6-4
					Mario Ancic
7.			Mario Ancic		4-6 6-0 6-3 6-2
				Mario Ancic
8.		[31]	Andreas Seppi	6-2 7-6(1) 6-2
							Roger Federer
9.			Alejandro Falla				6-4 7-5 7-5
				Alejandro Falla
10.		[20]	Ivo Karlovic	3-6 7-6(4) 7-6(6) 5-7 6-4
					Julien Benneteau
11.			Julien Benneteau		1-6 7-6(6) 6-3 6-7(4) 6-0
				Julien Benneteau
12.			Vince Spadea	6-4 6-4 3-6 3-6 6-3
						Julien Benneteau
13.		[Q]	Paul Capdeville			1-6 7-6(6) 6-0 6-1
				Paul Capdeville
14.			Mischa Zverev	6-1 6-4 6-2
					Robin Soderling
15.			Robin Soderling		6-3 6-2 6-4
				Robin Soderling
16.		[13]	Juan Monaco	6-2 6-3 6-1
								Roger Federer
17.		[9]	Stan Wawrinka					2-6 6-2 6-3 6-4
				Stan Wawrinka
18.			Philipp Kohlschreiber	6-3 6-4 6-3
					Stan Wawrinka
19.			Marin Cilic		7-6(3) 7-6(4) 6-1
				Marin Cilic
20.			Robin Haase	7-6(6) 6-2 7-6(4)
						Fernando Gonzalez
21.		[LL]	Pablo Andujar			5-7 2-6 6-4 6-4 6-4
				Pablo Andujar
22.			Filippo Volandri	6-7(6) 6-2 6-3 6-3
					Fernando Gonzalez
23.		[24]	Fernando Gonzalez		7-5 6-0 6-7(4) 7-6(3)
				Fernando Gonzalez
24.			Pablo Cuevas	6-3 6-3 6-1
							Fernando Gonzalez
25.		[27]	Igor Andreev				7-6(4) 6-3 6-1
				Igor Andreev
26.			Potito Starace	6-1 6-7(3) 6-1 6-4
					Robby Ginepri
27.			Robby Ginepri		4-6 6-2 7-6(5) 6-2
				Robby Ginepri
28.			Donald Young	6-2 3-6 7-6(4) 6-2
						Robby Ginepri
29.			Victor Hanescu			6-4 6-4 6-4
				Victor Hanescu
30.			Dudi Sela	4-6 6-2 4-6 6-4 6-3
					Florent Serra
31.			Florent Serra		6-4 6-3 6-7(5) 7-6(5)
				Florent Serra
32.		[LL]	Santiago Giraldo	6-4 6-3 6-2
									Roger Federer
33.		[4]	Nikolay Davydenko						6-2 5-7 6-3 7-5
				Nikolay Davydenko
34.			Thomas Johansson	6-3 6-3 6-3
					Nikolay Davydenko
35.			Marat Safin		7-6(4) 6-2 6-2
				Marat Safin
36.		[Q]	Jean-Rene Lisnard	6-7(5) 6-1 6-3 6-2
						Ivan Ljubicic
37.		[Q]	Diego Junqueira			4-6 2-6 6-3 6-2 6-4
				Diego Junqueira
38.		[WC]	Adrian Mannarino	6-1 6-2 6-2
					Ivan Ljubicic
39.		[28]	Ivan Ljubicic		6-3 6-4 6-2
				Ivan Ljubicic
40.		[WC]	Eric Prodon	7-5 7-6(6) 7-6(4)
							Gael Monfils
41.			Marcos Daniel				7-6(1) 4-6 6-3 6-2
				Marcos Daniel
42.		[23]	Juan Carlos Ferrero	6-7(5) 2-2 rtd.
					Jurgen Melzer
43.			Jurgen Melzer		4-6 6-3 2-6 6-3 6-4
				Jurgen Melzer
44.			Peter Luczak	6-3 6-2 6-4
						Gael Monfils
45.			Gael Monfils			4-6 7-5 4-6 6-0 6-2
				Gael Monfils
46.			Arnaud Clement	7-5 6-3 6-1
					Gael Monfils
47.			Luis Horna		7-6(5) 6-4 7-5
				Luis Horna
48.		[Q]	Scoville Jenkins	6-4 5-7 6-3 6-0
								Gael Monfils
49.		[12]	Tommy Robredo					6-3 3-6 6-3 6-1
				Tommy Robredo
50.			Guillermo Coria	5-7 6-4 6-1 6-4
					Tommy Robredo
51.			Marc Gicquel		6-7(7) 6-4 6-4 6-4
				Marc Gicquel
52.			Viktor Troicki	6-4 6-3 4-6 7-5
						Radek Stepanek
53.			Jiri Vanek			6-3 6-2 6-1
				Jiri Vanek
54.		[Q]	Jesse Huta Galung	6-3 7-5 6-2
					Radek Stepanek
55.		[21]	Radek Stepanek		6-1 6-0 6-7(7) 6-3
				Radek Stepanek
56.			Gilles Simon	6-2 6-4 6-1
							David Ferrer
57.		[25]	Lleyton Hewitt				4-6 6-2 1-6 6-3 6-3
				Lleyton Hewitt
58.			Nicolas Mahut	6-4 6-2 6-4
					Lleyton Hewitt
59.			Mardy Fish		6-4 6-3 6-2
				Mardy Fish
60.			Agustin Calleri	6-7(6) 6-4 6-2 6-4
						David Ferrer
61.			Fabrice Santoro			6-2 3-6 3-6 6-3 6-4
				Fabrice Santoro
62.		[LL]	Evgeny Korolev	7-6(3) 6-1 6-4
					David Ferrer
63.		[5]	David Ferrer		6-0 6-1 6-0
				David Ferrer
64.			Steve Darcis	6-3 6-4 6-3
										Rafael Nadal
65.		[7]	James Blake							6-1 6-3 6-0
				James Blake
66.			Rainer Schuettler	6-4 6-1 7-6(3)
					Ernests Gulbis
67.			Ernests Gulbis		7-6(2) 3-6 7-5 6-3
				Ernests Gulbis
68.		[Q]	Simon Greul	6-4 6-0 6-4
						Ernests Gulbis
69.			Bobby Reynolds			6-3 7-5 6-2
				Bobby Reynolds
70.			Thierry Ascione	7-6(2) 4-6 6-3 6-2
					Nicolas Lapentti
71.			Nicolas Lapentti		7-5 6-4 5-7 7-5
				Nicolas Lapentti
72.		[32]	Janko Tipsarevic	6-4 4-6 6-1 7-6(7)
							Ernests Gulbis
73.			Simone Bolelli				6-4 7-6(4) 6-3
				Simone Bolelli
74.		[17]	Marcos Baghdatis	6-2 6-4 6-2
					Simone Bolelli
75.			Juan Martin Del Potro		3-6 7-6(0) 7-5 6-2
				Juan Martin Del Potro
76.		[LL]	Josselin Ouanna	6-3 6-2 6-3
						Michael Llodra
77.			Michael Llodra			7-6(2) 6-4 7-6(5)
				Michael Llodra
78.		[WC]	Olivier Patience	3-6 7-6(1) 6-3 7-5
					Michael Llodra
79.		[11]	Tomas Berdych		6-3 4-6 5-7 6-3 6-4
				Tomas Berdych
80.		[WC]	Robert Smeets	6-1 6-0 6-0
								Novak Djokovic
81.		[Q]	Eduardo Schwank					7-5 7-6(3) 7-5
				Eduardo Schwank
82.		[16]	Carlos Moya	7-6(4) 6-2 6-7(1) 4-6 6-3
					Eduardo Schwank
83.			Marcel Granollers		6-7(5) 6-2 6-4 6-4
				Marcel Granollers
84.			Michael Berrer	6-3 3-6 6-2 6-3
						Paul-Henri Mathieu
85.			Oscar Hernandez			6-2 6-3 3-6 7-6(9)
				Oscar Hernandez
86.			Ivo Minar	4-6 7-6(5) 6-3 7-5
					Paul-Henri Mathieu
87.		[18]	Paul-Henri Mathieu		2-6 1-6 6-4 6-3 6-2
				Paul-Henri Mathieu
88.		[WC]	Gustavo Kuerten	6-3 6-4 6-2
							Novak Djokovic
89.		[WC]	Wayne Odesnik				6-4 6-3 6-4
				Wayne Odesnik
90.		[29]	Guillermo Canas	7-6(6) 7-6(3) 7-6(8)
					Wayne Odesnik
91.			Hyung-Taik Lee		6-2 4-6 6-3 6-2
				Hyung-Taik Lee
92.			Jonas Bjorkman	6-4 6-4 6-3
						Novak Djokovic
93.		[Q]	Miguel Lopez			7-5 6-4 6-2
				Miguel Lopez
94.			Frank Dancevic	7-6(6) 3-6 7-5 7-6(2)
					Novak Djokovic
95.		[3]	Novak Djokovic		6-1 6-1 6-3
				Novak Djokovic
96.			Denis Gremelmayr	4-6 6-3 7-5 6-2
									Rafael Nadal
97.		[6]	David Nalbandian						6-4 6-2 7-6(3)
				David Nalbandian
98.			Carlos Berlocq	6-2 6-4 6-1
					Jeremy Chardy
99.		[WC]	Jeremy Chardy		3-6 4-6 6-2 6-1 6-2
				Jeremy Chardy
100.		[Q]	Frederico Gil	6-3 6-2 7-6(1)
						Jeremy Chardy
101.			Guillermo Garcia-Lopez			7-6(1) 6-3 6-4
				Guillermo Garcia-Lopez
102.			Sergio Roitman	6-2 6-4 7-6(5)
					Dmitry Tursunov
103.		[30]	Dmitry Tursunov		7-6(4) 6-0 6-0
				Dmitry Tursunov
104.		[Q]	Daniel Brands	6-2 6-4 7-5
							Nicolas Almagro
105.		[19]	Nicolas Almagro				7-6(0) 7-6(7) 7-5
				Nicolas Almagro
106.			Boris Pashanski	6-4 7-5 6-1
					Nicolas Almagro
107.		[LL]	Sebastian Decoud		7-6(2) 6-2 6-1
				Sebastian Decoud
108.			Olivier Rochus	3-6 6-4 6-3 6-7(8) 6-1
						Nicolas Almagro
109.			Jose Acasuso			6-3 6-7(3) 6-3 7-5
				Jose Acasuso
110.			Dominik Hrbaty	6-4 6-2 6-4
					Andy Murray
111.		[10]	Andy Murray		6-4 6-0 6-4
				Andy Murray
112.		[WC]	Jonathan Eysseric	6-2 1-6 4-6 6-0 6-2
								Rafael Nadal
113.		[15]	Mikhail Youzhny					6-1 6-1 6-1
				Mikhail Youzhny
114.			Benjamin Becker	6-1 6-3 7-6(4)
					Mikhail Youzhny
115.		[Q]	Maximo Gonzalez		6-3 6-2 6-2
				Maximo Gonzalez
116.		[Q]	Roko Karanusic	6-3 7-5 4-6 3-6 6-2
						Fernando Verdasco
117.			Juan Ignacio Chela			7-6(5) 5-7 7-5 6-1
				Juan Ignacio Chela
118.			John Isner	2-6 3-6 7-5 6-3 6-4
					Fernando Verdasco
119.		[22]	Fernando Verdasco		7-5 4-6 6-3 7-5
				Fernando Verdasco
120.			Santiago Ventura	4-6 6-3 6-4 6-7(6) 6-1
							Rafael Nadal
121.		[26]	Jarkko Nieminen				6-1 6-0 6-2
				Jarkko Nieminen
122.		[LL]	Marc Lopez	2-6 6-3 6-4 6-3
					Jarkko Nieminen
123.			Martin Arguello		7-5 6-1 3-6 7-6(2)
				Martin Arguello
124.			Feliciano Lopez	7-6(1) 6-4 3-6 4-6 6-3
						Rafael Nadal
125.		[Q]	Nicolas Devilder			6-1 6-3 6-1
				Nicolas Devilder
126.			Chris Guccione	6-4 6-1 6-4
					Rafael Nadal
127.		[2]	Rafael Nadal		6-4 6-0 6-1
				Rafael Nadal
128.		[Q]	Thomaz Bellucci	7-5 6-3 6-1

(default) 17 queries took 35 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	19
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` = '2008' 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` = (386) 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 (147, 137, 120, 7241, 8628, 8672, 7255, 74, 118, 141, 102, 6169, 7312, 7301, 7248, 123, 156, 122, 3722, 66, 79, 61, 7327, 5934, 3591, 57, 4776, 175, 135, 97, 126, 54, 169, 5723, 6260, 4924, 4777, 130, 172, 144, 7467, 93, 140, 4210, 99, 5932, 7247, 8605, 5051, 7326, 4926, 92, 6281, 143, 59, 100, 65, 58, 116, 7314, 4129, 7323, 83, 127, 3578, 4209, 89, 5052, 4927, 7231, 6181, 68, 3585, 158, 131, 7278, 88, 7233, 148, 7758, 5933, 6190, 108, 4212, 7310, 7299, 3590, 6205, 3718, 6254, 7266, 5726, 8915, 4771, 52, 7770, 167, 142, 160, 110, 94, 7209, 69, 4929, 163, 7275, 8916, 150, 7298, 6230, 84, 7293, 72, 159, 4208, 7469, 76, 164, 139, 7307, 166, 8636, 7295, 171, 7271, 7308, 179, 96) 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` = 386	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 43, 92, 68, 53, 13, 133, 154, 10, 173, 196, 104, 29, 91, 150, 197, 72, 21, 153, 14, 50, 179, 52, 67, 27, 36, 124, 178, 198, 58, 168, 147, 100, 41, 96)	35	35	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 43, 92, 68, 53, 13, 133, 154, 10, 173, 196, 104, 29, 91, 150, 197, 72, 21, 153, 14, 50, 179, 52, 67, 27, 36, 124, 178, 198, 58, 168, 147, 100, 41, 96)	35	35	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (147, 137, 120, 7241, 8628, 8672, 7255, 74, 118, 141, 102, 6169, 7312, 7301, 7248, 123, 156, 122, 3722, 66, 79, 61, 7327, 5934, 3591, 57, 4776, 175, 135, 97, 126, 54, 169, 5723, 6260, 4924, 4777, 130, 172, 144, 7467, 93, 140, 4210, 99, 5932, 7247, 8605, 5051, 7326, 4926, 92, 6281, 143, 59, 100, 65, 58, 116, 7314, 4129, 7323, 83, 127, 3578, 4209, 89, 5052, 4927, 7231, 6181, 68, 3585, 158, 131, 7278, 88, 7233, 148, 7758, 5933, 6190, 108, 4212, 7310, 7299, 3590, 6205, 3718, 6254, 7266, 5726, 8915, 4771, 52, 7770, 167, 142, 160, 110, 94, 7209, 69, 4929, 163, 7275, 8916, 150, 7298, 6230, 84, 7293, 72, 159, 4208, 7469, 76, 164, 139, 7307, 166, 8636, 7295, 171, 7271, 7308, 179, 96)) AND (`Playercontest`.`contest_id` = 386))	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` = 2008	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 35 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` = '2008' 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` = (386) 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 (147, 137, 120, 7241, 8628, 8672, 7255, 74, 118, 141, 102, 6169, 7312, 7301, 7248, 123, 156, 122, 3722, 66, 79, 61, 7327, 5934, 3591, 57, 4776, 175, 135, 97, 126, 54, 169, 5723, 6260, 4924, 4777, 130, 172, 144, 7467, 93, 140, 4210, 99, 5932, 7247, 8605, 5051, 7326, 4926, 92, 6281, 143, 59, 100, 65, 58, 116, 7314, 4129, 7323, 83, 127, 3578, 4209, 89, 5052, 4927, 7231, 6181, 68, 3585, 158, 131, 7278, 88, 7233, 148, 7758, 5933, 6190, 108, 4212, 7310, 7299, 3590, 6205, 3718, 6254, 7266, 5726, 8915, 4771, 52, 7770, 167, 142, 160, 110, 94, 7209, 69, 4929, 163, 7275, 8916, 150, 7298, 6230, 84, 7293, 72, 159, 4208, 7469, 76, 164, 139, 7307, 166, 8636, 7295, 171, 7271, 7308, 179, 96) 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` = 386

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 43, 92, 68, 53, 13, 133, 154, 10, 173, 196, 104, 29, 91, 150, 197, 72, 21, 153, 14, 50, 179, 52, 67, 27, 36, 124, 178, 198, 58, 168, 147, 100, 41, 96)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (164, 43, 92, 68, 53, 13, 133, 154, 10, 173, 196, 104, 29, 91, 150, 197, 72, 21, 153, 14, 50, 179, 52, 67, 27, 36, 124, 178, 198, 58, 168, 147, 100, 41, 96)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (147, 137, 120, 7241, 8628, 8672, 7255, 74, 118, 141, 102, 6169, 7312, 7301, 7248, 123, 156, 122, 3722, 66, 79, 61, 7327, 5934, 3591, 57, 4776, 175, 135, 97, 126, 54, 169, 5723, 6260, 4924, 4777, 130, 172, 144, 7467, 93, 140, 4210, 99, 5932, 7247, 8605, 5051, 7326, 4926, 92, 6281, 143, 59, 100, 65, 58, 116, 7314, 4129, 7323, 83, 127, 3578, 4209, 89, 5052, 4927, 7231, 6181, 68, 3585, 158, 131, 7278, 88, 7233, 148, 7758, 5933, 6190, 108, 4212, 7310, 7299, 3590, 6205, 3718, 6254, 7266, 5726, 8915, 4771, 52, 7770, 167, 142, 160, 110, 94, 7209, 69, 4929, 163, 7275, 8916, 150, 7298, 6230, 84, 7293, 72, 159, 4208, 7469, 76, 164, 139, 7307, 166, 8636, 7295, 171, 7271, 7308, 179, 96)) AND (`Playercontest`.`contest_id` = 386))

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

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)