US Open 2001 Women's Singles (August 27 - September 9)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Martina Hingis
				Martina Hingis
2.		[WC]	Laura Granville	6-2 6-0
					Martina Hingis
3.			Lina Krasnoroutskaya		6-0 6-2
				Lina Krasnoroutskaya
4.			Jill Craybas	7-5 6-3
						Martina Hingis
5.			Iva Majoli			4-6 6-4 7-6(5)
				Iva Majoli
6.			Tatiana Panova	6-1 6-1
					Iva Majoli
7.			Barbara Rittner		6-4 7-5
				Barbara Rittner
8.		[29]	Amy Frazier	6-1 6-2
							Martina Hingis
9.		[20]	Arantxa Sanchez-Vicario				6-4 6-0
				Arantxa Sanchez-Vicario
10.			Petra Mandula	6-3 3-6 7-6(5)
					Arantxa Sanchez-Vicario
11.			Ai Sugiyama		6-3 6-2
				Ai Sugiyama
12.		[WC]	Ansley Cargill	7-6(4) 6-3
						Jelena Dokic
13.			Lilia Osterloh			6-4 7-5
				Lilia Osterloh
14.		[Q]	Marie-Gaiane Mikaelian	6-4 6-3
					Jelena Dokic
15.		[14]	Jelena Dokic		6-3 6-3
				Jelena Dokic
16.			Adriana Serra-Zanetti	6-2 3-6 6-2
								Martina Hingis
17.		[12]	Meghann Shaughnessy					6-2 6-0
				Meghann Shaughnessy
18.			Rita Grande	3-6 6-3 7-6(2)
					Meghann Shaughnessy
19.			Asa Carlsson		7-6(4) 6-3
				Asa Carlsson
20.			Nuria Llagostera-Vives	6-0 6-4
						Daja Bedanova
21.			Daja Bedanova			6-4 6-1
				Daja Bedanova
22.			Joanette Kruger	6-1 6-2
					Daja Bedanova
23.			Silvija Talaja		6-1 6-3
				Silvija Talaja
24.		[24]	Paola Suarez	7-5 6-2
							Daja Bedanova
25.			Rachel McQuillan				7-5 4-6 6-3
				Rachel McQuillan
26.		[26]	Tamarine Tanasugarn	6-3 7-5
					Eleni Daniilidou
27.		[Q]	Eleni Daniilidou		6-1 7-5
				Eleni Daniilidou
28.		[WC]	Amber Liu	6-3 6-3
						Monica Seles
29.		[Q]	Evgenia Koulikovskaya			6-2 6-3
				Evgenia Koulikovskaya
30.			Bianka Lamade	6-4 7-6(5)
					Monica Seles
31.		[7]	Monica Seles		6-1 6-4
				Monica Seles
32.			Nicole Pratt	6-1 6-2
									Serena Williams
33.		[3]	Lindsay Davenport						6-3 6-2
				Lindsay Davenport
34.			Andrea Glass	6-2 6-3
					Lindsay Davenport
35.			Emilie Loit		6-0 6-2
				Emilie Loit
36.			Maria Elena Camerin	6-3 7-5
						Lindsay Davenport
37.			Miriam Oremans			6-3 6-2
				Miriam Oremans
38.			Zsofia Gubacsi	6-4 4-6 6-3
					Angeles Montolio
39.		[27]	Angeles Montolio		6-2 6-1
				Angeles Montolio
40.		[Q]	Gloria Pizzichini	6-1 6-7(2) 6-1
							Lindsay Davenport
41.		[21]	Elena Likhovtseva				6-3 0-6 6-3
				Elena Likhovtseva
42.		[Q]	Tatiana Perebiynis	4-6 7-6(4) 6-1
					Elena Likhovtseva
43.			Nadia Petrova		6-4 2-6 6-4
				Nadia Petrova
44.		[Q]	Alexandra Fusai	6-4 6-7(3) 6-2
						Elena Likhovtseva
45.			Virginie Razzano			6-7(6) 7-5 6-4
				Virginie Razzano
46.			Shinobu Asagoe	6-4 5-7 6-4
					Barbara Schwartz
47.		[Q]	Barbara Schwartz		6-1 7-6(4)
				Barbara Schwartz
48.		[13]	Amanda Coetzer	1-6 6-4 6-4
								Serena Williams
49.		[10]	Serena Williams					6-3 6-7(7) 7-5
				Serena Williams
50.			Anca Barna	4-6 6-1 6-2
					Serena Williams
51.			Denisa Chladkova		6-1 6-1
				Denisa Chladkova
52.		[LL]	Martina Muller	6-1 6-2
						Serena Williams
53.			Martina Sucha			6-1 6-0
				Martina Sucha
54.		[Q]	Roberta Vinci	7-6(4) 6-1
					Martina Sucha
55.			Eva Bes		6-2 6-3
				Eva Bes
56.		[23]	Magui Serna	6-3 6-1
							Serena Williams
57.			Miroslava Vavrinec				7-5 6-0
				Miroslava Vavrinec
58.		[31]	Cristina Torrens-Valero	2-6 6-1 6-1
					Miroslava Vavrinec
59.			Tatiana Poutchek		7-5 4-6 6-2
				Tatiana Poutchek
60.			Anne Kremer	6-0 6-2
						Justine Henin
61.			Patty Schnyder			6-1 6-2
				Patty Schnyder
62.			Rossana De Los Rios	6-4 6-1
					Justine Henin
63.		[6]	Justine Henin		6-7(7) 6-1 6-4
				Justine Henin
64.			Marissa Irvin	6-3 6-3
										Venus Williams
65.		[5]	Kim Clijsters							6-2 6-4
				Kim Clijsters
66.			Pavlina Stoyanova	6-1 6-1
					Kim Clijsters
67.		[WC]	Allison Bradshaw		6-3 6-2
				Allison Bradshaw
68.			Catalina Castano	6-7(3) 7-6(5) 6-3
						Kim Clijsters
69.			Nathalie Dechy			6-3 7-5
				Nathalie Dechy
70.			Daniela Hantuchova	5-7 6-4 6-2
					Henrieta Nagyova
71.		[25]	Henrieta Nagyova		6-2 6-1
				Henrieta Nagyova
72.			Mariana Diaz-Oliva	6-0 6-4
							Kim Clijsters
73.		[17]	Anke Huber				7-5 4-6 6-2
				Anke Huber
74.			Maria-Emilia Salerni	6-2 6-4
					Anke Huber
75.		[WC]	Sarah Taylor		7-6(2) 6-4
				Sarah Taylor
76.			Marlene Weingartner	6-3 6-7(4) 6-1
						Elena Dementieva
77.			Karina Habsudova			6-3 7-5
				Karina Habsudova
78.			Emmanuelle Gagliardi	5-7 6-4 7-6(2)
					Elena Dementieva
79.		[11]	Elena Dementieva		7-6(5) 5-7 6-0
				Elena Dementieva
80.		[Q]	Cho Yoon-Jeong	6-3 7-5
								Venus Williams
81.			Maja Matevzic					6-3 6-1
				Maja Matevzic
82.		[16]	Silvia Farina	6-2 6-4
					Maja Matevzic
83.			Wynne Prakusya		6-2 6-3
				Wynne Prakusya
84.		[LL]	Greta Arn	6-1 6-0
						Sandrine Testud
85.			Gala Leon Garcia			6-2 6-0
				Gala Leon Garcia
86.			Rita Kuti-Kis	4-6 7-5 6-1
					Sandrine Testud
87.		[18]	Sandrine Testud		5-7 6-4 6-4
				Sandrine Testud
88.		[Q]	Nina Dubbers	6-3 6-2
							Venus Williams
89.		[30]	Lisa Raymond				6-3 6-1
				Lisa Raymond
90.			Anna Smashnova	6-2 6-3
					Lisa Raymond
91.			Jennifer Hopkins		6-2 6-1
				Jennifer Hopkins
92.			Sandra Cacic	7-5 6-4
						Venus Williams
93.			Meilen Tu			6-3 6-4
				Meilen Tu
94.		[WC]	Ashley Harkleroad	6-4 2-6 6-0
					Venus Williams
95.		[4]	Venus Williams		6-2 6-2
				Venus Williams
96.		[Q]	Lenka Dhlopolcova	6-2 6-3
									Venus Williams
97.		[8]	Amelie Mauresmo						6-4 6-2
				Amelie Mauresmo
98.			Anastasia Myskina	3-6 6-1 6-4
					Amelie Mauresmo
99.			Janette Husarova		7-6(6) 6-2
				Janette Husarova
100.			Ludmila Cervanova	7-6(2) 6-4
						Amelie Mauresmo
101.		[Q]	Adriana Gersi			7-5 7-5
				Adriana Gersi
102.			Elena Bovina	6-3 6-2
					Chanda Rubin
103.		[28]	Chanda Rubin		6-4 6-1
				Chanda Rubin
104.			Jana Kandarr	6-4 3-6 6-3
							Amelie Mauresmo
105.		[22]	Iroda Tulyaganova				6-0 6-7(1) 6-3
				Iroda Tulyaganova
106.			Marta Marrero	6-1 6-4
					Jana Nejedly
107.		[Q]	Jana Nejedly		1-6 6-3 6-4
				Jana Nejedly
108.			Anabel Medina-Garrigues	6-2 6-1
						Nathalie Tauziat
109.		[Q]	Katarina Srebotnik			6-1 3-6 6-3
				Katarina Srebotnik
110.			Aniko Kapros	6-1 6-4
					Nathalie Tauziat
111.		[9]	Nathalie Tauziat		7-5 1-6 6-3
				Nathalie Tauziat
112.			Cara Black	4-6 6-3 6-2
								Jennifer Capriati
113.		[15]	Magdalena Maleeva					6-3 6-4
				Magdalena Maleeva
114.			Kveta Hrdlickova	6-2 6-1
					Alicia Molik
115.			Alicia Molik		6-3 3-6 6-3
				Alicia Molik
116.		[WC]	Bethanie Mattek-Sands	4-6 6-2 6-4
						Barbara Schett
117.			Selima Sfar			7-5 3-6 6-3
				Selima Sfar
118.			Tina Pisnik	6-2 5-7 6-4
					Barbara Schett
119.		[19]	Barbara Schett		6-4 7-6(5)
				Barbara Schett
120.		[WC]	Alexandra Stevenson	6-1 6-3
							Jennifer Capriati
121.			Virginia Ruano-Pascual				6-3 6-3
				Virginia Ruano-Pascual
122.		[32]	Francesca Schiavone	6-1 6-3
					Virginia Ruano-Pascual
123.		[Q]	Evelyn Fauth		5-7 6-2 6-4
				Evelyn Fauth
124.			Anne-Gaelle Sidot	6-4 7-6(6)
						Jennifer Capriati
125.			Evie Dominikovic			6-4 6-4
				Evie Dominikovic
126.			Maria Jose Martinez-Sanchez	6-1 6-1
					Jennifer Capriati
127.		[2]	Jennifer Capriati		6-2 6-0
				Jennifer Capriati
128.		[Q]	Amanda Hopmans	6-2 6-1

(default) 17 queries took 21 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` = '2001' 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` = (1420) 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 (10078, 10278, 10199, 10171, 10088, 10145, 9967, 9845, 9957, 10182, 10070, 10277, 10175, 10275, 10173, 10095, 10147, 10098, 10101, 10221, 10210, 10023, 10122, 10119, 9819, 10115, 10253, 13394, 10298, 10273, 9974, 9937, 10025, 10141, 10165, 10264, 9953, 10267, 10069, 10016, 10064, 10312, 10163, 10026, 10187, 10222, 10167, 10018, 10150, 10194, 10133, 10266, 10223, 10387, 10269, 10111, 10185, 10123, 10216, 10128, 10356, 10065, 10179, 10203, 10192, 10188, 11399, 10337, 10116, 10299, 10129, 10146, 9915, 10257, 10280, 10157, 9946, 10130, 10174, 10256, 10276, 10049, 10263, 10224, 10114, 10169, 9990, 13414, 10039, 10062, 10209, 10061, 10126, 10323, 10151, 13415, 10152, 10262, 10045, 10184, 10117, 10211, 9985, 10106, 10205, 10215, 10092, 10208, 10180, 10271, 10017, 10160, 9959, 10156, 10172, 10487, 10259, 10202, 10077, 10193, 10055, 10218, 13416, 10131, 10109, 10212, 9997, 10196) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	2
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` = 1420	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (84, 94, 72, 53, 173, 207, 154, 197, 92, 178, 43, 168, 100, 21, 172, 74, 68, 10, 219, 13, 14, 179, 133, 111, 50, 31, 169, 36, 135, 194, 20, 87, 146, 189, 91, 184, 199)	37	37	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (84, 94, 72, 53, 173, 207, 154, 197, 92, 178, 43, 168, 100, 21, 172, 74, 68, 10, 219, 13, 14, 179, 133, 111, 50, 31, 169, 36, 135, 194, 20, 87, 146, 189, 91, 184, 199)	37	37	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10078, 10278, 10199, 10171, 10088, 10145, 9967, 9845, 9957, 10182, 10070, 10277, 10175, 10275, 10173, 10095, 10147, 10098, 10101, 10221, 10210, 10023, 10122, 10119, 9819, 10115, 10253, 13394, 10298, 10273, 9974, 9937, 10025, 10141, 10165, 10264, 9953, 10267, 10069, 10016, 10064, 10312, 10163, 10026, 10187, 10222, 10167, 10018, 10150, 10194, 10133, 10266, 10223, 10387, 10269, 10111, 10185, 10123, 10216, 10128, 10356, 10065, 10179, 10203, 10192, 10188, 11399, 10337, 10116, 10299, 10129, 10146, 9915, 10257, 10280, 10157, 9946, 10130, 10174, 10256, 10276, 10049, 10263, 10224, 10114, 10169, 9990, 13414, 10039, 10062, 10209, 10061, 10126, 10323, 10151, 13415, 10152, 10262, 10045, 10184, 10117, 10211, 9985, 10106, 10205, 10215, 10092, 10208, 10180, 10271, 10017, 10160, 9959, 10156, 10172, 10487, 10259, 10202, 10077, 10193, 10055, 10218, 13416, 10131, 10109, 10212, 9997, 10196)) AND (`Playercontest`.`contest_id` = 1420))	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` = 2001	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 21 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` = '2001' 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` = (1420) 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 (10078, 10278, 10199, 10171, 10088, 10145, 9967, 9845, 9957, 10182, 10070, 10277, 10175, 10275, 10173, 10095, 10147, 10098, 10101, 10221, 10210, 10023, 10122, 10119, 9819, 10115, 10253, 13394, 10298, 10273, 9974, 9937, 10025, 10141, 10165, 10264, 9953, 10267, 10069, 10016, 10064, 10312, 10163, 10026, 10187, 10222, 10167, 10018, 10150, 10194, 10133, 10266, 10223, 10387, 10269, 10111, 10185, 10123, 10216, 10128, 10356, 10065, 10179, 10203, 10192, 10188, 11399, 10337, 10116, 10299, 10129, 10146, 9915, 10257, 10280, 10157, 9946, 10130, 10174, 10256, 10276, 10049, 10263, 10224, 10114, 10169, 9990, 13414, 10039, 10062, 10209, 10061, 10126, 10323, 10151, 13415, 10152, 10262, 10045, 10184, 10117, 10211, 9985, 10106, 10205, 10215, 10092, 10208, 10180, 10271, 10017, 10160, 9959, 10156, 10172, 10487, 10259, 10202, 10077, 10193, 10055, 10218, 13416, 10131, 10109, 10212, 9997, 10196) 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` = 1420

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (84, 94, 72, 53, 173, 207, 154, 197, 92, 178, 43, 168, 100, 21, 172, 74, 68, 10, 219, 13, 14, 179, 133, 111, 50, 31, 169, 36, 135, 194, 20, 87, 146, 189, 91, 184, 199)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (84, 94, 72, 53, 173, 207, 154, 197, 92, 178, 43, 168, 100, 21, 172, 74, 68, 10, 219, 13, 14, 179, 133, 111, 50, 31, 169, 36, 135, 194, 20, 87, 146, 189, 91, 184, 199)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10078, 10278, 10199, 10171, 10088, 10145, 9967, 9845, 9957, 10182, 10070, 10277, 10175, 10275, 10173, 10095, 10147, 10098, 10101, 10221, 10210, 10023, 10122, 10119, 9819, 10115, 10253, 13394, 10298, 10273, 9974, 9937, 10025, 10141, 10165, 10264, 9953, 10267, 10069, 10016, 10064, 10312, 10163, 10026, 10187, 10222, 10167, 10018, 10150, 10194, 10133, 10266, 10223, 10387, 10269, 10111, 10185, 10123, 10216, 10128, 10356, 10065, 10179, 10203, 10192, 10188, 11399, 10337, 10116, 10299, 10129, 10146, 9915, 10257, 10280, 10157, 9946, 10130, 10174, 10256, 10276, 10049, 10263, 10224, 10114, 10169, 9990, 13414, 10039, 10062, 10209, 10061, 10126, 10323, 10151, 13415, 10152, 10262, 10045, 10184, 10117, 10211, 9985, 10106, 10205, 10215, 10092, 10208, 10180, 10271, 10017, 10160, 9959, 10156, 10172, 10487, 10259, 10202, 10077, 10193, 10055, 10218, 13416, 10131, 10109, 10212, 9997, 10196)) AND (`Playercontest`.`contest_id` = 1420))

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

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)