US Open 1994 Women's Singles (August 29 - September 11)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Steffi Graf
				Steffi Graf
2.		[WC]	Anne Mall	6-2 6-1
					Steffi Graf
3.			Sandra Cacic		6-0 6-2
				Sandra Cacic
4.			Angeles Montolio	7-5 6-3
						Steffi Graf
5.			Nicole Provis			6-2 6-3
				Nicole Provis
6.		[WC]	Jolene Watanabe	6-3 6-4
					Radka Bobkova
7.			Radka Bobkova		6-7 6-4 6-2
				Radka Bobkova
8.			Kimberly Po	3-6 7-5 7-6
							Steffi Graf
9.		[Q]	Maria Jose Gaidano				6-1 6-2
				Maria Jose Gaidano
10.		[WC]	Angela Lettiere	6-1 7-6
					Alexia Dechaume
11.			Alexia Dechaume		7-5 6-3
				Alexia Dechaume
12.			Miriam Oremans	6-4 6-3
						Zina Garrison
13.			Paola Suarez			2-6 6-4 7-6
				Paola Suarez
14.		[WC]	Julie Steven	7-6 6-2
					Zina Garrison
15.		[10]	Zina Garrison		6-4 6-3
				Zina Garrison
16.			Kristine Radford	6-3 6-4
								Steffi Graf
17.		[11]	Amanda Coetzer					6-0 6-2
				Amanda Coetzer
18.			Petra Ritter	6-1 7-6
					Amanda Coetzer
19.			Eugenia Maniokova		6-2 6-0
				Eugenia Maniokova
20.			Helen Kelesi	4-6 6-2 2-0 rtd.
						Amanda Coetzer
21.			Marianne Werdel			6-1 6-3
				Marianne Werdel
22.			Ludmila Richterova	6-3 2-6 6-4
					Mariaan De Swardt
23.		[Q]	Mariaan De Swardt		6-4 2-6 7-6
				Mariaan De Swardt
24.			Yayuk Basuki	6-3 6-4
							Amanda Coetzer
25.			Julie Halard				6-3 6-0
				Julie Halard
26.			Petra Langrova	6-1 3-6 6-2
					Mana Endo
27.			Mana Endo		6-1 7-5
				Mana Endo
28.			Tami Whitlinger	6-4 7-6
						Mana Endo
29.			Pam Shriver			6-3 7-6
				Pam Shriver
30.			Beate Reinstadler	7-6 6-4
					Lindsay Davenport
31.		[6]	Lindsay Davenport		6-1 6-2
				Lindsay Davenport
32.			Marzia Grossi	6-1 6-1
									Steffi Graf
33.		[4]	Mary Pierce						6-3 7-5
				Mary Pierce
34.		[Q]	Andrea Temesvari	6-3 6-2
					Mary Pierce
35.			Katarina Studenikova		6-3 2-6 6-4
				Katarina Studenikova
36.			Debbie Graham	6-3 3-6 6-4
						Mary Pierce
37.			Caroline Kuhlman			6-2 6-4
				Caroline Kuhlman
38.			Silke Frankl	6-3 6-1
					Judith Wiesner
39.			Judith Wiesner		6-2 6-2
				Judith Wiesner
40.			Romana Tedjakusuma	6-2 6-0
							Mary Pierce
41.			Iva Majoli				6-1 6-2
				Iva Majoli
42.			Noelle Van Lottum	6-1 2-0 rtd.
					Iva Majoli
43.			Elna Reinach		6-2 6-2
				Elna Reinach
44.		[Q]	Dianne Van Rensburg	6-3 2-6 6-4
						Iva Majoli
45.			Nicole Jagerman			6-2 6-3
				Nicole Jagerman
46.			Janette Husarova	7-5 6-1
					Anna Smashnova
47.			Anna Smashnova		6-2 3-6 6-3
				Anna Smashnova
48.		[13]	Lori McNeil	6-2 6-4
								Jana Novotna
49.		[15]	Magdalena Maleeva					6-4 6-0
				Magdalena Maleeva
50.			Chanda Rubin	6-3 6-3
					Magdalena Maleeva
51.			Ruxandra Dragomir		7-5 6-3
				Ruxandra Dragomir
52.			Kristie Boogert	7-5 6-2
						Magdalena Maleeva
53.			Linda Harvey			6-3 7-6
				Linda Harvey
54.			Adriana Serra-Zanetti	6-0 6-4
					Shaun Stafford
55.			Shaun Stafford		6-0 6-7 6-2
				Shaun Stafford
56.			Naoko Sawamatsu	2-6 7-6 6-4
							Jana Novotna
57.			Angelica Gavaldon				6-0 6-4
				Angelica Gavaldon
58.			Bettina Fulco	7-5 7-6
					Patricia Hy
59.			Patricia Hy		6-3 6-2
				Patricia Hy
60.			Florencia Labat	6-1 7-6
						Jana Novotna
61.			Karina Habsudova			6-1 6-2
				Karina Habsudova
62.			Dominique Monami	6-3 6-2
					Jana Novotna
63.		[7]	Jana Novotna		6-2 6-3
				Jana Novotna
64.			Elena Makarova	7-5 7-5
										Arantxa Sanchez-Vicario
65.		[8]	Gabriela Sabatini							1-6 7-6(3) 6-4
				Gabriela Sabatini
66.			Larisa Savchenko	6-0 6-1
					Gabriela Sabatini
67.			Meredith McGrath		6-4 6-7 6-1
				Meredith McGrath
68.			Tessa Price	6-1 6-2
						Gabriela Sabatini
69.			Radomira Zrubakova			6-0 6-2
				Radomira Zrubakova
70.			Patricia Tarabini	6-2 6-2
					Isabelle Demongeot
71.		[Q]	Isabelle Demongeot		3-6 6-1 6-2
				Isabelle Demongeot
72.		[Q]	Lea Ghirardi	6-2 6-3
							Gabriela Sabatini
73.			Silvia Farina				6-2 6-1
				Silvia Farina
74.		[WC]	Meilen Tu	7-5 6-7 6-1
					Elena Likhovtseva
75.			Elena Likhovtseva		7-5 2-6 6-3
				Elena Likhovtseva
76.			Joanette Kruger	6-2 6-4
						Elena Likhovtseva
77.			Natalia Medvedeva			7-6 7-6
				Natalia Medvedeva
78.			Barbara Schett	4-6 6-2 7-6
					Natalia Medvedeva
79.		[16]	Amy Frazier		6-2 6-7 6-4
				Amy Frazier
80.			Rachel McQuillan	6-0 6-3
								Gabriela Sabatini
81.			Gigi Fernandez					6-2 7-5
				Gigi Fernandez
82.		[12]	Sabine Hack	6-2 2-6 7-6
					Gigi Fernandez
83.			Sandrine Testud		7-5 6-3
				Sandrine Testud
84.		[Q]	Elena Brioukhovets	7-5 7-5
						Gigi Fernandez
85.			Shi-Ting Wang			6-3 6-2
				Shi-Ting Wang
86.			Fang Li	7-5 6-4
					Shi-Ting Wang
87.			Kyoko Nagatsuka		4-6 6-0 6-2
				Kyoko Nagatsuka
88.			Sandra Dopfer	6-1 6-3
							Gigi Fernandez
89.			Ginger Helgeson				6-3 6-4
				Ginger Helgeson
90.			Karin Kschwendt	6-2 6-1
					Ginger Helgeson
91.			Asa Carlsson		6-1 6-1
				Asa Carlsson
92.			Nancy Feber	4-6 6-1 6-2
						Ginger Helgeson
93.			Nicole Arendt			3-6 6-4 6-1
				Nicole Arendt
94.			Clare Wood	6-2 7-6
					Conchita Martinez
95.		[3]	Conchita Martinez		6-3 6-3
				Conchita Martinez
96.			Veronika Martinek	6-1 6-0
									Arantxa Sanchez-Vicario
97.		[5]	Kimiko Date						6-1 7-6
				Kimiko Date
98.		[Q]	Rika Hiraki	6-0 6-2
					Kimiko Date
99.			Yone Kamio		6-0 6-2
				Yone Kamio
100.			Laura Golarsa	6-4 6-4
						Kimiko Date
101.			Alexandra Fusai			6-4 6-2
				Alexandra Fusai
102.			Brenda Schultz	6-4 6-3
					Lisa Raymond
103.			Lisa Raymond		6-2 3-6 6-1
				Lisa Raymond
104.		[WC]	Carrie Cunningham	7-6 6-4
							Kimiko Date
105.			Barbara Rittner				6-2 6-7 7-5
				Barbara Rittner
106.			Manon Bollegraf	6-2 6-1
					Barbara Rittner
107.			Emanuela Zardo		6-0 6-3
				Emanuela Zardo
108.			Eva Martincova	6-3 6-0
						Leila Meskhi
109.			Leila Meskhi			4-6 6-3 6-2
				Leila Meskhi
110.			Ai Sugiyama	6-1 6-4
					Leila Meskhi
111.		[14]	Anke Huber		6-2 6-2
				Anke Huber
112.			Irina Spirlea	6-4 6-2
								Arantxa Sanchez-Vicario
113.		[9]	Mary Joe Fernandez					6-3 6-0
				Mary Joe Fernandez
114.			Sabine Appelmans	6-4 6-3
					Mary Joe Fernandez
115.			Patty Fendick		6-2 2-6 7-6
				Patty Fendick
116.		[WC]	Katrina Adams	6-7 6-4 6-3
						Ann Grossman
117.			Ann Grossman			6-4 6-4
				Ann Grossman
118.			Christina Singer	6-3 6-4
					Ann Grossman
119.			Katerina Maleeva		6-4 1-6 6-1
				Katerina Maleeva
120.			Marketa Kochta	6-1 6-2
							Arantxa Sanchez-Vicario
121.			Sandra Cecchini				6-2 6-0
				Sandra Cecchini
122.			Silke Meier	6-3 6-1
					Sandra Cecchini
123.		[WC]	Audra Keller		6-3 3-6 6-4
				Audra Keller
124.			Laurence Courtois	6-1 6-3
						Arantxa Sanchez-Vicario
125.			Nathalie Tauziat			6-2 6-1
				Nathalie Tauziat
126.			Stephanie Rottier	7-5 2-6 7-5
					Arantxa Sanchez-Vicario
127.		[2]	Arantxa Sanchez-Vicario		6-2 7-6
				Arantxa Sanchez-Vicario
128.			Linda Ferrando	7-5 6-1

(default) 17 queries took 53 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	3
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	8
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` = '1994' 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` = (1413) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	127	127	4
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (9715, 13425, 10061, 10069, 9768, 10058, 9989, 9991, 10056, 13426, 9873, 9953, 10119, 13427, 9706, 9868, 10018, 10007, 10013, 9771, 9798, 10081, 10074, 10032, 9829, 9880, 10014, 9942, 9656, 9921, 10025, 10038, 10024, 9741, 10054, 10002, 10019, 10001, 9781, 10060, 10088, 9970, 9780, 9793, 9830, 10045, 10062, 9727, 9959, 9985, 10063, 10048, 10009, 10095, 9916, 9966, 9941, 10010, 9796, 9994, 9946, 10012, 9848, 10040, 9883, 9750, 10047, 10034, 9837, 9963, 9938, 10089, 10049, 10126, 10064, 10023, 9926, 10077, 9845, 9819, 9719, 9975, 9990, 12484, 10028, 9987, 10035, 10030, 9972, 9890, 10101, 10093, 9983, 9851, 9885, 9881, 9930, 9988, 9998, 9896, 10026, 9863, 10039, 9911, 9967, 9784, 9944, 11380, 9914, 10070, 9915, 10050, 9909, 9936, 9857, 9866, 9907, 9790, 9756, 9971, 10091, 9900, 9922, 10037, 10017, 9961, 9957, 10057) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	4
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` = 1413	130	130	4
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 21, 87, 53, 133, 194, 178, 92, 172, 94, 68, 14, 153, 72, 10, 121, 168, 36, 42, 154, 50, 31, 173, 13, 71, 104, 91, 84, 181, 196, 179)	31	31	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 21, 87, 53, 133, 194, 178, 92, 172, 94, 68, 14, 153, 72, 10, 121, 168, 36, 42, 154, 50, 31, 173, 13, 71, 104, 91, 84, 181, 196, 179)	31	31	13
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9715, 13425, 10061, 10069, 9768, 10058, 9989, 9991, 10056, 13426, 9873, 9953, 10119, 13427, 9706, 9868, 10018, 10007, 10013, 9771, 9798, 10081, 10074, 10032, 9829, 9880, 10014, 9942, 9656, 9921, 10025, 10038, 10024, 9741, 10054, 10002, 10019, 10001, 9781, 10060, 10088, 9970, 9780, 9793, 9830, 10045, 10062, 9727, 9959, 9985, 10063, 10048, 10009, 10095, 9916, 9966, 9941, 10010, 9796, 9994, 9946, 10012, 9848, 10040, 9883, 9750, 10047, 10034, 9837, 9963, 9938, 10089, 10049, 10126, 10064, 10023, 9926, 10077, 9845, 9819, 9719, 9975, 9990, 12484, 10028, 9987, 10035, 10030, 9972, 9890, 10101, 10093, 9983, 9851, 9885, 9881, 9930, 9988, 9998, 9896, 10026, 9863, 10039, 9911, 9967, 9784, 9944, 11380, 9914, 10070, 9915, 10050, 9909, 9936, 9857, 9866, 9907, 9790, 9756, 9971, 10091, 9900, 9922, 10037, 10017, 9961, 9957, 10057)) AND (`Playercontest`.`contest_id` = 1413))	128	128	3
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	3
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1994	20	20	2
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 53 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` = '1994' 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` = (1413) 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 (9715, 13425, 10061, 10069, 9768, 10058, 9989, 9991, 10056, 13426, 9873, 9953, 10119, 13427, 9706, 9868, 10018, 10007, 10013, 9771, 9798, 10081, 10074, 10032, 9829, 9880, 10014, 9942, 9656, 9921, 10025, 10038, 10024, 9741, 10054, 10002, 10019, 10001, 9781, 10060, 10088, 9970, 9780, 9793, 9830, 10045, 10062, 9727, 9959, 9985, 10063, 10048, 10009, 10095, 9916, 9966, 9941, 10010, 9796, 9994, 9946, 10012, 9848, 10040, 9883, 9750, 10047, 10034, 9837, 9963, 9938, 10089, 10049, 10126, 10064, 10023, 9926, 10077, 9845, 9819, 9719, 9975, 9990, 12484, 10028, 9987, 10035, 10030, 9972, 9890, 10101, 10093, 9983, 9851, 9885, 9881, 9930, 9988, 9998, 9896, 10026, 9863, 10039, 9911, 9967, 9784, 9944, 11380, 9914, 10070, 9915, 10050, 9909, 9936, 9857, 9866, 9907, 9790, 9756, 9971, 10091, 9900, 9922, 10037, 10017, 9961, 9957, 10057) 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` = 1413

130

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9715, 13425, 10061, 10069, 9768, 10058, 9989, 9991, 10056, 13426, 9873, 9953, 10119, 13427, 9706, 9868, 10018, 10007, 10013, 9771, 9798, 10081, 10074, 10032, 9829, 9880, 10014, 9942, 9656, 9921, 10025, 10038, 10024, 9741, 10054, 10002, 10019, 10001, 9781, 10060, 10088, 9970, 9780, 9793, 9830, 10045, 10062, 9727, 9959, 9985, 10063, 10048, 10009, 10095, 9916, 9966, 9941, 10010, 9796, 9994, 9946, 10012, 9848, 10040, 9883, 9750, 10047, 10034, 9837, 9963, 9938, 10089, 10049, 10126, 10064, 10023, 9926, 10077, 9845, 9819, 9719, 9975, 9990, 12484, 10028, 9987, 10035, 10030, 9972, 9890, 10101, 10093, 9983, 9851, 9885, 9881, 9930, 9988, 9998, 9896, 10026, 9863, 10039, 9911, 9967, 9784, 9944, 11380, 9914, 10070, 9915, 10050, 9909, 9936, 9857, 9866, 9907, 9790, 9756, 9971, 10091, 9900, 9922, 10037, 10017, 9961, 9957, 10057)) AND (`Playercontest`.`contest_id` = 1413))

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

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)