Wimbledon 2017 Ladies' Singles (July 3 - July 15)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Angelique Kerber
				Angelique Kerber
2.		[Q]	Irina Falconi	6-4 6-4
					Angelique Kerber
3.			Kirsten Flipkens		7-5 7-5
				Kirsten Flipkens
4.			Misaki Doi	6-4 6-3
						Angelique Kerber
5.			Shelby Rogers			4-6 7-6(2) 6-4
				Shelby Rogers
6.			Julia Boserup	6-3 4-6 6-3
					Shelby Rogers
7.		[32]	Lucie Safarova		6-7(4) 6-4 6-3
				Lucie Safarova
8.			Oceane Dodin	6-2 6-2
							Garbine Muguruza
9.			Sorana Cirstea				4-6 6-4 6-4
				Sorana Cirstea
10.		[23]	Kiki Bertens	7-6(4) 7-5
					Sorana Cirstea
11.		[WC]	Bethanie Mattek-Sands		4-6 7-6(4) rtd.
				Bethanie Mattek-Sands
12.			Magda Linette	1-6 6-2 6-3
						Garbine Muguruza
13.			Yanina Wickmayer			6-2 6-2
				Yanina Wickmayer
14.			Kateryna Bondarenko	6-2 7-5
					Garbine Muguruza
15.		[14]	Garbine Muguruza		6-2 6-4
				Garbine Muguruza
16.			Ekaterina Alexandrova	6-2 6-4
								Garbine Muguruza
17.		[9]	Agnieszka Radwanska					6-3 6-4
				Agnieszka Radwanska
18.			Jelena Jankovic	7-6(3) 6-0
					Agnieszka Radwanska
19.			Christina McHale		5-7 7-6(7) 6-3
				Christina McHale
20.		[WC]	Katie Boulter	3-6 7-5 6-3
						Agnieszka Radwanska
21.			Kristina Kucova			3-6 6-4 6-1
				Kristina Kucova
22.		[Q]	Bianca Andreescu	6-4 6-3
					Timea Bacsinszky
23.		[19]	Timea Bacsinszky		6-1 6-0
				Timea Bacsinszky
24.			Monica Puig	6-1 3-6 6-0
							Svetlana Kuznetsova
25.			Varvara Lepchenko				6-2 6-4
				Varvara Lepchenko
26.		[28]	Lauren Davis	6-4 7-5
					Polona Hercog
27.		[Q]	Polona Hercog		6-7(2) 6-2 6-2
				Polona Hercog
28.			Annika Beck	6-2 6-1
						Svetlana Kuznetsova
29.			Ekaterina Makarova			6-4 6-0
				Ekaterina Makarova
30.		[Q]	Alison Van Uytvanck	6-3 6-1
					Svetlana Kuznetsova
31.		[7]	Svetlana Kuznetsova		6-0 7-5
				Svetlana Kuznetsova
32.		[Q]	Ons Jabeur	6-3 6-2
									Garbine Muguruza
33.		[3]	Karolina Pliskova						6-1 6-1
				Karolina Pliskova
34.			Evgeniya Rodina	6-1 6-4
					Magdalena Rybarikova
35.			Magdalena Rybarikova		3-6 7-5 6-2
				Magdalena Rybarikova
36.			Monica Niculescu	6-4 6-1
						Magdalena Rybarikova
37.			Lesia Tsurenko			6-2 6-1
				Lesia Tsurenko
38.			Julia Goerges	6-7(5) 7-6(8) 6-4
					Lesia Tsurenko
39.			Viktorija Golubic		6-1 2-6 6-3
				Viktorija Golubic
40.		[30]	Shuai Zhang	6-3 6-7(2) 6-1
							Magdalena Rybarikova
41.		[Q]	Petra Martic				6-4 2-6 6-3
				Petra Martic
42.		[20]	Daria Gavrilova	6-4 2-6 10-8
					Petra Martic
43.			Denisa Allertova		6-1 6-4
				Denisa Allertova
44.			Risa Ozaki	7-6(5) 2-6 6-3
						Petra Martic
45.		[WC]	Zarina Diyas			7-6(6) 6-1
				Zarina Diyas
46.			Xinyun Han	6-3 6-4
					Zarina Diyas
47.		[Q]	Arina Rodionova		6-4 7-6(4)
				Arina Rodionova
48.		[16]	Anastasia Pavlyuchenkova	3-6 7-6(6) 9-7
								Magdalena Rybarikova
49.		[12]	Kristina Mladenovic					6-3 6-3
				Kristina Mladenovic
50.			Pauline Parmentier	6-1 6-3
					Alison Riske
51.			Alison Riske		2-6 6-4 6-4
				Alison Riske
52.			Sloane Stephens	6-2 7-5
						Coco Vandeweghe
53.			Tatjana Maria			6-2 6-4
				Tatjana Maria
54.		[Q]	Anastasia Potapova	6-3 2-2 rtd.
					Coco Vandeweghe
55.		[24]	Coco Vandeweghe		6-4 6-2
				Coco Vandeweghe
56.			Mona Barthel	7-5 6-2
							Coco Vandeweghe
57.		[29]	Daria Kasatkina				7-6(4) 6-4
				Daria Kasatkina
58.			Saisai Zheng	6-2 6-4
					Anett Kontaveit
59.			Anett Kontaveit		6-3 6-2
				Anett Kontaveit
60.			Lara Arruabarrena	6-2 6-4
						Caroline Wozniacki
61.			Tsvetana Pironkova			3-6 7-6(3) 6-2
				Tsvetana Pironkova
62.			Sara Errani	6-1 6-4
					Caroline Wozniacki
63.		[5]	Caroline Wozniacki		6-3 6-4
				Caroline Wozniacki
64.			Timea Babos	6-4 4-6 6-1
										Garbine Muguruza
65.		[8]	Dominika Cibulkova							7-5 6-0
				Dominika Cibulkova
66.			Andrea Petkovic	6-3 3-6 9-7
					Dominika Cibulkova
67.			Jennifer Brady		6-4 6-4
				Jennifer Brady
68.			Danka Kovinic	6-3 6-1
						Ana Konjuh
69.			Irina-Camelia Begu			7-6(3) 3-6 6-4
				Irina-Camelia Begu
70.		[WC]	Naomi Broady	6-4 6-2
					Ana Konjuh
71.		[27]	Ana Konjuh		7-6(3) 2-6 6-3
				Ana Konjuh
72.			Sabine Lisicki	6-1 6-4
							Venus Williams
73.		[22]	Barbora Strycova				6-3 6-2
				Barbora Strycova
74.			Veronica Cepede Royg	6-3 6-3
					Naomi Osaka
75.			Naomi Osaka		6-1 0-6 6-4
				Naomi Osaka
76.			Sara Sorribes Tormo	6-3 7-6(3)
						Venus Williams
77.			Qiang Wang			7-6(3) 6-4
				Qiang Wang
78.			Kai-Chen Chang	6-3 6-4
					Venus Williams
79.		[10]	Venus Williams		4-6 6-4 6-1
				Venus Williams
80.			Elise Mertens	7-6(7) 6-4
								Venus Williams
81.		[13]	Jelena Ostapenko					6-3 7-5
				Jelena Ostapenko
82.			Aliaksandra Sasnovich	6-0 1-6 6-3
					Jelena Ostapenko
83.		[Q]	Francoise Abanda		4-6 7-6(4) 6-3
				Francoise Abanda
84.			Kurumi Nara	6-2 6-4
						Jelena Ostapenko
85.			Camila Giorgi			7-5 7-5
				Camila Giorgi
86.			Alize Cornet	5-7 6-4 6-4
					Camila Giorgi
87.		[17]	Madison Keys		6-4 6-7(10) 6-1
				Madison Keys
88.			Nao Hibino	6-4 6-2
							Jelena Ostapenko
89.			Carina Witthoeft				6-3 7-6(6)
				Carina Witthoeft
90.		[26]	Mirjana Lucic	6-3 5-7 8-6
					Carina Witthoeft
91.		[Q]	Aryna Sabalenka		7-6(5) 3-6 6-3
				Aryna Sabalenka
92.			Irina Khromacheva	6-3 6-4
						Elina Svitolina
93.			Francesca Schiavone			6-1 7-5
				Francesca Schiavone
94.			Mandy Minella	6-1 6-1
					Elina Svitolina
95.		[4]	Elina Svitolina		6-3 6-0
				Elina Svitolina
96.			Ashleigh Barty	7-5 7-6(8)
									Venus Williams
97.		[6]	Johanna Konta						6-4 6-2
				Johanna Konta
98.			Su-Wei Hsieh	6-2 6-2
					Johanna Konta
99.			Donna Vekic		7-6(4) 4-6 10-8
				Donna Vekic
100.			Natalia Vikhlyantseva	6-7(6) 6-4 6-1
						Johanna Konta
101.			Maria Sakkari			6-4 6-1
				Maria Sakkari
102.			Katerina Siniakova	6-3 6-4
					Maria Sakkari
103.			Kristyna Pliskova		6-7(6) 6-4 6-4
				Kristyna Pliskova
104.		[31]	Roberta Vinci	7-6(6) 6-2
							Johanna Konta
105.		[21]	Caroline Garcia				7-6(3) 4-6 6-4
				Caroline Garcia
106.			Jana Cepelova	6-1 6-1
					Caroline Garcia
107.			Ana Bogdan		6-4 6-3
				Ana Bogdan
108.			Yingying Duan	6-4 6-2
						Caroline Garcia
109.			Madison Brengle			6-4 6-3
				Madison Brengle
110.			Richel Hogenkamp	6-3 6-3
					Madison Brengle
111.		[11]	Petra Kvitova		6-3 1-6 6-2
				Petra Kvitova
112.			Johanna Larsson	6-3 6-4
								Johanna Konta
113.		[15]	Elena Vesnina					6-7(2) 7-6(5) 6-4
				Elena Vesnina
114.		[Q]	Anna Blinkova	6-4 5-7 6-2
					Victoria Azarenka
115.			Victoria Azarenka		6-3 6-3
				Victoria Azarenka
116.			Catherine Bellis	3-6 6-2 6-1
						Victoria Azarenka
117.		[WC]	Heather Watson			3-6 6-1 6-4
				Heather Watson
118.			Maryna Zanevska	6-1 7-6(5)
					Heather Watson
119.		[18]	Anastasija Sevastova		6-0 6-4
				Anastasija Sevastova
120.			Yulia Putintseva	6-1 7-6(3)
							Simona Halep
121.		[25]	Carla Suarez-Navarro				7-6(3) 6-2
				Carla Suarez-Navarro
122.			Eugenie Bouchard	1-6 6-1 6-1
					Shuai Peng
123.			Shuai Peng		6-2 6-2
				Shuai Peng
124.			Marketa Vondrousova	6-7(5) 6-0 6-4
						Simona Halep
125.			Beatriz Haddad Maia			6-4 7-6(7)
				Beatriz Haddad Maia
126.		[WC]	Laura Robson	6-4 6-2
					Simona Halep
127.		[2]	Simona Halep		7-5 6-3
				Simona Halep
128.		[Q]	Marina Erakovic	6-4 6-1

(default) 17 queries took 20 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` = '2017' 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` = (2253) 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 (10413, 10495, 10410, 10538, 11448, 14202, 10385, 14095, 10429, 10535, 10487, 14133, 10443, 10462, 10527, 14204, 10394, 10284, 10453, 14297, 10468, 14290, 10433, 11447, 10395, 10499, 10478, 11456, 10458, 13570, 10255, 13877, 10523, 10485, 10438, 10434, 10498, 10444, 14180, 10503, 10465, 10540, 14097, 14329, 13574, 10466, 10492, 10445, 10452, 10425, 10489, 10515, 11451, 14292, 10480, 10511, 14168, 13882, 13623, 10541, 10363, 10417, 10440, 10531, 10419, 10428, 14310, 13609, 10522, 12690, 13571, 10430, 10318, 14132, 14183, 14192, 13875, 10469, 10151, 14232, 14137, 13878, 13883, 11426, 10537, 10374, 10521, 14179, 11475, 10149, 14298, 14344, 10218, 10518, 10534, 10505, 11479, 10414, 10525, 14286, 14159, 13575, 10532, 10387, 10494, 10528, 14231, 13534, 10400, 14098, 10446, 10500, 10368, 14294, 10377, 13876, 10510, 13605, 10476, 10526, 10457, 11460, 10335, 14304, 14280, 10508, 10496, 10435) 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` = 2253	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 72, 154, 164, 189, 50, 196, 63, 126, 168, 53, 178, 149, 181, 133, 94, 169, 42, 153, 29, 179, 92, 13, 68, 21, 135, 96, 146, 36, 111, 173, 104, 31, 151, 20, 74, 194, 84, 54)	39	39	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 72, 154, 164, 189, 50, 196, 63, 126, 168, 53, 178, 149, 181, 133, 94, 169, 42, 153, 29, 179, 92, 13, 68, 21, 135, 96, 146, 36, 111, 173, 104, 31, 151, 20, 74, 194, 84, 54)	39	39	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10413, 10495, 10410, 10538, 11448, 14202, 10385, 14095, 10429, 10535, 10487, 14133, 10443, 10462, 10527, 14204, 10394, 10284, 10453, 14297, 10468, 14290, 10433, 11447, 10395, 10499, 10478, 11456, 10458, 13570, 10255, 13877, 10523, 10485, 10438, 10434, 10498, 10444, 14180, 10503, 10465, 10540, 14097, 14329, 13574, 10466, 10492, 10445, 10452, 10425, 10489, 10515, 11451, 14292, 10480, 10511, 14168, 13882, 13623, 10541, 10363, 10417, 10440, 10531, 10419, 10428, 14310, 13609, 10522, 12690, 13571, 10430, 10318, 14132, 14183, 14192, 13875, 10469, 10151, 14232, 14137, 13878, 13883, 11426, 10537, 10374, 10521, 14179, 11475, 10149, 14298, 14344, 10218, 10518, 10534, 10505, 11479, 10414, 10525, 14286, 14159, 13575, 10532, 10387, 10494, 10528, 14231, 13534, 10400, 14098, 10446, 10500, 10368, 14294, 10377, 13876, 10510, 13605, 10476, 10526, 10457, 11460, 10335, 14304, 14280, 10508, 10496, 10435)) AND (`Playercontest`.`contest_id` = 2253))	128	128	1
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` = 2017	10	10	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (1, 3, 12, 17, 14, 19, 22, 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 20 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` = '2017' 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` = (2253) 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 (10413, 10495, 10410, 10538, 11448, 14202, 10385, 14095, 10429, 10535, 10487, 14133, 10443, 10462, 10527, 14204, 10394, 10284, 10453, 14297, 10468, 14290, 10433, 11447, 10395, 10499, 10478, 11456, 10458, 13570, 10255, 13877, 10523, 10485, 10438, 10434, 10498, 10444, 14180, 10503, 10465, 10540, 14097, 14329, 13574, 10466, 10492, 10445, 10452, 10425, 10489, 10515, 11451, 14292, 10480, 10511, 14168, 13882, 13623, 10541, 10363, 10417, 10440, 10531, 10419, 10428, 14310, 13609, 10522, 12690, 13571, 10430, 10318, 14132, 14183, 14192, 13875, 10469, 10151, 14232, 14137, 13878, 13883, 11426, 10537, 10374, 10521, 14179, 11475, 10149, 14298, 14344, 10218, 10518, 10534, 10505, 11479, 10414, 10525, 14286, 14159, 13575, 10532, 10387, 10494, 10528, 14231, 13534, 10400, 14098, 10446, 10500, 10368, 14294, 10377, 13876, 10510, 13605, 10476, 10526, 10457, 11460, 10335, 14304, 14280, 10508, 10496, 10435) 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` = 2253

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10413, 10495, 10410, 10538, 11448, 14202, 10385, 14095, 10429, 10535, 10487, 14133, 10443, 10462, 10527, 14204, 10394, 10284, 10453, 14297, 10468, 14290, 10433, 11447, 10395, 10499, 10478, 11456, 10458, 13570, 10255, 13877, 10523, 10485, 10438, 10434, 10498, 10444, 14180, 10503, 10465, 10540, 14097, 14329, 13574, 10466, 10492, 10445, 10452, 10425, 10489, 10515, 11451, 14292, 10480, 10511, 14168, 13882, 13623, 10541, 10363, 10417, 10440, 10531, 10419, 10428, 14310, 13609, 10522, 12690, 13571, 10430, 10318, 14132, 14183, 14192, 13875, 10469, 10151, 14232, 14137, 13878, 13883, 11426, 10537, 10374, 10521, 14179, 11475, 10149, 14298, 14344, 10218, 10518, 10534, 10505, 11479, 10414, 10525, 14286, 14159, 13575, 10532, 10387, 10494, 10528, 14231, 13534, 10400, 14098, 10446, 10500, 10368, 14294, 10377, 13876, 10510, 13605, 10476, 10526, 10457, 11460, 10335, 14304, 14280, 10508, 10496, 10435)) AND (`Playercontest`.`contest_id` = 2253))

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

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