Roland Garros 2017 Women's Singles (May 28 - June 10)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.			Ekaterina Makarova
				Ekaterina Makarova
2.		[1]	Angelique Kerber	6-2 6-2
					Lesia Tsurenko
3.			Lesia Tsurenko		6-2 6-2
				Lesia Tsurenko
4.		[Q]	Kateryna Kozlova	6-4 6-0
						Jelena Ostapenko
5.			Jelena Ostapenko			6-1 6-4
				Jelena Ostapenko
6.			Louisa Chirico	4-6 6-3 6-2
					Jelena Ostapenko
7.			Monica Puig		6-3 6-2
				Monica Puig
8.		[31]	Roberta Vinci	6-3 3-6 6-2
							Jelena Ostapenko
9.		[23]	Samantha Stosur				2-6 6-2 6-4
				Samantha Stosur
10.			Kristina Kucova	7-5 6-1
					Samantha Stosur
11.			Kirsten Flipkens		6-2 7-6(6)
				Kirsten Flipkens
12.			Mandy Minella	6-3 6-3
						Samantha Stosur
13.		[Q]	Bethanie Mattek-Sands			6-2 6-2
				Bethanie Mattek-Sands
14.			Evgeniya Rodina	7-5 6-2
					Bethanie Mattek-Sands
15.		[15]	Petra Kvitova		7-6(5) 7-6(5)
				Petra Kvitova
16.			Julia Boserup	6-3 6-2
								Jelena Ostapenko
17.		[11]	Caroline Wozniacki					4-6 6-2 6-2
				Caroline Wozniacki
18.		[WC]	Jamiee Fourlis	6-4 3-6 6-2
					Caroline Wozniacki
19.		[Q]	Francoise Abanda		6-0 6-0
				Francoise Abanda
20.		[WC]	Tessah Andrianjafitrimo	6-3 6-4
						Caroline Wozniacki
21.			Catherine Bellis			6-2 2-6 6-3
				Catherine Bellis
22.		[Q]	Quirine Lemoine	6-3 3-6 6-1
					Catherine Bellis
23.		[18]	Kiki Bertens		6-3 7-6(5)
				Kiki Bertens
24.			Ajla Tomljanovic	4-6 6-1 6-1
							Caroline Wozniacki
25.		[32]	Shuai Zhang				6-1 4-6 6-2
				Shuai Zhang
26.			Donna Vekic	7-5 6-4
					Shuai Zhang
27.			Aliaksandra Sasnovich		6-2 4-6 6-3
				Aliaksandra Sasnovich
28.			Viktorija Golubic	4-6 7-5 6-3
						Svetlana Kuznetsova
29.			Oceane Dodin			7-6(5) 4-6 7-5
				Oceane Dodin
30.			Camila Giorgi	6-2 6-3
					Svetlana Kuznetsova
31.		[8]	Svetlana Kuznetsova		7-6(5) 5-7 6-3
				Svetlana Kuznetsova
32.			Christina McHale	7-5 6-4
									Jelena Ostapenko
33.		[4]	Garbine Muguruza						7-6(4) 3-6 6-3
				Garbine Muguruza
34.			Francesca Schiavone	6-2 6-4
					Garbine Muguruza
35.			Anett Kontaveit		6-7(4) 6-4 6-2
				Anett Kontaveit
36.			Monica Niculescu	7-5 6-1
						Garbine Muguruza
37.			Johanna Larsson			7-5 6-2
				Johanna Larsson
38.			Natalia Vikhlyantseva	6-4 6-4
					Yulia Putintseva
39.		[27]	Yulia Putintseva		6-3 1-6 6-3
				Yulia Putintseva
40.		[WC]	Myrtille Georges	6-3 6-0
							Kristina Mladenovic
41.			Cagla Buyukakcay				6-1 3-6 6-3
				Cagla Buyukakcay
42.		[22]	Mirjana Lucic	6-3 6-3
					Shelby Rogers
43.			Shelby Rogers		7-6(6) 6-4
				Shelby Rogers
44.			Marina Erakovic	7-6(4) 6-4
						Kristina Mladenovic
45.		[Q]	Sara Errani			7-5 4-6 8-6
				Sara Errani
46.			Misaki Doi	7-6(7) 6-1
					Kristina Mladenovic
47.		[13]	Kristina Mladenovic		6-2 6-3
				Kristina Mladenovic
48.			Jennifer Brady	3-6 6-3 9-7
								Timea Bacsinszky
49.		[10]	Venus Williams					6-4 6-4
				Venus Williams
50.			Qiang Wang	6-4 7-6(3)
					Venus Williams
51.			Kurumi Nara		6-3 6-1
				Kurumi Nara
52.		[WC]	Amanda Anisimova	3-6 7-5 6-4
						Venus Williams
53.		[Q]	Richel Hogenkamp			6-3 6-1
				Richel Hogenkamp
54.			Jelena Jankovic	6-2 7-5
					Elise Mertens
55.			Elise Mertens		6-3 6-4
				Elise Mertens
56.		[24]	Daria Gavrilova	7-6(4) 1-6 6-4
							Timea Bacsinszky
57.		[30]	Timea Bacsinszky				5-7 6-2 6-1
				Timea Bacsinszky
58.			Sara Sorribes Tormo	6-1 6-2
					Timea Bacsinszky
59.			Madison Brengle		6-0 6-2
				Madison Brengle
60.			Julia Goerges	1-6 6-3 13-11
						Timea Bacsinszky
61.		[LL]	Ons Jabeur			6-2 6-2
				Ons Jabeur
62.		[Q]	Ana Bogdan	6-3 6-4
					Ons Jabeur
63.		[6]	Dominika Cibulkova		6-4 6-3
				Dominika Cibulkova
64.			Lara Arruabarrena	6-2 6-1
										Jelena Ostapenko
65.		[5]	Elina Svitolina							4-6 6-4 6-3
				Elina Svitolina
66.			Yaroslava Shvedova	6-4 6-3
					Elina Svitolina
67.			Tsvetana Pironkova		3-6 6-3 6-2
				Tsvetana Pironkova
68.			Mona Barthel	6-0 6-4
						Elina Svitolina
69.			Magda Linette			6-4 7-5
				Magda Linette
70.		[WC]	Alize Lim	6-0 7-5
					Magda Linette
71.		[29]	Ana Konjuh		6-0 7-5
				Ana Konjuh
72.			Danka Kovinic	7-5 7-6(4)
							Elina Svitolina
73.		[17]	Anastasija Sevastova				4-6 6-3 7-5
				Anastasija Sevastova
74.			Annika Beck	6-2 6-4
					Anastasija Sevastova
75.			Eugenie Bouchard		6-3 6-0
				Eugenie Bouchard
76.			Risa Ozaki	2-6 6-3 6-2
						Petra Martic
77.		[Q]	Petra Martic			6-1 6-1
				Petra Martic
78.			Kateryna Bondarenko	6-2 7-5
					Petra Martic
79.		[12]	Madison Keys		3-6 6-3 6-1
				Madison Keys
80.			Ashleigh Barty	6-3 6-2
								Simona Halep
81.		[14]	Elena Vesnina					3-6 7-6(6) 6-0
				Elena Vesnina
82.		[Q]	Beatriz Haddad Maia	6-2 3-6 6-4
					Elena Vesnina
83.			Varvara Lepchenko		4-6 6-3 6-0
				Varvara Lepchenko
84.			Andrea Petkovic	6-4 3-6 6-3
						Carla Suarez-Navarro
85.			Sorana Cirstea			6-4 6-4
				Sorana Cirstea
86.			Shuai Peng	6-3 6-1
					Carla Suarez-Navarro
87.		[21]	Carla Suarez-Navarro		7-5 6-4
				Carla Suarez-Navarro
88.			Maria Sakkari	6-4 6-2
							Simona Halep
89.		[26]	Daria Kasatkina				6-1 6-1
				Daria Kasatkina
90.			Yanina Wickmayer	7-5 6-4
					Daria Kasatkina
91.		[Q]	Marketa Vondrousova		7-6(1) 6-4
				Marketa Vondrousova
92.		[WC]	Amandine Hesse	6-1 6-0
						Simona Halep
93.			Tatjana Maria			6-0 7-5
				Tatjana Maria
94.			Yingying Duan	6-4 6-1
					Simona Halep
95.		[3]	Simona Halep		6-4 6-3
				Simona Halep
96.			Jana Cepelova	6-2 6-3
									Simona Halep
97.			Su-Wei Hsieh						6-4 3-6 6-3
				Su-Wei Hsieh
98.		[7]	Johanna Konta	1-6 7-6(2) 6-4
					Su-Wei Hsieh
99.			Taylor Townsend		6-0 2-6 6-3
				Taylor Townsend
100.		[Q]	Miyu Kato	6-4 6-0
						Su-Wei Hsieh
101.		[WC]	Chloe Paquet			6-4 4-6 9-7
				Chloe Paquet
102.			Kristyna Pliskova	6-7(4) 6-2 6-2
					Caroline Garcia
103.		[28]	Caroline Garcia		7-5 6-4
				Caroline Garcia
104.			Nao Hibino	6-2 6-2
							Caroline Garcia
105.		[20]	Barbora Strycova				6-2 6-4
				Barbora Strycova
106.			Alison Riske	6-3 6-0
					Alize Cornet
107.			Alize Cornet		6-4 6-1
				Alize Cornet
108.			Timea Babos	6-2 6-7(5) 6-2
						Alize Cornet
109.		[Q]	Alison Van Uytvanck			6-2 6-1
				Alison Van Uytvanck
110.			Naomi Osaka	6-3 7-5
					Agnieszka Radwanska
111.		[9]	Agnieszka Radwanska		6-7(3) 6-2 6-3
				Agnieszka Radwanska
112.		[WC]	Fiona Ferro	6-1 6-1
								Karolina Pliskova
113.		[16]	Anastasia Pavlyuchenkova					7-6(3) 6-4
				Anastasia Pavlyuchenkova
114.			Patricia Maria Tig	6-1 1-0 rtd.
					Veronica Cepede Royg
115.			Veronica Cepede Royg		7-6(4) 2-6 6-4
				Veronica Cepede Royg
116.			Lucie Safarova	6-1 6-4
						Veronica Cepede Royg
117.			Mariana Duque-Marino			3-6 7-6(2) 6-3
				Mariana Duque-Marino
118.			Irina-Camelia Begu	7-6(2) 6-4
					Mariana Duque-Marino
119.			Magdalena Rybarikova		1-6 6-3 8-6
				Magdalena Rybarikova
120.		[19]	Coco Vandeweghe	6-1 6-4
							Karolina Pliskova
121.			Carina Witthoeft				2-6 6-3 6-4
				Carina Witthoeft
122.		[25]	Lauren Davis	2-6 6-3 6-3
					Carina Witthoeft
123.			Pauline Parmentier		6-4 7-6(5)
				Pauline Parmentier
124.			Irina Khromacheva	6-3 6-0
						Karolina Pliskova
125.			Ekaterina Alexandrova			7-5 6-1
				Ekaterina Alexandrova
126.			Katerina Siniakova	6-4 2-6 6-2
					Karolina Pliskova
127.		[2]	Karolina Pliskova		6-2 4-6 6-3
				Karolina Pliskova
128.			Saisai Zheng	7-5 6-2

(default) 17 queries took 25 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	3
7	SELECT `Contest`.`id`, `Contest`.`category_id`, `Contest`.`year`, `Contest`.`slug`, `Contest`.`ch`, `Contest`.`date_from`, `Contest`.`date_to`, `Contest`.`book`, `Contest`.`name_of_the_tournament`, `Contest`.`location`, `Contest`.`venue`, `Contest`.`surface`, `Contest`.`participants`, `Contest`.`prize_money`, `Contest`.`attendance`, `Contest`.`misc`, `Contest`.`final_misc`, `Contest`.`created`, `Contest`.`created_by`, `Contest`.`modified`, `Contest`.`modified_by`, `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` LEFT JOIN `zavoihu1_db4tennis`.`categories` AS `Category` ON (`Contest`.`category_id` = `Category`.`id`) WHERE `Category`.`tournament_id` = 2 AND `Contest`.`category_id` = 14 AND `Contest`.`slug` = '2017' 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` = (2252) 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 (10458, 10413, 10498, 14155, 14137, 14131, 11447, 10387, 10270, 10468, 10410, 10518, 10487, 10485, 10446, 14202, 10440, 14321, 13883, 14189, 13876, 14362, 10535, 11480, 10503, 10525, 13878, 14180, 14095, 10537, 10255, 10453, 10527, 10218, 13623, 10434, 10500, 14286, 10526, 14193, 14191, 10149, 11448, 10435, 10417, 10538, 10452, 14310, 10151, 13875, 11426, 14296, 14098, 10284, 14232, 10540, 10433, 14192, 10400, 10444, 13877, 14231, 10419, 10541, 10534, 10420, 10363, 10511, 14133, 13601, 13571, 13609, 10476, 11456, 11460, 14329, 10465, 10462, 10521, 10505, 10368, 14280, 10395, 10428, 10429, 10335, 10457, 14159, 14168, 10443, 14304, 13603, 11451, 13534, 10496, 10528, 10414, 11479, 13604, 14364, 14323, 10532, 10494, 14179, 10318, 10489, 10374, 10531, 13570, 14183, 10394, 13602, 10445, 14203, 14132, 10385, 10441, 10522, 10438, 10480, 11475, 10499, 10425, 14344, 14204, 13575, 10523, 13882) 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` = 2252	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (96, 151, 53, 31, 149, 197, 154, 168, 72, 42, 68, 94, 104, 153, 173, 74, 20, 92, 13, 194, 21, 50, 54, 111, 241, 133, 178, 126, 63, 196, 164, 189, 181, 29, 179, 135, 43, 146, 190, 36, 84)	41	41	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (96, 151, 53, 31, 149, 197, 154, 168, 72, 42, 68, 94, 104, 153, 173, 74, 20, 92, 13, 194, 21, 50, 54, 111, 241, 133, 178, 126, 63, 196, 164, 189, 181, 29, 179, 135, 43, 146, 190, 36, 84)	41	41	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10458, 10413, 10498, 14155, 14137, 14131, 11447, 10387, 10270, 10468, 10410, 10518, 10487, 10485, 10446, 14202, 10440, 14321, 13883, 14189, 13876, 14362, 10535, 11480, 10503, 10525, 13878, 14180, 14095, 10537, 10255, 10453, 10527, 10218, 13623, 10434, 10500, 14286, 10526, 14193, 14191, 10149, 11448, 10435, 10417, 10538, 10452, 14310, 10151, 13875, 11426, 14296, 14098, 10284, 14232, 10540, 10433, 14192, 10400, 10444, 13877, 14231, 10419, 10541, 10534, 10420, 10363, 10511, 14133, 13601, 13571, 13609, 10476, 11456, 11460, 14329, 10465, 10462, 10521, 10505, 10368, 14280, 10395, 10428, 10429, 10335, 10457, 14159, 14168, 10443, 14304, 13603, 11451, 13534, 10496, 10528, 10414, 11479, 13604, 14364, 14323, 10532, 10494, 14179, 10318, 10489, 10374, 10531, 13570, 14183, 10394, 13602, 10445, 14203, 14132, 10385, 10441, 10522, 10438, 10480, 11475, 10499, 10425, 14344, 14204, 13575, 10523, 13882)) AND (`Playercontest`.`contest_id` = 2252))	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` = 2017	10	10	2
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (1, 3, 12, 17, 14, 19, 22, 24, 4, 2) 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 25 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` = '2017' 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` = (2252) 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 (10458, 10413, 10498, 14155, 14137, 14131, 11447, 10387, 10270, 10468, 10410, 10518, 10487, 10485, 10446, 14202, 10440, 14321, 13883, 14189, 13876, 14362, 10535, 11480, 10503, 10525, 13878, 14180, 14095, 10537, 10255, 10453, 10527, 10218, 13623, 10434, 10500, 14286, 10526, 14193, 14191, 10149, 11448, 10435, 10417, 10538, 10452, 14310, 10151, 13875, 11426, 14296, 14098, 10284, 14232, 10540, 10433, 14192, 10400, 10444, 13877, 14231, 10419, 10541, 10534, 10420, 10363, 10511, 14133, 13601, 13571, 13609, 10476, 11456, 11460, 14329, 10465, 10462, 10521, 10505, 10368, 14280, 10395, 10428, 10429, 10335, 10457, 14159, 14168, 10443, 14304, 13603, 11451, 13534, 10496, 10528, 10414, 11479, 13604, 14364, 14323, 10532, 10494, 14179, 10318, 10489, 10374, 10531, 13570, 14183, 10394, 13602, 10445, 14203, 14132, 10385, 10441, 10522, 10438, 10480, 11475, 10499, 10425, 14344, 14204, 13575, 10523, 13882) 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` = 2252

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (96, 151, 53, 31, 149, 197, 154, 168, 72, 42, 68, 94, 104, 153, 173, 74, 20, 92, 13, 194, 21, 50, 54, 111, 241, 133, 178, 126, 63, 196, 164, 189, 181, 29, 179, 135, 43, 146, 190, 36, 84)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (96, 151, 53, 31, 149, 197, 154, 168, 72, 42, 68, 94, 104, 153, 173, 74, 20, 92, 13, 194, 21, 50, 54, 111, 241, 133, 178, 126, 63, 196, 164, 189, 181, 29, 179, 135, 43, 146, 190, 36, 84)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10458, 10413, 10498, 14155, 14137, 14131, 11447, 10387, 10270, 10468, 10410, 10518, 10487, 10485, 10446, 14202, 10440, 14321, 13883, 14189, 13876, 14362, 10535, 11480, 10503, 10525, 13878, 14180, 14095, 10537, 10255, 10453, 10527, 10218, 13623, 10434, 10500, 14286, 10526, 14193, 14191, 10149, 11448, 10435, 10417, 10538, 10452, 14310, 10151, 13875, 11426, 14296, 14098, 10284, 14232, 10540, 10433, 14192, 10400, 10444, 13877, 14231, 10419, 10541, 10534, 10420, 10363, 10511, 14133, 13601, 13571, 13609, 10476, 11456, 11460, 14329, 10465, 10462, 10521, 10505, 10368, 14280, 10395, 10428, 10429, 10335, 10457, 14159, 14168, 10443, 14304, 13603, 11451, 13534, 10496, 10528, 10414, 11479, 13604, 14364, 14323, 10532, 10494, 14179, 10318, 10489, 10374, 10531, 13570, 14183, 10394, 13602, 10445, 14203, 14132, 10385, 10441, 10522, 10438, 10480, 11475, 10499, 10425, 14344, 14204, 13575, 10523, 13882)) AND (`Playercontest`.`contest_id` = 2252))

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

SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (1, 3, 12, 17, 14, 19, 22, 24, 4, 2) 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)