Wimbledon 2024 Ladies' Singles (July 1 - July 13)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Iga Swiatek
				Iga Swiatek
2.			Sofia Kenin	6-3 6-4
					Iga Swiatek
3.			Petra Martic		6-4 6-3
				Petra Martic
4.		[WC]	Francesca Jones	3-6 6-1 6-2
						Yulia Putintseva
5.			Yulia Putintseva			3-6 6-1 6-2
				Yulia Putintseva
6.		[WC]	Angelique Kerber	7-5 6-3
					Yulia Putintseva
7.		[27]	Katerina Siniakova		6-0 4-6 6-2
				Katerina Siniakova
8.		[Q]	Marina Stakusic	6-4 6-2
							Jelena Ostapenko
9.		[23]	Caroline Garcia				6-2 6-3
				Caroline Garcia
10.			Anna Blinkova	6-4 7-5
					Bernarda Pera
11.			Bernarda Pera		3-6 6-3 6-4
				Bernarda Pera
12.			Anastasia Potapova	6-7(4) 6-4 7-6(6)
						Jelena Ostapenko
13.		[Q]	Daria Snigur			6-1 6-3
				Daria Snigur
14.			Oceane Dodin	6-4 6-0
					Jelena Ostapenko
15.		[13]	Jelena Ostapenko		6-3 6-0
				Jelena Ostapenko
16.		[WC]	Ajla Tomljanovic	6-1 6-2
								Barbora Krejcikova
17.		[11]	Danielle Collins					6-4 7-6(4)
				Danielle Collins
18.			Clara Tauson	6-3 7-6(4)
					Danielle Collins
19.		[Q]	Dalma Galfi		6-3 6-4
				Dalma Galfi
20.			Mayar Sherif	6-1 6-2
						Danielle Collins
21.			Camila Osorio			6-4 6-4
				Camila Osorio
22.			Lauren Davis	6-3 6-1
					Beatriz Haddad Maia
23.		[20]	Beatriz Haddad Maia		3-0 30-0 rtd.
				Beatriz Haddad Maia
24.			Magdalena Frech	7-5 6-3
							Barbora Krejcikova
25.		[31]	Barbora Krejcikova				7-5 6-3
				Barbora Krejcikova
26.			Veronika Kudermetova	7-6(4) 6-7(1) 7-5
					Barbora Krejcikova
27.		[Q]	Katie Volynets		7-6(6) 7-6(5)
				Katie Volynets
28.			Maria Lourdes Carle	6-2 7-5
						Barbora Krejcikova
29.			Cristina Bucsa			6-0 4-3 rtd.
				Cristina Bucsa
30.			Ana Bogdan	6-4 4-6 7-6(5)
					Jessica Bouzas Maneiro
31.			Jessica Bouzas Maneiro		7-6(1) 6-3
				Jessica Bouzas Maneiro
32.		[6]	Marketa Vondrousova	6-4 6-2
									Barbora Krejcikova
33.		[4]	Elena Rybakina						3-6 6-3 6-4
				Elena Rybakina
34.		[Q]	Elena-Gabriela Ruse	6-3 6-1
					Elena Rybakina
35.			Laura Siegemund		6-3 3-6 6-3
				Laura Siegemund
36.			Kateryna Kozlova	6-4 6-1
						Elena Rybakina
37.		[WC]	Caroline Wozniacki			6-0 6-1
				Caroline Wozniacki
38.		[Q]	Alycia Parks	6-2 6-0
					Caroline Wozniacki
39.		[30]	Leylah Fernandez		6-3 2-6 7-5
				Leylah Fernandez
40.			Lucia Bronzetti	6-4 6-3
							Elena Rybakina
41.		[17]	Anna Kalinskaya				6-3 3-0 rtd.
				Anna Kalinskaya
42.		[Q]	Panna Udvardy	6-3 6-2
					Anna Kalinskaya
43.			Marie Bouzkova		6-4 6-1
				Marie Bouzkova
44.			Julia Riera	6-2 6-1
						Anna Kalinskaya
45.			Elina Avanesyan			7-6(4) 6-2
				Elina Avanesyan
46.			Anhelina Kalinina	6-2 6-3
					Ludmilla Samsonova
47.		[15]	Ludmilla Samsonova		6-3 6-3
				Ludmilla Samsonova
48.			Rebeka Masarova	6-3 4-6 6-2
								Elena Rybakina
49.		[10]	Ons Jabeur					6-3 6-2
				Ons Jabeur
50.			Moyuka Uchijima	6-3 6-1
					Ons Jabeur
51.		[Q]	Robin Montgomery		6-1 7-5
				Robin Montgomery
52.		[Q]	Olivia Gadecki	6-4 6-4
						Elina Svitolina
53.			Jule Niemeier			6-1 7-6(4)
				Jule Niemeier
54.			Viktorija Golubic	6-2 6-1
					Elina Svitolina
55.		[21]	Elina Svitolina		6-3 6-4
				Elina Svitolina
56.			Magda Linette	7-5 6-7(9) 6-3
							Elina Svitolina
57.		[32]	Katie Boulter				6-2 6-1
				Katie Boulter
58.			Tatjana Maria	7-6(6) 7-5
					Harriet Dart
59.			Harriet Dart		4-6 6-1 7-6(8)
				Harriet Dart
60.		[Q]	Zhuoxuan Bai	6-4 6-0
						Xinyu Wang
61.			Xinyu Wang			2-6 7-5 6-3
				Xinyu Wang
62.			Viktoriya Tomova	7-6(4) 3-6 6-0
					Xinyu Wang
63.		[5]	Jessica Pegula		6-4 6-7(7) 6-1
				Jessica Pegula
64.			Ashlyn Krueger	6-2 6-0
										Barbora Krejcikova
65.		[Q]	Lulu Radovcic							6-2 2-6 6-4
				Lulu Radovcic
66.		[8]	Qinwen Zheng	4-6 6-2 6-4
					Lulu Radovcic
67.		[Q]	Yuliia Starodubtseva		4-6 6-3 6-2
				Yuliia Starodubtseva
68.			Alison Van Uytvanck	6-4 6-3
						Lulu Radovcic
69.			Lin Zhu			7-6(4) 7-6(6)
				Lin Zhu
70.			Irina-Camelia Begu	6-0 6-4
					Lin Zhu
71.		[25]	Anastasia Pavlyuchenkova		6-4 6-3
				Anastasia Pavlyuchenkova
72.			Taylor Townsend	7-6(4) 6-1
							Lulu Radovcic
73.		[WC]	Emma Raducanu				6-2 5-7 6-2
				Emma Raducanu
74.		[LL]	Renata Zarazua	7-6(0) 6-3
					Emma Raducanu
75.			Elise Mertens		6-1 6-2
				Elise Mertens
76.			Nao Hibino	2-6 6-2 6-4
						Emma Raducanu
77.			Arantxa Rus			6-2 6-3
				Arantxa Rus
78.			Yue Yuan	6-2 6-3
					Maria Sakkari
79.			Maria Sakkari		7-5 6-3
				Maria Sakkari
80.		[Q]	McCartney Kessler	6-3 6-1
								Donna Vekic
81.		[14]	Daria Kasatkina					5-7 6-4 6-1
				Daria Kasatkina
82.			Shuai Zhang	6-3 6-0
					Daria Kasatkina
83.		[WC]	Yuriko Miyazaki		6-0 6-0
				Yuriko Miyazaki
84.			Tamara Korpatsch	6-2 6-1
						Paula Badosa Gibert
85.			Paula Badosa Gibert			7-6(6) 4-6 6-4
				Paula Badosa Gibert
86.			Karolina Muchova	6-3 6-2
					Paula Badosa Gibert
87.			Brenda Fruhvirtova		6-4 6-2
				Brenda Fruhvirtova
88.		[24]	Mirra Andreeva	1-6 6-3 6-2
							Donna Vekic
89.		[28]	Dayana Yastremska				6-2 1-6 6-4
				Dayana Yastremska
90.			Nadia Podoroska	6-1 7-6(1)
					Dayana Yastremska
91.			Varvara Gracheva		3-6 6-4 7-6(5)
				Varvara Gracheva
92.			Lesia Tsurenko	6-3 6-1
						Donna Vekic
93.			Donna Vekic			7-6(4) 6-7(3) 6-1
				Donna Vekic
94.			Xiyu Wang	3-6 6-3 6-4
					Donna Vekic
95.		[LL]	Erika Andreeva		6-2 6-3
				Erika Andreeva
96.			Emina Bektas	7-6(5) 3-6 6-3
									Jasmine Paolini
97.		[7]	Jasmine Paolini						2-6 6-4 7-6(8)
				Jasmine Paolini
98.			Sara Sorribes Tormo	7-5 6-3
					Jasmine Paolini
99.			Greet Minnen		7-6(5) 6-2
				Greet Minnen
100.		[WC]	Heather Watson	7-5 6-4
						Jasmine Paolini
101.			Bianca Andreescu			7-6(4) 6-1
				Bianca Andreescu
102.			Jaqueline Cristian	6-4 6-2
					Bianca Andreescu
103.		[26]	Linda Noskova		6-3 7-6(5)
				Linda Noskova
104.			Sara Errani	7-6(3) 6-1
							Jasmine Paolini
105.		[18]	Marta Kostyuk				6-3 6-7(6) 5-5 15-15 rtd.
				Marta Kostyuk
106.			Rebecca Sramkova	6-3 6-2
					Marta Kostyuk
107.			Daria Gavrilova		4-6 7-6(2) 6-4
				Daria Gavrilova
108.			Peyton Stearns	6-4 6-2
						Madison Keys
109.			Yafan Wang			6-4 6-3
				Yafan Wang
110.			Anna Schmiedlova	6-0 3-6 6-4
					Madison Keys
111.		[12]	Madison Keys		6-2 6-2
				Madison Keys
112.			Martina Trevisan	6-4 7-6(4)
								Jasmine Paolini
113.			Sloane Stephens					6-2 6-1
				Sloane Stephens
114.		[LL]	Elsa Jacquemot	6-3 6-3
					Diana Shnaider
115.			Diana Shnaider		6-1 6-1
				Diana Shnaider
116.			Karolina Pliskova	4-6 6-4 7-5
						Emma Navarro
117.		[WC]	Naomi Osaka			2-6 6-3 6-4
				Naomi Osaka
118.			Diane Parry	6-1 1-6 6-4
					Emma Navarro
119.		[19]	Emma Navarro		6-4 6-1
				Emma Navarro
120.			Qiang Wang	6-0 6-2
							Emma Navarro
121.		[Q]	Sonay Kartal				6-4 6-3
				Sonay Kartal
122.		[29]	Sorana Cirstea	3-6 6-2 6-0
					Sonay Kartal
123.			Clara Burel		6-3 5-7 6-3
				Clara Burel
124.		[Q]	Eva Lys	6-2 6-4
						Cori Gauff
125.		[Q]	Anca Todoni			6-4 6-0
				Anca Todoni
126.		[LL]	Olga Danilovic	7-5 6-1
					Cori Gauff
127.		[2]	Cori Gauff		6-2 6-1
				Cori Gauff
128.			Caroline Dolehide	6-1 6-2

(default) 17 queries took 25 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` = 'wimbledon' 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` = (3)	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` = (3)	4	4	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` = (3)	57	57	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` = 'wimbledon' 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` = (19) ORDER BY `Contest`.`year` ASC	130	130	3
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` = 3 AND `Contest`.`category_id` = 19 AND `Contest`.`slug` = '2024' 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` = (2334) 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 (14288, 14149, 10465, 14466, 10526, 10413, 13575, 14769, 10494, 14294, 14305, 14292, 14580, 14095, 14137, 11480, 13879, 14457, 14489, 14456, 14475, 10499, 14280, 14325, 14356, 14281, 14404, 14756, 14488, 14231, 14635, 14304, 14369, 14361, 14140, 14155, 10440, 14493, 14421, 14498, 14299, 14504, 14365, 14757, 14584, 14338, 14376, 14492, 13877, 14585, 14438, 14588, 14567, 14180, 10534, 14133, 14297, 11451, 14301, 14634, 14351, 14328, 14156, 14491, 14692, 14500, 14696, 13570, 14139, 10522, 10445, 13604, 14481, 14454, 14232, 14179, 10488, 14579, 14159, 14691, 14168, 10503, 14565, 14437, 14306, 14283, 14601, 14615, 14279, 14227, 14440, 10498, 10525, 14406, 14578, 14509, 14371, 14192, 14418, 10510, 14290, 14505, 14545, 10417, 14314, 14345, 10540, 14576, 14181, 11458, 10521, 14420, 10515, 14455, 14590, 10523, 14183, 14377, 14494, 13875, 14559, 10429, 14285, 14587, 14770, 14467, 14399, 14324) 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` = 2334	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (153, 164, 196, 197, 68, 92, 36, 149, 53, 13, 84, 173, 179, 29, 94, 189, 194, 154, 72, 50, 21, 43, 104, 10, 96, 135, 133, 74, 168, 59, 54, 31, 42, 121)	34	34	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (153, 164, 196, 197, 68, 92, 36, 149, 53, 13, 84, 173, 179, 29, 94, 189, 194, 154, 72, 50, 21, 43, 104, 10, 96, 135, 133, 74, 168, 59, 54, 31, 42, 121)	34	34	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (14288, 14149, 10465, 14466, 10526, 10413, 13575, 14769, 10494, 14294, 14305, 14292, 14580, 14095, 14137, 11480, 13879, 14457, 14489, 14456, 14475, 10499, 14280, 14325, 14356, 14281, 14404, 14756, 14488, 14231, 14635, 14304, 14369, 14361, 14140, 14155, 10440, 14493, 14421, 14498, 14299, 14504, 14365, 14757, 14584, 14338, 14376, 14492, 13877, 14585, 14438, 14588, 14567, 14180, 10534, 14133, 14297, 11451, 14301, 14634, 14351, 14328, 14156, 14491, 14692, 14500, 14696, 13570, 14139, 10522, 10445, 13604, 14481, 14454, 14232, 14179, 10488, 14579, 14159, 14691, 14168, 10503, 14565, 14437, 14306, 14283, 14601, 14615, 14279, 14227, 14440, 10498, 10525, 14406, 14578, 14509, 14371, 14192, 14418, 10510, 14290, 14505, 14545, 10417, 14314, 14345, 10540, 14576, 14181, 11458, 10521, 14420, 10515, 14455, 14590, 10523, 14183, 14377, 14494, 13875, 14559, 10429, 14285, 14587, 14770, 14467, 14399, 14324)) AND (`Playercontest`.`contest_id` = 2334))	128	128	2
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 19 ORDER BY `Contest`.`date_from` ASC	130	130	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 2024	10	10	2
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (1, 3, 2, 4, 19, 17, 12, 14, 22, 24) 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 25 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` = 'wimbledon' 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` = (3)

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

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

130

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` = 3 AND `Contest`.`category_id` = 19 AND `Contest`.`slug` = '2024' 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` = (2334) 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, 14149, 10465, 14466, 10526, 10413, 13575, 14769, 10494, 14294, 14305, 14292, 14580, 14095, 14137, 11480, 13879, 14457, 14489, 14456, 14475, 10499, 14280, 14325, 14356, 14281, 14404, 14756, 14488, 14231, 14635, 14304, 14369, 14361, 14140, 14155, 10440, 14493, 14421, 14498, 14299, 14504, 14365, 14757, 14584, 14338, 14376, 14492, 13877, 14585, 14438, 14588, 14567, 14180, 10534, 14133, 14297, 11451, 14301, 14634, 14351, 14328, 14156, 14491, 14692, 14500, 14696, 13570, 14139, 10522, 10445, 13604, 14481, 14454, 14232, 14179, 10488, 14579, 14159, 14691, 14168, 10503, 14565, 14437, 14306, 14283, 14601, 14615, 14279, 14227, 14440, 10498, 10525, 14406, 14578, 14509, 14371, 14192, 14418, 10510, 14290, 14505, 14545, 10417, 14314, 14345, 10540, 14576, 14181, 11458, 10521, 14420, 10515, 14455, 14590, 10523, 14183, 14377, 14494, 13875, 14559, 10429, 14285, 14587, 14770, 14467, 14399, 14324) 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` = 2334

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (14288, 14149, 10465, 14466, 10526, 10413, 13575, 14769, 10494, 14294, 14305, 14292, 14580, 14095, 14137, 11480, 13879, 14457, 14489, 14456, 14475, 10499, 14280, 14325, 14356, 14281, 14404, 14756, 14488, 14231, 14635, 14304, 14369, 14361, 14140, 14155, 10440, 14493, 14421, 14498, 14299, 14504, 14365, 14757, 14584, 14338, 14376, 14492, 13877, 14585, 14438, 14588, 14567, 14180, 10534, 14133, 14297, 11451, 14301, 14634, 14351, 14328, 14156, 14491, 14692, 14500, 14696, 13570, 14139, 10522, 10445, 13604, 14481, 14454, 14232, 14179, 10488, 14579, 14159, 14691, 14168, 10503, 14565, 14437, 14306, 14283, 14601, 14615, 14279, 14227, 14440, 10498, 10525, 14406, 14578, 14509, 14371, 14192, 14418, 10510, 14290, 14505, 14545, 10417, 14314, 14345, 10540, 14576, 14181, 11458, 10521, 14420, 10515, 14455, 14590, 10523, 14183, 14377, 14494, 13875, 14559, 10429, 14285, 14587, 14770, 14467, 14399, 14324)) AND (`Playercontest`.`contest_id` = 2334))

128

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

130

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

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