Wimbledon 1994 Ladies' Singles (June 20 - July 2)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.			Lori McNeil
				Lori McNeil
2.		[1]	Steffi Graf	7-5 7-6(5)
					Lori McNeil
3.			Yone Kamio		6-3 6-7(5) 6-3
				Yone Kamio
4.			Petra Begerow	6-0 6-2
						Lori McNeil
5.			Kristie Boogert			6-2 6-4
				Kristie Boogert
6.		[Q]	Liz Sayers	6-4 4-6 6-2
					Kristie Boogert
7.		[Q]	Alexia Dechaume		6-3 7-5
				Alexia Dechaume
8.			Kyoko Nagatsuka	6-3 7-5
							Lori McNeil
9.			Rachel McQuillan				7-6(4) 7-6(4)
				Rachel McQuillan
10.			Patty Fendick	6-3 2-6 6-3
					Pam Shriver
11.			Pam Shriver		5-7 6-2 8-6
				Pam Shriver
12.			Amy Frazier	6-7(4) 6-2 8-6
						Florencia Labat
13.			Petra Langrova			6-4 4-6 6-2
				Petra Langrova
14.			Helen Kelesi	7-6(6) 6-2
					Florencia Labat
15.			Florencia Labat		6-2 6-2
				Florencia Labat
16.		[15]	Sabine Hack	6-3 3-6 6-4
								Lori McNeil
17.		[14]	Amanda Coetzer					6-3 6-4
				Amanda Coetzer
18.			Elena Likhovtseva	6-4 6-0
					Amanda Coetzer
19.		[Q]	Louise Field		6-4 6-0
				Louise Field
20.			Chanda Rubin	6-2 6-7(4) 8-6
						Amanda Coetzer
21.		[LL]	Claire Wegink			6-0 6-3
				Claire Wegink
22.		[WC]	Amanda Wainwright	6-2 6-3
					Ginger Helgeson
23.			Ginger Helgeson		6-2 6-2
				Ginger Helgeson
24.			Veronika Martinek	6-3 6-2
							Larisa Savchenko
25.			Larisa Savchenko				1-6 6-3 6-4
				Larisa Savchenko
26.		[Q]	Katrina Adams	6-4 6-3
					Larisa Savchenko
27.			Anna Smashnova		6-3 6-4
				Anna Smashnova
28.			Eugenia Maniokova	6-4 4-6 7-5
						Larisa Savchenko
29.			Shirli-Ann Siddall			6-3 6-2
				Shirli-Ann Siddall
30.			Christina Singer	6-4 5-7 7-5
					Kimiko Date
31.		[6]	Kimiko Date		6-2 6-0
				Kimiko Date
32.		[LL]	Ai Sugiyama	6-3 7-6(0)
									Conchita Martinez
33.		[3]	Conchita Martinez						3-6 6-2 10-8
				Conchita Martinez
34.			Rene Simpson	6-1 6-3
					Conchita Martinez
35.		[Q]	Nana Miyagi		6-3 7-6(3)
				Nana Miyagi
36.			Lisa Raymond	4-6 7-5 8-6
						Conchita Martinez
37.			Nathalie Tauziat			6-1 6-3
				Nathalie Tauziat
38.			Asa Carlsson	6-2 6-1
					Nathalie Tauziat
39.			Elna Reinach		6-3 6-7(4) 6-2
				Elna Reinach
40.			Joanette Kruger	7-6(6) 6-3
							Conchita Martinez
41.			Kristine Radford				3-6 6-3 6-4
				Kristine Radford
42.			Angelica Gavaldon	6-0 6-0
					Kristine Radford
43.			Irina Spirlea		7-5 3-6 6-4
				Irina Spirlea
44.		[WC]	Monique Javer	6-1 6-2
						Kristine Radford
45.			Ines Gorrochategui			w/o
				Ines Gorrochategui
46.			Debbie Graham	6-3 6-1
					Ines Gorrochategui
47.		[12]	Anke Huber		6-3 6-4
				Anke Huber
48.		[WC]	Jo Durie	7-5 6-2
								Conchita Martinez
49.		[10]	Gabriela Sabatini					6-2 6-7(4) 6-3
				Gabriela Sabatini
50.			Judith Wiesner	2-6 6-4 6-1
					Gabriela Sabatini
51.			Jenny Byrne		6-2 6-3
				Jenny Byrne
52.			Janette Husarova	6-3 6-0
						Gabriela Sabatini
53.			Caroline Kuhlman			6-4 6-1
				Caroline Kuhlman
54.			Karine Quentrec	3-6 7-5 6-4
					Meredith McGrath
55.			Meredith McGrath		6-1 6-3
				Meredith McGrath
56.		[WC]	Julie Pullin	6-2 6-4
							Lindsay Davenport
57.			Ruxandra Dragomir				6-1 6-3
				Ruxandra Dragomir
58.			Clare Wood	6-3 6-1
					Barbara Rittner
59.			Barbara Rittner		6-2 6-1
				Barbara Rittner
60.			Sabine Appelmans	6-0 6-4
						Lindsay Davenport
61.		[LL]	Tessa Price			6-4 3-6 6-1
				Tessa Price
62.		[LL]	Andrea Strnadova	6-3 7-5
					Lindsay Davenport
63.		[9]	Lindsay Davenport		6-4 6-2
				Lindsay Davenport
64.			Julie Halard	6-1 6-4
										Conchita Martinez
65.		[5]	Jana Novotna							6-4 3-6 6-3
				Jana Novotna
66.			Miriam Oremans	6-4 4-6 6-4
					Jana Novotna
67.			Wiltrud Probst		6-2 6-1
				Wiltrud Probst
68.			Sandrine Testud	6-2 6-1
						Jana Novotna
69.			Elena Brioukhovets			6-0 4-6 6-0
				Elena Brioukhovets
70.			Alexandra Fusai	7-5 7-5
					Dominique Monami
71.			Dominique Monami		6-1 4-6 6-2
				Dominique Monami
72.		[WC]	Joanne Ward	6-0 6-2
							Jana Novotna
73.			Naoko Sawamatsu				6-3 6-3
				Naoko Sawamatsu
74.			Caroline Vis	7-6(4) 6-3
					Naoko Sawamatsu
75.			Radka Bobkova		6-1 6-3
				Radka Bobkova
76.			Ludmila Richterova	6-3 6-1
						Naoko Sawamatsu
77.			Brenda Schultz			6-0 7-5
				Brenda Schultz
78.			Leila Meskhi	2-6 6-3 6-4
					Mary Joe Fernandez
79.		[11]	Mary Joe Fernandez		6-4 6-4
				Mary Joe Fernandez
80.			Karina Habsudova	6-4 6-2
								Martina Navratilova
81.		[17]	Helena Sukova					5-7 6-0 6-1
				Helena Sukova
82.			Tami Whitlinger	6-7(7) 6-0 6-3
					Helena Sukova
83.			Patricia Tarabini		6-4 6-2
				Patricia Tarabini
84.			Petra Ritter	6-3 3-6 8-6
						Helena Sukova
85.			Silke Frankl			6-3 6-2
				Silke Frankl
86.			Barbara Schett	6-1 7-6(1)
					Silke Frankl
87.			Sandra Cacic		2-6 6-1 6-3
				Sandra Cacic
88.			Iva Majoli	4-6 6-3 6-4
							Martina Navratilova
89.			Linda Harvey				6-1 6-2
				Linda Harvey
90.			Manon Bollegraf	6-1 4-6 6-3
					Linda Harvey
91.			Meike Babel		6-2 2-6 6-2
				Meike Babel
92.			Paola Suarez	4-6 6-2 6-1
						Martina Navratilova
93.			Sandra Cecchini			6-3 6-2
				Sandra Cecchini
94.			Patricia Hy	6-2 6-4
					Martina Navratilova
95.		[4]	Martina Navratilova		6-2 6-0
				Martina Navratilova
96.		[WC]	Claire Taylor	6-2 6-3
									Martina Navratilova
97.			Mana Endo						6-4 7-6(6)
				Mana Endo
98.		[8]	Natasha Zvereva	4-6 6-4 6-1
					Mana Endo
99.			Jolene Watanabe		6-3 6-4
				Jolene Watanabe
100.		[WC]	Karen Cross	6-2 6-4
						Gigi Fernandez
101.			Kimberly Po			4-6 6-3 6-3
				Kimberly Po
102.			Marketa Kochta	6-2 6-4
					Gigi Fernandez
103.			Gigi Fernandez		6-2 1-6 9-7
				Gigi Fernandez
104.			Marzia Grossi	6-2 6-1
							Gigi Fernandez
105.			Ann Grossman				6-4 6-1
				Ann Grossman
106.			Silvia Farina	6-2 6-4
					Ann Grossman
107.			Nicole Arendt		6-4 3-6 6-4
				Nicole Arendt
108.			Nicole Jagerman	6-3 6-2
						Yayuk Basuki
109.			Yayuk Basuki			6-3 6-2
				Yayuk Basuki
110.			Natalia Medvedeva	6-3 6-2
					Yayuk Basuki
111.		[16]	Magdalena Maleeva		5-7 7-6(3) 6-4
				Magdalena Maleeva
112.			Shaun Stafford	6-7(6) 6-2 6-4
								Gigi Fernandez
113.		[13]	Zina Garrison					6-4 6-4
				Zina Garrison
114.			Katarina Studenikova	6-3 7-6(4)
					Zina Garrison
115.		[Q]	Mercedes Paz		7-5 6-0
				Mercedes Paz
116.			Sandra Dopfer	6-1 7-6(2)
						Zina Garrison
117.			Fang Li			6-2 4-1 rtd.
				Fang Li
118.			Emanuela Zardo	6-4 6-3
					Laura Golarsa
119.			Laura Golarsa		6-3 6-0
				Laura Golarsa
120.		[Q]	Isabelle Demongeot	6-3 7-6(3)
							Zina Garrison
121.			Marianne Werdel				7-5 4-6 6-3
				Marianne Werdel
122.			Bettina Fulco	6-2 5-7 6-2
					Nancy Feber
123.		[Q]	Nancy Feber		6-4 6-4
				Nancy Feber
124.			Laurence Courtois	6-0 6-1
						Arantxa Sanchez-Vicario
125.			Maria Jose Gaidano			6-2 6-1
				Maria Jose Gaidano
126.			Beate Reinstadler	7-6(6) 7-5
					Arantxa Sanchez-Vicario
127.		[2]	Arantxa Sanchez-Vicario		6-2 6-1
				Arantxa Sanchez-Vicario
128.			Katerina Maleeva	6-1 6-2

(default) 17 queries took 58 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	2
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	2
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	6
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` = '1994' LIMIT 1	1	1	18
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` = (1805) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	127	127	3
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (9727, 9715, 9998, 10046, 10048, 9661, 9873, 10035, 9819, 9857, 9656, 9845, 9880, 9771, 9994, 9975, 10018, 10064, 9742, 9985, 12492, 12495, 9972, 9881, 9750, 9866, 10062, 10013, 12490, 9790, 9930, 10070, 9885, 9870, 9920, 10039, 10017, 10101, 9780, 10023, 9868, 9941, 10050, 9817, 9999, 10002, 9915, 9692, 9883, 9781, 9739, 10045, 10019, 9905, 10047, 10191, 10063, 9851, 9967, 9936, 10034, 9951, 10025, 9829, 9848, 9953, 9804, 9990, 12484, 10026, 10012, 12497, 9966, 10051, 9989, 10081, 9863, 9914, 9909, 9946, 9677, 9942, 9963, 10007, 10001, 10077, 10061, 10088, 10009, 9784, 10005, 10119, 10091, 9796, 9582, 12498, 10014, 9945, 10058, 12496, 9991, 9971, 9719, 10038, 9907, 10049, 9983, 9830, 10032, 9926, 9959, 9916, 9706, 10054, 9962, 10030, 9987, 9944, 9896, 9938, 9798, 10010, 10093, 10037, 10056, 9921, 9957, 9756) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	9
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` = 1805	131	131	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 21, 72, 87, 53, 133, 194, 13, 178, 92, 172, 196, 94, 68, 14, 153, 10, 121, 168, 36, 42, 154, 50, 31, 173, 71, 104, 91, 179, 20)	30	30	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 21, 72, 87, 53, 133, 194, 13, 178, 92, 172, 196, 94, 68, 14, 153, 10, 121, 168, 36, 42, 154, 50, 31, 173, 71, 104, 91, 179, 20)	30	30	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9727, 9715, 9998, 10046, 10048, 9661, 9873, 10035, 9819, 9857, 9656, 9845, 9880, 9771, 9994, 9975, 10018, 10064, 9742, 9985, 12492, 12495, 9972, 9881, 9750, 9866, 10062, 10013, 12490, 9790, 9930, 10070, 9885, 9870, 9920, 10039, 10017, 10101, 9780, 10023, 9868, 9941, 10050, 9817, 9999, 10002, 9915, 9692, 9883, 9781, 9739, 10045, 10019, 9905, 10047, 10191, 10063, 9851, 9967, 9936, 10034, 9951, 10025, 9829, 9848, 9953, 9804, 9990, 12484, 10026, 10012, 12497, 9966, 10051, 9989, 10081, 9863, 9914, 9909, 9946, 9677, 9942, 9963, 10007, 10001, 10077, 10061, 10088, 10009, 9784, 10005, 10119, 10091, 9796, 9582, 12498, 10014, 9945, 10058, 12496, 9991, 9971, 9719, 10038, 9907, 10049, 9983, 9830, 10032, 9926, 9959, 9916, 9706, 10054, 9962, 10030, 9987, 9944, 9896, 9938, 9798, 10010, 10093, 10037, 10056, 9921, 9957, 9756)) AND (`Playercontest`.`contest_id` = 1805))	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	2
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1994	20	20	4
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	2
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 58 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` = '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` = (1805) 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 (9727, 9715, 9998, 10046, 10048, 9661, 9873, 10035, 9819, 9857, 9656, 9845, 9880, 9771, 9994, 9975, 10018, 10064, 9742, 9985, 12492, 12495, 9972, 9881, 9750, 9866, 10062, 10013, 12490, 9790, 9930, 10070, 9885, 9870, 9920, 10039, 10017, 10101, 9780, 10023, 9868, 9941, 10050, 9817, 9999, 10002, 9915, 9692, 9883, 9781, 9739, 10045, 10019, 9905, 10047, 10191, 10063, 9851, 9967, 9936, 10034, 9951, 10025, 9829, 9848, 9953, 9804, 9990, 12484, 10026, 10012, 12497, 9966, 10051, 9989, 10081, 9863, 9914, 9909, 9946, 9677, 9942, 9963, 10007, 10001, 10077, 10061, 10088, 10009, 9784, 10005, 10119, 10091, 9796, 9582, 12498, 10014, 9945, 10058, 12496, 9991, 9971, 9719, 10038, 9907, 10049, 9983, 9830, 10032, 9926, 9959, 9916, 9706, 10054, 9962, 10030, 9987, 9944, 9896, 9938, 9798, 10010, 10093, 10037, 10056, 9921, 9957, 9756) 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` = 1805

131

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9727, 9715, 9998, 10046, 10048, 9661, 9873, 10035, 9819, 9857, 9656, 9845, 9880, 9771, 9994, 9975, 10018, 10064, 9742, 9985, 12492, 12495, 9972, 9881, 9750, 9866, 10062, 10013, 12490, 9790, 9930, 10070, 9885, 9870, 9920, 10039, 10017, 10101, 9780, 10023, 9868, 9941, 10050, 9817, 9999, 10002, 9915, 9692, 9883, 9781, 9739, 10045, 10019, 9905, 10047, 10191, 10063, 9851, 9967, 9936, 10034, 9951, 10025, 9829, 9848, 9953, 9804, 9990, 12484, 10026, 10012, 12497, 9966, 10051, 9989, 10081, 9863, 9914, 9909, 9946, 9677, 9942, 9963, 10007, 10001, 10077, 10061, 10088, 10009, 9784, 10005, 10119, 10091, 9796, 9582, 12498, 10014, 9945, 10058, 12496, 9991, 9971, 9719, 10038, 9907, 10049, 9983, 9830, 10032, 9926, 9959, 9916, 9706, 10054, 9962, 10030, 9987, 9944, 9896, 9938, 9798, 10010, 10093, 10037, 10056, 9921, 9957, 9756)) AND (`Playercontest`.`contest_id` = 1805))

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