US Open 2022 Women's Singles (August 29 - September 10)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Iga Swiatek
				Iga Swiatek
2.			Jasmine Paolini	6-3 6-0
					Iga Swiatek
3.			Sloane Stephens		6-3 6-2
				Sloane Stephens
4.			Greet Minnen	1-6 6-3 6-3
						Iga Swiatek
5.			Lauren Davis			6-3 6-4
				Lauren Davis
6.			Lucia Bronzetti	4-6 7-6(3) 5-4 rtd.
					Lauren Davis
7.		[28]	Ekaterina Alexandrova		0-6 6-4 7-6(5)
				Ekaterina Alexandrova
8.		[WC]	Peyton Stearns	6-4 4-6 7-5
							Iga Swiatek
9.			Yulia Putintseva				2-6 6-4 6-0
				Yulia Putintseva
10.		[24]	Amanda Anisimova	6-3 6-3
					Jule Niemeier
11.			Jule Niemeier		6-4 6-3
				Jule Niemeier
12.		[WC]	Sofia Kenin	7-6(3) 6-4
						Jule Niemeier
13.			Anastasia Potapova			6-4 7-6(5)
				Anastasia Potapova
14.			Claire Liu	6-1 6-4
					Qinwen Zheng
15.			Qinwen Zheng		7-6(4) 7-6(3)
				Qinwen Zheng
16.		[16]	Jelena Ostapenko	6-3 3-6 6-4
								Iga Swiatek
17.		[9]	Garbine Muguruza					6-3 7-6(4)
				Garbine Muguruza
18.			Clara Tauson	6-3 7-6(5)
					Garbine Muguruza
19.		[Q]	Linda Fruhvirtova		6-0 6-4
				Linda Fruhvirtova
20.			Xinyu Wang	6-3 6-4
						Petra Kvitova
21.			Anhelina Kalinina			5-7 6-3 7-6(10)
				Anhelina Kalinina
22.			Bernarda Pera	6-4 6-4
					Petra Kvitova
23.		[21]	Petra Kvitova		w/o
				Petra Kvitova
24.		[Q]	Erika Andreeva	7-6(3) 6-0
							Jessica Pegula
25.			Irina-Camelia Begu				6-3 6-2
				Irina-Camelia Begu
26.		[32]	Elise Mertens	3-6 6-2 6-3
					Yue Yuan
27.		[Q]	Yue Yuan		6-3 7-6(6)
				Yue Yuan
28.		[WC]	Jamiee Fourlis	6-3 6-2
						Jessica Pegula
29.			Aliaksandra Sasnovich			6-2 6-7(6) 6-0
				Aliaksandra Sasnovich
30.		[Q]	Elisabetta Cocciaretto	6-2 6-4
					Jessica Pegula
31.		[8]	Jessica Pegula		6-4 6-4
				Jessica Pegula
32.		[Q]	Viktorija Golubic	6-2 6-2
									Iga Swiatek
33.		[4]	Paula Badosa Gibert						3-6 6-1 6-4
				Paula Badosa Gibert
34.			Lesia Tsurenko	3-6 7-6(4) 6-3
					Petra Martic
35.			Petra Martic		6-7(5) 6-1 6-2
				Petra Martic
36.			Varvara Gracheva	6-4 7-6(3)
						Victoria Azarenka
37.			Marta Kostyuk			6-3 6-0
				Marta Kostyuk
38.			Mayar Sherif	7-6(2) 6-4
					Victoria Azarenka
39.		[26]	Victoria Azarenka		6-2 6-3
				Victoria Azarenka
40.		[Q]	Ashlyn Krueger	6-1 4-6 6-2
							Karolina Pliskova
41.		[22]	Karolina Pliskova				7-5 6-7(5) 6-2
				Karolina Pliskova
42.			Magda Linette	6-2 4-6 7-6(8)
					Karolina Pliskova
43.			Marie Bouzkova		6-3 6-2
				Marie Bouzkova
44.		[Q]	Linda Noskova	6-2 6-7(3) 6-2
						Karolina Pliskova
45.			Sorana Cirstea			5-7 6-4 6-3
				Sorana Cirstea
46.			Laura Siegemund	6-4 6-4
					Belinda Bencic
47.		[13]	Belinda Bencic		3-6 7-5 6-2
				Belinda Bencic
48.			Andrea Petkovic	6-2 4-6 6-4
								Aryna Sabalenka
49.			Alize Cornet					6-1 7-6(4)
				Alize Cornet
50.		[11]	Emma Raducanu	6-3 6-3
					Alize Cornet
51.			Katerina Siniakova		6-1 1-6 6-3
				Katerina Siniakova
52.			Taylor Townsend	6-4 4-6 6-2
						Danielle Collins
53.		[Q]	Cristina Bucsa			6-4 7-6(9)
				Cristina Bucsa
54.			Kaja Juvan	6-4 6-4
					Danielle Collins
55.		[19]	Danielle Collins		6-2 7-5
				Danielle Collins
56.			Naomi Osaka	7-6(5) 6-3
							Aryna Sabalenka
57.		[Q]	Clara Burel				3-6 6-3 6-2
				Clara Burel
58.		[25]	Elena Rybakina	6-4 6-4
					Clara Burel
59.			Alison Van Uytvanck		6-4 4-6 6-4
				Alison Van Uytvanck
60.		[WC]	Venus Williams	6-1 7-6(5)
						Aryna Sabalenka
61.			Kaia Kanepi			6-0 6-2
				Kaia Kanepi
62.			Tereza Martincova	7-6(4) 6-3
					Aryna Sabalenka
63.		[6]	Aryna Sabalenka		2-6 7-6(8) 6-4
				Aryna Sabalenka
64.		[Q]	Catherine Harrison	6-1 6-3
										Iga Swiatek
65.		[Q]	Daria Snigur							6-2 7-6(5)
				Daria Snigur
66.		[7]	Simona Halep	6-2 0-6 6-4
					Rebecca Marino
67.			Rebecca Marino		6-3 7-6(5)
				Rebecca Marino
68.			Magdalena Frech	6-2 6-3
						Shuai Zhang
69.			Anna Schmiedlova			6-2 6-4
				Anna Schmiedlova
70.			Nadia Podoroska	6-3 6-2
					Shuai Zhang
71.			Shuai Zhang		7-5 6-1
				Shuai Zhang
72.		[30]	Jil Teichmann	6-4 6-2
							Cori Gauff
73.		[20]	Madison Keys				7-5 7-5
				Madison Keys
74.			Dayana Yastremska	7-6(3) 6-3
					Madison Keys
75.			Camila Giorgi		6-4 5-7 7-6(6)
				Camila Giorgi
76.			Anna Bondar	4-6 6-3 6-1
						Cori Gauff
77.			Elena-Gabriela Ruse			6-2 6-3
				Elena-Gabriela Ruse
78.			Daria Gavrilova	3-6 6-2 6-4
					Cori Gauff
79.		[12]	Cori Gauff		6-2 7-6(4)
				Cori Gauff
80.		[Q]	Leolia Jeanjean	6-2 6-3
								Caroline Garcia
81.		[15]	Beatriz Haddad Maia					6-3 6-4
				Beatriz Haddad Maia
82.			Ana Konjuh	6-0 6-0
					Bianca Andreescu
83.			Bianca Andreescu		6-2 6-4
				Bianca Andreescu
84.		[WC]	Harmony Tan	6-0 3-6 6-1
						Caroline Garcia
85.			Anna Kalinskaya			6-3 6-2
				Anna Kalinskaya
86.			Rebecca Peterson	6-4 6-3
					Caroline Garcia
87.		[17]	Caroline Garcia		6-3 6-1
				Caroline Garcia
88.		[LL]	Kamilla Rakhimova	6-2 6-4
							Caroline Garcia
89.		[29]	Alison Riske				6-4 6-1
				Alison Riske
90.		[WC]	Eleana Yu	6-2 6-4
					Alison Riske
91.			Camila Osorio		6-4 6-7(5) 7-6(5)
				Camila Osorio
92.			Ann Li	1-6 6-3 6-1
						Alison Riske
93.			Xiyu Wang			6-4 3-6 6-4
				Xiyu Wang
94.			Diane Parry	5-7 6-3 6-3
					Xiyu Wang
95.		[3]	Maria Sakkari		3-6 7-5 7-5
				Maria Sakkari
96.			Tatjana Maria	6-4 3-6 6-0
									Ons Jabeur
97.		[5]	Ons Jabeur						6-1 6-3
				Ons Jabeur
98.			Madison Brengle	7-5 6-2
					Ons Jabeur
99.		[WC]	Elizabeth Mandlik		7-5 6-2
				Elizabeth Mandlik
100.			Tamara Zidansek	5-7 7-6(3) 6-4
						Ons Jabeur
101.		[Q]	Viktoria Kuzmova			4-6 6-4 6-3
				Viktoria Kuzmova
102.			Sara Sorribes Tormo	6-3 6-4
					Shelby Rogers
103.		[31]	Shelby Rogers		7-5 6-1
				Shelby Rogers
104.			Arantxa Rus	3-6 6-3 6-4
							Ons Jabeur
105.		[18]	Veronika Kudermetova				7-6(1) 6-4
				Veronika Kudermetova
106.			Donna Vekic	7-5 6-3
					Veronika Kudermetova
107.			Maryna Zanevska		6-2 6-3
				Maryna Zanevska
108.		[WC]	Coco Vandeweghe	6-1 7-5
						Veronika Kudermetova
109.			Dalma Galfi			6-2 6-0
				Dalma Galfi
110.			Nuria Parrizas Diaz	6-4 6-3
					Dalma Galfi
111.			Harriet Dart		6-4 6-0
				Harriet Dart
112.		[10]	Daria Kasatkina	7-6(8) 1-6 6-3
								Ons Jabeur
113.		[14]	Leylah Fernandez					6-4 7-6(4)
				Leylah Fernandez
114.			Oceane Dodin	6-3 6-4
					Ludmilla Samsonova
115.			Ludmilla Samsonova		6-3 7-6(3)
				Ludmilla Samsonova
116.		[Q]	Sara Bejlek	6-3 6-1
						Ludmilla Samsonova
117.			Aleksandra Krunic			6-3 6-3
				Aleksandra Krunic
118.		[Q]	Elina Avanesyan	6-4 6-4
					Aleksandra Krunic
119.		[23]	Barbora Krejcikova		2-6 6-4 6-2
				Barbora Krejcikova
120.		[Q]	Fernanda Contreraz Gomez	6-0 6-4
							Ajla Tomljanovic
121.			Evgeniya Rodina				7-6(8) 6-1
				Evgeniya Rodina
122.		[27]	Martina Trevisan	7-5 6-1
					Ajla Tomljanovic
123.			Ajla Tomljanovic		1-6 6-2 7-5
				Ajla Tomljanovic
124.			Karolina Muchova	6-3 7-6(5)
						Ajla Tomljanovic
125.			Serena Williams			7-5 6-7(4) 6-1
				Serena Williams
126.			Danka Kovinic	6-3 6-3
					Serena Williams
127.		[5]	Anett Kontaveit		7-6(4) 2-6 6-2
				Anett Kontaveit
128.			Jaqueline Cristian	6-3 6-0

(default) 17 queries took 18 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` = '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` = (2308) 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, 14371, 10515, 14418, 10499, 14498, 14204, 14576, 10526, 14296, 14567, 14149, 14292, 14327, 14500, 14137, 10527, 14457, 14577, 14351, 14338, 14305, 10446, 14578, 10522, 14232, 14579, 14321, 13878, 14422, 14156, 14180, 14306, 10498, 10465, 14440, 14314, 14456, 10377, 14491, 10523, 14133, 14365, 14545, 10429, 14140, 13572, 10428, 10374, 14481, 13575, 13604, 14488, 14379, 13879, 14183, 14285, 14369, 13570, 10151, 10398, 14385, 14298, 14560, 14580, 10496, 10490, 14325, 11458, 14227, 10503, 14337, 10521, 14279, 10537, 14508, 14361, 10540, 14399, 14542, 14280, 13571, 14290, 14368, 14299, 14302, 10494, 14453, 10489, 14581, 14475, 14419, 14406, 14377, 14159, 11451, 13877, 10400, 14582, 14289, 14295, 14192, 11448, 10488, 14281, 10525, 13605, 10480, 14489, 14490, 14301, 14168, 14421, 14095, 14376, 14583, 13531, 14584, 14356, 14544, 10485, 14420, 11480, 14283, 10150, 13609, 13623, 14505) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	1
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` = 2308	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (154, 20, 168, 72, 53, 197, 149, 68, 54, 179, 13, 173, 92, 194, 21, 50, 42, 74, 96, 153, 133, 196, 10, 178, 104, 43, 94, 36, 164, 126, 63, 169, 189, 29, 121, 84, 59)	37	37	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (154, 20, 168, 72, 53, 197, 149, 68, 54, 179, 13, 173, 92, 194, 21, 50, 42, 74, 96, 153, 133, 196, 10, 178, 104, 43, 94, 36, 164, 126, 63, 169, 189, 29, 121, 84, 59)	37	37	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (14288, 14371, 10515, 14418, 10499, 14498, 14204, 14576, 10526, 14296, 14567, 14149, 14292, 14327, 14500, 14137, 10527, 14457, 14577, 14351, 14338, 14305, 10446, 14578, 10522, 14232, 14579, 14321, 13878, 14422, 14156, 14180, 14306, 10498, 10465, 14440, 14314, 14456, 10377, 14491, 10523, 14133, 14365, 14545, 10429, 14140, 13572, 10428, 10374, 14481, 13575, 13604, 14488, 14379, 13879, 14183, 14285, 14369, 13570, 10151, 10398, 14385, 14298, 14560, 14580, 10496, 10490, 14325, 11458, 14227, 10503, 14337, 10521, 14279, 10537, 14508, 14361, 10540, 14399, 14542, 14280, 13571, 14290, 14368, 14299, 14302, 10494, 14453, 10489, 14581, 14475, 14419, 14406, 14377, 14159, 11451, 13877, 10400, 14582, 14289, 14295, 14192, 11448, 10488, 14281, 10525, 13605, 10480, 14489, 14490, 14301, 14168, 14421, 14095, 14376, 14583, 13531, 14584, 14356, 14544, 10485, 14420, 11480, 14283, 10150, 13609, 13623, 14505)) AND (`Playercontest`.`contest_id` = 2308))	128	128	1
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` = 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 18 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` = '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` = (2308) 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, 14371, 10515, 14418, 10499, 14498, 14204, 14576, 10526, 14296, 14567, 14149, 14292, 14327, 14500, 14137, 10527, 14457, 14577, 14351, 14338, 14305, 10446, 14578, 10522, 14232, 14579, 14321, 13878, 14422, 14156, 14180, 14306, 10498, 10465, 14440, 14314, 14456, 10377, 14491, 10523, 14133, 14365, 14545, 10429, 14140, 13572, 10428, 10374, 14481, 13575, 13604, 14488, 14379, 13879, 14183, 14285, 14369, 13570, 10151, 10398, 14385, 14298, 14560, 14580, 10496, 10490, 14325, 11458, 14227, 10503, 14337, 10521, 14279, 10537, 14508, 14361, 10540, 14399, 14542, 14280, 13571, 14290, 14368, 14299, 14302, 10494, 14453, 10489, 14581, 14475, 14419, 14406, 14377, 14159, 11451, 13877, 10400, 14582, 14289, 14295, 14192, 11448, 10488, 14281, 10525, 13605, 10480, 14489, 14490, 14301, 14168, 14421, 14095, 14376, 14583, 13531, 14584, 14356, 14544, 10485, 14420, 11480, 14283, 10150, 13609, 13623, 14505) 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` = 2308

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (14288, 14371, 10515, 14418, 10499, 14498, 14204, 14576, 10526, 14296, 14567, 14149, 14292, 14327, 14500, 14137, 10527, 14457, 14577, 14351, 14338, 14305, 10446, 14578, 10522, 14232, 14579, 14321, 13878, 14422, 14156, 14180, 14306, 10498, 10465, 14440, 14314, 14456, 10377, 14491, 10523, 14133, 14365, 14545, 10429, 14140, 13572, 10428, 10374, 14481, 13575, 13604, 14488, 14379, 13879, 14183, 14285, 14369, 13570, 10151, 10398, 14385, 14298, 14560, 14580, 10496, 10490, 14325, 11458, 14227, 10503, 14337, 10521, 14279, 10537, 14508, 14361, 10540, 14399, 14542, 14280, 13571, 14290, 14368, 14299, 14302, 10494, 14453, 10489, 14581, 14475, 14419, 14406, 14377, 14159, 11451, 13877, 10400, 14582, 14289, 14295, 14192, 11448, 10488, 14281, 10525, 13605, 10480, 14489, 14490, 14301, 14168, 14421, 14095, 14376, 14583, 13531, 14584, 14356, 14544, 10485, 14420, 11480, 14283, 10150, 13609, 13623, 14505)) AND (`Playercontest`.`contest_id` = 2308))

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