Australian Open 2021 Women's Singles (February 8 - February 20)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Ashleigh Barty
				Ashleigh Barty
2.			Danka Kovinic	6-0 6-0
					Ashleigh Barty
3.		[WC]	Daria Gavrilova		6-1 7-6(7)
				Daria Gavrilova
4.			Sara Sorribes Tormo	6-1 7-5
						Ashleigh Barty
5.			Barbora Krejcikova			6-2 6-4
				Barbora Krejcikova
6.			Saisai Zheng	6-3 2-6 6-2
					Ekaterina Alexandrova
7.		[29]	Ekaterina Alexandrova		6-3 7-6(4)
				Ekaterina Alexandrova
8.			Martina Trevisan	6-3 6-4
							Ashleigh Barty
9.		[21]	Anett Kontaveit				6-3 6-4
				Anett Kontaveit
10.			Aliaksandra Sasnovich	7-5 6-2
					Anett Kontaveit
11.			Heather Watson		6-7(5) 6-4 6-2
				Heather Watson
12.			Kristyna Pliskova	7-6(4) 7-6(3)
						Shelby Rogers
13.			Shelby Rogers			6-4 6-3
				Shelby Rogers
14.		[Q]	Francesca Jones	6-4 6-1
					Shelby Rogers
15.		[Q]	Olga Danilovic		6-2 6-3
				Olga Danilovic
16.		[16]	Petra Martic	7-5 3-6 6-4
								Karolina Muchova
17.		[11]	Belinda Bencic					1-6 6-3 6-2
				Belinda Bencic
18.			Lauren Davis	6-3 4-6 6-1
					Belinda Bencic
19.			Svetlana Kuznetsova		7-5 2-6 6-4
				Svetlana Kuznetsova
20.			Barbora Strycova	6-2 6-2
						Elise Mertens
21.			Lin Zhu			6-2 6-1
				Lin Zhu
22.		[Q]	Whitney Osuigwe	6-1 6-1
					Elise Mertens
23.		[18]	Elise Mertens		7-6(8) 6-1
				Elise Mertens
24.			Leylah Fernandez	6-1 6-3
							Karolina Muchova
25.		[25]	Karolina Muchova				7-6(5) 7-5
				Karolina Muchova
26.			Jelena Ostapenko	7-5 6-2
					Karolina Muchova
27.			Mona Barthel		6-4 6-1
				Mona Barthel
28.		[Q]	Elisabetta Cocciaretto	3-6 6-4 6-4
						Karolina Muchova
29.			Danielle Collins			7-5 7-5
				Danielle Collins
30.			Ana Bogdan	6-3 6-1
					Karolina Pliskova
31.		[6]	Karolina Pliskova		7-5 6-2
				Karolina Pliskova
32.			Jasmine Paolini	6-0 6-2
									Jennifer Brady
33.		[4]	Sofia Kenin						6-4 3-6 6-4
				Sofia Kenin
34.		[WC]	Maddison Inglis	7-5 6-4
					Kaia Kanepi
35.			Kaia Kanepi		6-3 6-2
				Kaia Kanepi
36.			Anastasija Sevastova	6-3 6-1
						Donna Vekic
37.			Nadia Podoroska			5-7 7-6(2) 6-4
				Nadia Podoroska
38.			Christina McHale	6-4 6-4
					Donna Vekic
39.		[28]	Donna Vekic		6-2 6-2
				Donna Vekic
40.			Yafan Wang	4-6 6-3 6-4
							Jennifer Brady
41.		[22]	Jennifer Brady				6-1 7-5
				Jennifer Brady
42.			Aliona Bolsova	6-1 6-3
					Jennifer Brady
43.			Madison Brengle		6-1 6-2
				Madison Brengle
44.		[WC]	Arina Rodionova	6-1 6-2
						Jennifer Brady
45.		[Q]	Mayar Sherif			6-1 6-3
				Mayar Sherif
46.		[Q]	Chloe Paquet	7-5 7-5
					Kaja Juvan
47.		[Q]	Kaja Juvan		3-6 7-6(2) 6-3
				Kaja Juvan
48.		[13]	Johanna Konta	4-6 2-0 rtd.
								Jennifer Brady
49.			Jessica Pegula					4-6 6-2 6-1
				Jessica Pegula
50.		[12]	Victoria Azarenka	7-5 6-4
					Jessica Pegula
51.		[WC]	Samantha Stosur		6-0 6-1
				Samantha Stosur
52.		[WC]	Destanee Aiava	6-4 6-4
						Jessica Pegula
53.		[Q]	Nao Hibino			6-2 6-1
				Nao Hibino
54.		[WC]	Astra Sharma	2-6 6-3 7-5
					Kristina Mladenovic
55.			Kristina Mladenovic		7-5 6-1
				Kristina Mladenovic
56.		[20]	Maria Sakkari	6-2 0-6 6-3
							Jessica Pegula
57.		[26]	Yulia Putintseva				6-4 3-6 6-3
				Yulia Putintseva
58.			Sloane Stephens	4-6 6-2 6-3
					Yulia Putintseva
59.			Alison Van Uytvanck		6-4 1-6 6-2
				Alison Van Uytvanck
60.		[Q]	Clara Burel	4-6 6-3 6-4
						Elina Svitolina
61.			Cori Gauff			6-4 6-0
				Cori Gauff
62.			Jil Teichmann	6-3 6-2
					Elina Svitolina
63.		[5]	Elina Svitolina		6-4 6-3
				Elina Svitolina
64.			Marie Bouzkova	6-3 7-6(5)
										Naomi Osaka
65.		[8]	Bianca Andreescu							6-4 6-3
				Bianca Andreescu
66.		[LL]	Mihaela Buzarnescu	6-2 4-6 6-3
					Su-Wei Hsieh
67.			Su-Wei Hsieh		6-3 6-2
				Su-Wei Hsieh
68.		[Q]	Tsvetana Pironkova	7-5 6-2
						Su-Wei Hsieh
69.			Venus Williams			6-4 2-6 7-5
				Venus Williams
70.			Kirsten Flipkens	7-5 6-2
					Sara Errani
71.		[Q]	Sara Errani		6-1 6-0
				Sara Errani
72.		[30]	Qiang Wang	2-6 6-4 6-4
							Su-Wei Hsieh
73.		[19]	Marketa Vondrousova				6-4 6-2
				Marketa Vondrousova
74.			Rebecca Peterson	2-6 7-5 7-5
					Marketa Vondrousova
75.		[Q]	Rebecca Marino		6-1 7-5
				Rebecca Marino
76.		[WC]	Kimberly Birrell	6-0 7-6(9)
						Marketa Vondrousova
77.			Sorana Cirstea			6-2 6-4
				Sorana Cirstea
78.			Patricia Maria Tig	6-2 6-1
					Sorana Cirstea
79.		[9]	Petra Kvitova		6-4 1-6 6-1
				Petra Kvitova
80.		[Q]	Greet Minnen	6-3 6-4
								Naomi Osaka
81.		[14]	Garbine Muguruza					6-2 6-2
				Garbine Muguruza
82.		[LL]	Margarita Gasparyan	6-4 6-0
					Garbine Muguruza
83.		[Q]	Ludmilla Samsonova		6-3 6-1
				Ludmilla Samsonova
84.			Paula Badosa Gibert	6-7(4) 7-6(4) 7-5
						Garbine Muguruza
85.			Zarina Diyas			6-1 6-1
				Zarina Diyas
86.			Tamara Zidansek	6-2 7-5
					Zarina Diyas
87.			Bernarda Pera		6-4 3-6 6-3
				Bernarda Pera
88.		[23]	Angelique Kerber	6-0 6-4
							Naomi Osaka
89.		[27]	Ons Jabeur				4-6 6-4 7-5
				Ons Jabeur
90.			Andrea Petkovic	6-3 3-6 6-4
					Ons Jabeur
91.		[LL]	Anna Schmiedlova		6-3 6-2
				Anna Schmiedlova
92.			Hibi Mayo	7-6(2) 6-4
						Naomi Osaka
93.			Caroline Garcia			6-3 6-2
				Caroline Garcia
94.			Polona Hercog	7-6(6) 6-3
					Naomi Osaka
95.		[3]	Naomi Osaka		6-2 6-3
				Naomi Osaka
96.			Anastasia Pavlyuchenkova	6-1 6-2
									Naomi Osaka
97.		[7]	Aryna Sabalenka						6-3 6-4
				Aryna Sabalenka
98.			Viktoria Kuzmova	6-0 6-4
					Aryna Sabalenka
99.			Daria Kasatkina		7-6(5) 6-3
				Daria Kasatkina
100.			Katie Boulter	6-1 6-4
						Aryna Sabalenka
101.			Alize Cornet			6-3 6-1
				Alize Cornet
102.		[Q]	Valeria Savinykh	6-2 4-6 7-6(7)
					Ann Li
103.			Ann Li		6-2 7-6(6)
				Ann Li
104.		[31]	Shuai Zhang	6-2 6-0
							Serena Williams
105.			Anastasia Potapova				6-4 2-6 6-4
				Anastasia Potapova
106.		[24]	Alison Riske	6-2 6-1
					Anastasia Potapova
107.		[Q]	Timea Babos		6-2 6-4
				Timea Babos
108.		[LL]	Ysaline Bonaventure	7-6(0) 6-4
						Serena Williams
109.			Nina Stojanovic			7-6(5) 6-2
				Nina Stojanovic
110.			Irina-Camelia Begu	6-3 6-4
					Serena Williams
111.		[10]	Serena Williams		6-3 6-0
				Serena Williams
112.			Laura Siegemund	6-1 6-1
								Serena Williams
113.		[15]	Iga Swiatek					6-3 6-3
				Iga Swiatek
114.			Arantxa Rus	6-1 6-3
					Iga Swiatek
115.			Camila Giorgi		6-2 6-4
				Camila Giorgi
116.			Yaroslava Shvedova	6-3 6-3
						Iga Swiatek
117.			Fiona Ferro			6-4 6-3
				Fiona Ferro
118.			Katerina Siniakova	6-7(5) 6-2 6-4
					Fiona Ferro
119.		[17]	Elena Rybakina		6-4 6-4
				Elena Rybakina
120.			Vera Zvonareva	4-6 6-4 6-4
							Simona Halep
121.		[32]	Veronika Kudermetova				3-6 6-1 6-4
				Veronika Kudermetova
122.			Marta Kostyuk	6-2 7-6(5)
					Veronika Kudermetova
123.			Varvara Gracheva		5-7 6-2 6-2
				Varvara Gracheva
124.			Anna Blinkova	6-1 3-6 7-6(7)
						Simona Halep
125.			Ajla Tomljanovic			6-1 6-3
				Ajla Tomljanovic
126.			Misaki Doi	6-2 6-1
					Simona Halep
127.		[2]	Simona Halep		4-6 6-4 7-5
				Simona Halep
128.		[WC]	Lizette Cabrera	6-2 6-1

(default) 17 queries took 24 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` = 'australian-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` = (1)	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` = (1)	1	1	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` = (1)	1	1	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` = 'australian-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` = (3) ORDER BY `Contest`.`year` ASC	98	98	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` = 1 AND `Contest`.`category_id` = 3 AND `Contest`.`slug` = '2021' 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` = (2283) 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 (10505, 13609, 10540, 14192, 14356, 13882, 14204, 14420, 13623, 13878, 10510, 10532, 11448, 14466, 14467, 10465, 13572, 10499, 10255, 10318, 14139, 14291, 14232, 14421, 14283, 14137, 10511, 14422, 13879, 14231, 10523, 14371, 14149, 14185, 10398, 10476, 14227, 10453, 10525, 14181, 14310, 14374, 10400, 10492, 14456, 14323, 14379, 11479, 14156, 10377, 10270, 14293, 14179, 14300, 10452, 14159, 10526, 10515, 13570, 14285, 14399, 14337, 10534, 14365, 14290, 14282, 10414, 10363, 10151, 10410, 10417, 13875, 14304, 14302, 10490, 14186, 10429, 14203, 10446, 14418, 10527, 14130, 14376, 14306, 13574, 14289, 14305, 10413, 13877, 10428, 11458, 14157, 10494, 10478, 14183, 10445, 14298, 14295, 14168, 14297, 10374, 10519, 14419, 10503, 14292, 10489, 10531, 14309, 14407, 10522, 10150, 14140, 14288, 10488, 10537, 10420, 13602, 13575, 14369, 10281, 14281, 14314, 14440, 14294, 11480, 10538, 10496, 14346) 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` = 2283	128	128	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (42, 197, 196, 53, 50, 21, 92, 173, 13, 153, 179, 149, 194, 164, 72, 96, 104, 168, 154, 20, 74, 133, 10, 31, 178, 68, 94, 36, 126, 63, 169, 189, 181, 84, 59)	35	35	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (42, 197, 196, 53, 50, 21, 92, 173, 13, 153, 179, 149, 194, 164, 72, 96, 104, 168, 154, 20, 74, 133, 10, 31, 178, 68, 94, 36, 126, 63, 169, 189, 181, 84, 59)	35	35	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10505, 13609, 10540, 14192, 14356, 13882, 14204, 14420, 13623, 13878, 10510, 10532, 11448, 14466, 14467, 10465, 13572, 10499, 10255, 10318, 14139, 14291, 14232, 14421, 14283, 14137, 10511, 14422, 13879, 14231, 10523, 14371, 14149, 14185, 10398, 10476, 14227, 10453, 10525, 14181, 14310, 14374, 10400, 10492, 14456, 14323, 14379, 11479, 14156, 10377, 10270, 14293, 14179, 14300, 10452, 14159, 10526, 10515, 13570, 14285, 14399, 14337, 10534, 14365, 14290, 14282, 10414, 10363, 10151, 10410, 10417, 13875, 14304, 14302, 10490, 14186, 10429, 14203, 10446, 14418, 10527, 14130, 14376, 14306, 13574, 14289, 14305, 10413, 13877, 10428, 11458, 14157, 10494, 10478, 14183, 10445, 14298, 14295, 14168, 14297, 10374, 10519, 14419, 10503, 14292, 10489, 10531, 14309, 14407, 10522, 10150, 14140, 14288, 10488, 10537, 10420, 13602, 13575, 14369, 10281, 14281, 14314, 14440, 14294, 11480, 10538, 10496, 14346)) AND (`Playercontest`.`contest_id` = 2283))	128	128	2
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 3 ORDER BY `Contest`.`date_from` ASC	98	98	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 2021	10	10	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (17, 19, 1, 3, 22, 12, 14, 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 24 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` = 'australian-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` = (1)

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

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

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` = 1 AND `Contest`.`category_id` = 3 AND `Contest`.`slug` = '2021' 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` = (2283) 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 (10505, 13609, 10540, 14192, 14356, 13882, 14204, 14420, 13623, 13878, 10510, 10532, 11448, 14466, 14467, 10465, 13572, 10499, 10255, 10318, 14139, 14291, 14232, 14421, 14283, 14137, 10511, 14422, 13879, 14231, 10523, 14371, 14149, 14185, 10398, 10476, 14227, 10453, 10525, 14181, 14310, 14374, 10400, 10492, 14456, 14323, 14379, 11479, 14156, 10377, 10270, 14293, 14179, 14300, 10452, 14159, 10526, 10515, 13570, 14285, 14399, 14337, 10534, 14365, 14290, 14282, 10414, 10363, 10151, 10410, 10417, 13875, 14304, 14302, 10490, 14186, 10429, 14203, 10446, 14418, 10527, 14130, 14376, 14306, 13574, 14289, 14305, 10413, 13877, 10428, 11458, 14157, 10494, 10478, 14183, 10445, 14298, 14295, 14168, 14297, 10374, 10519, 14419, 10503, 14292, 10489, 10531, 14309, 14407, 10522, 10150, 14140, 14288, 10488, 10537, 10420, 13602, 13575, 14369, 10281, 14281, 14314, 14440, 14294, 11480, 10538, 10496, 14346) 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` = 2283

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10505, 13609, 10540, 14192, 14356, 13882, 14204, 14420, 13623, 13878, 10510, 10532, 11448, 14466, 14467, 10465, 13572, 10499, 10255, 10318, 14139, 14291, 14232, 14421, 14283, 14137, 10511, 14422, 13879, 14231, 10523, 14371, 14149, 14185, 10398, 10476, 14227, 10453, 10525, 14181, 14310, 14374, 10400, 10492, 14456, 14323, 14379, 11479, 14156, 10377, 10270, 14293, 14179, 14300, 10452, 14159, 10526, 10515, 13570, 14285, 14399, 14337, 10534, 14365, 14290, 14282, 10414, 10363, 10151, 10410, 10417, 13875, 14304, 14302, 10490, 14186, 10429, 14203, 10446, 14418, 10527, 14130, 14376, 14306, 13574, 14289, 14305, 10413, 13877, 10428, 11458, 14157, 10494, 10478, 14183, 10445, 14298, 14295, 14168, 14297, 10374, 10519, 14419, 10503, 14292, 10489, 10531, 14309, 14407, 10522, 10150, 14140, 14288, 10488, 10537, 10420, 13602, 13575, 14369, 10281, 14281, 14314, 14440, 14294, 11480, 10538, 10496, 14346)) AND (`Playercontest`.`contest_id` = 2283))

128

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

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

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