Roland Garros 2022 Women's Singles (May 22 - June 4)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Iga Swiatek
				Iga Swiatek
2.		[Q]	Lesia Tsurenko	6-2 6-0
					Iga Swiatek
3.			Alison Riske		6-0 6-2
				Alison Riske
4.			Dayana Yastremska	6-3 6-3
						Iga Swiatek
5.			Anna Schmiedlova			6-3 7-5
				Anna Schmiedlova
6.			Kristina Kucova	4-6 7-6(1) 6-2
					Danka Kovinic
7.			Danka Kovinic		6-3 7-5
				Danka Kovinic
8.		[25]	Ludmilla Samsonova	2-6 6-2 6-1
							Iga Swiatek
9.		[19]	Simona Halep				6-7(5) 6-0 6-2
				Simona Halep
10.		[LL]	Nastasja Schunk	6-4 1-6 6-1
					Qinwen Zheng
11.			Qinwen Zheng		2-6 6-2 6-1
				Qinwen Zheng
12.			Maryna Zanevska	6-3 6-1
						Qinwen Zheng
13.			Alize Cornet			6-0 3-0 rtd.
				Alize Cornet
14.			Misaki Doi	6-2 6-0
					Alize Cornet
15.		[13]	Jelena Ostapenko		6-0 1-6 6-3
				Jelena Ostapenko
16.			Lucia Bronzetti	6-1 6-4
								Iga Swiatek
17.		[11]	Jessica Pegula					6-3 6-2
				Jessica Pegula
18.			Qiang Wang	6-2 6-4
					Jessica Pegula
19.			Anhelina Kalinina		6-1 5-7 6-4
				Anhelina Kalinina
20.		[Q]	Hailey Baptiste	5-2 rtd.
						Jessica Pegula
21.			Mayar Sherif			6-1 7-6(2)
				Mayar Sherif
22.			Marta Kostyuk	6-3 7-5
					Tamara Zidansek
23.		[24]	Tamara Zidansek		w/o
				Tamara Zidansek
24.			Claire Liu	6-2 6-2
							Jessica Pegula
25.		[30]	Ekaterina Alexandrova				4-6 6-2 6-3
				Ekaterina Alexandrova
26.			Greet Minnen	7-5 6-3
					Irina-Camelia Begu
27.			Irina-Camelia Begu		6-7(3) 6-3 6-4
				Irina-Camelia Begu
28.			Jasmine Paolini	4-6 6-1 7-6(5)
						Irina-Camelia Begu
29.		[WC]	Leolia Jeanjean			6-1 6-4
				Leolia Jeanjean
30.			Nuria Parrizas Diaz	6-4 6-3
					Leolia Jeanjean
31.		[8]	Karolina Pliskova		6-2 6-2
				Karolina Pliskova
32.		[WC]	Tessah Andrianjafitrimo	2-6 6-3 6-1
									Iga Swiatek
33.		[3]	Paula Badosa Gibert						6-2 6-1
				Paula Badosa Gibert
34.		[WC]	Fiona Ferro	6-2 6-0
					Paula Badosa Gibert
35.			Kaja Juvan		7-5 3-6 6-2
				Kaja Juvan
36.		[Q]	Oksana Selekhmeteva	7-5 7-6(4)
						Veronika Kudermetova
37.		[Q]	Aleksandra Krunic			6-3 2-1 rtd.
				Aleksandra Krunic
38.			Kamilla Rakhimova	6-4 6-3
					Veronika Kudermetova
39.		[29]	Veronika Kudermetova		6-3 6-3
				Veronika Kudermetova
40.		[Q]	Lin Zhu	6-4 3-6 6-3
							Veronika Kudermetova
41.		[22]	Madison Keys				1-6 6-3 6-1
				Madison Keys
42.			Anna Kalinskaya	6-3 3-6 6-4
					Madison Keys
43.			Caroline Garcia		6-4 7-6(3)
				Caroline Garcia
44.			Taylor Townsend	6-3 6-4
						Madison Keys
45.		[WC]	Katie Volynets			3-6 6-1 7-6(3)
				Katie Volynets
46.			Viktorija Golubic	6-2 2-6 6-1
					Elena Rybakina
47.		[16]	Elena Rybakina		6-4 6-0
				Elena Rybakina
48.			Arantxa Rus	6-1 5-7 6-2
								Daria Kasatkina
49.		[9]	Danielle Collins					6-4 7-6(5)
				Danielle Collins
50.		[LL]	Viktoriya Tomova	6-0 6-4
					Shelby Rogers
51.			Shelby Rogers		6-4 6-3
				Shelby Rogers
52.			Tereza Martincova	6-4 6-3
						Daria Kasatkina
53.		[Q]	Fernanda Contreraz Gomez			6-3 6-2
				Fernanda Contreraz Gomez
54.			Panna Udvardy	7-6(8) 6-3
					Daria Kasatkina
55.		[20]	Daria Kasatkina		6-0 6-3
				Daria Kasatkina
56.		[LL]	Rebecca Sramkova	6-2 6-0
							Daria Kasatkina
57.		[28]	Camila Giorgi				6-2 6-2
				Camila Giorgi
58.			Shuai Zhang	3-6 6-2 6-2
					Camila Giorgi
59.			Yulia Putintseva		6-3 7-5
				Yulia Putintseva
60.		[Q]	Irina Bara	6-3 6-1
						Camila Giorgi
61.			Madison Brengle			4-6 6-1 6-0
				Madison Brengle
62.		[LL]	Mihaela Buzarnescu	6-1 6-2
					Aryna Sabalenka
63.		[7]	Aryna Sabalenka		6-1 6-3
				Aryna Sabalenka
64.			Chloe Paquet	2-6 6-3 6-4
										Iga Swiatek
65.			Magda Linette							6-1 6-3
				Magda Linette
66.		[6]	Ons Jabeur	3-6 7-6(4) 7-5
					Martina Trevisan
67.			Martina Trevisan		6-3 6-2
				Martina Trevisan
68.			Harriet Dart	6-0 6-2
						Martina Trevisan
69.		[WC]	Daria Gavrilova			6-3 6-4
				Daria Gavrilova
70.		[Q]	Valentini Grammatikopoulou	6-1 6-2
					Daria Gavrilova
71.		[32]	Petra Kvitova		6-4 6-2
				Petra Kvitova
72.			Anna Bondar	7-6(0) 6-1
							Martina Trevisan
73.		[21]	Angelique Kerber				7-6(10) 7-5
				Angelique Kerber
74.			Magdalena Frech	2-6 6-3 7-5
					Angelique Kerber
75.		[WC]	Elsa Jacquemot		6-1 7-6(2)
				Elsa Jacquemot
76.			Heather Watson	6-3 6-3
						Aliaksandra Sasnovich
77.			Aliaksandra Sasnovich			6-4 7-6(5)
				Aliaksandra Sasnovich
78.			Xinyu Wang	6-4 6-1
					Aliaksandra Sasnovich
79.		[12]	Emma Raducanu		3-6 6-1 6-1
				Emma Raducanu
80.		[Q]	Linda Noskova	6-7(4) 7-5 6-1
								Martina Trevisan
81.		[14]	Belinda Bencic					6-2 6-7(3) 6-3
				Belinda Bencic
82.		[LL]	Reka-Luca Jani	6-1 6-1
					Belinda Bencic
83.			Bianca Andreescu		6-2 6-4
				Bianca Andreescu
84.		[Q]	Ysaline Bonaventure	3-6 7-5 6-0
						Leylah Fernandez
85.			Katerina Siniakova			7-5 3-6 7-5
				Katerina Siniakova
86.			Petra Martic	6-4 7-6(6)
					Leylah Fernandez
87.		[17]	Leylah Fernandez		6-3 6-2
				Leylah Fernandez
88.			Kristina Mladenovic	6-0 7-5
							Leylah Fernandez
89.		[27]	Amanda Anisimova				6-3 4-6 6-3
				Amanda Anisimova
90.			Naomi Osaka	7-5 6-4
					Amanda Anisimova
91.		[Q]	Donna Vekic		6-4 6-1
				Donna Vekic
92.		[Q]	Mirjam Bjorklund	7-6(6) 6-2
						Amanda Anisimova
93.			Karolina Muchova			6-7(7) 6-2 3-0 rtd.
				Karolina Muchova
94.		[WC]	Carole Monnet	6-3 6-3
					Karolina Muchova
95.		[4]	Maria Sakkari		7-6(5) 7-6(4)
				Maria Sakkari
96.			Clara Burel	6-2 6-3
									Cori Gauff
97.			Ajla Tomljanovic						6-3 6-1
				Ajla Tomljanovic
98.		[5]	Anett Kontaveit	7-6(5) 7-5
					Varvara Gracheva
99.			Varvara Gracheva		6-4 6-7(5) 7-5
				Varvara Gracheva
100.			Astra Sharma	4-6 6-4 7-5
						Elise Mertens
101.			Marie Bouzkova			6-2 6-3
				Marie Bouzkova
102.		[LL]	Anastasia Gasanova	6-2 6-1
					Elise Mertens
103.		[31]	Elise Mertens		w/o
				Elise Mertens
104.			Elena-Gabriela Ruse	6-3 6-1
							Cori Gauff
105.		[18]	Cori Gauff				6-4 6-0
				Cori Gauff
106.		[Q]	Rebecca Marino	7-5 6-0
					Cori Gauff
107.			Alison Van Uytvanck		6-1 7-6(4)
				Alison Van Uytvanck
108.			Ann Li	3-6 2-3 rtd.
						Cori Gauff
109.			Beatriz Haddad Maia			6-3 6-4
				Beatriz Haddad Maia
110.		[Q]	Cristina Bucsa	6-3 1-6 6-2
					Kaia Kanepi
111.			Kaia Kanepi		6-4 6-4
				Kaia Kanepi
112.		[10]	Garbine Muguruza	2-6 6-3 6-4
								Cori Gauff
113.		[15]	Victoria Azarenka					7-5 6-2
				Victoria Azarenka
114.			Ana Bogdan	6-7(7) 7-6(1) 6-2
					Victoria Azarenka
115.			Andrea Petkovic		6-1 7-6(3)
				Andrea Petkovic
116.			Oceane Dodin	6-4 6-2
						Jil Teichmann
117.		[Q]	Olga Danilovic			4-6 7-5 7-6(5)
				Olga Danilovic
118.			Dalma Galfi	3-6 7-6(4) 6-2
					Jil Teichmann
119.		[23]	Jil Teichmann		6-4 6-1
				Jil Teichmann
120.			Bernarda Pera	6-2 6-1
							Sloane Stephens
121.		[26]	Sorana Cirstea				6-2 6-0
				Sorana Cirstea
122.			Tatjana Maria	6-3 6-3
					Sloane Stephens
123.			Sloane Stephens		3-6 6-2 6-0
				Sloane Stephens
124.			Jule Niemeier	5-7 6-4 6-2
						Sloane Stephens
125.			Camila Osorio			6-2 6-3
				Camila Osorio
126.		[WC]	Harmony Tan	6-4 6-3
					Diane Parry
127.			Diane Parry		6-3 6-3
				Diane Parry
128.		[2]	Barbora Krejcikova	1-6 6-2 6-3

(default) 17 queries took 69 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	34
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	13
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	7
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` = '2022' 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` = (2303) 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 (14288, 10498, 10489, 14279, 11458, 10468, 13609, 14376, 10496, 14541, 14500, 13605, 10374, 10538, 14137, 14498, 14156, 13875, 14338, 14439, 14456, 14314, 14289, 14327, 14204, 14418, 10522, 14371, 14542, 14490, 10523, 14189, 14306, 13602, 14379, 14543, 13531, 14453, 14281, 14139, 10521, 14299, 10494, 13604, 14404, 14180, 14369, 10488, 13879, 14328, 11448, 14385, 14544, 14504, 14168, 14345, 10537, 10503, 10526, 14458, 10400, 14282, 14298, 14323, 14133, 13877, 14420, 14301, 10540, 14495, 10446, 14508, 10413, 14325, 14455, 10510, 13878, 14351, 14481, 14545, 13572, 13378, 14290, 14309, 13575, 10465, 14421, 10452, 14296, 14183, 10525, 14546, 14283, 14547, 14159, 14285, 11480, 13623, 14440, 14300, 14365, 14548, 14232, 14361, 14399, 10490, 13570, 14419, 14280, 14488, 10398, 10527, 10377, 14231, 10428, 14095, 14467, 14489, 14337, 14305, 10429, 11451, 10515, 14567, 14475, 14368, 14377, 14356) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	2
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` = 2303	129	129	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (169, 42, 21, 194, 196, 197, 50, 84, 92, 31, 13, 179, 68, 149, 168, 53, 154, 72, 20, 74, 96, 153, 133, 104, 43, 94, 173, 36, 164, 126, 63, 189, 29, 121, 178, 59)	36	36	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (169, 42, 21, 194, 196, 197, 50, 84, 92, 31, 13, 179, 68, 149, 168, 53, 154, 72, 20, 74, 96, 153, 133, 104, 43, 94, 173, 36, 164, 126, 63, 189, 29, 121, 178, 59)	36	36	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (14288, 10498, 10489, 14279, 11458, 10468, 13609, 14376, 10496, 14541, 14500, 13605, 10374, 10538, 14137, 14498, 14156, 13875, 14338, 14439, 14456, 14314, 14289, 14327, 14204, 14418, 10522, 14371, 14542, 14490, 10523, 14189, 14306, 13602, 14379, 14543, 13531, 14453, 14281, 14139, 10521, 14299, 10494, 13604, 14404, 14180, 14369, 10488, 13879, 14328, 11448, 14385, 14544, 14504, 14168, 14345, 10537, 10503, 10526, 14458, 10400, 14282, 14298, 14323, 14133, 13877, 14420, 14301, 10540, 14495, 10446, 14508, 10413, 14325, 14455, 10510, 13878, 14351, 14481, 14545, 13572, 13378, 14290, 14309, 13575, 10465, 14421, 10452, 14296, 14183, 10525, 14546, 14283, 14547, 14159, 14285, 11480, 13623, 14440, 14300, 14365, 14548, 14232, 14361, 14399, 10490, 13570, 14419, 14280, 14488, 10398, 10527, 10377, 14231, 10428, 14095, 14467, 14489, 14337, 14305, 10429, 11451, 10515, 14567, 14475, 14368, 14377, 14356)) AND (`Playercontest`.`contest_id` = 2303))	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` = 2022	10	10	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (1, 3, 4, 12, 14, 17, 19, 22, 24, 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 69 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` = '2022' 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` = (2303) 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 (14288, 10498, 10489, 14279, 11458, 10468, 13609, 14376, 10496, 14541, 14500, 13605, 10374, 10538, 14137, 14498, 14156, 13875, 14338, 14439, 14456, 14314, 14289, 14327, 14204, 14418, 10522, 14371, 14542, 14490, 10523, 14189, 14306, 13602, 14379, 14543, 13531, 14453, 14281, 14139, 10521, 14299, 10494, 13604, 14404, 14180, 14369, 10488, 13879, 14328, 11448, 14385, 14544, 14504, 14168, 14345, 10537, 10503, 10526, 14458, 10400, 14282, 14298, 14323, 14133, 13877, 14420, 14301, 10540, 14495, 10446, 14508, 10413, 14325, 14455, 10510, 13878, 14351, 14481, 14545, 13572, 13378, 14290, 14309, 13575, 10465, 14421, 10452, 14296, 14183, 10525, 14546, 14283, 14547, 14159, 14285, 11480, 13623, 14440, 14300, 14365, 14548, 14232, 14361, 14399, 10490, 13570, 14419, 14280, 14488, 10398, 10527, 10377, 14231, 10428, 14095, 14467, 14489, 14337, 14305, 10429, 11451, 10515, 14567, 14475, 14368, 14377, 14356) 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` = 2303

129

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (14288, 10498, 10489, 14279, 11458, 10468, 13609, 14376, 10496, 14541, 14500, 13605, 10374, 10538, 14137, 14498, 14156, 13875, 14338, 14439, 14456, 14314, 14289, 14327, 14204, 14418, 10522, 14371, 14542, 14490, 10523, 14189, 14306, 13602, 14379, 14543, 13531, 14453, 14281, 14139, 10521, 14299, 10494, 13604, 14404, 14180, 14369, 10488, 13879, 14328, 11448, 14385, 14544, 14504, 14168, 14345, 10537, 10503, 10526, 14458, 10400, 14282, 14298, 14323, 14133, 13877, 14420, 14301, 10540, 14495, 10446, 14508, 10413, 14325, 14455, 10510, 13878, 14351, 14481, 14545, 13572, 13378, 14290, 14309, 13575, 10465, 14421, 10452, 14296, 14183, 10525, 14546, 14283, 14547, 14159, 14285, 11480, 13623, 14440, 14300, 14365, 14548, 14232, 14361, 14399, 10490, 13570, 14419, 14280, 14488, 10398, 10527, 10377, 14231, 10428, 14095, 14467, 14489, 14337, 14305, 10429, 11451, 10515, 14567, 14475, 14368, 14377, 14356)) AND (`Playercontest`.`contest_id` = 2303))

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

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