Roland Garros 1994 Women's Singles (May 23 - June 5)

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

(default) 17 queries took 25 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` = 'roland-garros' 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` = (2)	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` = (2)	5	5	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` = (2)	5	5	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` = 'roland-garros' 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` = (14) ORDER BY `Contest`.`year` ASC	117	117	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` = 2 AND `Contest`.`category_id` = 14 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` = (1284) 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 (9715, 10054, 9961, 9926, 10023, 10013, 9837, 9888, 10050, 10071, 9905, 11380, 9941, 9790, 9909, 9946, 9677, 10037, 9851, 9719, 9999, 9797, 9966, 11337, 9890, 11376, 9991, 11362, 10088, 10012, 10049, 9883, 9953, 9582, 9936, 11381, 10007, 10039, 10017, 9921, 10081, 10077, 9942, 10035, 10091, 9845, 10063, 9959, 10024, 9768, 11382, 9796, 9727, 10051, 10048, 9938, 9971, 9697, 9756, 10009, 9989, 9819, 10018, 9930, 10062, 9848, 9916, 10040, 9880, 10010, 9907, 10069, 10026, 9830, 9987, 9771, 12484, 9784, 9975, 10056, 10001, 9706, 10038, 10019, 9873, 9944, 9804, 11379, 9863, 10119, 9798, 9656, 9972, 9780, 9885, 9750, 9945, 10060, 9781, 9964, 10028, 10101, 9900, 9998, 9829, 9963, 10046, 10047, 10031, 10089, 10025, 9985, 9915, 9990, 10005, 9857, 9914, 10059, 10061, 10014, 9967, 9868, 10030, 9896, 9970, 10057, 9957, 9994) 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` = 1284	130	130	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (21, 197, 72, 92, 53, 133, 194, 178, 68, 172, 153, 94, 14, 10, 121, 168, 36, 13, 42, 50, 154, 31, 173, 71, 149, 104, 91, 87, 181, 196, 179, 20)	32	32	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (21, 197, 72, 92, 53, 133, 194, 178, 68, 172, 153, 94, 14, 10, 121, 168, 36, 13, 42, 50, 154, 31, 173, 71, 149, 104, 91, 87, 181, 196, 179, 20)	32	32	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9715, 10054, 9961, 9926, 10023, 10013, 9837, 9888, 10050, 10071, 9905, 11380, 9941, 9790, 9909, 9946, 9677, 10037, 9851, 9719, 9999, 9797, 9966, 11337, 9890, 11376, 9991, 11362, 10088, 10012, 10049, 9883, 9953, 9582, 9936, 11381, 10007, 10039, 10017, 9921, 10081, 10077, 9942, 10035, 10091, 9845, 10063, 9959, 10024, 9768, 11382, 9796, 9727, 10051, 10048, 9938, 9971, 9697, 9756, 10009, 9989, 9819, 10018, 9930, 10062, 9848, 9916, 10040, 9880, 10010, 9907, 10069, 10026, 9830, 9987, 9771, 12484, 9784, 9975, 10056, 10001, 9706, 10038, 10019, 9873, 9944, 9804, 11379, 9863, 10119, 9798, 9656, 9972, 9780, 9885, 9750, 9945, 10060, 9781, 9964, 10028, 10101, 9900, 9998, 9829, 9963, 10046, 10047, 10031, 10089, 10025, 9985, 9915, 9990, 10005, 9857, 9914, 10059, 10061, 10014, 9967, 9868, 10030, 9896, 9970, 10057, 9957, 9994)) AND (`Playercontest`.`contest_id` = 1284))	128	128	2
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 14 ORDER BY `Contest`.`date_from` ASC	117	117	1
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 25 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` = 'roland-garros' 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` = (2)

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` = (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`, `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` = 'roland-garros' AND `Category`.`slug` = 'women-singles' LIMIT 1

117

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` = 2 AND `Contest`.`category_id` = 14 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` = (1284) 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, 10054, 9961, 9926, 10023, 10013, 9837, 9888, 10050, 10071, 9905, 11380, 9941, 9790, 9909, 9946, 9677, 10037, 9851, 9719, 9999, 9797, 9966, 11337, 9890, 11376, 9991, 11362, 10088, 10012, 10049, 9883, 9953, 9582, 9936, 11381, 10007, 10039, 10017, 9921, 10081, 10077, 9942, 10035, 10091, 9845, 10063, 9959, 10024, 9768, 11382, 9796, 9727, 10051, 10048, 9938, 9971, 9697, 9756, 10009, 9989, 9819, 10018, 9930, 10062, 9848, 9916, 10040, 9880, 10010, 9907, 10069, 10026, 9830, 9987, 9771, 12484, 9784, 9975, 10056, 10001, 9706, 10038, 10019, 9873, 9944, 9804, 11379, 9863, 10119, 9798, 9656, 9972, 9780, 9885, 9750, 9945, 10060, 9781, 9964, 10028, 10101, 9900, 9998, 9829, 9963, 10046, 10047, 10031, 10089, 10025, 9985, 9915, 9990, 10005, 9857, 9914, 10059, 10061, 10014, 9967, 9868, 10030, 9896, 9970, 10057, 9957, 9994) 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` = 1284

130

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9715, 10054, 9961, 9926, 10023, 10013, 9837, 9888, 10050, 10071, 9905, 11380, 9941, 9790, 9909, 9946, 9677, 10037, 9851, 9719, 9999, 9797, 9966, 11337, 9890, 11376, 9991, 11362, 10088, 10012, 10049, 9883, 9953, 9582, 9936, 11381, 10007, 10039, 10017, 9921, 10081, 10077, 9942, 10035, 10091, 9845, 10063, 9959, 10024, 9768, 11382, 9796, 9727, 10051, 10048, 9938, 9971, 9697, 9756, 10009, 9989, 9819, 10018, 9930, 10062, 9848, 9916, 10040, 9880, 10010, 9907, 10069, 10026, 9830, 9987, 9771, 12484, 9784, 9975, 10056, 10001, 9706, 10038, 10019, 9873, 9944, 9804, 11379, 9863, 10119, 9798, 9656, 9972, 9780, 9885, 9750, 9945, 10060, 9781, 9964, 10028, 10101, 9900, 9998, 9829, 9963, 10046, 10047, 10031, 10089, 10025, 9985, 9915, 9990, 10005, 9857, 9914, 10059, 10061, 10014, 9967, 9868, 10030, 9896, 9970, 10057, 9957, 9994)) AND (`Playercontest`.`contest_id` = 1284))

128

SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 14 ORDER BY `Contest`.`date_from` ASC

117

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)