Roland Garros 1975 Women's Singles (June 2 - June 15)

	Nation		R64	R32	R16	QF	SF	F	Champion
1.		[2]	Martina Navratilova
				Martina Navratilova
2.			Beatriz Araujo	6-4 6-4
					Martina Navratilova
3.			Nathalie Fuchs		7-5 6-3
				Nathalie Fuchs
4.			Marijke Jansen	6-4 6-2
						Martina Navratilova
5.			Lita Liem			6-2 2-6 6-3
				Lita Liem
6.			Michele Gurdal	4-6 7-6 6-4
					Pam Teeguarden
7.			Pam Teeguarden		4-6 7-5 9-7
				Pam Teeguarden
8.			Glynis Coles	6-2 7-6
							Martina Navratilova
9.		[5]	Helga Niessen				6-1 6-1
				Helga Niessen
10.			Sharon Walsh	6-1 6-1
					Dianne Fromholtz
11.			Dianne Fromholtz		3-6 6-1 6-3
				Dianne Fromholtz
12.			Lany Kaligis	5-7 6-1 6-0
						Donna Ganz
13.			Rosie Reyes			6-3 6-4
				Rosie Reyes
14.			Lea Pericoli	5-7 6-1 6-3
					Donna Ganz
15.			Donna Ganz		6-1 6-1
				Donna Ganz
16.			Mariana Simionescu	6-4 6-3
								Martina Navratilova
17.			Odile De Roubin					6-2 6-3
				Odile De Roubin
18.		[4]	Julie Heldman	7-5 4-6 6-0
					Odile De Roubin
19.		[LL]	Michelle Boulle		6-4 6-3
				Michelle Boulle
20.			Sue Mappin	6-2 6-3
						Eva Szabo
21.			Betsy Nagelsen			6-1 6-4
				Betsy Nagelsen
22.			Linda Rupert	6-2 6-7 6-1
					Eva Szabo
23.			Eva Szabo		6-3 6-4
				Eva Szabo
24.		[Q]	Antonella Rosa	6-3 6-4
							Janet Newberry
25.			Janet Newberry				6-1 6-2
				Janet Newberry
26.			Brigitte Simon	6-0 6-4
					Janet Newberry
27.			Margareta Strandberg		6-1 6-4
				Margareta Strandberg
28.			Ana-Maria Arias	6-1 6-3
						Janet Newberry
29.			Elly Appel			6-3 6-3
				Elly Appel
30.			Paulina Peisachov	6-4 6-1
					Elly Appel
31.			Julie Anthony		6-1 6-0
				Julie Anthony
32.			Ingrid Lofdahl	6-7 7-5 6-0
									Chris Evert
33.			Marina Kroschina						2-6 6-1 6-1
				Marina Kroschina
34.			Jeanne Evert	6-4 6-3
					Marina Kroschina
35.			Laurie Fleming Rowley		6-0 6-0
				Laurie Fleming Rowley
36.		[Q]	Christina Sandberg	7-5 6-2
						Raquel Giscafre
37.			Florence Guedy			6-2 6-3
				Florence Guedy
38.			Beatrix Klein	2-6 6-3 6-1
					Raquel Giscafre
39.		[7]	Raquel Giscafre		6-1 6-1
				Raquel Giscafre
40.			Maria-Victoria Baldovinos	6-7 6-2 6-0
							Olga Morozova
41.			Sue Barker				7-5 6-7 6-0
				Sue Barker
42.			Katja Burgemeister	6-4 6-2
					Sue Barker
43.			Linky Boshoff		6-2 6-1
				Linky Boshoff
44.		[Q]	Elvira Weisenberger	6-2 4-6 9-7
						Olga Morozova
45.			Virginia Ruzici			6-1 6-0
				Virginia Ruzici
46.			Maria Teresa Nasuelli	6-2 6-4
					Olga Morozova
47.		[3]	Olga Morozova		6-2 6-3
				Olga Morozova
48.		[LL]	Robin Tenney	6-2 6-1
								Chris Evert
49.		[Q]	Wendy Gilchrist					6-4 6-0
				Wendy Gilchrist
50.			Miroslava Bendlova	6-3 6-2
					Kazuko Sawamatsu
51.			Kazuko Sawamatsu		6-3 3-6 6-3
				Kazuko Sawamatsu
52.			Nicole Bimes	6-0 6-2
						Kazuko Sawamatsu
53.			Fiorella Bonicelli			7-6 6-3
				Fiorella Bonicelli
54.		[Q]	Florenta Mihai	6-3 6-2
					Fiorella Bonicelli
55.		[6]	Gail Sherriff		6-4 6-4
				Gail Sherriff
56.			Lesley Charles	6-3 6-0
							Chris Evert
57.			Marie Neumanova				6-2 6-2
				Marie Neumanova
58.			Helena Anliot	6-4 6-1
					Renata Tomanova
59.			Renata Tomanova		6-2 6-2
				Renata Tomanova
60.		[Q]	Iris Riedel	6-3 3-6 6-2
						Chris Evert
61.			Mima Jausovec			6-3 6-2
				Mima Jausovec
62.		[Q]	Daniela Marzano	6-4 6-4
					Chris Evert
63.		[1]	Chris Evert		6-2 6-3
				Chris Evert
64.			Carmen Perea-Alcala	6-2 6-2

(default) 17 queries took 21 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` = '1975' 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` = (1265) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	63	63	2
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (9582, 11234, 9529, 11195, 9463, 9545, 9573, 9533, 9396, 9515, 9513, 9477, 9398, 9414, 11235, 11215, 11117, 9561, 9436, 9577, 9636, 12446, 11164, 11224, 9551, 9603, 9559, 11175, 11237, 11238, 11239, 11089, 11240, 11241, 11242, 9503, 11212, 11243, 9423, 11232, 9554, 9618, 11220, 11228, 9638, 11180, 9520, 11227, 9464, 11213, 9539, 11176, 9451, 11244, 9363, 9544, 9660, 9552, 9606, 11245, 9670, 9610, 9672, 11214) 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` = 1265	65	65	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (178, 197, 133, 10, 41, 173, 196, 68, 198, 172, 212, 13, 21, 219, 87, 84, 217, 218, 92, 153, 91, 94)	22	22	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (178, 197, 133, 10, 41, 173, 196, 68, 198, 172, 212, 13, 21, 219, 87, 84, 217, 218, 92, 153, 91, 94)	22	22	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9582, 11234, 9529, 11195, 9463, 9545, 9573, 9533, 9396, 9515, 9513, 9477, 9398, 9414, 11235, 11215, 11117, 9561, 9436, 9577, 9636, 12446, 11164, 11224, 9551, 9603, 9559, 11175, 11237, 11238, 11239, 11089, 11240, 11241, 11242, 9503, 11212, 11243, 9423, 11232, 9554, 9618, 11220, 11228, 9638, 11180, 9520, 11227, 9464, 11213, 9539, 11176, 9451, 11244, 9363, 9544, 9660, 9552, 9606, 11245, 9670, 9610, 9672, 11214)) AND (`Playercontest`.`contest_id` = 1265))	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` = 1975	19	19	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, 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 21 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` = '1975' 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` = (1265) 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 (9582, 11234, 9529, 11195, 9463, 9545, 9573, 9533, 9396, 9515, 9513, 9477, 9398, 9414, 11235, 11215, 11117, 9561, 9436, 9577, 9636, 12446, 11164, 11224, 9551, 9603, 9559, 11175, 11237, 11238, 11239, 11089, 11240, 11241, 11242, 9503, 11212, 11243, 9423, 11232, 9554, 9618, 11220, 11228, 9638, 11180, 9520, 11227, 9464, 11213, 9539, 11176, 9451, 11244, 9363, 9544, 9660, 9552, 9606, 11245, 9670, 9610, 9672, 11214) 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` = 1265

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9582, 11234, 9529, 11195, 9463, 9545, 9573, 9533, 9396, 9515, 9513, 9477, 9398, 9414, 11235, 11215, 11117, 9561, 9436, 9577, 9636, 12446, 11164, 11224, 9551, 9603, 9559, 11175, 11237, 11238, 11239, 11089, 11240, 11241, 11242, 9503, 11212, 11243, 9423, 11232, 9554, 9618, 11220, 11228, 9638, 11180, 9520, 11227, 9464, 11213, 9539, 11176, 9451, 11244, 9363, 9544, 9660, 9552, 9606, 11245, 9670, 9610, 9672, 11214)) AND (`Playercontest`.`contest_id` = 1265))

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

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, 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)