US Open 1997 Women's Singles (August 25 - September 7)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Martina Hingis
				Martina Hingis
2.			Tami Whitlinger	6-0 6-1
					Martina Hingis
3.			Denisa Chladkova		6-1 6-2
				Denisa Chladkova
4.			Helena Sukova	6-1 1-6 6-1
						Martina Hingis
5.			Elena Likhovtseva			7-5 6-2
				Elena Likhovtseva
6.			Petra Langrova	7-5 6-4
					Elena Likhovtseva
7.		[Q]	Ludmila Richterova		7-5 6-1
				Ludmila Richterova
8.			Jana Kandarr	6-1 6-1
							Martina Hingis
9.			Florencia Labat				6-0 6-2
				Florencia Labat
10.		[Q]	Angelica Gavaldon	6-2 6-1
					Florencia Labat
11.			Francesca Lubiani		6-1 6-1
				Francesca Lubiani
12.		[Q]	Fang Li	6-4 3-6 6-2
						Florencia Labat
13.			Olga Barabanschikova			4-6 7-6 6-1
				Olga Barabanschikova
14.			Laura Golarsa	6-3 6-3
					Olga Barabanschikova
15.		[13]	Brenda Schultz		6-3 6-3
				Brenda Schultz
16.			Asa Carlsson	6-7 6-3 6-4
								Martina Hingis
17.		[10]	Arantxa Sanchez-Vicario					6-3 6-2
				Arantxa Sanchez-Vicario
18.			Kerry-Anne Guse	6-2 6-4
					Arantxa Sanchez-Vicario
19.			Meilen Tu		6-2 5-7 6-2
				Meilen Tu
20.			Jolene Watanabe	6-3 7-5
						Arantxa Sanchez-Vicario
21.			Nana Miyagi			6-2 6-1
				Nana Miyagi
22.			Ines Gorrochategui	6-2 7-5
					Alexandra Fusai
23.			Alexandra Fusai		6-3 3-6 6-4
				Alexandra Fusai
24.			Emmanuelle Gagliardi	6-1 6-1
							Arantxa Sanchez-Vicario
25.			Rika Hiraki				6-1 6-2
				Rika Hiraki
26.			Mariana Diaz-Oliva	6-4 4-6 6-2
					Rachel McQuillan
27.			Rachel McQuillan		6-0 6-2
				Rachel McQuillan
28.			Cristina Torrens-Valero	4-6 7-5 6-4
						Rachel McQuillan
29.		[Q]	Samantha Smith			6-2 7-5
				Samantha Smith
30.		[Q]	Nicole Pratt	6-3 6-1
					Conchita Martinez
31.		[7]	Conchita Martinez		6-1 6-0
				Conchita Martinez
32.			Jennifer Capriati	6-1 6-2
									Martina Hingis
33.		[3]	Jana Novotna						6-2 6-4
				Jana Novotna
34.			Virginia Ruano-Pascual	6-0 6-4
					Jana Novotna
35.			Yayuk Basuki		6-4 6-2
				Yayuk Basuki
36.			Noelle Van Lottum	6-3 6-4
						Jana Novotna
37.		[WC]	Brie Rippner			6-2 6-7 6-3
				Brie Rippner
38.			Natalia Medvedeva	6-2 6-2
					Mirjana Lucic
39.			Mirjana Lucic		6-0 6-1
				Mirjana Lucic
40.			Sandra Kleinova	6-0 6-3
							Jana Novotna
41.			Paola Suarez				7-5 6-4
				Paola Suarez
42.			Sandra Dopfer	6-3 3-6 7-6
					Paola Suarez
43.		[WC]	Jacqueline Trail		4-6 7-5 6-4
				Jacqueline Trail
44.			Adriana Gersi	7-6 6-2
						Mary Joe Fernandez
45.			Rita Grande			6-1 6-2
				Rita Grande
46.			Sandra Cacic	6-2 6-1
					Mary Joe Fernandez
47.		[12]	Mary Joe Fernandez		4-6 6-2 6-2
				Mary Joe Fernandez
48.			Naoko Kijimuta	6-2 6-3
								Lindsay Davenport
49.		[16]	Kimberly Po					6-2 4-6 7-6
				Kimberly Po
50.			Eva Martincova	6-4 6-1
					Kimberly Po
51.			Barbara Schett		6-3 4-6 7-5
				Barbara Schett
52.			Marion Maruska	6-1 6-0
						Magui Serna
53.			Magui Serna			6-4 6-3
				Magui Serna
54.			Magdalena Grzybowska	6-4 1-6 6-3
					Magui Serna
55.		[Q]	Nathalie Dechy		6-4 6-4
				Nathalie Dechy
56.			Petra Begerow	6-3 6-1
							Lindsay Davenport
57.			Patty Schnyder				6-0 6-3
				Patty Schnyder
58.			Dominique Monami	6-2 6-2
					Patty Schnyder
59.			Yuka Yoshida		4-6 6-2 6-4
				Yuka Yoshida
60.			Kristina Brandi	6-7 6-1 6-4
						Lindsay Davenport
61.			Wiltrud Probst			1-6 6-1 6-4
				Wiltrud Probst
62.			Lindsay Lee	6-1 5-7 6-3
					Lindsay Davenport
63.		[6]	Lindsay Davenport		6-2 6-3
				Lindsay Davenport
64.		[WC]	Lori McNeil	6-2 7-6
										Martina Hingis
65.		[8]	Anke Huber							6-0 6-4
				Anke Huber
66.			Gloria Pizzichini	6-2 6-2
					Anke Huber
67.		[WC]	Janet Lee		6-2 6-1
				Janet Lee
68.			Miho Saeki	6-3 6-7 6-3
						Venus Williams
69.			Venus Williams			6-3 6-4
				Venus Williams
70.			Larisa Savchenko	5-7 6-0 6-1
					Venus Williams
71.			Gala Leon Garcia		6-0 6-1
				Gala Leon Garcia
72.			Anne Miller	4-6 6-2 6-3
							Venus Williams
73.			Tamarine Tanasugarn				6-2 6-3
				Tamarine Tanasugarn
74.			Chanda Rubin	6-4 6-0
					Tamarine Tanasugarn
75.			Maria Vento-Kabchi		6-4 6-3
				Maria Vento-Kabchi
76.			Andrea Glass	1-6 7-6 6-2
						Joanette Kruger
77.			Henrieta Nagyova			6-7 7-5 6-4
				Henrieta Nagyova
78.			Aleksandra Olsza	6-3 6-0
					Joanette Kruger
79.			Joanette Kruger		6-4 7-6
				Joanette Kruger
80.		[14]	Barbara Paulus	6-1 6-7 6-1
								Venus Williams
81.			Lisa Raymond					7-5 7-5
				Lisa Raymond
82.		[15]	Ruxandra Dragomir	6-2 3-6 6-2
					Magdalena Maleeva
83.			Magdalena Maleeva		3-6 6-2 6-4
				Magdalena Maleeva
84.		[Q]	Pavlina Stoyanova	6-2 6-3
						Karina Habsudova
85.			Karina Habsudova			0-6 7-5 6-1
				Karina Habsudova
86.			Nathalie Tauziat	7-5 7-6
					Karina Habsudova
87.			Ai Sugiyama		5-7 6-3 7-5
				Ai Sugiyama
88.			Ann Grossman	6-7 7-5 6-2
							Sandrine Testud
89.			Patricia Hy				6-3 4-6 7-6
				Patricia Hy
90.			Marketa Kochta	6-2 6-1
					Elena Pampoulova
91.			Elena Pampoulova		6-3 0-6 7-6
				Elena Pampoulova
92.			Katarina Studenikova	6-2 6-3
						Sandrine Testud
93.			Sandrine Testud			6-1 6-3
				Sandrine Testud
94.			Maria Sanchez Lorenzo	6-3 6-3
					Sandrine Testud
95.		[4]	Iva Majoli		6-4 2-6 6-1
				Iva Majoli
96.			Catalina Cristea	6-3 6-2
									Venus Williams
97.		[5]	Amanda Coetzer						7-6 4-6 7-6
				Amanda Coetzer
98.			Nicole Arendt	6-3 6-2
					Amanda Coetzer
99.			Alexia Dechaume		6-1 6-1
				Alexia Dechaume
100.			Anne-Gaelle Sidot	6-3 3-6 6-3
						Amanda Coetzer
101.			Sarah Pitkowski			6-2 7-5
				Sarah Pitkowski
102.			Rene Simpson	6-1 4-6 7-6
					Flora Perfetti
103.			Flora Perfetti		6-4 6-3
				Flora Perfetti
104.			Els Callens	6-3 6-4
							Irina Spirlea
105.			Corina Morariu				7-6 6-4
				Corina Morariu
106.			Annabel Ellwood	7-6 7-6
					Lilia Osterloh
107.		[WC]	Lilia Osterloh		6-7 6-1 3-0 rtd.
				Lilia Osterloh
108.			Barbara Rittner	6-3 1-6 6-3
						Irina Spirlea
109.			Anna Kournikova			6-2 7-5
				Anna Kournikova
110.			Sabine Appelmans	6-2 6-0
					Irina Spirlea
111.		[11]	Irina Spirlea		6-1 3-6 6-3
				Irina Spirlea
112.			Amy Frazier	6-1 6-1
								Irina Spirlea
113.		[9]	Mary Pierce					6-7 7-6 6-3
				Mary Pierce
114.		[WC]	Gigi Fernandez	6-1 6-2
					Mary Pierce
115.			Silvia Farina		6-2 3-0 rtd.
				Silvia Farina
116.			Linda Harvey	6-4 6-7 6-4
						Mary Pierce
117.			Naoko Sawamatsu			7-6 6-1
				Naoko Sawamatsu
118.		[WC]	Erika De Lone	6-4 6-3
					Natasha Zvereva
119.			Natasha Zvereva		6-4 3-6 6-3
				Natasha Zvereva
120.			Radomira Zrubakova	6-1 7-5
							Monica Seles
121.			Meike Babel				1-6 6-2 6-2
				Meike Babel
122.			Tatiana Panova	6-4 6-1
					Miriam Oremans
123.			Miriam Oremans		7-5 6-1
				Miriam Oremans
124.			Elena Makarova	3-6 6-4 6-4
						Monica Seles
125.		[WC]	Tara Snyder			6-1 6-1
				Tara Snyder
126.		[Q]	Olga Lugina	6-0 7-6
					Monica Seles
127.		[2]	Monica Seles		6-2 6-3
				Monica Seles
128.			Kristie Boogert	6-1 6-2

(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` = '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` = '1997' 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` = (1416) 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, 9942, 10133, 9677, 10064, 9880, 10081, 10106, 9994, 9941, 10087, 9987, 10137, 9896, 9863, 10101, 9957, 9869, 10126, 10058, 9920, 9999, 10026, 10130, 9988, 10146, 9819, 10123, 9992, 9937, 9885, 9997, 9848, 10055, 10032, 9970, 10164, 9926, 10149, 10100, 10119, 10030, 13423, 10117, 10098, 10061, 9909, 10052, 9991, 11380, 10077, 10000, 10111, 10103, 10116, 10046, 10356, 10012, 10072, 10124, 9804, 10097, 10025, 9727, 9915, 10016, 10086, 10112, 10151, 9750, 10114, 10076, 10115, 9985, 10105, 10141, 10129, 10120, 10023, 9918, 10039, 10063, 9959, 10188, 9946, 10017, 10070, 9907, 9796, 9971, 9928, 10054, 9990, 10090, 10088, 10059, 10018, 9983, 9873, 10131, 10084, 9870, 10036, 10068, 10121, 10080, 10175, 9967, 10113, 9936, 10050, 9845, 10024, 9719, 10049, 10009, 9966, 9913, 9945, 9837, 10005, 10145, 9953, 10040, 10135, 10138, 9974, 10048) 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` = 1416	129	129	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (20, 168, 94, 197, 201, 68, 173, 184, 53, 10, 31, 153, 196, 36, 133, 179, 14, 104, 72, 13, 92, 154, 149, 21, 194, 50, 42, 181, 172, 121, 178, 151, 87)	33	33	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (20, 168, 94, 197, 201, 68, 173, 184, 53, 10, 31, 153, 196, 36, 133, 179, 14, 104, 72, 13, 92, 154, 149, 21, 194, 50, 42, 181, 172, 121, 178, 151, 87)	33	33	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10078, 9942, 10133, 9677, 10064, 9880, 10081, 10106, 9994, 9941, 10087, 9987, 10137, 9896, 9863, 10101, 9957, 9869, 10126, 10058, 9920, 9999, 10026, 10130, 9988, 10146, 9819, 10123, 9992, 9937, 9885, 9997, 9848, 10055, 10032, 9970, 10164, 9926, 10149, 10100, 10119, 10030, 13423, 10117, 10098, 10061, 9909, 10052, 9991, 11380, 10077, 10000, 10111, 10103, 10116, 10046, 10356, 10012, 10072, 10124, 9804, 10097, 10025, 9727, 9915, 10016, 10086, 10112, 10151, 9750, 10114, 10076, 10115, 9985, 10105, 10141, 10129, 10120, 10023, 9918, 10039, 10063, 9959, 10188, 9946, 10017, 10070, 9907, 9796, 9971, 9928, 10054, 9990, 10090, 10088, 10059, 10018, 9983, 9873, 10131, 10084, 9870, 10036, 10068, 10121, 10080, 10175, 9967, 10113, 9936, 10050, 9845, 10024, 9719, 10049, 10009, 9966, 9913, 9945, 9837, 10005, 10145, 9953, 10040, 10135, 10138, 9974, 10048)) AND (`Playercontest`.`contest_id` = 1416))	128	128	2
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` = 1997	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` = '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` = '1997' 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` = (1416) 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, 9942, 10133, 9677, 10064, 9880, 10081, 10106, 9994, 9941, 10087, 9987, 10137, 9896, 9863, 10101, 9957, 9869, 10126, 10058, 9920, 9999, 10026, 10130, 9988, 10146, 9819, 10123, 9992, 9937, 9885, 9997, 9848, 10055, 10032, 9970, 10164, 9926, 10149, 10100, 10119, 10030, 13423, 10117, 10098, 10061, 9909, 10052, 9991, 11380, 10077, 10000, 10111, 10103, 10116, 10046, 10356, 10012, 10072, 10124, 9804, 10097, 10025, 9727, 9915, 10016, 10086, 10112, 10151, 9750, 10114, 10076, 10115, 9985, 10105, 10141, 10129, 10120, 10023, 9918, 10039, 10063, 9959, 10188, 9946, 10017, 10070, 9907, 9796, 9971, 9928, 10054, 9990, 10090, 10088, 10059, 10018, 9983, 9873, 10131, 10084, 9870, 10036, 10068, 10121, 10080, 10175, 9967, 10113, 9936, 10050, 9845, 10024, 9719, 10049, 10009, 9966, 9913, 9945, 9837, 10005, 10145, 9953, 10040, 10135, 10138, 9974, 10048) 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` = 1416

129

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10078, 9942, 10133, 9677, 10064, 9880, 10081, 10106, 9994, 9941, 10087, 9987, 10137, 9896, 9863, 10101, 9957, 9869, 10126, 10058, 9920, 9999, 10026, 10130, 9988, 10146, 9819, 10123, 9992, 9937, 9885, 9997, 9848, 10055, 10032, 9970, 10164, 9926, 10149, 10100, 10119, 10030, 13423, 10117, 10098, 10061, 9909, 10052, 9991, 11380, 10077, 10000, 10111, 10103, 10116, 10046, 10356, 10012, 10072, 10124, 9804, 10097, 10025, 9727, 9915, 10016, 10086, 10112, 10151, 9750, 10114, 10076, 10115, 9985, 10105, 10141, 10129, 10120, 10023, 9918, 10039, 10063, 9959, 10188, 9946, 10017, 10070, 9907, 9796, 9971, 9928, 10054, 9990, 10090, 10088, 10059, 10018, 9983, 9873, 10131, 10084, 9870, 10036, 10068, 10121, 10080, 10175, 9967, 10113, 9936, 10050, 9845, 10024, 9719, 10049, 10009, 9966, 9913, 9945, 9837, 10005, 10145, 9953, 10040, 10135, 10138, 9974, 10048)) AND (`Playercontest`.`contest_id` = 1416))

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

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)