US Open 2023 Women's Singles (August 28 - September 9)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Iga Swiatek
				Iga Swiatek
2.			Rebecca Peterson	6-0 6-1
					Iga Swiatek
3.			Daria Gavrilova		6-3 6-4
				Daria Gavrilova
4.		[WC]	Clervie Ngounoue	6-0 6-2
						Iga Swiatek
5.			Lauren Davis			6-0 6-1
				Lauren Davis
6.			Danka Kovinic	6-2 6-2
					Kaja Juvan
7.		[Q]	Kaja Juvan		6-7(3) 6-4 6-3
				Kaja Juvan
8.		[29]	Elisabetta Cocciaretto	6-2 7-5
							Jelena Ostapenko
9.		[20]	Jelena Ostapenko				3-6 6-3 6-1
				Jelena Ostapenko
10.			Jasmine Paolini	6-2 4-6 6-1
					Jelena Ostapenko
11.			Elina Avanesyan		6-3 5-7 7-5
				Elina Avanesyan
12.			Alize Cornet	6-2 1-6 6-4
						Jelena Ostapenko
13.			Xiyu Wang			4-6 6-3 6-3
				Xiyu Wang
14.		[LL]	Viktoria Kuzmova	4-6 6-3 7-6(6)
					Bernarda Pera
15.			Bernarda Pera		3-6 7-6(5) 6-2
				Bernarda Pera
16.		[16]	Veronika Kudermetova	7-5 6-4
								Cori Gauff
17.		[11]	Petra Kvitova					6-0 6-2
				Petra Kvitova
18.			Cristina Bucsa	6-1 7-6(5)
					Caroline Wozniacki
19.		[WC]	Caroline Wozniacki		7-5 7-6(5)
				Caroline Wozniacki
20.		[Q]	Tatiana Prozorova	6-3 6-2
						Caroline Wozniacki
21.			Jennifer Brady			4-6 6-3 6-1
				Jennifer Brady
22.		[LL]	Kimberly Birrell	6-3 7-6(4)
					Jennifer Brady
23.		[24]	Magda Linette		6-1 2-6 6-2
				Magda Linette
24.			Aliaksandra Sasnovich	6-3 6-1
							Cori Gauff
25.		[32]	Elise Mertens				6-3 3-6 6-1
				Elise Mertens
26.		[Q]	Mirjam Bjorklund	3-6 6-3 7-6(3)
					Elise Mertens
27.			Danielle Collins		3-6 7-6(7) 6-1
				Danielle Collins
28.			Linda Fruhvirtova	6-2 6-0
						Cori Gauff
29.			Mirra Andreeva			3-6 6-3 6-0
				Mirra Andreeva
30.		[Q]	Olivia Gadecki	1-6 6-3 6-4
					Cori Gauff
31.		[6]	Cori Gauff		6-3 6-2
				Cori Gauff
32.		[Q]	Laura Siegemund	3-6 6-2 6-4
									Cori Gauff
33.		[4]	Elena Rybakina						6-4 7-5
				Elena Rybakina
34.			Marta Kostyuk	6-2 6-1
					Elena Rybakina
35.			Ajla Tomljanovic		w/o
				Ajla Tomljanovic
36.			Panna Udvardy	3-6 6-2 6-4
						Sorana Cirstea
37.			Anna Kalinskaya			6-3 6-7(6) 6-4
				Anna Kalinskaya
38.			Katerina Siniakova	6-4 6-2
					Sorana Cirstea
39.		[30]	Sorana Cirstea		6-3 6-4
				Sorana Cirstea
40.		[WC]	Kayla Day	6-2 6-3
							Sorana Cirstea
41.		[18]	Victoria Azarenka				6-3 6-3
				Victoria Azarenka
42.		[WC]	Fiona Ferro	6-1 6-2
					Lin Zhu
43.			Lin Zhu		6-3 6-3
				Lin Zhu
44.			Mayar Sherif	6-3 7-5
						Belinda Bencic
45.		[Q]	Yuriko Miyazaki			7-6(1) 2-6 6-3
				Yuriko Miyazaki
46.			Margarita Gasparyan	6-3 6-3
					Belinda Bencic
47.		[15]	Belinda Bencic		6-3 6-3
				Belinda Bencic
48.			Kamilla Rakhimova	6-2 6-4
								Karolina Muchova
49.		[10]	Karolina Muchova					6-0 6-3
				Karolina Muchova
50.		[WC]	Storm Sanders	6-4 6-0
					Karolina Muchova
51.			Magdalena Frech		6-3 6-3
				Magdalena Frech
52.			Emma Navarro	7-6(10) 1-6 6-2
						Karolina Muchova
53.			Taylor Townsend			7-6(0) 6-3
				Taylor Townsend
54.			Varvara Gracheva	6-4 6-2
					Taylor Townsend
55.		[19]	Beatriz Haddad Maia		7-6(1) 7-5
				Beatriz Haddad Maia
56.			Sloane Stephens	6-2 5-7 6-4
							Karolina Muchova
57.			Sara Sorribes Tormo				6-3 5-7 6-1
				Sara Sorribes Tormo
58.		[28]	Anhelina Kalinina	6-4 7-5
					Xinyu Wang
59.			Xinyu Wang		5-7 6-3 6-4
				Xinyu Wang
60.		[Q]	Katie Volynets	6-3 6-4
						Xinyu Wang
61.			Anna Schmiedlova			4-6 6-3 6-2
				Anna Schmiedlova
62.			Kateryna Kozlova	6-4 3-6 6-3
					Anna Schmiedlova
63.			Rebeka Masarova		7-6(0) 6-2
				Rebeka Masarova
64.		[8]	Maria Sakkari	6-4 6-4
										Cori Gauff
65.		[Q]	Yafan Wang							2-6 6-3 6-2
				Yafan Wang
66.		[7]	Caroline Garcia	6-4 6-1
					Katie Boulter
67.			Katie Boulter		5-7 6-1 6-4
				Katie Boulter
68.			Diane Parry	6-4 6-0
						Peyton Stearns
69.			Peyton Stearns			6-4 6-3
				Peyton Stearns
70.			Viktoriya Tomova	6-3 6-4
					Peyton Stearns
71.			Clara Tauson		6-3 6-0
				Clara Tauson
72.		[27]	Anastasia Potapova	7-6(4) 3-6 6-3
							Marketa Vondrousova
73.		[22]	Ekaterina Alexandrova				6-7(3) 6-3 6-2
				Ekaterina Alexandrova
74.			Leylah Fernandez	7-6(4) 5-7 6-4
					Ekaterina Alexandrova
75.			Lesia Tsurenko		6-1 6-3
				Lesia Tsurenko
76.		[Q]	Elsa Jacquemot	7-5 3-6 6-1
						Marketa Vondrousova
77.			Martina Trevisan			6-2 6-1
				Martina Trevisan
78.			Yulia Putintseva	0-6 7-6(0) 7-6(8)
					Marketa Vondrousova
79.		[9]	Marketa Vondrousova		6-2 6-2
				Marketa Vondrousova
80.		[Q]	Na-Lae Han	6-3 6-0
								Madison Keys
81.		[14]	Ludmilla Samsonova					6-1 6-4
				Ludmilla Samsonova
82.			Claire Liu	7-6(3) 6-3
					Ludmilla Samsonova
83.			Tamara Korpatsch		6-3 6-3
				Tamara Korpatsch
84.			Irina-Camelia Begu	6-3 6-2
						Madison Keys
85.		[LL]	Yanina Wickmayer			5-7 6-2 6-2
				Yanina Wickmayer
86.		[Q]	Vera Zvonareva	6-4 6-4
					Madison Keys
87.			Madison Keys		6-1 6-2
				Madison Keys
88.			Arantxa Rus	6-2 6-4
							Madison Keys
89.		[26]	Elina Svitolina				6-1 6-3
				Elina Svitolina
90.			Anna-Lena Friedsam	6-3 6-1
					Elina Svitolina
91.			Anastasia Pavlyuchenkova		5-7 6-4 6-4
				Anastasia Pavlyuchenkova
92.		[Q]	Fiona Crawley	6-2 6-4
						Jessica Pegula
93.			Patricia Maria Tig			6-4 4-6 6-2
				Patricia Maria Tig
94.			Rebecca Marino	7-6(6) 7-6(1)
					Jessica Pegula
95.		[3]	Jessica Pegula		6-3 6-1
				Jessica Pegula
96.			Camila Giorgi	6-2 6-2
									Aryna Sabalenka
97.		[5]	Ons Jabeur						0-6 7-6(1) 7-6(5)
				Ons Jabeur
98.			Camila Osorio	7-5 7-6(4)
					Ons Jabeur
99.			Linda Noskova		7-6(7) 4-6 6-3
				Linda Noskova
100.			Madison Brengle	6-2 6-1
						Ons Jabeur
101.			Petra Martic			5-7 7-6(5) 6-3
				Petra Martic
102.			Tatjana Maria	6-2 6-1
					Marie Bouzkova
103.		[31]	Marie Bouzkova		6-1 6-2
				Marie Bouzkova
104.		[WC]	Ashlyn Krueger	7-5 6-4
							Qinwen Zheng
105.		[23]	Qinwen Zheng				6-2 6-4
				Qinwen Zheng
106.			Nadia Podoroska	6-1 6-0
					Qinwen Zheng
107.			Kaia Kanepi		6-2 3-6 6-2
				Kaia Kanepi
108.			Barbora Strycova	6-4 6-4
						Qinwen Zheng
109.		[Q]	Eva Lys			6-3 4-6 6-4
				Eva Lys
110.		[WC]	Robin Montgomery	6-2 6-1
					Lucia Bronzetti
111.			Lucia Bronzetti		6-3 6-2
				Lucia Bronzetti
112.		[12]	Barbora Krejcikova	6-4 7-6(3)
								Aryna Sabalenka
113.		[13]	Daria Kasatkina					6-1 6-4
				Daria Kasatkina
114.			Alycia Parks	2-6 6-4 6-2
					Daria Kasatkina
115.			Sofia Kenin		2-6 6-4 6-4
				Sofia Kenin
116.			Ana Bogdan	7-6(2) 6-4
						Daria Kasatkina
117.		[Q]	Greet Minnen			6-3 6-4
				Greet Minnen
118.		[WC]	Venus Williams	6-1 6-1
					Greet Minnen
119.		[Q]	Sachia Vickery		6-3 4-6 6-4
				Sachia Vickery
120.		[21]	Donna Vekic	2-6 7-5 6-2
							Aryna Sabalenka
121.		[25]	Karolina Pliskova				6-1 6-3
				Karolina Pliskova
122.		[Q]	Elena-Gabriela Ruse	6-1 6-4
					Clara Burel
123.			Clara Burel		6-4 6-2
				Clara Burel
124.			Caroline Dolehide	6-4 6-3
						Aryna Sabalenka
125.			Jodie Burrage			6-1 6-1
				Jodie Burrage
126.			Anna Blinkova	6-3 6-4
					Aryna Sabalenka
127.		[2]	Aryna Sabalenka		6-3 6-2
				Aryna Sabalenka
128.			Maryna Zanevska	6-3 6-2

(default) 17 queries took 29 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` = 'us-open' 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` = (4)	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` = (4)	3	3	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` = (4)	2	2	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` = 'us-open' 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` = (24) ORDER BY `Contest`.`year` ASC	138	138	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` = 4 AND `Contest`.`category_id` = 24 AND `Contest`.`slug` = '2023' 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` = (2318) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	127	127	5
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (14288, 14302, 10540, 14674, 10499, 13609, 14379, 14422, 14137, 14371, 14584, 10374, 14406, 14295, 14305, 14281, 10446, 14488, 10440, 14676, 14310, 14186, 14133, 13878, 14232, 14546, 13879, 14577, 14615, 14588, 14399, 14140, 14369, 14314, 11480, 14504, 14299, 13575, 10429, 14230, 10377, 13602, 14139, 14456, 14565, 14130, 13572, 14453, 14283, 13577, 14325, 14494, 13604, 14440, 14280, 10515, 14192, 14338, 14351, 14404, 11458, 14155, 14492, 14159, 14181, 10494, 14297, 14377, 14576, 14328, 14457, 14292, 14204, 14421, 10498, 14455, 14420, 10526, 14304, 14412, 14376, 14327, 14437, 10522, 10443, 10281, 10521, 10488, 10534, 13610, 10445, 14677, 14203, 10490, 14156, 10537, 13877, 14475, 14545, 10400, 10465, 11451, 14365, 14491, 14500, 14227, 10398, 10318, 14587, 14438, 14498, 14356, 14168, 14493, 14149, 14231, 14418, 10151, 13536, 10525, 10523, 14361, 14285, 14324, 14482, 14294, 14298, 13605) 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` = 2318	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (42, 21, 54, 197, 53, 50, 84, 194, 92, 173, 31, 13, 153, 149, 72, 168, 20, 154, 74, 96, 133, 10, 178, 68, 104, 43, 196, 36, 126, 63, 169, 189, 100, 29, 179, 59)	36	36	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (42, 21, 54, 197, 53, 50, 84, 194, 92, 173, 31, 13, 153, 149, 72, 168, 20, 154, 74, 96, 133, 10, 178, 68, 104, 43, 196, 36, 126, 63, 169, 189, 100, 29, 179, 59)	36	36	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (14288, 14302, 10540, 14674, 10499, 13609, 14379, 14422, 14137, 14371, 14584, 10374, 14406, 14295, 14305, 14281, 10446, 14488, 10440, 14676, 14310, 14186, 14133, 13878, 14232, 14546, 13879, 14577, 14615, 14588, 14399, 14140, 14369, 14314, 11480, 14504, 14299, 13575, 10429, 14230, 10377, 13602, 14139, 14456, 14565, 14130, 13572, 14453, 14283, 13577, 14325, 14494, 13604, 14440, 14280, 10515, 14192, 14338, 14351, 14404, 11458, 14155, 14492, 14159, 14181, 10494, 14297, 14377, 14576, 14328, 14457, 14292, 14204, 14421, 10498, 14455, 14420, 10526, 14304, 14412, 14376, 14327, 14437, 10522, 10443, 10281, 10521, 10488, 10534, 13610, 10445, 14677, 14203, 10490, 14156, 10537, 13877, 14475, 14545, 10400, 10465, 11451, 14365, 14491, 14500, 14227, 10398, 10318, 14587, 14438, 14498, 14356, 14168, 14493, 14149, 14231, 14418, 10151, 13536, 10525, 10523, 14361, 14285, 14324, 14482, 14294, 14298, 13605)) AND (`Playercontest`.`contest_id` = 2318))	128	128	5
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 24 ORDER BY `Contest`.`date_from` ASC	138	138	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 2023	10	10	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (3, 1, 12, 14, 17, 19, 22, 24, 2, 4) 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 29 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` = 'us-open' 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` = (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` = (4)

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` = 'us-open' AND `Category`.`slug` = 'women-singles' LIMIT 1

138

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` = 4 AND `Contest`.`category_id` = 24 AND `Contest`.`slug` = '2023' 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` = (2318) 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, 14302, 10540, 14674, 10499, 13609, 14379, 14422, 14137, 14371, 14584, 10374, 14406, 14295, 14305, 14281, 10446, 14488, 10440, 14676, 14310, 14186, 14133, 13878, 14232, 14546, 13879, 14577, 14615, 14588, 14399, 14140, 14369, 14314, 11480, 14504, 14299, 13575, 10429, 14230, 10377, 13602, 14139, 14456, 14565, 14130, 13572, 14453, 14283, 13577, 14325, 14494, 13604, 14440, 14280, 10515, 14192, 14338, 14351, 14404, 11458, 14155, 14492, 14159, 14181, 10494, 14297, 14377, 14576, 14328, 14457, 14292, 14204, 14421, 10498, 14455, 14420, 10526, 14304, 14412, 14376, 14327, 14437, 10522, 10443, 10281, 10521, 10488, 10534, 13610, 10445, 14677, 14203, 10490, 14156, 10537, 13877, 14475, 14545, 10400, 10465, 11451, 14365, 14491, 14500, 14227, 10398, 10318, 14587, 14438, 14498, 14356, 14168, 14493, 14149, 14231, 14418, 10151, 13536, 10525, 10523, 14361, 14285, 14324, 14482, 14294, 14298, 13605) 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` = 2318

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (14288, 14302, 10540, 14674, 10499, 13609, 14379, 14422, 14137, 14371, 14584, 10374, 14406, 14295, 14305, 14281, 10446, 14488, 10440, 14676, 14310, 14186, 14133, 13878, 14232, 14546, 13879, 14577, 14615, 14588, 14399, 14140, 14369, 14314, 11480, 14504, 14299, 13575, 10429, 14230, 10377, 13602, 14139, 14456, 14565, 14130, 13572, 14453, 14283, 13577, 14325, 14494, 13604, 14440, 14280, 10515, 14192, 14338, 14351, 14404, 11458, 14155, 14492, 14159, 14181, 10494, 14297, 14377, 14576, 14328, 14457, 14292, 14204, 14421, 10498, 14455, 14420, 10526, 14304, 14412, 14376, 14327, 14437, 10522, 10443, 10281, 10521, 10488, 10534, 13610, 10445, 14677, 14203, 10490, 14156, 10537, 13877, 14475, 14545, 10400, 10465, 11451, 14365, 14491, 14500, 14227, 10398, 10318, 14587, 14438, 14498, 14356, 14168, 14493, 14149, 14231, 14418, 10151, 13536, 10525, 10523, 14361, 14285, 14324, 14482, 14294, 14298, 13605)) AND (`Playercontest`.`contest_id` = 2318))

128

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

138

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

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