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

	Nation		R64	R32	R16	QF	SF	F	Champion
1.		[1]	Mima Jausovec
				Mima Jausovec
2.			Sabina Simmonds	6-3 6-3
					Mima Jausovec
3.			Ingrid Lofdahl		6-2 6-1
				Ingrid Lofdahl
4.			Naoko Sato	6-7 6-4 6-3
						Mima Jausovec
5.		[Q]	Silvana Urroz			6-2 6-0
				Silvana Urroz
6.			Glynis Coles	4-6 7-6 6-2
					Pam Whytcross
7.			Pam Whytcross		6-1 6-2
				Pam Whytcross
8.			Lele Forood	6-1 6-0
							Mima Jausovec
9.		[8]	Nancy Richey				7-5 6-4
				Nancy Richey
10.			Michelle Tyler	6-0 6-3
					Nancy Richey
11.			Fiorella Bonicelli		6-4 5-7 6-1
				Fiorella Bonicelli
12.			Marcie Louie	6-4 6-3
						Pam Teeguarden
13.		[Q]	Donna Ganz			7-5 4-6 6-3
				Donna Ganz
14.			Candy Reynolds	7-6 5-7 6-4
					Pam Teeguarden
15.			Pam Teeguarden		6-4 4-6 7-5
				Pam Teeguarden
16.			Tanya Harford	7-5 7-6
								Mima Jausovec
17.		[4]	Regina Marsikova					6-1 3-6 6-3
				Regina Marsikova
18.			Marise Kruger	7-5 6-4
					Regina Marsikova
19.			Raquel Giscafre		6-4 6-2
				Raquel Giscafre
20.			Sharon Walsh	6-2 6-3
						Regina Marsikova
21.			Yvonne Vermaak			6-2 6-4
				Yvonne Vermaak
22.			Mary Struthers	6-2 6-3
					Yvonne Vermaak
23.			Marie Neumanova		1-6 6-1 6-2
				Marie Neumanova
24.			Rayni Fox	6-4 6-2
							Regina Marsikova
25.		[5]	Renata Tomanova				7-6 6-7 6-3
				Renata Tomanova
26.			Belinda Thompson	6-3 6-4
					Renata Tomanova
27.		[Q]	Carmen Perea-Alcala		6-1 7-5
				Carmen Perea-Alcala
28.			Kimiyo Yagahara	6-4 6-4
						Renata Tomanova
29.			Brigette Cuypers			6-3 6-4
				Brigette Cuypers
30.		[Q]	Sylvie Pruvot	5-7 7-6 6-0
					Brigette Cuypers
31.			Frederique Thibault		6-4 6-4
				Frederique Thibault
32.			Cynthia Sieler	7-6 7-6
									Mima Jausovec
33.			Sue Mappin						6-2 6-7 6-1
				Sue Mappin
34.			Mary Hamm	6-4 6-4
					Sue Mappin
35.			Katja Burgemeister		6-3 6-4
				Katja Burgemeister
36.			Marita Redondo	6-1 6-1
						Linky Boshoff
37.			Linky Boshoff			5-7 7-5 6-2
				Linky Boshoff
38.			Jackie Fayter	7-5 6-1
					Linky Boshoff
39.		[Q]	Viviana Gonzalez		4-6 6-3 6-3
				Viviana Gonzalez
40.		[6]	Lesley Hunt	6-0 6-0
							Florenta Mihai
41.			Lesley Charles				6-3 4-6 7-5
				Lesley Charles
42.		[Q]	Claudia Casabianca	6-1 4-6 10-8
					Florenta Mihai
43.			Florenta Mihai		4-6 6-3 6-3
				Florenta Mihai
44.			Florence Guedy	6-3 6-3
						Florenta Mihai
45.			Mary Carillo			3-6 6-3 8-6
				Mary Carillo
46.			Judith Connor	6-4 6-3
					Helga Niessen
47.		[3]	Helga Niessen		1-6 6-1 6-3
				Helga Niessen
48.			Michele Gurdal	6-2 6-4
								Florenta Mihai
49.			Laura DuPont					7-6 6-3
				Laura DuPont
50.			Nathalie Fuchs	6-1 2-6 6-2
					Laura DuPont
51.			Iris Riedel		6-1 6-2
				Iris Riedel
52.			Ilana Kloss	6-4 6-0
						Janet Newberry
53.			Heidi Eisterlehner			6-3 7-5
				Heidi Eisterlehner
54.			Bunny Bruning	7-6 7-6
					Janet Newberry
55.		[7]	Janet Newberry		6-3 6-4
				Janet Newberry
56.			Brigitte Simon	6-3 6-4
							Janet Newberry
57.			Helen Gourlay				6-4 5-7 6-2
				Helen Gourlay
58.		[LL]	Chris O'Neil	6-3 6-1
					Helen Gourlay
59.			Linda Mottram		6-0 6-2
				Linda Mottram
60.			Carolyn Meyer	6-3 6-2
						Kathy May
61.		[Q]	Hana Strachonova			6-2 6-2
				Hana Strachonova
62.			Kathy Harter	6-3 6-3
					Kathy May
63.		[2]	Kathy May		7-6 6-2
				Kathy May
64.			Diane Evers	6-4 6-4

(default) 17 queries took 19 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	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` = '1977' LIMIT 1	1	1	1
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` = (1267) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	63	63	1
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (9670, 9637, 11089, 9620, 11258, 9533, 9526, 9653, 9442, 9607, 9451, 9659, 11235, 9668, 9573, 9664, 9613, 11259, 9423, 9515, 9711, 11260, 9660, 9616, 9606, 9586, 11214, 13797, 11249, 11247, 9601, 9467, 9577, 11263, 9618, 11246, 11220, 9569, 11262, 9399, 9544, 11265, 11244, 11212, 11261, 9611, 9396, 9545, 9587, 9529, 11245, 11254, 9604, 9615, 9551, 9603, 9391, 9571, 9591, 11266, 9662, 9465, 11256, 9580) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	64	64	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` = 1267	66	66	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (198, 172, 197, 10, 135, 196, 212, 213, 13, 68, 21, 219, 178, NULL, 217, 153, 84, 173, 94, 92, 41)	20	20	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (198, 172, 197, 10, 135, 196, 212, 213, 13, 68, 21, 219, 178, NULL, 217, 153, 84, 173, 94, 92, 41)	20	20	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9670, 9637, 11089, 9620, 11258, 9533, 9526, 9653, 9442, 9607, 9451, 9659, 11235, 9668, 9573, 9664, 9613, 11259, 9423, 9515, 9711, 11260, 9660, 9616, 9606, 9586, 11214, 13797, 11249, 11247, 9601, 9467, 9577, 11263, 9618, 11246, 11220, 9569, 11262, 9399, 9544, 11265, 11244, 11212, 11261, 9611, 9396, 9545, 9587, 9529, 11245, 11254, 9604, 9615, 9551, 9603, 9391, 9571, 9591, 11266, 9662, 9465, 11256, 9580)) AND (`Playercontest`.`contest_id` = 1267))	64	64	1
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` = 1977	23	23	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 2, 3, 3, 1, 1, 12, 17, 22, 18, 13, 23, 4, 4, 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 19 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` = '1977' 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` = (1267) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC

SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (9670, 9637, 11089, 9620, 11258, 9533, 9526, 9653, 9442, 9607, 9451, 9659, 11235, 9668, 9573, 9664, 9613, 11259, 9423, 9515, 9711, 11260, 9660, 9616, 9606, 9586, 11214, 13797, 11249, 11247, 9601, 9467, 9577, 11263, 9618, 11246, 11220, 9569, 11262, 9399, 9544, 11265, 11244, 11212, 11261, 9611, 9396, 9545, 9587, 9529, 11245, 11254, 9604, 9615, 9551, 9603, 9391, 9571, 9591, 11266, 9662, 9465, 11256, 9580) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC

SELECT `Playercontest`.`id`, `Playercontest`.`player_id`, `Playercontest`.`contest_id`, `Playercontest`.`nat_id`, `Playercontest`.`draw` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE `Playercontest`.`contest_id` = 1267

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (198, 172, 197, 10, 135, 196, 212, 213, 13, 68, 21, 219, 178, NULL, 217, 153, 84, 173, 94, 92, 41)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (198, 172, 197, 10, 135, 196, 212, 213, 13, 68, 21, 219, 178, NULL, 217, 153, 84, 173, 94, 92, 41)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9670, 9637, 11089, 9620, 11258, 9533, 9526, 9653, 9442, 9607, 9451, 9659, 11235, 9668, 9573, 9664, 9613, 11259, 9423, 9515, 9711, 11260, 9660, 9616, 9606, 9586, 11214, 13797, 11249, 11247, 9601, 9467, 9577, 11263, 9618, 11246, 11220, 9569, 11262, 9399, 9544, 11265, 11244, 11212, 11261, 9611, 9396, 9545, 9587, 9529, 11245, 11254, 9604, 9615, 9551, 9603, 9391, 9571, 9591, 11266, 9662, 9465, 11256, 9580)) AND (`Playercontest`.`contest_id` = 1267))

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

SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 2, 3, 3, 1, 1, 12, 17, 22, 18, 13, 23, 4, 4, 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)