Roland Garros 1991 Women's Singles (May 27 - June 9)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Monica Seles
				Monica Seles
2.			Radomira Zrubakova	6-3 6-0
					Monica Seles
3.			Mariaan De Swardt		6-0 6-2
				Mariaan De Swardt
4.		[WC]	Alexandra Fusai	6-7(2) 7-6(5) 6-1
						Monica Seles
5.			Patty Fendick			6-1 6-2
				Patty Fendick
6.			Angeliki Kanellopoulous	6-4 6-2
					Karine Quentrec
7.			Karine Quentrec		6-1 4-6 6-3
				Karine Quentrec
8.			Ginger Helgeson	7-6(7) 7-6(6)
							Monica Seles
9.			Sandra Cecchini				3-6 6-3 6-0
				Sandra Cecchini
10.			Isabel Cueto	6-3 3-6 7-5
					Sandra Cecchini
11.		[WC]	Catherine Suire		6-2 6-2
				Catherine Suire
12.			Pascale Paradis	6-2 6-3
						Sandra Cecchini
13.			Federica Bonsignori			6-3 6-4
				Federica Bonsignori
14.			Nathalie Herreman	6-3 6-4
					Anke Huber
15.		[16]	Anke Huber		6-0 6-2
				Anke Huber
16.			Laura Garrone	6-2 6-3
								Monica Seles
17.		[10]	Jennifer Capriati					6-0 7-5
				Jennifer Capriati
18.			Katia Piccolini	6-2 7-5
					Jennifer Capriati
19.			Andrea Temesvari		6-2 6-1
				Andrea Temesvari
20.			Nana Miyagi	6-1 6-3
						Jennifer Capriati
21.		[WC]	Noelle Van Lottum			6-3 6-0
				Noelle Van Lottum
22.			Elena Pampoulova	6-4 2-6 6-3
					Maya Kidowaki
23.			Maya Kidowaki		6-3 5-7 8-6
				Maya Kidowaki
24.			Brenda Schultz	6-4 6-4
							Conchita Martinez
25.			Carrie Cunningham				6-3 6-3
				Carrie Cunningham
26.			Stacey Martin	6-2 6-2
					Carrie Cunningham
27.			Julie Halard		6-2 7-5
				Julie Halard
28.			Karina Habsudova	6-4 7-5
						Conchita Martinez
29.			Stephanie Rehe			6-1 6-4
				Stephanie Rehe
30.			Yayuk Basuki	7-5 6-3
					Conchita Martinez
31.		[7]	Conchita Martinez		6-1 7-6(3)
				Conchita Martinez
32.			Judith Wiesner	6-4 6-3
									Monica Seles
33.		[3]	Gabriela Sabatini						6-4 6-1
				Gabriela Sabatini
34.			Marianne Werdel	6-1 6-1
					Gabriela Sabatini
35.			Emanuela Zardo		6-1 6-1
				Emanuela Zardo
36.			Mercedes Paz	6-3 6-2
						Gabriela Sabatini
37.			Veronika Martinek			6-2 6-1
				Veronika Martinek
38.			Claudia Porwik	6-1 6-0
					Mary Pierce
39.			Mary Pierce		6-3 6-0
				Mary Pierce
40.			Cecilia Dahlman	7-6(1) 6-0
							Gabriela Sabatini
41.			Gigi Fernandez				6-3 6-0
				Gigi Fernandez
42.			Tamaka Takagi	7-6(4) 6-2
					Rachel McQuillan
43.			Rachel McQuillan		6-2 6-2
				Rachel McQuillan
44.			Csilla Bartos	6-3 7-5
						Rachel McQuillan
45.			Helen Kelesi			6-4 2-6 6-4
				Helen Kelesi
46.			Barbara Rittner	6-0 6-2
					Helen Kelesi
47.		[12]	Helena Sukova		4-6 7-5 6-0
				Helena Sukova
48.			Eva Sviglerova	6-0 6-1
								Gabriela Sabatini
49.		[14]	Leila Meskhi					5-7 7-6(10) 6-0
				Leila Meskhi
50.		[LL]	Sandra Dopfer	6-2 6-2
					Leila Meskhi
51.			Claudia Kohde-Kilsch		7-5 6-1
				Claudia Kohde-Kilsch
52.			Sarah Loosemore	6-1 6-3
						Leila Meskhi
53.			Linda Harvey			6-3 6-1
				Linda Harvey
54.		[Q]	Nathalie Baudone	6-4 7-5
					Linda Harvey
55.			Laura Arraya		7-6(7) 6-7(7) 11-9
				Laura Arraya
56.			Samantha Smith	6-3 2-6 6-1
							Jana Novotna
57.			Cathy Caverzasio				6-0 7-6(7)
				Cathy Caverzasio
58.			Audra Keller	6-4 6-3
					Elena Brioukhovets
59.			Elena Brioukhovets		6-2 6-2
				Elena Brioukhovets
60.			Alexia Dechaume	1-6 6-2 7-5
						Jana Novotna
61.			Patricia Hy			7-6(6) 6-2
				Patricia Hy
62.			Catherine Mothes	6-2 6-2
					Jana Novotna
63.		[6]	Jana Novotna		6-2 6-1
				Jana Novotna
64.		[LL]	Silvia Farina	7-5 6-2
										Monica Seles
65.		[5]	Arantxa Sanchez-Vicario							6-3 6-4
				Arantxa Sanchez-Vicario
66.			Lori McNeil	6-2 6-2
					Arantxa Sanchez-Vicario
67.			Kristin Godridge		6-1 6-2
				Kristin Godridge
68.			Meredith McGrath	6-4 4-6 6-3
						Arantxa Sanchez-Vicario
69.		[Q]	Bettina Fulco			6-1 6-1
				Bettina Fulco
70.			Liz Sayers	6-4 6-0
					Bettina Fulco
71.			Cristina Tessi		6-2 6-2
				Cristina Tessi
72.			Clare Wood	6-4 6-1
							Arantxa Sanchez-Vicario
73.			Kathy Rinaldi				6-2 6-1
				Kathy Rinaldi
74.		[Q]	Leona Laskova	6-2 6-3
					Tami Whitlinger
75.			Tami Whitlinger		6-4 6-0
				Tami Whitlinger
76.			Erika De Lone	6-1 7-6(7)
						Tami Whitlinger
77.			Ann Grossman			7-6(7) 6-4
				Ann Grossman
78.			Laura Golarsa	7-5 6-0
					Ann Grossman
79.		[15]	Natasha Zvereva		4-6 6-1 6-4
				Natasha Zvereva
80.			Donna Faber	6-0 6-0
								Arantxa Sanchez-Vicario
81.		[11]	Katerina Maleeva					6-3 6-2
				Katerina Maleeva
82.		[Q]	Michelle Jaggard	6-3 6-4
					Katerina Maleeva
83.			Akiko Kijimuta		6-2 6-3
				Akiko Kijimuta
84.			Maria Strandlund	6-0 6-4
						Elna Reinach
85.			Elna Reinach			6-4 6-4
				Elna Reinach
86.			Manon Bollegraf	6-0 6-2
					Elna Reinach
87.			Halle Cioffi		6-3 6-1
				Halle Cioffi
88.			Linda Ferrando	7-5 4-6 6-0
							Mary Joe Fernandez
89.		[Q]	Petra Thoren				6-4 7-6(2)
				Petra Thoren
90.			Monique Javer	6-2 6-2
					Petra Thoren
91.			Larisa Savchenko		6-3 3-6 7-5
				Larisa Savchenko
92.		[WC]	Nathalie Housset	6-1 6-4
						Mary Joe Fernandez
93.			Sabine Hack			6-4 6-3
				Sabine Hack
94.			Jo Durie	6-4 7-5
					Mary Joe Fernandez
95.		[4]	Mary Joe Fernandez		6-4 6-0
				Mary Joe Fernandez
96.			Francesca Romano	6-3 6-0
									Arantxa Sanchez-Vicario
97.			Naoko Sawamatsu						6-0 6-2
				Naoko Sawamatsu
98.		[8]	Zina Garrison	6-4 6-0
					Naoko Sawamatsu
99.			Renata Marcinkowska		6-0 7-6(3)
				Renata Marcinkowska
100.		[WC]	Maider Laval	3-6 6-4 6-3
						Naoko Sawamatsu
101.		[WC]	Sybille Niox-Chateau			5-7 6-2 6-4
				Sybille Niox-Chateau
102.			Isabelle Demongeot	6-4 6-4
					Debbie Graham
103.			Debbie Graham		6-4 6-0
				Debbie Graham
104.			Beate Reinstadler	6-1 7-5
							Nathalie Tauziat
105.			Nicole Jagerman				7-5 2-6 12-10
				Nicole Jagerman
106.			Andrea Strnadova	6-2 6-4
					Nicole Jagerman
107.			Nicole Provis		6-4 5-7 6-3
				Nicole Provis
108.			Rika Hiraki	4-6 7-6(7) 6-2
						Nathalie Tauziat
109.		[WC]	Nathalie Guerree			6-4 6-0
				Nathalie Guerree
110.			Sara Gomer	6-3 7-6(11)
					Nathalie Tauziat
111.		[13]	Nathalie Tauziat		6-2 6-1
				Nathalie Tauziat
112.		[WC]	Pascale Etchemendy	6-3 6-1
								Steffi Graf
113.		[9]	Manuela Maleeva					6-3 6-2
				Manuela Maleeva
114.		[Q]	Nanne Dahlman	6-2 6-2
					Regina Rajchrtova
115.			Regina Rajchrtova		6-4 6-0
				Regina Rajchrtova
116.			Wiltrud Probst	6-4 6-3
						Sabine Appelmans
117.			Amanda Coetzer			6-2 6-0
				Amanda Coetzer
118.			Anne Minter	5-7 7-5 6-3
					Sabine Appelmans
119.			Sabine Appelmans		6-3 5-7 6-1
				Sabine Appelmans
120.		[Q]	Beverly Bowes	6-1 3-6 7-5
							Steffi Graf
121.			Shaun Stafford				6-2 6-2
				Shaun Stafford
122.			Catherine Tanvier	6-2 6-1
					Shaun Stafford
123.			Florencia Labat		6-3 7-5
				Florencia Labat
124.		[Q]	Stephanie Rottier	1-6 7-5 6-1
						Steffi Graf
125.			Petra Langrova			6-0 6-1
				Petra Langrova
126.			Sandrine Testud	6-2 0-6 9-7
					Steffi Graf
127.		[2]	Steffi Graf		6-0 6-1
				Steffi Graf
128.			Magdalena Maleeva	6-3 7-6(6)

(default) 17 queries took 30 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	3
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	3
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	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` = 2 AND `Contest`.`category_id` = 14 AND `Contest`.`slug` = '1991' 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` = (1281) 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 (9974, 9837, 10074, 10026, 9857, 11334, 9905, 9972, 10091, 9973, 9716, 9721, 9899, 9888, 9915, 11337, 9997, 11373, 9741, 9920, 9970, 9928, 9939, 9863, 9911, 9924, 9829, 9946, 9996, 10032, 9885, 9781, 9883, 9798, 9944, 9962, 9881, 9779, 10024, 9884, 9719, 9893, 9819, 9785, 9771, 9967, 9677, 9886, 9914, 10030, 9654, 9827, 10009, 10021, 9948, 9992, 9871, 9922, 12484, 9873, 9796, 11362, 9848, 10049, 9957, 9727, 9929, 10047, 10010, 9661, 9947, 9851, 9717, 11366, 9942, 9913, 9907, 9896, 9945, 9877, 9756, 9797, 9794, 9894, 9780, 9784, 9901, 10057, 9940, 9817, 9750, 10003, 9975, 9692, 9909, 9968, 9966, 9706, 9898, 9840, 9824, 9938, 10002, 9921, 9830, 9951, 9768, 9988, 9876, 9743, 10017, 9931, 9702, 9995, 9919, 9804, 10018, 9646, 9936, 9773, 9916, 9695, 9994, 9961, 9880, 9990, 9715, 9959) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	5
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` = 1281	130	130	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (21, 197, 87, 92, 133, 218, 179, 172, 72, 178, 67, 68, 14, 196, 147, 13, 217, 94, 36, 74, 10, 31, 173, 219, 84)	25	25	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (21, 197, 87, 92, 133, 218, 179, 172, 72, 178, 67, 68, 14, 196, 147, 13, 217, 94, 36, 74, 10, 31, 173, 219, 84)	25	25	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9974, 9837, 10074, 10026, 9857, 11334, 9905, 9972, 10091, 9973, 9716, 9721, 9899, 9888, 9915, 11337, 9997, 11373, 9741, 9920, 9970, 9928, 9939, 9863, 9911, 9924, 9829, 9946, 9996, 10032, 9885, 9781, 9883, 9798, 9944, 9962, 9881, 9779, 10024, 9884, 9719, 9893, 9819, 9785, 9771, 9967, 9677, 9886, 9914, 10030, 9654, 9827, 10009, 10021, 9948, 9992, 9871, 9922, 12484, 9873, 9796, 11362, 9848, 10049, 9957, 9727, 9929, 10047, 10010, 9661, 9947, 9851, 9717, 11366, 9942, 9913, 9907, 9896, 9945, 9877, 9756, 9797, 9794, 9894, 9780, 9784, 9901, 10057, 9940, 9817, 9750, 10003, 9975, 9692, 9909, 9968, 9966, 9706, 9898, 9840, 9824, 9938, 10002, 9921, 9830, 9951, 9768, 9988, 9876, 9743, 10017, 9931, 9702, 9995, 9919, 9804, 10018, 9646, 9936, 9773, 9916, 9695, 9994, 9961, 9880, 9990, 9715, 9959)) AND (`Playercontest`.`contest_id` = 1281))	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` = 1991	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 30 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` = '1991' 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` = (1281) 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 (9974, 9837, 10074, 10026, 9857, 11334, 9905, 9972, 10091, 9973, 9716, 9721, 9899, 9888, 9915, 11337, 9997, 11373, 9741, 9920, 9970, 9928, 9939, 9863, 9911, 9924, 9829, 9946, 9996, 10032, 9885, 9781, 9883, 9798, 9944, 9962, 9881, 9779, 10024, 9884, 9719, 9893, 9819, 9785, 9771, 9967, 9677, 9886, 9914, 10030, 9654, 9827, 10009, 10021, 9948, 9992, 9871, 9922, 12484, 9873, 9796, 11362, 9848, 10049, 9957, 9727, 9929, 10047, 10010, 9661, 9947, 9851, 9717, 11366, 9942, 9913, 9907, 9896, 9945, 9877, 9756, 9797, 9794, 9894, 9780, 9784, 9901, 10057, 9940, 9817, 9750, 10003, 9975, 9692, 9909, 9968, 9966, 9706, 9898, 9840, 9824, 9938, 10002, 9921, 9830, 9951, 9768, 9988, 9876, 9743, 10017, 9931, 9702, 9995, 9919, 9804, 10018, 9646, 9936, 9773, 9916, 9695, 9994, 9961, 9880, 9990, 9715, 9959) 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` = 1281

130

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (21, 197, 87, 92, 133, 218, 179, 172, 72, 178, 67, 68, 14, 196, 147, 13, 217, 94, 36, 74, 10, 31, 173, 219, 84)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (21, 197, 87, 92, 133, 218, 179, 172, 72, 178, 67, 68, 14, 196, 147, 13, 217, 94, 36, 74, 10, 31, 173, 219, 84)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9974, 9837, 10074, 10026, 9857, 11334, 9905, 9972, 10091, 9973, 9716, 9721, 9899, 9888, 9915, 11337, 9997, 11373, 9741, 9920, 9970, 9928, 9939, 9863, 9911, 9924, 9829, 9946, 9996, 10032, 9885, 9781, 9883, 9798, 9944, 9962, 9881, 9779, 10024, 9884, 9719, 9893, 9819, 9785, 9771, 9967, 9677, 9886, 9914, 10030, 9654, 9827, 10009, 10021, 9948, 9992, 9871, 9922, 12484, 9873, 9796, 11362, 9848, 10049, 9957, 9727, 9929, 10047, 10010, 9661, 9947, 9851, 9717, 11366, 9942, 9913, 9907, 9896, 9945, 9877, 9756, 9797, 9794, 9894, 9780, 9784, 9901, 10057, 9940, 9817, 9750, 10003, 9975, 9692, 9909, 9968, 9966, 9706, 9898, 9840, 9824, 9938, 10002, 9921, 9830, 9951, 9768, 9988, 9876, 9743, 10017, 9931, 9702, 9995, 9919, 9804, 10018, 9646, 9936, 9773, 9916, 9695, 9994, 9961, 9880, 9990, 9715, 9959)) AND (`Playercontest`.`contest_id` = 1281))

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

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)