Roland Garros 1989 Women's Singles (May 29 - June 11)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Steffi Graf
				Steffi Graf
2.			Camille Benjamin	6-1 6-1
					Steffi Graf
3.			Bettina Fulco		6-0 6-1
				Bettina Fulco
4.		[Q]	Petra Ritter	7-5 6-7(3) 8-6
						Steffi Graf
5.			Nicole Jagerman			6-1 6-2
				Nicole Jagerman
6.			Tine Scheuer-Larsen	6-2 7-6(2)
					Nicole Jagerman
7.			Michelle Jaggard		6-3 6-3
				Michelle Jaggard
8.			Amy Frazier	6-0 6-3
							Steffi Graf
9.		[Q]	Silvia La Fratta				6-2 6-1
				Silvia La Fratta
10.			Gigi Fernandez	6-2 6-0
					Silvia La Fratta
11.			Elna Reinach		6-3 5-7 6-3
				Elna Reinach
12.			Karen Schimper	6-3 6-3
						Silvia La Fratta
13.			Silke Meier			6-4 7-5
				Silke Meier
14.			Iwona Kuczynska	6-7(0) 6-4 6-4
					Andrea Vieira
15.		[Q]	Andrea Vieira		6-2 6-2
				Andrea Vieira
16.		[14]	Hana Mandlikova	6-7(8) 6-1 6-4
								Steffi Graf
17.		[9]	Katerina Maleeva					6-0 6-4
				Katerina Maleeva
18.			Brenda Schultz	7-6(2) 6-1
					Katerina Maleeva
19.			Catherine Tanvier		6-0 6-2
				Catherine Tanvier
20.			Elly Hakami	6-0 6-1
						Katerina Maleeva
21.			Martina Pawlik			4-6 6-4 6-1
				Martina Pawlik
22.			Terry Phelps	6-7(4) 6-2 6-4
					Martina Pawlik
23.		[LL]	Kimiko Date		6-4 7-6(2)
				Kimiko Date
24.			Michelle Torres	5-7 6-3 6-0
							Conchita Martinez
25.		[WC]	Sophie Amiach				6-0 6-1
				Sophie Amiach
26.		[LL]	Leona Laskova	3-6 6-1 7-5
					Sophie Amiach
27.			Laura Arraya		7-6(0) 6-7(4) 6-3
				Laura Arraya
28.			Wiltrud Probst	6-4 6-3
						Conchita Martinez
29.		[Q]	Jana Pospisilova			6-3 6-3
				Jana Pospisilova
30.			Denisa Krajcovicova	6-0 6-2
					Conchita Martinez
31.		[8]	Conchita Martinez		6-0 6-4
				Conchita Martinez
32.			Beth Herr	6-3 6-2
									Steffi Graf
33.		[4]	Zina Garrison						6-3 3-6 6-3
				Zina Garrison
34.			Louise Allen	6-2 6-2
					Zina Garrison
35.			Cathy Caverzasio		5-7 6-3 6-2
				Cathy Caverzasio
36.			Seda Noorlander	6-4 6-4
						Monica Seles
37.			Monica Seles			6-3 6-2
				Monica Seles
38.			Ronnie Reis	6-4 6-1
					Monica Seles
39.			Stacey Martin		6-0 6-2
				Stacey Martin
40.			Katrina Adams	7-5 7-6(3)
							Monica Seles
41.			Jo-Anne Faull				6-3 6-2
				Jo-Anne Faull
42.		[WC]	Catherine Suire	6-1 6-2
					Jo-Anne Faull
43.			Adriana Villagran		6-7(1) 6-1 6-1
				Adriana Villagran
44.			Leigh Anne Eldredge	6-1 6-1
						Jo-Anne Faull
45.		[WC]	Catherine Mothes			6-3 6-1
				Catherine Mothes
46.			Silke Frankl	6-2 6-2
					Susan Sloane Lundy
47.		[16]	Susan Sloane Lundy		6-1 6-1
				Susan Sloane Lundy
48.			Carrie Cunningham	6-0 6-2
								Monica Seles
49.		[12]	Lori McNeil					6-3 7-5
				Lori McNeil
50.			Nathalie Tauziat	6-4 6-4
					Manon Bollegraf
51.			Manon Bollegraf		6-2 6-1
				Manon Bollegraf
52.			Dianne Van Rensburg	3-6 6-3 6-2
						Janine Thompson
53.		[Q]	Janine Thompson			6-2 6-3
				Janine Thompson
54.			Catarina Lindqvist	6-3 2-6 6-4
					Janine Thompson
55.		[WC]	Pascale Etchemendy		6-1 6-4
				Pascale Etchemendy
56.			Linda Ferrando	2-6 7-5 6-3
							Manuela Maleeva
57.			Larisa Savchenko				7-6(3) 6-2
				Larisa Savchenko
58.			Isabel Cueto	6-0 7-5
					Larisa Savchenko
59.			Elise Burgin		7-5 7-6(5)
				Elise Burgin
60.			Judith Wiesner	6-3 6-4
						Manuela Maleeva
61.			Sandra Wasserman			6-1 6-2
				Sandra Wasserman
62.		[Q]	Sabine Hack	3-6 7-5 6-3
					Manuela Maleeva
63.		[6]	Manuela Maleeva		6-3 5-7 6-3
				Manuela Maleeva
64.			Liz Sayers	6-4 6-4
										Arantxa Sanchez-Vicario
65.		[7]	Arantxa Sanchez-Vicario							7-6(6) 3-6 7-5
				Arantxa Sanchez-Vicario
66.			Regina Rajchrtova	6-2 6-1
					Arantxa Sanchez-Vicario
67.			Isabelle Demongeot		6-4 6-4
				Isabelle Demongeot
68.			Mercedes Paz	6-3 7-5
						Arantxa Sanchez-Vicario
69.		[Q]	Natalia Medvedeva			6-0 3-6 6-2
				Natalia Medvedeva
70.			Rachel McQuillan	3-6 6-3 6-2
					Natalia Medvedeva
71.			Angeliki Kanellopoulous		6-0 6-1
				Angeliki Kanellopoulous
72.			Maria Strandlund	6-1 6-1
							Arantxa Sanchez-Vicario
73.			Amanda Coetzer				6-3 6-2
				Amanda Coetzer
74.			Veronika Martinek	6-4 6-1
					Amanda Coetzer
75.			Shaun Stafford		6-3 6-3
				Shaun Stafford
76.			Kumiko Okamoto	6-4 6-4
						Amanda Coetzer
77.			Sara Gomer			7-6(6) 6-1
				Sara Gomer
78.		[WC]	Emmanuelle Derly	2-6 6-3 7-5
					Karine Quentrec
79.			Karine Quentrec		6-3 6-3
				Karine Quentrec
80.		[13]	Claudia Kohde-Kilsch	4-6 6-2 8-6
								Arantxa Sanchez-Vicario
81.		[11]	Jana Novotna					6-2 6-2
				Jana Novotna
82.			Julie Halard	6-3 6-2
					Jana Novotna
83.			Claudia Porwik		6-3 7-5
				Claudia Porwik
84.			Sabrina Goles	6-4 6-2
						Jana Novotna
85.			Rene Simpson			6-1 6-0
				Rene Simpson
86.			Meredith McGrath	6-1 6-3
					Rene Simpson
87.			Marianne Werdel		6-3 6-4
				Marianne Werdel
88.			Jenny Byrne	6-2 6-7(4) 7-5
							Jana Novotna
89.			Laura Golarsa				6-1 6-4
				Laura Golarsa
90.			Eva Pfaff	6-3 6-4
					Laura Golarsa
91.			Nathalie Guerree		6-4 7-5
				Nathalie Guerree
92.			Iva Budarova	6-7(5) 7-5 6-1
						Sylvia Hanika
93.			Sylvia Hanika			4-6 6-1 6-3
				Sylvia Hanika
94.		[WC]	Sybille Niox-Chateau	6-7(5) 6-0 6-3
					Sylvia Hanika
95.			Raffaella Reggi		2-6 6-1 7-5
				Raffaella Reggi
96.		[3]	Natasha Zvereva	3-6 7-6(5) 6-2
									Arantxa Sanchez-Vicario
97.		[5]	Helena Sukova						6-2 6-2
				Helena Sukova
98.			Leila Meskhi	7-5 6-1
					Akiko Kijimuta
99.			Akiko Kijimuta		6-1 7-5
				Akiko Kijimuta
100.			Petra Langrova	7-5 6-1
						Ann Grossman
101.			Ann Grossman			6-4 6-1
				Ann Grossman
102.			Patricia Tarabini	7-5 6-1
					Ann Grossman
103.			Anne Minter		6-4 6-4
				Anne Minter
104.		[LL]	Inmaculada Varas	6-3 6-3
							Helen Kelesi
105.			Gretchen Anne Rush				6-1 6-2
				Gretchen Anne Rush
106.		[WC]	Maider Laval	6-3 3-6 7-5
					Gretchen Anne Rush
107.			Kathy Rinaldi		6-2 6-3
				Kathy Rinaldi
108.		[Q]	Barbara Romano	3-6 6-0 6-3
						Helen Kelesi
109.			Andrea Temesvari			6-4 2-6 6-3
				Andrea Temesvari
110.			Beverly Bowes	6-4 6-4
					Helen Kelesi
111.		[10]	Helen Kelesi		6-0 7-6(4)
				Helen Kelesi
112.			Radomira Zrubakova	6-1 6-2
								Mary Joe Fernandez
113.		[15]	Mary Joe Fernandez					6-2 7-5
				Mary Joe Fernandez
114.			Nathalie Herreman	6-2 6-3
					Mary Joe Fernandez
115.			Andrea Farley		6-7(6) 6-3 6-1
				Andrea Farley
116.			Jo Durie	6-4 6-2
						Mary Joe Fernandez
117.			Neige Dias			6-7(3) 6-1 6-1
				Neige Dias
118.			Robin White	6-1 6-1
					Neige Dias
119.			Barbara Paulus		7-6(1) 7-5
				Barbara Paulus
120.			Sandra Cecchini	1-6 6-4 6-4
							Mary Joe Fernandez
121.			Nicole Provis				6-4 6-4
				Nicole Provis
122.			Donna Faber	4-6 6-4 6-0
					Nicole Provis
123.			Laura Lapi		6-1 6-1
				Laura Lapi
124.			Louise Field	7-5 6-0
						Gabriela Sabatini
125.		[WC]	Alexia Dechaume			4-6 7-5 6-3
				Alexia Dechaume
126.		[LL]	Regina Marsikova	6-3 6-4
					Gabriela Sabatini
127.		[2]	Gabriela Sabatini		6-3 6-1
				Gabriela Sabatini
128.			Akemi Nishiya	6-0 6-0

(default) 17 queries took 27 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	8
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` = '1989' 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` = (1279) 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, 9709, 10010, 10007, 9830, 9752, 9797, 9845, 11364, 9719, 9780, 11356, 9900, 9906, 11365, 9648, 9756, 9863, 9695, 10042, 9872, 9795, 9930, 11307, 9725, 11366, 9948, 9804, 9943, 9965, 9885, 9728, 9706, 9772, 9871, 10162, 9974, 9902, 9924, 9866, 9843, 9716, 9747, 9867, 11362, 10001, 10008, 9911, 9727, 10017, 9784, 9793, 9766, 9753, 9931, 10057, 9750, 9973, 9744, 9781, 9855, 9975, 9702, 9661, 9957, 9919, 9938, 9962, 9926, 9819, 11334, 9894, 10018, 9881, 9916, 9783, 9743, 9859, 9905, 9654, 9848, 9829, 9779, 11313, 9870, 10047, 9798, 9739, 9896, 9828, 9876, 9699, 9665, 9824, 9722, 9945, 9677, 9914, 9794, 9880, 9907, 9963, 9646, 11368, 9802, 9840, 9717, 11361, 9741, 9773, 9771, 9837, 9909, 9888, 9878, 9692, 11341, 13428, 9918, 10091, 9768, 9877, 11369, 9742, 9873, 9613, 9883, 9847) 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` = 1279	132	132	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 197, 68, 133, 217, 179, 92, 172, 212, 94, 29, 196, 147, 219, 74, 36, 149, 178, 31, 173, 218, 14, 10, 54, 84, 21)	26	26	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 197, 68, 133, 217, 179, 92, 172, 212, 94, 29, 196, 147, 219, 74, 36, 149, 178, 31, 173, 218, 14, 10, 54, 84, 21)	26	26	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9715, 9709, 10010, 10007, 9830, 9752, 9797, 9845, 11364, 9719, 9780, 11356, 9900, 9906, 11365, 9648, 9756, 9863, 9695, 10042, 9872, 9795, 9930, 11307, 9725, 11366, 9948, 9804, 9943, 9965, 9885, 9728, 9706, 9772, 9871, 10162, 9974, 9902, 9924, 9866, 9843, 9716, 9747, 9867, 11362, 10001, 10008, 9911, 9727, 10017, 9784, 9793, 9766, 9753, 9931, 10057, 9750, 9973, 9744, 9781, 9855, 9975, 9702, 9661, 9957, 9919, 9938, 9962, 9926, 9819, 11334, 9894, 10018, 9881, 9916, 9783, 9743, 9859, 9905, 9654, 9848, 9829, 9779, 11313, 9870, 10047, 9798, 9739, 9896, 9828, 9876, 9699, 9665, 9824, 9722, 9945, 9677, 9914, 9794, 9880, 9907, 9963, 9646, 11368, 9802, 9840, 9717, 11361, 9741, 9773, 9771, 9837, 9909, 9888, 9878, 9692, 11341, 13428, 9918, 10091, 9768, 9877, 11369, 9742, 9873, 9613, 9883, 9847)) AND (`Playercontest`.`contest_id` = 1279))	128	128	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` = 1989	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 27 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` = '1989' 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` = (1279) 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, 9709, 10010, 10007, 9830, 9752, 9797, 9845, 11364, 9719, 9780, 11356, 9900, 9906, 11365, 9648, 9756, 9863, 9695, 10042, 9872, 9795, 9930, 11307, 9725, 11366, 9948, 9804, 9943, 9965, 9885, 9728, 9706, 9772, 9871, 10162, 9974, 9902, 9924, 9866, 9843, 9716, 9747, 9867, 11362, 10001, 10008, 9911, 9727, 10017, 9784, 9793, 9766, 9753, 9931, 10057, 9750, 9973, 9744, 9781, 9855, 9975, 9702, 9661, 9957, 9919, 9938, 9962, 9926, 9819, 11334, 9894, 10018, 9881, 9916, 9783, 9743, 9859, 9905, 9654, 9848, 9829, 9779, 11313, 9870, 10047, 9798, 9739, 9896, 9828, 9876, 9699, 9665, 9824, 9722, 9945, 9677, 9914, 9794, 9880, 9907, 9963, 9646, 11368, 9802, 9840, 9717, 11361, 9741, 9773, 9771, 9837, 9909, 9888, 9878, 9692, 11341, 13428, 9918, 10091, 9768, 9877, 11369, 9742, 9873, 9613, 9883, 9847) 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` = 1279

132

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9715, 9709, 10010, 10007, 9830, 9752, 9797, 9845, 11364, 9719, 9780, 11356, 9900, 9906, 11365, 9648, 9756, 9863, 9695, 10042, 9872, 9795, 9930, 11307, 9725, 11366, 9948, 9804, 9943, 9965, 9885, 9728, 9706, 9772, 9871, 10162, 9974, 9902, 9924, 9866, 9843, 9716, 9747, 9867, 11362, 10001, 10008, 9911, 9727, 10017, 9784, 9793, 9766, 9753, 9931, 10057, 9750, 9973, 9744, 9781, 9855, 9975, 9702, 9661, 9957, 9919, 9938, 9962, 9926, 9819, 11334, 9894, 10018, 9881, 9916, 9783, 9743, 9859, 9905, 9654, 9848, 9829, 9779, 11313, 9870, 10047, 9798, 9739, 9896, 9828, 9876, 9699, 9665, 9824, 9722, 9945, 9677, 9914, 9794, 9880, 9907, 9963, 9646, 11368, 9802, 9840, 9717, 11361, 9741, 9773, 9771, 9837, 9909, 9888, 9878, 9692, 11341, 13428, 9918, 10091, 9768, 9877, 11369, 9742, 9873, 9613, 9883, 9847)) AND (`Playercontest`.`contest_id` = 1279))

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

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)