Roland Garros 1982 Women's Singles (May 24 - June 6)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Chris Evert
				Chris Evert
2.			bye
					Chris Evert
3.			Lele Forood		6-0 6-0
				Lele Forood
4.			Laura Arraya	6-4 1-6 6-3
						Chris Evert
5.			Kim Steinmetz			6-2 6-1
				Kim Steinmetz
6.			Pilar Vasquez	6-1 1-6 7-5
					Kim Steinmetz
7.			Pam Teeguarden		6-4 3-6 6-4
				Pam Teeguarden
8.			bye
							Chris Evert
9.			Brigitte Simon				6-2 6-0
				Brigitte Simon
10.			bye
					Brigitte Simon
11.			Jenny Klitch		6-3 6-3
				Jenny Klitch
12.			Hana Strachonova	6-2 6-1
						Pam Casale
13.			Tanya Harford			6-3 6-2
				Tanya Harford
14.			Isabelle Bianchi	6-3 7-6
					Pam Casale
15.		[16]	Pam Casale		6-1 6-3
				Pam Casale
16.			bye
								Chris Evert
17.		[10]	Billie Jean King					6-2 6-4
				Billie Jean King
18.			bye
					Billie Jean King
19.			Leigh-Anne Thompson		6-4 6-4
				Leigh-Anne Thompson
20.			Patricia Medrado	6-4 6-2
						Lucia Romanov
21.			Lucia Romanov			6-3 6-4
				Lucia Romanov
22.			Anne Hobbs	6-4 6-2
					Lucia Romanov
23.			Claudia Kohde-Kilsch		6-3 6-1
				Claudia Kohde-Kilsch
24.			bye
							Lucia Romanov
25.		[Q]	Michaela Pazderova				6-5 rtd.
				Michaela Pazderova
26.			Sophie Amiach	6-3 6-2
					Michaela Pazderova
27.			Renata Tomanova		6-2 6-1
				Renata Tomanova
28.			bye
						Anne Smith
29.			Susan Leo			6-1 6-2
				Susan Leo
30.			Betsy Nagelsen	6-4 6-4
					Anne Smith
31.		[8]	Anne Smith		6-3 6-1
				Anne Smith
32.			bye
									Andrea Jaeger
33.		[4]	Andrea Jaeger						6-3 6-1
				Andrea Jaeger
34.			bye
					Andrea Jaeger
35.			JoAnne Russell		6-0 6-2
				JoAnne Russell
36.			Claudia Pasquale	6-3 6-2
						Andrea Jaeger
37.			Sharon Walsh			6-0 6-1
				Sharon Walsh
38.			bye
					Helena Sukova
39.			Helena Sukova		6-3 6-4
				Helena Sukova
40.			bye
							Andrea Jaeger
41.			Catherine Tanvier				6-1 6-1
				Catherine Tanvier
42.			Deborah Jevans	6-2 6-2
					Catherine Tanvier
43.			Jo Durie		6-0 6-3
				Jo Durie
44.			Glynis Coles	1-6 6-4 6-3
						Dana Gilbert
45.			Dana Gilbert			6-3 7-6
				Dana Gilbert
46.			bye
					Dana Gilbert
47.			Sandra Collins		3-6 6-3 7-5
				Sandra Collins
48.		[Q]	Pascale Paradis	3-6 7-6 8-6
								Andrea Jaeger
49.		[11]	Virginia Ruzici					6-1 6-0
				Virginia Ruzici
50.			bye
					Virginia Ruzici
51.			Petra Delhees		7-6 6-1
				Petra Delhees
52.		[Q]	Elizabeth Jones	7-6 6-3
						Virginia Ruzici
53.		[Q]	Cornelia Dries			6-4 6-2
				Cornelia Dries
54.			Rosalyn Fairbank	1-6 6-4 6-2
					Paula Smith
55.			Paula Smith		6-3 6-1
				Paula Smith
56.			bye
							Virginia Ruzici
57.			Iris Riedel				6-4 6-2
				Iris Riedel
58.			bye
					Stacy Margolin
59.			Stacy Margolin		2-6 6-1 9-7
				Stacy Margolin
60.			Anne Minter	6-4 4-6 6-2
						Ivanna Madruga
61.			Ivanna Madruga			6-1 6-2
				Ivanna Madruga
62.			Rene Blount	6-0 6-4
					Ivanna Madruga
63.		[6]	Sylvia Hanika		6-4 1-6 6-4
				Sylvia Hanika
64.			bye
										Martina Navratilova
65.		[5]	Hana Mandlikova							7-6 6-1
				Hana Mandlikova
66.			bye
					Hana Mandlikova
67.			Betty Stove		6-3 6-4
				Betty Stove
68.			Marie Neumanova	6-4 6-4
						Hana Mandlikova
69.			Susan Mascarin			6-2 6-1
				Susan Mascarin
70.			Susan Rollinson	6-2 3-2 rtd.
					Virginia Wade
71.			Virginia Wade		6-3 6-3
				Virginia Wade
72.			bye
							Hana Mandlikova
73.			Wendy White				6-3 6-1
				Wendy White
74.			bye
					Wendy White
75.			Leslie Allen		6-2 7-5
				Leslie Allen
76.			Gail Sherriff	7-5 6-2
						Andrea Leand
77.			Frederique Thibault			7-5 6-1
				Frederique Thibault
78.			Laura DuPont	4-6 6-3 6-3
					Andrea Leand
79.		[12]	Andrea Leand		6-2 6-4
				Andrea Leand
80.			bye
								Hana Mandlikova
81.		[14]	Mary Lou Piatek					7-6 6-7 6-2
				Mary Lou Piatek
82.			bye
					Marcella Mesker
83.			Marcella Mesker		7-6 6-1
				Marcella Mesker
84.			Barbara Jordan	6-3 6-2
						Yvonne Vermaak
85.			Yvonne Vermaak			5-1 rtd.
				Yvonne Vermaak
86.			Trey Lewis	6-3 1-6 6-3
					Yvonne Vermaak
87.			Marianne Van Der Torre		6-4 6-4
				Marianne Van Der Torre
88.			bye
							Tracy Austin
89.			Duk-Hee Lee				6-2 6-0
				Duk-Hee Lee
90.			bye
					Andrea Temesvari
91.			Andrea Temesvari		6-0 6-1
				Andrea Temesvari
92.		[LL]	Michelle Torres	6-4 6-2
						Tracy Austin
93.			Eva Pfaff			7-5 6-0
				Eva Pfaff
94.			Elly Appel	6-3 6-0
					Tracy Austin
95.		[3]	Tracy Austin		6-2 6-4
				Tracy Austin
96.			bye
									Martina Navratilova
97.		[7]	Mima Jausovec						6-0 6-2
				Mima Jausovec
98.			bye
					Mima Jausovec
99.			Claudia Monteiro		6-3 6-2
				Claudia Monteiro
100.		[Q]	Anne Gabriel	6-2 5-7 6-4
						Mima Jausovec
101.			Bonnie Gadusek			w/o
				Bonnie Gadusek
102.			Lena Sandin	6-2 6-2
					Bonnie Gadusek
103.			Marcelis Skuherska		6-4 6-3
				Marcelis Skuherska
104.			bye
							Zina Garrison
105.			Beth Herr				7-5 6-1
				Beth Herr
106.			bye
					Beth Herr
107.			Iva Budarova		7-5 6-4
				Iva Budarova
108.			Kim Sands	3-6 6-1 6-3
						Zina Garrison
109.			Zina Garrison			6-0 6-4
				Zina Garrison
110.			Barbara Hallquist	6-1 6-1
					Zina Garrison
111.		[9]	Bettina Bunge		1-6 7-6 6-4
				Bettina Bunge
112.			bye
								Martina Navratilova
113.		[15]	Kathy Rinaldi					6-3 6-2
				Kathy Rinaldi
114.			bye
					Kathy Rinaldi
115.			Julie Harrington		6-2 6-4
				Julie Harrington
116.			Sabina Simmonds	2-6 6-2 6-3
						Kathy Rinaldi
117.			Kathy Horvath			4-6 6-3 6-2
				Kathy Horvath
118.			Barbara Rossi	6-1 6-1
					Kathy Horvath
119.			Corinne Vanier		6-3 6-3
				Corinne Vanier
120.			bye
							Martina Navratilova
121.			Manuela Maleeva				6-0 2-6 6-0
				Manuela Maleeva
122.			bye
					Lisa Bonder
123.			Lisa Bonder		7-5 6-1
				Lisa Bonder
124.		[Q]	Nancy Neviaser	7-5 6-0
						Martina Navratilova
125.			Candy Reynolds			6-1 6-3
				Candy Reynolds
126.			Kate Latham	6-3 3-6 6-3
					Martina Navratilova
127.		[2]	Martina Navratilova		6-1 6-1
				Martina Navratilova
128.			bye

(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` = '1982' 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` = (1272) 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 (9672, 9653, 9948, 9696, 9799, 9573, 9603, 11301, 9662, 9664, 9683, 9842, 9406, 11302, 11268, 11282, 9682, 9654, 9791, 9725, 9606, 9628, 9636, 9678, 9681, 11303, 11304, 9515, 9677, 9695, 11296, 9692, 9533, 11289, 9748, 9721, 9638, 9710, 11305, 11306, 9658, 9680, 11245, 11288, 9646, 11269, 9631, 9665, 9648, 9455, 9660, 9705, 11293, 9528, 9703, 9688, 9363, 9601, 9587, 9704, 9690, 9640, 9644, 9711, 11298, 9792, 9532, 9741, 11307, 9828, 11237, 9697, 9670, 9707, 11308, 9673, 11286, 9730, 9728, 9699, 9635, 9706, 9663, 9671, 9717, 11287, 9637, 9897, 11297, 9687, 9702, 9764, 11309, 9668, 9701, 9582) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	96	96	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` = 1272	96	96	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 68, 133, 217, 212, 196, 179, 172, 21, 147, 219, 100, 13, 10, 31, 29, 84, 153, 92, 178)	20	20	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 68, 133, 217, 212, 196, 179, 172, 21, 147, 219, 100, 13, 10, 31, 29, 84, 153, 92, 178)	20	20	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9672, 9653, 9948, 9696, 9799, 9573, 9603, 11301, 9662, 9664, 9683, 9842, 9406, 11302, 11268, 11282, 9682, 9654, 9791, 9725, 9606, 9628, 9636, 9678, 9681, 11303, 11304, 9515, 9677, 9695, 11296, 9692, 9533, 11289, 9748, 9721, 9638, 9710, 11305, 11306, 9658, 9680, 11245, 11288, 9646, 11269, 9631, 9665, 9648, 9455, 9660, 9705, 11293, 9528, 9703, 9688, 9363, 9601, 9587, 9704, 9690, 9640, 9644, 9711, 11298, 9792, 9532, 9741, 11307, 9828, 11237, 9697, 9670, 9707, 11308, 9673, 11286, 9730, 9728, 9699, 9635, 9706, 9663, 9671, 9717, 11287, 9637, 9897, 11297, 9687, 9702, 9764, 11309, 9668, 9701, 9582)) AND (`Playercontest`.`contest_id` = 1272))	96	96	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` = 1982	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` = '1982' 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` = (1272) 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 (9672, 9653, 9948, 9696, 9799, 9573, 9603, 11301, 9662, 9664, 9683, 9842, 9406, 11302, 11268, 11282, 9682, 9654, 9791, 9725, 9606, 9628, 9636, 9678, 9681, 11303, 11304, 9515, 9677, 9695, 11296, 9692, 9533, 11289, 9748, 9721, 9638, 9710, 11305, 11306, 9658, 9680, 11245, 11288, 9646, 11269, 9631, 9665, 9648, 9455, 9660, 9705, 11293, 9528, 9703, 9688, 9363, 9601, 9587, 9704, 9690, 9640, 9644, 9711, 11298, 9792, 9532, 9741, 11307, 9828, 11237, 9697, 9670, 9707, 11308, 9673, 11286, 9730, 9728, 9699, 9635, 9706, 9663, 9671, 9717, 11287, 9637, 9897, 11297, 9687, 9702, 9764, 11309, 9668, 9701, 9582) 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` = 1272

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 68, 133, 217, 212, 196, 179, 172, 21, 147, 219, 100, 13, 10, 31, 29, 84, 153, 92, 178)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 68, 133, 217, 212, 196, 179, 172, 21, 147, 219, 100, 13, 10, 31, 29, 84, 153, 92, 178)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9672, 9653, 9948, 9696, 9799, 9573, 9603, 11301, 9662, 9664, 9683, 9842, 9406, 11302, 11268, 11282, 9682, 9654, 9791, 9725, 9606, 9628, 9636, 9678, 9681, 11303, 11304, 9515, 9677, 9695, 11296, 9692, 9533, 11289, 9748, 9721, 9638, 9710, 11305, 11306, 9658, 9680, 11245, 11288, 9646, 11269, 9631, 9665, 9648, 9455, 9660, 9705, 11293, 9528, 9703, 9688, 9363, 9601, 9587, 9704, 9690, 9640, 9644, 9711, 11298, 9792, 9532, 9741, 11307, 9828, 11237, 9697, 9670, 9707, 11308, 9673, 11286, 9730, 9728, 9699, 9635, 9706, 9663, 9671, 9717, 11287, 9637, 9897, 11297, 9687, 9702, 9764, 11309, 9668, 9701, 9582)) AND (`Playercontest`.`contest_id` = 1272))

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

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)