Roland Garros 2009 Women's Singles (May 24 - June 6)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Dinara Safina
				Dinara Safina
2.			Anne Keothavong	6-0 6-0
					Dinara Safina
3.		[Q]	Vitalia Diatchenko		6-1 6-1
				Vitalia Diatchenko
4.			Mathilde Johansson	2-6 6-2 10-8
						Dinara Safina
5.			Julie Coin			6-2 6-0
				Julie Coin
6.			Nuria Llagostera-Vives	7-5 6-2
					Anastasia Pavlyuchenkova
7.		[27]	Anastasia Pavlyuchenkova		6-2 7-6(2)
				Anastasia Pavlyuchenkova
8.			Ioana Raluca Olaru	6-3 6-2
							Dinara Safina
9.		[Q]	Polona Hercog				6-1 6-0
				Polona Hercog
10.		[23]	Alisa Kleybanova	6-2 4-6 6-1
					Aravane Rezai
11.			Aravane Rezai		3-6 6-4 6-2
				Aravane Rezai
12.			Ai Sugiyama	6-3 6-2
						Aravane Rezai
13.		[Q]	Michelle Larcher De Brito			7-6(3) 6-2
				Michelle Larcher De Brito
14.			Melanie South	0-6 7-6(5) 7-5
					Michelle Larcher De Brito
15.		[15]	Jie Zheng		6-4 6-3
				Jie Zheng
16.			Stephanie Cohen-Aloro	6-1 6-3
								Dinara Safina
17.		[9]	Victoria Azarenka					1-6 6-4 6-2
				Victoria Azarenka
18.			Roberta Vinci	6-4 6-2
					Victoria Azarenka
19.			Kristina Barrois		7-6(1) 7-5
				Kristina Barrois
20.			Maria-Emilia Salerni	3-6 6-1 6-2
						Victoria Azarenka
21.			Lucie Hradecka			5-7 7-5 6-2
				Lucie Hradecka
22.		[Q]	Yvonne Meusburger	6-1 6-2
					Carla Suarez-Navarro
23.		[22]	Carla Suarez-Navarro		6-2 6-4
				Carla Suarez-Navarro
24.			Edina Gallovits	6-1 6-4
							Victoria Azarenka
25.		[32]	Iveta Benesova				6-2 6-3
				Iveta Benesova
26.			Julia Goerges	7-5 4-1 rtd.
					Iveta Benesova
27.			Alla Kudryavtseva		6-1 6-2
				Alla Kudryavtseva
28.			Varvara Lepchenko	6-3 6-3
						Ana Ivanovic
29.			Tamarine Tanasugarn			6-0 6-2
				Tamarine Tanasugarn
30.			Camille Pin	6-3 5-7 7-5
					Ana Ivanovic
31.		[8]	Ana Ivanovic		6-1 6-2
				Ana Ivanovic
32.			Sara Errani	7-6(3) 6-3
									Dinara Safina
33.		[3]	Venus Williams						6-3 6-3
				Venus Williams
34.			Bethanie Mattek-Sands	6-1 4-6 6-2
					Venus Williams
35.			Lucie Safarova		6-7(5) 6-2 7-5
				Lucie Safarova
36.			Sabine Lisicki	6-2 1-6 6-1
						Agnes Szavay
37.			Elena Vesnina			6-0 6-4
				Elena Vesnina
38.			Severine Beltrame	6-3 6-3
					Agnes Szavay
39.		[29]	Agnes Szavay		6-2 6-0
				Agnes Szavay
40.		[Q]	Corinna Dentoni	6-3 6-4
							Dominika Cibulkova
41.		[20]	Dominika Cibulkova				6-2 6-4
				Dominika Cibulkova
42.			Alona Bondarenko	6-4 2-6 6-4
					Dominika Cibulkova
43.			Kirsten Flipkens		6-1 6-0
				Kirsten Flipkens
44.			Stephanie Foretz	6-1 4-6 6-4
						Dominika Cibulkova
45.			Gisela Dulko			6-4 6-2
				Gisela Dulko
46.			Tamira Paszek	6-1 6-3
					Gisela Dulko
47.			Anna-Lena Groenefeld		7-6(5) 0-6 6-2
				Anna-Lena Groenefeld
48.		[16]	Amelie Mauresmo	6-4 6-3
								Dominika Cibulkova
49.		[11]	Nadia Petrova					6-0 6-2
				Nadia Petrova
50.		[WC]	Lauren Embree	6-1 6-2
					Maria Sharapova
51.			Maria Sharapova		6-2 1-6 8-6
				Maria Sharapova
52.			Anastasia Yakimova	3-6 6-1 6-2
						Maria Sharapova
53.		[Q]	Arantxa Rus			1-6 6-3 6-4
				Arantxa Rus
54.		[WC]	Olivia Sanchez	6-1 6-1
					Yaroslava Shvedova
55.		[Q]	Yaroslava Shvedova		6-0 6-2
				Yaroslava Shvedova
56.		[19]	Kaia Kanepi	7-6(2) 3-6 6-2
							Maria Sharapova
57.		[25]	Na Li				6-4 0-6 6-4
				Na Li
58.			Marta Domachowska	6-4 6-2
					Na Li
59.			Timea Bacsinszky		6-1 6-4
				Timea Bacsinszky
60.		[WC]	Emilie Loit	4-6 6-4 6-1
						Na Li
61.			Akgul Amanmuradova			7-5 6-1
				Akgul Amanmuradova
62.		[WC]	Irena Pavlovic	6-3 6-4
					Olga Govortsova
63.			Olga Govortsova		6-3 6-7(3) 7-5
				Olga Govortsova
64.		[LL]	Katie O'Brien	6-1 6-1
										Svetlana Kuznetsova
65.		[5]	Jelena Jankovic							6-4 6-2
				Jelena Jankovic
66.			Petra Cetkovska	6-2 6-3
					Jelena Jankovic
67.			Magdalena Rybarikova		6-1 6-2
				Magdalena Rybarikova
68.		[WC]	Kristina Mladenovic	6-1 2-6 8-6
						Jelena Jankovic
69.			Jarmila Gajdosova			6-1 6-1
				Jarmila Gajdosova
70.		[WC]	Kinnie Laisne	6-4 6-3
					Jarmila Gajdosova
71.		[LL]	Mariana Duque-Marino		6-2 7-6(9)
				Mariana Duque-Marino
72.		[26]	Anna Chakvetadze	3-6 6-4 6-4
							Sorana Cirstea
73.		[21]	Alize Cornet				3-6 6-0 9-7
				Alize Cornet
74.			Maret Ani	6-4 7-5
					Sorana Cirstea
75.			Sorana Cirstea		6-3 6-2
				Sorana Cirstea
76.		[Q]	Carly Gullickson	6-4 6-2
						Sorana Cirstea
77.			Jill Craybas			7-6(3) 7-5
				Jill Craybas
78.			Tsvetana Pironkova	7-5 6-2
					Caroline Wozniacki
79.		[10]	Caroline Wozniacki		6-1 6-4
				Caroline Wozniacki
80.			Vera Dushevina	4-6 7-5 6-1
								Samantha Stosur
81.		[13]	Marion Bartoli					6-1 6-3
				Marion Bartoli
82.			Pauline Parmentier	3-6 6-1 6-3
					Tathiana Garbin
83.			Tathiana Garbin		6-3 7-5
				Tathiana Garbin
84.			Ayumi Morita	7-5 7-5
						Virginie Razzano
85.			Virginie Razzano			7-5 7-5
				Virginie Razzano
86.			Daniela Hantuchova	6-3 6-3
					Virginie Razzano
87.		[18]	Anabel Medina-Garrigues		6-2 6-2
				Anabel Medina-Garrigues
88.			Ekaterina Makarova	6-2 5-7 6-0
							Samantha Stosur
89.		[30]	Samantha Stosur				6-1 6-2
				Samantha Stosur
90.			Francesca Schiavone	6-4 6-2
					Samantha Stosur
91.			Yanina Wickmayer		6-3 4-6 6-4
				Yanina Wickmayer
92.			Urszula Radwanska	4-6 6-3 6-0
						Samantha Stosur
93.			Jelena Dokic			6-3 4-6 6-1
				Jelena Dokic
94.			Karolina Sprem	3-6 6-1 6-2
					Elena Dementieva
95.		[4]	Elena Dementieva		2-6 4-3 rtd.
				Elena Dementieva
96.		[Q]	Chanelle Scheepers	6-4 6-3
									Svetlana Kuznetsova
97.		[7]	Svetlana Kuznetsova						6-4 6-7(5) 6-3
				Svetlana Kuznetsova
98.		[WC]	Claire Feuerstein	6-1 6-4
					Svetlana Kuznetsova
99.			Galina Voskoboeva		6-0 6-2
				Galina Voskoboeva
100.			Sania Mirza	6-4 7-6(3)
						Svetlana Kuznetsova
101.			Melinda Czink			6-1 6-3
				Melinda Czink
102.		[Q]	Anastasija Sevastova	3-6 6-4 6-1
					Melinda Czink
103.		[28]	Sybille Bammer		4-6 6-3 10-8
				Sybille Bammer
104.			Nathalie Dechy	6-3 7-6(1)
							Svetlana Kuznetsova
105.			Kateryna Bondarenko				6-4 1-6 6-1
				Kateryna Bondarenko
106.		[17]	Patty Schnyder	6-4 6-3
					Kateryna Bondarenko
107.		[WC]	Olivia Rogowska		4-6 7-5 7-5
				Olivia Rogowska
108.			Maria Kirilenko	6-4 6-4
						Agnieszka Radwanska
109.			Mariya Koryttseva			6-2 6-4
				Mariya Koryttseva
110.			Patricia Mayr	6-1 6-1
					Agnieszka Radwanska
111.		[12]	Agnieszka Radwanska		6-1 6-4
				Agnieszka Radwanska
112.			Rossana De Los Rios	6-3 6-1
								Svetlana Kuznetsova
113.			Alexa Glatch					7-6(3) 5-7 7-5
				Alexa Glatch
114.		[14]	Flavia Pennetta	6-1 6-1
					Lourdes Dominguez-Lino
115.			Lourdes Dominguez-Lino		7-6(0) 7-5
				Lourdes Dominguez-Lino
116.			Barbora Strycova	6-1 4-6 9-7
						Aleksandra Wozniak
117.		[Q]	Petra Martic			6-2 3-6 6-3
				Petra Martic
118.			Mara Santangelo	6-4 6-2
					Aleksandra Wozniak
119.		[24]	Aleksandra Wozniak		6-3 6-3
				Aleksandra Wozniak
120.			Monica Niculescu	6-4 4-6 6-3
							Serena Williams
121.			Maria Jose Martinez-Sanchez				6-1 6-2
				Maria Jose Martinez-Sanchez
122.		[31]	Shuai Peng	1-6 6-2 6-4
					Maria Jose Martinez-Sanchez
123.			Viktoriya Kutuzova		3-6 6-3 6-3
				Viktoriya Kutuzova
124.		[Q]	Zuzana Ondraskova	6-2 6-4
						Serena Williams
125.			Virginia Ruano-Pascual			4-6 6-3 6-4
				Virginia Ruano-Pascual
126.			Nicole Vaidisova	6-4 6-3
					Serena Williams
127.		[2]	Serena Williams		6-2 6-0
				Serena Williams
128.			Klara Koukalova	6-3 6-7(5) 6-4

(default) 17 queries took 23 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` = 'women-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` = (14) ORDER BY `Contest`.`year` ASC	117	117	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` = 14 AND `Contest`.`slug` = '2009' 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` = (1300) 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 (10290, 10442, 11416, 10432, 10454, 10221, 10445, 10422, 10478, 10427, 10403, 10070, 10536, 10459, 10322, 10327, 10377, 10387, 10450, 10257, 10472, 10371, 10457, 10407, 10279, 10444, 10390, 10395, 10115, 10294, 10355, 10417, 10151, 10487, 10385, 10430, 10368, 10382, 10426, 11417, 10419, 10343, 10410, 10297, 10316, 10393, 10345, 10152, 10163, 11418, 10326, 10336, 10488, 11413, 10420, 10398, 10351, 10349, 10433, 10165, 10367, 10507, 10424, 10437, 10284, 10415, 10438, 10452, 10372, 11419, 10441, 10342, 10374, 10375, 10429, 11420, 10171, 10363, 10440, 10321, 10261, 10425, 10170, 10448, 10187, 10299, 10208, 10458, 10270, 10218, 10443, 10464, 10173, 10320, 10174, 10461, 10255, 11421, 10361, 10353, 10286, 10476, 10383, 10116, 10462, 10356, 10447, 10360, 10431, 10439, 10394, 10065, 11422, 10302, 10365, 10318, 10465, 10306, 10389, 10434, 10212, 10335, 10378, 10307, 10055, 10330, 10150, 10282) 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` = 1300	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (199, 63, 20, 179, 14, 72, 68, 53, 194, 154, 168, 153, 197, 84, 92, 13, 149, 173, 10, 43, 21, 169, 164, 196, 150, 42, 50, 86, 94, 31, 146, 133, 172, 104, 96, 184, 54, 36)	38	38	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (199, 63, 20, 179, 14, 72, 68, 53, 194, 154, 168, 153, 197, 84, 92, 13, 149, 173, 10, 43, 21, 169, 164, 196, 150, 42, 50, 86, 94, 31, 146, 133, 172, 104, 96, 184, 54, 36)	38	38	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10290, 10442, 11416, 10432, 10454, 10221, 10445, 10422, 10478, 10427, 10403, 10070, 10536, 10459, 10322, 10327, 10377, 10387, 10450, 10257, 10472, 10371, 10457, 10407, 10279, 10444, 10390, 10395, 10115, 10294, 10355, 10417, 10151, 10487, 10385, 10430, 10368, 10382, 10426, 11417, 10419, 10343, 10410, 10297, 10316, 10393, 10345, 10152, 10163, 11418, 10326, 10336, 10488, 11413, 10420, 10398, 10351, 10349, 10433, 10165, 10367, 10507, 10424, 10437, 10284, 10415, 10438, 10452, 10372, 11419, 10441, 10342, 10374, 10375, 10429, 11420, 10171, 10363, 10440, 10321, 10261, 10425, 10170, 10448, 10187, 10299, 10208, 10458, 10270, 10218, 10443, 10464, 10173, 10320, 10174, 10461, 10255, 11421, 10361, 10353, 10286, 10476, 10383, 10116, 10462, 10356, 10447, 10360, 10431, 10439, 10394, 10065, 11422, 10302, 10365, 10318, 10465, 10306, 10389, 10434, 10212, 10335, 10378, 10307, 10055, 10330, 10150, 10282)) AND (`Playercontest`.`contest_id` = 1300))	128	128	2
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 14 ORDER BY `Contest`.`date_from` ASC	117	117	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 2009	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` = 'Women' 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 23 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` = 'women-singles' LIMIT 1

117

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` = 14 AND `Contest`.`slug` = '2009' 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` = (1300) 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 (10290, 10442, 11416, 10432, 10454, 10221, 10445, 10422, 10478, 10427, 10403, 10070, 10536, 10459, 10322, 10327, 10377, 10387, 10450, 10257, 10472, 10371, 10457, 10407, 10279, 10444, 10390, 10395, 10115, 10294, 10355, 10417, 10151, 10487, 10385, 10430, 10368, 10382, 10426, 11417, 10419, 10343, 10410, 10297, 10316, 10393, 10345, 10152, 10163, 11418, 10326, 10336, 10488, 11413, 10420, 10398, 10351, 10349, 10433, 10165, 10367, 10507, 10424, 10437, 10284, 10415, 10438, 10452, 10372, 11419, 10441, 10342, 10374, 10375, 10429, 11420, 10171, 10363, 10440, 10321, 10261, 10425, 10170, 10448, 10187, 10299, 10208, 10458, 10270, 10218, 10443, 10464, 10173, 10320, 10174, 10461, 10255, 11421, 10361, 10353, 10286, 10476, 10383, 10116, 10462, 10356, 10447, 10360, 10431, 10439, 10394, 10065, 11422, 10302, 10365, 10318, 10465, 10306, 10389, 10434, 10212, 10335, 10378, 10307, 10055, 10330, 10150, 10282) 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` = 1300

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (199, 63, 20, 179, 14, 72, 68, 53, 194, 154, 168, 153, 197, 84, 92, 13, 149, 173, 10, 43, 21, 169, 164, 196, 150, 42, 50, 86, 94, 31, 146, 133, 172, 104, 96, 184, 54, 36)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (199, 63, 20, 179, 14, 72, 68, 53, 194, 154, 168, 153, 197, 84, 92, 13, 149, 173, 10, 43, 21, 169, 164, 196, 150, 42, 50, 86, 94, 31, 146, 133, 172, 104, 96, 184, 54, 36)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10290, 10442, 11416, 10432, 10454, 10221, 10445, 10422, 10478, 10427, 10403, 10070, 10536, 10459, 10322, 10327, 10377, 10387, 10450, 10257, 10472, 10371, 10457, 10407, 10279, 10444, 10390, 10395, 10115, 10294, 10355, 10417, 10151, 10487, 10385, 10430, 10368, 10382, 10426, 11417, 10419, 10343, 10410, 10297, 10316, 10393, 10345, 10152, 10163, 11418, 10326, 10336, 10488, 11413, 10420, 10398, 10351, 10349, 10433, 10165, 10367, 10507, 10424, 10437, 10284, 10415, 10438, 10452, 10372, 11419, 10441, 10342, 10374, 10375, 10429, 11420, 10171, 10363, 10440, 10321, 10261, 10425, 10170, 10448, 10187, 10299, 10208, 10458, 10270, 10218, 10443, 10464, 10173, 10320, 10174, 10461, 10255, 11421, 10361, 10353, 10286, 10476, 10383, 10116, 10462, 10356, 10447, 10360, 10431, 10439, 10394, 10065, 11422, 10302, 10365, 10318, 10465, 10306, 10389, 10434, 10212, 10335, 10378, 10307, 10055, 10330, 10150, 10282)) AND (`Playercontest`.`contest_id` = 1300))

128

SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 14 ORDER BY `Contest`.`date_from` ASC

117

SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 2009

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` = 'Women' AND `Category`.`type` = 'Singles'

SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 3, 4)