Roland Garros 2019 Women's Singles (May 26 - June 9)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Naomi Osaka
				Naomi Osaka
2.			Anna Schmiedlova	0-6 7-6(4) 6-1
					Naomi Osaka
3.			Victoria Azarenka		4-6 7-5 6-3
				Victoria Azarenka
4.			Jelena Ostapenko	6-4 7-6(4)
						Katerina Siniakova
5.			Katerina Siniakova			6-4 6-2
				Katerina Siniakova
6.		[Q]	Elena Rybakina	7-6(5) 6-1
					Katerina Siniakova
7.		[29]	Maria Sakkari		7-6(5) 6-7(8) 6-3
				Maria Sakkari
8.			Anna Tatishvili	6-0 6-1
							Madison Keys
9.		[24]	Caroline Garcia				6-2 6-4
				Caroline Garcia
10.			Mona Barthel	6-2 6-4
					Anna Blinkova
11.		[Q]	Anna Blinkova		1-6 6-4 6-4
				Anna Blinkova
12.			Margarita Gasparyan	6-3 4-6 8-6
						Madison Keys
13.		[WC]	Priscilla Hon			6-3 6-7(5) 6-4
				Priscilla Hon
14.		[LL]	Timea Babos	3-6 6-2 6-1
					Madison Keys
15.		[14]	Madison Keys		7-5 5-7 6-3
				Madison Keys
16.			Evgeniya Rodina	6-1 6-2
								Ashleigh Barty
17.		[10]	Serena Williams					6-3 7-5
				Serena Williams
18.			Vitalia Diatchenko	2-6 6-1 6-0
					Serena Williams
19.		[Q]	Kurumi Nara		6-3 6-2
				Kurumi Nara
20.			Dalila Jakupovic	7-5 5-7 6-3
						Sofia Kenin
21.			Sofia Kenin			6-2 7-5
				Sofia Kenin
22.			Giulia Gatto-Montice	6-3 5-7 6-2
					Sofia Kenin
23.		[22]	Bianca Andreescu		w/o
				Bianca Andreescu
24.		[LL]	Marie Bouzkova	5-7 6-4 6-4
							Ashleigh Barty
25.		[25]	Su-Wei Hsieh				6-3 3-6 6-0
				Su-Wei Hsieh
26.			Viktorija Golubic	6-4 3-6 6-0
					Andrea Petkovic
27.			Andrea Petkovic		4-6 6-3 8-6
				Andrea Petkovic
28.			Alison Riske	2-6 6-3 7-5
						Ashleigh Barty
29.			Danielle Collins			6-3 6-1
				Danielle Collins
30.			Tatjana Maria	6-0 6-2
					Ashleigh Barty
31.		[8]	Ashleigh Barty		7-5 6-1
				Ashleigh Barty
32.			Jessica Pegula	6-3 6-3
									Ashleigh Barty
33.		[3]	Simona Halep						6-7(4) 6-3 6-3
				Simona Halep
34.			Ajla Tomljanovic	6-2 3-6 6-1
					Simona Halep
35.			Magda Linette		6-4 5-7 6-3
				Magda Linette
36.		[WC]	Chloe Paquet	3-6 6-1 6-2
						Simona Halep
37.			Aleksandra Krunic			6-2 6-1
				Aleksandra Krunic
38.			Daria Gavrilova	6-3 2-2 rtd.
					Lesia Tsurenko
39.		[27]	Lesia Tsurenko		5-7 7-5 11-9
				Lesia Tsurenko
40.			Eugenie Bouchard	6-2 6-2
							Simona Halep
41.		[21]	Daria Kasatkina				6-1 6-0
				Daria Kasatkina
42.		[Q]	Jasmine Paolini	6-2 6-3
					Monica Puig
43.			Monica Puig		6-3 6-1
				Monica Puig
44.			Kirsten Flipkens	6-1 7-5
						Iga Swiatek
45.			Iga Swiatek			0-6 6-3 6-3
				Iga Swiatek
46.		[WC]	Selena Janicijevic	6-3 6-0
					Iga Swiatek
47.		[16]	Qiang Wang		6-3 6-0
				Qiang Wang
48.			Saisai Zheng	6-1 7-5
								Amanda Anisimova
49.		[11]	Aryna Sabalenka					6-2 6-4
				Aryna Sabalenka
50.			Dominika Cibulkova	7-5 6-1
					Amanda Anisimova
51.			Amanda Anisimova		6-4 6-2
				Amanda Anisimova
52.		[WC]	Harmony Tan	6-3 6-1
						Amanda Anisimova
53.			Irina-Camelia Begu			7-6(6) 6-4
				Irina-Camelia Begu
54.			Lin Zhu	6-1 6-1
					Irina-Camelia Begu
55.			Karolina Muchova		1-6 6-3 6-4
				Karolina Muchova
56.		[17]	Anett Kontaveit	3-6 6-2 6-2
							Amanda Anisimova
57.			Ekaterina Alexandrova				6-3 6-0
				Ekaterina Alexandrova
58.			Mihaela Buzarnescu	6-4 6-4
					Ekaterina Alexandrova
59.			Samantha Stosur		3-6 6-1 6-4
				Samantha Stosur
60.			Barbora Strycova	6-2 7-6(3)
						Aliona Bolsova
61.		[Q]	Aliona Bolsova			6-2 7-5
				Aliona Bolsova
62.			Vera Zvonareva	6-4 6-2
					Aliona Bolsova
63.			Sorana Cirstea		7-6(5) 7-6(3)
				Sorana Cirstea
64.		[LL]	Kaja Juvan	5-7 6-4 7-5
										Ashleigh Barty
65.		[7]	Sloane Stephens							6-1 6-3
				Sloane Stephens
66.			Misaki Doi	6-3 7-6(4)
					Sloane Stephens
67.			Sara Sorribes Tormo		6-1 7-6(3)
				Sara Sorribes Tormo
68.			Alison Van Uytvanck	6-1 5-7 6-2
						Sloane Stephens
69.			Jennifer Brady			6-3 5-7 6-4
				Jennifer Brady
70.			Ivana Jorovic	7-6(5) 4-6 7-5
					Polona Hercog
71.			Polona Hercog		6-3 6-7(8) 6-4
				Polona Hercog
72.		[32]	Aliaksandra Sasnovich	4-6 6-2 8-6
							Sloane Stephens
73.		[19]	Garbine Muguruza				6-4 6-3
				Garbine Muguruza
74.			Taylor Townsend	5-7 6-2 6-2
					Garbine Muguruza
75.			Johanna Larsson		6-4 6-1
				Johanna Larsson
76.			Magdalena Rybarikova	6-3 6-4
						Garbine Muguruza
77.			Kateryna Kozlova			6-3 6-3
				Kateryna Kozlova
78.		[Q]	Bernarda Pera	6-2 7-6(5)
					Elina Svitolina
79.		[9]	Elina Svitolina		w/o
				Elina Svitolina
80.			Venus Williams	6-3 6-3
								Johanna Konta
81.		[15]	Belinda Bencic					6-1 6-4
				Belinda Bencic
82.		[WC]	Jessika Ponchet	6-1 6-4
					Belinda Bencic
83.			Laura Siegemund		4-6 6-4 6-4
				Laura Siegemund
84.		[Q]	Sofya Zhuk	6-3 6-3
						Donna Vekic
85.			Rebecca Peterson			6-4 6-1
				Rebecca Peterson
86.			Yulia Putintseva	6-3 7-5
					Donna Vekic
87.		[23]	Donna Vekic		1-6 6-1 6-2
				Donna Vekic
88.		[Q]	Ludmilla Samsonova	6-2 6-4
							Johanna Konta
89.		[26]	Johanna Konta				6-2 6-4
				Johanna Konta
90.		[Q]	Antonia Lottner	6-4 6-4
					Johanna Konta
91.		[WC]	Lauren Davis		6-3 1-6 6-3
				Lauren Davis
92.			Kristyna Pliskova	6-2 6-4
						Johanna Konta
93.			Viktoria Kuzmova			6-2 6-1
				Viktoria Kuzmova
94.			Alize Cornet	6-4 6-3
					Viktoria Kuzmova
95.		[4]	Kiki Bertens		3-1 rtd.
				Kiki Bertens
96.			Pauline Parmentier	6-3 6-4
									Marketa Vondrousova
97.			Anastasia Potapova						7-5 7-6(2)
				Anastasia Potapova
98.		[5]	Angelique Kerber	6-4 6-2
					Marketa Vondrousova
99.			Marketa Vondrousova		6-4 6-0
				Marketa Vondrousova
100.			Yafan Wang	6-4 6-3
						Marketa Vondrousova
101.			Shelby Rogers			6-4 6-4
				Shelby Rogers
102.			Astra Sharma	6-3 6-3
					Carla Suarez-Navarro
103.			Carla Suarez-Navarro		6-1 6-7(4) 6-3
				Carla Suarez-Navarro
104.			Dayana Yastremska	2-6 7-6(7) 6-0
							Marketa Vondrousova
105.		[20]	Elise Mertens				6-2 6-0
				Elise Mertens
106.			Tamara Zidansek	6-4 3-6 6-1
					Elise Mertens
107.		[WC]	Diane Parry		6-1 6-3
				Diane Parry
108.			Vera Lapko	6-2 6-4
						Anastasija Sevastova
109.			Mandy Minella			6-7(3) 6-4 11-9
				Mandy Minella
110.			Anastasia Pavlyuchenkova	6-4 6-2
					Mandy Minella
111.		[12]	Anastasija Sevastova		6-2 6-4
				Anastasija Sevastova
112.			Luksika Kumkhum	6-1 6-4
								Marketa Vondrousova
113.			Veronika Kudermetova					7-6(1) 7-5
				Veronika Kudermetova
114.		[13]	Caroline Wozniacki	0-6 6-3 6-3
					Veronika Kudermetova
115.			Zarina Diyas		7-5 6-1
				Zarina Diyas
116.		[WC]	Audrey Albie	6-2 6-2
						Kaia Kanepi
117.			Shuai Zhang			4-6 6-3 6-0
				Shuai Zhang
118.		[Q]	Varvara Lepchenko	6-1 6-1
					Kaia Kanepi
119.			Kaia Kanepi		6-7(4) 6-0 7-5
				Kaia Kanepi
120.		[18]	Julia Goerges	7-5 6-1
							Petra Martic
121.		[31]	Petra Martic				5-7 6-2 6-4
				Petra Martic
122.			Ons Jabeur	6-1 6-2
					Petra Martic
123.			Kristina Mladenovic		6-2 6-1
				Kristina Mladenovic
124.			Fiona Ferro	6-3 7-6(3)
						Petra Martic
125.		[Q]	Kristina Kucova			6-3 6-3
				Kristina Kucova
126.			Svetlana Kuznetsova	6-4 6-2
					Karolina Pliskova
127.		[2]	Karolina Pliskova		6-2 6-2
				Karolina Pliskova
128.			Madison Brengle	6-2 6-3

(default) 17 queries took 21 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` = '2019' 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` = (2267) 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 (14183, 11458, 10377, 14137, 13575, 14369, 14159, 10506, 10494, 10511, 14294, 14130, 14182, 10531, 10521, 10485, 10150, 11416, 11426, 14287, 14149, 14370, 14290, 14365, 10414, 14180, 10428, 10489, 13879, 11451, 10505, 14156, 10496, 11480, 14133, 14323, 13531, 10540, 10498, 11460, 14168, 14371, 11447, 10410, 14288, 14372, 13875, 13882, 14298, 10419, 14296, 14368, 10522, 14139, 14283, 13623, 14204, 14282, 10270, 10318, 14374, 10281, 10429, 14379, 10515, 10538, 14192, 13570, 14310, 14352, 10478, 13878, 10527, 13604, 10500, 10438, 14155, 14305, 10534, 10151, 13572, 14307, 14140, 14375, 14302, 10526, 10525, 14376, 11479, 14225, 10499, 10532, 14295, 10374, 10535, 10425, 14292, 10413, 14304, 14181, 11448, 14300, 10457, 14279, 14232, 14289, 14377, 14303, 10518, 10445, 10476, 10524, 14281, 10440, 13574, 14378, 10503, 10395, 10398, 10444, 10465, 13877, 10452, 13602, 10468, 10255, 10523, 10400) 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` = 2267	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (53, 197, 153, 168, 68, 154, 96, 94, 21, 92, 13, 72, 179, 169, 181, 189, 164, 63, 196, 194, 184, 20, 178, 42, 149, 50, 111, 173, 104, 151, 74, 36, 133, 84, 54)	35	35	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (53, 197, 153, 168, 68, 154, 96, 94, 21, 92, 13, 72, 179, 169, 181, 189, 164, 63, 196, 194, 184, 20, 178, 42, 149, 50, 111, 173, 104, 151, 74, 36, 133, 84, 54)	35	35	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (14183, 11458, 10377, 14137, 13575, 14369, 14159, 10506, 10494, 10511, 14294, 14130, 14182, 10531, 10521, 10485, 10150, 11416, 11426, 14287, 14149, 14370, 14290, 14365, 10414, 14180, 10428, 10489, 13879, 11451, 10505, 14156, 10496, 11480, 14133, 14323, 13531, 10540, 10498, 11460, 14168, 14371, 11447, 10410, 14288, 14372, 13875, 13882, 14298, 10419, 14296, 14368, 10522, 14139, 14283, 13623, 14204, 14282, 10270, 10318, 14374, 10281, 10429, 14379, 10515, 10538, 14192, 13570, 14310, 14352, 10478, 13878, 10527, 13604, 10500, 10438, 14155, 14305, 10534, 10151, 13572, 14307, 14140, 14375, 14302, 10526, 10525, 14376, 11479, 14225, 10499, 10532, 14295, 10374, 10535, 10425, 14292, 10413, 14304, 14181, 11448, 14300, 10457, 14279, 14232, 14289, 14377, 14303, 10518, 10445, 10476, 10524, 14281, 10440, 13574, 14378, 10503, 10395, 10398, 10444, 10465, 13877, 10452, 13602, 10468, 10255, 10523, 10400)) AND (`Playercontest`.`contest_id` = 2267))	128	128	1
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` = 2019	10	10	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (3, 1, 12, 14, 19, 24, 17, 22, 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	0

(default) 17 queries took 21 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` = '2019' 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` = (2267) 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 (14183, 11458, 10377, 14137, 13575, 14369, 14159, 10506, 10494, 10511, 14294, 14130, 14182, 10531, 10521, 10485, 10150, 11416, 11426, 14287, 14149, 14370, 14290, 14365, 10414, 14180, 10428, 10489, 13879, 11451, 10505, 14156, 10496, 11480, 14133, 14323, 13531, 10540, 10498, 11460, 14168, 14371, 11447, 10410, 14288, 14372, 13875, 13882, 14298, 10419, 14296, 14368, 10522, 14139, 14283, 13623, 14204, 14282, 10270, 10318, 14374, 10281, 10429, 14379, 10515, 10538, 14192, 13570, 14310, 14352, 10478, 13878, 10527, 13604, 10500, 10438, 14155, 14305, 10534, 10151, 13572, 14307, 14140, 14375, 14302, 10526, 10525, 14376, 11479, 14225, 10499, 10532, 14295, 10374, 10535, 10425, 14292, 10413, 14304, 14181, 11448, 14300, 10457, 14279, 14232, 14289, 14377, 14303, 10518, 10445, 10476, 10524, 14281, 10440, 13574, 14378, 10503, 10395, 10398, 10444, 10465, 13877, 10452, 13602, 10468, 10255, 10523, 10400) 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` = 2267

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (14183, 11458, 10377, 14137, 13575, 14369, 14159, 10506, 10494, 10511, 14294, 14130, 14182, 10531, 10521, 10485, 10150, 11416, 11426, 14287, 14149, 14370, 14290, 14365, 10414, 14180, 10428, 10489, 13879, 11451, 10505, 14156, 10496, 11480, 14133, 14323, 13531, 10540, 10498, 11460, 14168, 14371, 11447, 10410, 14288, 14372, 13875, 13882, 14298, 10419, 14296, 14368, 10522, 14139, 14283, 13623, 14204, 14282, 10270, 10318, 14374, 10281, 10429, 14379, 10515, 10538, 14192, 13570, 14310, 14352, 10478, 13878, 10527, 13604, 10500, 10438, 14155, 14305, 10534, 10151, 13572, 14307, 14140, 14375, 14302, 10526, 10525, 14376, 11479, 14225, 10499, 10532, 14295, 10374, 10535, 10425, 14292, 10413, 14304, 14181, 11448, 14300, 10457, 14279, 14232, 14289, 14377, 14303, 10518, 10445, 10476, 10524, 14281, 10440, 13574, 14378, 10503, 10395, 10398, 10444, 10465, 13877, 10452, 13602, 10468, 10255, 10523, 10400)) AND (`Playercontest`.`contest_id` = 2267))

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

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