Wimbledon 1999 Ladies' Singles (June 21 - July 4)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[Q]	Jelena Dokic
				Jelena Dokic
2.		[1]	Martina Hingis	6-2 6-0
					Jelena Dokic
3.			Katarina Studenikova		6-0 4-6 8-6
				Katarina Studenikova
4.			Emilie Loit	6-1 6-3
						Jelena Dokic
5.			Anne Kremer			6-7(7) 6-3 6-4
				Anne Kremer
6.			Mary Joe Fernandez	6-3 4-6 7-5
					Anne Kremer
7.			Brie Rippner		6-2 6-3
				Brie Rippner
8.			Irina Spirlea	6-4 6-1
							Jelena Dokic
9.			Meghann Shaughnessy				6-4 6-3
				Meghann Shaughnessy
10.			Virginia Ruano-Pascual	6-3 3-6 6-3
					Elena Pampoulova
11.			Elena Pampoulova		7-6(3) 6-3
				Elena Pampoulova
12.		[WC]	Abigail Tordoff	6-0 6-1
						Mary Pierce
13.			Rita Grande			6-3 6-0
				Rita Grande
14.			Kristina Brandi	6-2 1-6 6-3
					Mary Pierce
15.		[9]	Mary Pierce		6-1 6-3
				Mary Pierce
16.			Fabiola Zuluaga	6-3 6-2
								Alexandra Stevenson
17.		[11]	Julie Halard					6-3 1-6 6-3
				Julie Halard
18.			Sandra Nacuk	6-1 6-0
					Julie Halard
19.			Silvia Farina		6-2 3-6 8-6
				Silvia Farina
20.			Adriana Serra-Zanetti	6-2 6-1
						Alexandra Stevenson
21.		[Q]	Alexandra Stevenson			6-3 6-3
				Alexandra Stevenson
22.			Amy Frazier	6-1 3-6 6-3
					Alexandra Stevenson
23.			Olga Barabanschikova		6-2 6-7(3) 6-3
				Olga Barabanschikova
24.			Catalina Cristea	6-2 6-3
							Alexandra Stevenson
25.			Tara Snyder				2-6 7-6(8) 6-1
				Tara Snyder
26.			Asa Carlsson	6-2 7-5
					Conchita Martinez
27.			Conchita Martinez		6-4 6-1
				Conchita Martinez
28.			Rita Kuti-Kis	6-2 6-1
						Lisa Raymond
29.			Lisa Raymond			6-3 6-1
				Lisa Raymond
30.			Andrea Glass	6-3 3-6 8-6
					Lisa Raymond
31.		[7]	Arantxa Sanchez-Vicario		7-6(4) 6-1
				Arantxa Sanchez-Vicario
32.		[Q]	Anna Maria Foldenyi	4-6 6-3 6-4
									Lindsay Davenport
33.		[3]	Lindsay Davenport						6-1 6-1
				Lindsay Davenport
34.			Alexandra Fusai	6-0 6-3
					Lindsay Davenport
35.			Karina Habsudova		6-2 6-2
				Karina Habsudova
36.		[WC]	Lorna Woodroffe	6-3 6-2
						Lindsay Davenport
37.			Laura Golarsa			6-3 6-2
				Laura Golarsa
38.			Pavlina Stoyanova	6-2 6-2
					Laura Golarsa
39.			Amelie Cocheteux		6-4 6-2
				Amelie Cocheteux
40.			Els Callens	6-0 6-3
							Lindsay Davenport
41.			Nicole Arendt				7-6(7) 6-1
				Nicole Arendt
42.			Magui Serna	6-3 7-6(4)
					Larisa Savchenko
43.			Larisa Savchenko		2-6 7-5 6-4
				Larisa Savchenko
44.			Fang Li	0-6 7-5 6-2
						Barbara Schett
45.			Alexia Dechaume			6-2 6-3
				Alexia Dechaume
46.			Lubomira Bacheva	6-4 4-6 6-4
					Barbara Schett
47.		[14]	Barbara Schett		6-7(6) 6-3 6-1
				Barbara Schett
48.			Gala Leon Garcia	7-5 6-2
								Lindsay Davenport
49.		[16]	Natasha Zvereva					6-3 6-4
				Natasha Zvereva
50.			Kimberly Po	5-7 6-1 6-3
					Tatiana Panova
51.			Tatiana Panova		6-4 7-5
				Tatiana Panova
52.			Henrieta Nagyova	6-3 6-3
						Nathalie Dechy
53.			Nathalie Dechy			6-0 6-3
				Nathalie Dechy
54.			Patty Schnyder	5-7 6-3 6-3
					Nathalie Dechy
55.			Sabine Appelmans		6-3 7-6(6)
				Sabine Appelmans
56.			Silvija Talaja	6-3 6-7(5) 6-3
							Jana Novotna
57.			Maria Sanchez Lorenzo				6-3 7-5
				Maria Sanchez Lorenzo
58.		[Q]	Linda Harvey	6-3 7-6(4)
					Maria Sanchez Lorenzo
59.		[Q]	Nadia Petrova		7-5 6-1
				Nadia Petrova
60.			Sonya Jeyaseelan	6-2 6-3
						Jana Novotna
61.			Sylvia Plischke			6-4 6-3
				Sylvia Plischke
62.			Cara Black	7-6(5) 7-5
					Jana Novotna
63.		[5]	Jana Novotna		6-2 6-1
				Jana Novotna
64.			Shi-Ting Wang	6-2 6-1
										Lindsay Davenport
65.		[8]	Nathalie Tauziat							6-4 7-5
				Nathalie Tauziat
66.		[WC]	Lucie Ahl	6-3 6-2
					Nathalie Tauziat
67.			Amanda Hopmans		6-3 6-4
				Amanda Hopmans
68.			Sandra Kleinova	6-4 6-2
						Nathalie Tauziat
69.		[Q]	Seda Noorlander			6-1 6-1
				Seda Noorlander
70.			Jana Nejedly	6-3 6-3
					Seda Noorlander
71.			Jennifer Capriati		6-1 6-3
				Jennifer Capriati
72.			Anke Huber	5-7 6-3 9-7
							Nathalie Tauziat
73.			Ai Sugiyama				6-3 3-6 6-3
				Ai Sugiyama
74.			Magdalena Grzybowska	6-1 6-2
					Elena Likhovtseva
75.			Elena Likhovtseva		7-6(6) 6-1
				Elena Likhovtseva
76.			Alicia Molik	6-2 6-0
						Dominique Monami
77.			Kristie Boogert			6-4 7-6(4)
				Kristie Boogert
78.			Chanda Rubin	6-4 7-5
					Dominique Monami
79.		[15]	Dominique Monami		6-3 6-3
				Dominique Monami
80.		[LL]	Elena Dementieva	3-6 6-4 6-4
								Mirjana Lucic
81.		[13]	Sandrine Testud					4-6 6-4 7-5
				Sandrine Testud
82.			Julie Pullin	6-1 6-3
					Sandrine Testud
83.			Barbara Rittner		7-6(2) 6-1
				Barbara Rittner
84.		[WC]	Denisa Chladkova	6-4 6-2
						Tamarine Tanasugarn
85.			Maureen Drake			6-2 1-6 6-3
				Maureen Drake
86.			Evgenia Koulikovskaya	6-3 6-0
					Tamarine Tanasugarn
87.			Tamarine Tanasugarn		6-4 6-3
				Tamarine Tanasugarn
88.			Kveta Hrdlickova	6-1 6-4
							Mirjana Lucic
89.			Mariana Diaz-Oliva				7-5 6-3
				Mariana Diaz-Oliva
90.			Anna Smashnova	7-6(3) 7-5
					Mirjana Lucic
91.			Mirjana Lucic		6-2 6-1
				Mirjana Lucic
92.		[Q]	Erika De Lone	3-6 7-6(4) 7-5
						Mirjana Lucic
93.			Marlene Weingartner			7-6(4) 7-6(4)
				Marlene Weingartner
94.		[WC]	Joanne Ward	4-6 7-5 6-3
					Monica Seles
95.		[4]	Monica Seles		6-0 6-0
				Monica Seles
96.			Cristina Torrens-Valero	6-3 6-1
									Steffi Graf
97.		[6]	Venus Williams						6-7(3) 6-4 6-3
				Venus Williams
98.			Miriam Oremans	6-1 7-5
					Venus Williams
99.			Elena Tatarkova		6-3 6-4
				Elena Tatarkova
100.			Jane Chi	7-5 6-0
						Venus Williams
101.			Sarah Pitkowski			6-1 6-1
				Sarah Pitkowski
102.			Katarina Srebotnik	7-6(5) 5-7 6-1
					Sarah Pitkowski
103.		[WC]	Louise Latimer		7-5 5-7 6-3
				Louise Latimer
104.			Anne-Gaelle Sidot	6-4 6-2
							Venus Williams
105.			Ruxandra Dragomir				3-6 6-3 6-2
				Ruxandra Dragomir
106.			Paola Suarez	6-4 6-1
					Ines Gorrochategui
107.			Ines Gorrochategui		6-2 6-2
				Ines Gorrochategui
108.			Samantha Smith	6-2 1-6 6-2
						Anna Kournikova
109.			Maria Vento-Kabchi			7-5 3-1 rtd.
				Maria Vento-Kabchi
110.			Emmanuelle Gagliardi	7-5 6-3
					Anna Kournikova
111.		[17]	Anna Kournikova		7-5 6-4
				Anna Kournikova
112.		[WC]	Barbara Schwartz	7-6(2) 4-6 6-2
								Steffi Graf
113.		[12]	Amanda Coetzer					6-2 3-6 6-4
				Amanda Coetzer
114.			Nicole Pratt	6-2 7-5
					Amanda Coetzer
115.			Miho Saeki		6-4 6-1
				Miho Saeki
116.			Christina Papadaki	6-3 6-2
						Kim Clijsters
117.		[Q]	Kim Clijsters			6-2 6-4
				Kim Clijsters
118.			Joanette Kruger	6-2 6-3
					Kim Clijsters
119.		[WC]	Karen Cross		6-2 6-0
				Karen Cross
120.			Lilia Osterloh	6-1 6-4
							Steffi Graf
121.			Janet Lee				6-2 6-2
				Janet Lee
122.			Kerry-Anne Guse	3-6 6-4 6-1
					Corina Morariu
123.			Corina Morariu		6-2 6-4
				Corina Morariu
124.			Laurence Courtois	7-6(8) 3-6 6-2
						Steffi Graf
125.			Mariaan De Swardt			6-1 6-3
				Mariaan De Swardt
126.			Jolene Watanabe	6-1 6-4
					Steffi Graf
127.		[2]	Steffi Graf		4-6 6-3 6-2
				Steffi Graf
128.			Ludmila Cervanova	6-1 6-4

(default) 17 queries took 22 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` = '1999' 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` = (1810) 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 (10173, 10078, 10054, 10165, 10128, 9909, 10164, 10050, 10147, 10055, 9928, 12542, 10098, 10124, 10024, 10198, 9829, 10195, 10049, 10095, 10193, 9845, 10137, 10059, 10135, 10101, 9885, 10169, 10039, 10141, 9957, 10004, 10025, 10026, 9946, 12494, 9896, 10188, 10155, 10068, 9983, 10111, 9750, 9987, 9873, 10189, 10077, 10114, 9945, 9991, 10145, 10129, 10116, 10356, 9936, 10122, 10090, 10009, 10163, 10094, 10153, 10160, 9848, 10028, 10017, 12539, 10196, 10100, 10162, 10092, 9997, 9915, 10070, 10103, 10064, 10172, 10048, 9985, 10012, 10174, 9990, 10191, 9967, 10133, 9934, 10298, 10115, 10156, 10146, 10062, 10149, 9913, 10157, 12497, 9974, 10123, 10151, 9953, 10134, 10159, 10084, 10180, 10219, 10131, 10063, 10119, 9999, 9992, 10105, 10130, 10113, 10167, 10018, 9937, 10112, 10044, 10192, 10023, 12496, 10175, 10086, 9869, 10121, 10037, 10074, 10058, 9715, 10184) 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` = 1810	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (20, 43, 196, 197, 72, 181, 201, 173, 68, 194, 184, 50, 94, 10, 168, 31, 169, 153, 91, 92, 14, 179, 104, 13, 154, 74, 133, 53, 36, 219, 21, 42, 172, 111, 84, 149, 178, 151, 207)	39	39	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (20, 43, 196, 197, 72, 181, 201, 173, 68, 194, 184, 50, 94, 10, 168, 31, 169, 153, 91, 92, 14, 179, 104, 13, 154, 74, 133, 53, 36, 219, 21, 42, 172, 111, 84, 149, 178, 151, 207)	39	39	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10173, 10078, 10054, 10165, 10128, 9909, 10164, 10050, 10147, 10055, 9928, 12542, 10098, 10124, 10024, 10198, 9829, 10195, 10049, 10095, 10193, 9845, 10137, 10059, 10135, 10101, 9885, 10169, 10039, 10141, 9957, 10004, 10025, 10026, 9946, 12494, 9896, 10188, 10155, 10068, 9983, 10111, 9750, 9987, 9873, 10189, 10077, 10114, 9945, 9991, 10145, 10129, 10116, 10356, 9936, 10122, 10090, 10009, 10163, 10094, 10153, 10160, 9848, 10028, 10017, 12539, 10196, 10100, 10162, 10092, 9997, 9915, 10070, 10103, 10064, 10172, 10048, 9985, 10012, 10174, 9990, 10191, 9967, 10133, 9934, 10298, 10115, 10156, 10146, 10062, 10149, 9913, 10157, 12497, 9974, 10123, 10151, 9953, 10134, 10159, 10084, 10180, 10219, 10131, 10063, 10119, 9999, 9992, 10105, 10130, 10113, 10167, 10018, 9937, 10112, 10044, 10192, 10023, 12496, 10175, 10086, 9869, 10121, 10037, 10074, 10058, 9715, 10184)) AND (`Playercontest`.`contest_id` = 1810))	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` = 1999	20	20	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 3, 1, 12, 17, 22, 18, 13, 23, 4, 7, 14, 24, 25, 26, 19, 15, 16, 20, 21) 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 22 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` = '1999' 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` = (1810) 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 (10173, 10078, 10054, 10165, 10128, 9909, 10164, 10050, 10147, 10055, 9928, 12542, 10098, 10124, 10024, 10198, 9829, 10195, 10049, 10095, 10193, 9845, 10137, 10059, 10135, 10101, 9885, 10169, 10039, 10141, 9957, 10004, 10025, 10026, 9946, 12494, 9896, 10188, 10155, 10068, 9983, 10111, 9750, 9987, 9873, 10189, 10077, 10114, 9945, 9991, 10145, 10129, 10116, 10356, 9936, 10122, 10090, 10009, 10163, 10094, 10153, 10160, 9848, 10028, 10017, 12539, 10196, 10100, 10162, 10092, 9997, 9915, 10070, 10103, 10064, 10172, 10048, 9985, 10012, 10174, 9990, 10191, 9967, 10133, 9934, 10298, 10115, 10156, 10146, 10062, 10149, 9913, 10157, 12497, 9974, 10123, 10151, 9953, 10134, 10159, 10084, 10180, 10219, 10131, 10063, 10119, 9999, 9992, 10105, 10130, 10113, 10167, 10018, 9937, 10112, 10044, 10192, 10023, 12496, 10175, 10086, 9869, 10121, 10037, 10074, 10058, 9715, 10184) 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` = 1810

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (20, 43, 196, 197, 72, 181, 201, 173, 68, 194, 184, 50, 94, 10, 168, 31, 169, 153, 91, 92, 14, 179, 104, 13, 154, 74, 133, 53, 36, 219, 21, 42, 172, 111, 84, 149, 178, 151, 207)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (20, 43, 196, 197, 72, 181, 201, 173, 68, 194, 184, 50, 94, 10, 168, 31, 169, 153, 91, 92, 14, 179, 104, 13, 154, 74, 133, 53, 36, 219, 21, 42, 172, 111, 84, 149, 178, 151, 207)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10173, 10078, 10054, 10165, 10128, 9909, 10164, 10050, 10147, 10055, 9928, 12542, 10098, 10124, 10024, 10198, 9829, 10195, 10049, 10095, 10193, 9845, 10137, 10059, 10135, 10101, 9885, 10169, 10039, 10141, 9957, 10004, 10025, 10026, 9946, 12494, 9896, 10188, 10155, 10068, 9983, 10111, 9750, 9987, 9873, 10189, 10077, 10114, 9945, 9991, 10145, 10129, 10116, 10356, 9936, 10122, 10090, 10009, 10163, 10094, 10153, 10160, 9848, 10028, 10017, 12539, 10196, 10100, 10162, 10092, 9997, 9915, 10070, 10103, 10064, 10172, 10048, 9985, 10012, 10174, 9990, 10191, 9967, 10133, 9934, 10298, 10115, 10156, 10146, 10062, 10149, 9913, 10157, 12497, 9974, 10123, 10151, 9953, 10134, 10159, 10084, 10180, 10219, 10131, 10063, 10119, 9999, 9992, 10105, 10130, 10113, 10167, 10018, 9937, 10112, 10044, 10192, 10023, 12496, 10175, 10086, 9869, 10121, 10037, 10074, 10058, 9715, 10184)) AND (`Playercontest`.`contest_id` = 1810))

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

SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 3, 1, 12, 17, 22, 18, 13, 23, 4, 7, 14, 24, 25, 26, 19, 15, 16, 20, 21) 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)