Australian Open 1989 Women's Singles (January 16 - January 29)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Steffi Graf
				Steffi Graf
2.		[WC]	Kerry-Anne Guse	6-2 6-1
					Steffi Graf
3.			Rene Simpson		6-0 6-0
				Rene Simpson
4.			Cathy Caverzasio	4-6 6-1 6-0
						Steffi Graf
5.			Marianne Werdel			6-0 6-1
				Marianne Werdel
6.			Beth Herr	6-1 6-3
					Marianne Werdel
7.			Akemi Nishiya		2-6 6-4 6-2
				Akemi Nishiya
8.			Martina Pawlik	3-0 rtd.
							Steffi Graf
9.			Amy Frazier				6-4 6-0
				Amy Frazier
10.			Masako Yanagi	6-2 6-4
					Amy Frazier
11.			Alexia Dechaume		6-3 6-3
				Alexia Dechaume
12.		[WC]	Jane Taylor	6-2 7-6(3)
						Nicole Provis
13.			Jill Hetherington			3-6 6-4 6-3
				Jill Hetherington
14.			Hester Witvoet	7-6(2) 6-1
					Nicole Provis
15.		[16]	Nicole Provis		6-4 6-3
				Nicole Provis
16.			Jo-Anne Faull	6-4 6-2
								Steffi Graf
17.		[Q]	Yukie Koizumi					6-2 6-3
				Yukie Koizumi
18.		[9]	Lori McNeil	6-1 4-6 6-4
					Nathalie Guerree
19.			Nathalie Guerree		6-1 6-1
				Nathalie Guerree
20.		[WC]	Sally McCann	7-5 6-4
						Donna Faber
21.			Donna Faber			6-2 6-1
				Donna Faber
22.			Carin Bakkum	6-1 6-0
					Donna Faber
23.			Claudia Porwik		7-5 6-3
				Claudia Porwik
24.			Sandra Collins	6-3 6-7(3) 6-2
							Claudia Kohde-Kilsch
25.		[Q]	Andrea Farley				6-3 6-3
				Andrea Farley
26.			Jennifer Santrock	6-3 6-3
					Andrea Farley
27.			Petra Langrova		6-1 3-6 6-1
				Petra Langrova
28.			Veronika Martinek	6-2 7-6(4)
						Claudia Kohde-Kilsch
29.			Maria-Christine Damas			6-3 3-6 6-2
				Maria-Christine Damas
30.			Jonna Jonerup	6-0 6-0
					Claudia Kohde-Kilsch
31.		[8]	Claudia Kohde-Kilsch		2-6 6-1 6-1
				Claudia Kohde-Kilsch
32.			Celine Cohen	4-6 6-1 6-3
									Steffi Graf
33.		[3]	Gabriela Sabatini						6-3 6-0
				Gabriela Sabatini
34.			Cecilia Dahlman	6-0 6-1
					Gabriela Sabatini
35.			Conchita Martinez		3-6 6-1 6-2
				Conchita Martinez
36.			Eva Sviglerova	6-0 6-2
						Gabriela Sabatini
37.			Camille Benjamin			6-0 6-0
				Camille Benjamin
38.			Monique Javer	6-2 6-4
					Camille Benjamin
39.			Dianne Van Rensburg		6-3 6-4
				Dianne Van Rensburg
40.			Anna Ivan	4-6 7-5 6-1
							Gabriela Sabatini
41.			Jo Durie				6-0 4-6 6-1
				Jo Durie
42.			Louise Allen	6-2 6-4
					Jo Durie
43.			Nathalie Herreman		7-6(6) 6-3
				Nathalie Herreman
44.			Wendy Turnbull	7-5 7-5
						Raffaella Reggi
45.			Christina Singer			6-2 6-2
				Christina Singer
46.		[WC]	Michelle Bowrey	2-6 6-3 6-0
					Raffaella Reggi
47.		[13]	Raffaella Reggi		6-0 6-4
				Raffaella Reggi
48.		[WC]	Louise Stacey	6-2 7-6(3)
								Gabriela Sabatini
49.			Elise Burgin					6-4 2-6 6-4
				Elise Burgin
50.		[11]	Sylvia Hanika	6-3 6-1
					Elise Burgin
51.			Louise Field		6-4 6-4
				Louise Field
52.			Liz Sayers	2-6 6-4 6-3
						Cammy MacGregor
53.			Cammy MacGregor			5-7 7-5 6-4
				Cammy MacGregor
54.		[Q]	Karin Kschwendt	6-4 7-6(7)
					Cammy MacGregor
55.		[WC]	Rennae Stubbs		2-6 6-0 6-2
				Rennae Stubbs
56.			Elizabeth Minter	6-2 6-4
							Zina Garrison
57.		[Q]	Kimberley Kessaris				7-5 6-1
				Kimberley Kessaris
58.		[Q]	Tamaka Takagi	6-1 6-4
					Kimberley Kessaris
59.			Maria Strandlund		6-3 3-6 6-4
				Maria Strandlund
60.			Ann Devries	2-6 7-5 6-4
						Zina Garrison
61.			Sandra Wasserman			6-0 6-0
				Sandra Wasserman
62.			Laxmi Poruri	6-4 6-4
					Zina Garrison
63.		[6]	Zina Garrison		7-6(3) 4-6 6-4
				Zina Garrison
64.			Maria Lindstrom	6-1 6-3
										Steffi Graf
65.			Belinda Cordwell							6-4 6-4
				Belinda Cordwell
66.		[7]	Barbara Potter	6-3 6-3
					Belinda Cordwell
67.			Beverly Bowes		3-6 6-3 12-10
				Beverly Bowes
68.			Laura Golarsa	1-6 6-4 6-4
						Belinda Cordwell
69.		[WC]	Andrea Temesvari			1-6 7-6(5) 6-1
				Andrea Temesvari
70.		[Q]	Jennifer Fuchs	6-1 6-1
					Andrea Temesvari
71.			Kathrin Keil		4-6 7-6(4) 6-4
				Kathrin Keil
72.			Kathy Horvath	6-0 6-7(4) 6-4
							Belinda Cordwell
73.			Michelle Jaggard				6-3 6-2
				Michelle Jaggard
74.			Renata Marcinkowska	6-4 2-6 7-5
					Michelle Jaggard
75.			Federica Bonsignori		6-4 3-6 10-8
				Federica Bonsignori
76.			Silke Meier	7-6(5) 7-5
						Brenda Schultz
77.			Brenda Schultz			6-4 6-2
				Brenda Schultz
78.			Iva Budarova	6-4 6-3
					Brenda Schultz
79.		[14]	Anne Minter		6-4 3-6 6-1
				Anne Minter
80.			Etsuko Inoue	2-6 6-0 7-5
								Belinda Cordwell
81.		[12]	Patty Fendick					6-2 2-6 6-1
				Patty Fendick
82.			Halle Cioffi	4-6 6-4 6-3
					Ronnie Reis
83.			Ronnie Reis		6-4 7-6(4)
				Ronnie Reis
84.			Gisele Miro	2-6 6-4 6-2
						Judith Wiesner
85.			Judith Wiesner			6-4 6-4
				Judith Wiesner
86.			Sandrine Jaquet	6-3 6-3
					Judith Wiesner
87.			Emmanuelle Derly		6-1 6-2
				Emmanuelle Derly
88.			Regina Marsikova	6-4 6-1
							Catarina Lindqvist
89.			Catarina Lindqvist				7-5 6-2
				Catarina Lindqvist
90.			Gretchen Anne Rush	6-3 6-2
					Catarina Lindqvist
91.			Lea Antonoplis		0-6 6-2 6-3
				Lea Antonoplis
92.			Carol Christian	6-2 2-6 6-1
						Catarina Lindqvist
93.			Sarah Loosemore			0-6 6-4 8-6
				Sarah Loosemore
94.			Nicole Jagerman	6-2 1-6 6-3
					Pam Shriver
95.		[4]	Pam Shriver		1-6 6-3 6-4
				Pam Shriver
96.			Rachel McQuillan	6-4 6-1
									Helena Sukova
97.		[5]	Helena Sukova						7-6(2) 4-6 6-2
				Helena Sukova
98.			Julie Richardson	7-5 6-0
					Helena Sukova
99.			Heather Ludloff		7-5 6-3
				Heather Ludloff
100.			Karine Quentrec	6-4 2-6 6-4
						Helena Sukova
101.		[WC]	Lisa O'Neill			6-2 6-1
				Lisa O'Neill
102.			Iwona Kuczynska	6-2 6-4
					Lisa O'Neill
103.			Eva Stutzki		6-2 7-6(4)
				Eva Stutzki
104.			Ann Henricksson	7-6(4) 6-1
							Helena Sukova
105.			Catherine Tanvier				7-5 6-4
				Catherine Tanvier
106.			Leigh Anne Eldredge	3-6 6-3 6-2
					Catherine Tanvier
107.			Pilar Vasquez		6-3 4-6 6-2
				Pilar Vasquez
108.		[Q]	Hellas Ter Riet	6-4 4-6 6-1
						Catherine Tanvier
109.			Ann Grossman			6-2 6-3
				Ann Grossman
110.			Sabine Auer	3-6 6-3 6-4
					Mary Joe Fernandez
111.		[10]	Mary Joe Fernandez		6-4 7-6(1)
				Mary Joe Fernandez
112.			Terry Phelps	6-1 4-6 6-1
								Helena Sukova
113.		[15]	Hana Mandlikova					6-2 3-6 9-7
				Hana Mandlikova
114.			Clare Wood	4-6 6-2 6-3
					Hana Mandlikova
115.			Eva Pfaff		4-6 6-1 6-4
				Eva Pfaff
116.			Sybille Niox-Chateau	6-3 6-1
						Hana Mandlikova
117.			Manon Bollegraf			3-6 6-3 9-7
				Manon Bollegraf
118.			Julie Halard	6-3 6-3
					Manon Bollegraf
119.			Katrina Adams		6-7(6) 6-2 6-3
				Katrina Adams
120.			Wiltrud Probst	6-7(3) 6-3 7-5
							Martina Navratilova
121.			Jana Novotna				6-4 6-1
				Jana Novotna
122.		[Q]	Jeri Ingram	7-5 7-5
					Jana Novotna
123.			Carrie Cunningham		6-2 6-2
				Carrie Cunningham
124.			Dianne Fromholtz	6-4 6-3
						Martina Navratilova
125.			Jenny Byrne			6-2 6-2
				Jenny Byrne
126.			Simone Schilder	6-0 6-2
					Martina Navratilova
127.		[2]	Martina Navratilova		6-4 7-6(7)
				Martina Navratilova
128.			Andrea Betzner	6-0 6-1

(default) 17 queries took 42 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` = 'australian-open' 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` = (1)	5	5	9
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` = (1)	1	1	11
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` = (1)	1	1	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` = 'australian-open' 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` = (3) ORDER BY `Contest`.`year` ASC	98	98	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` = 1 AND `Contest`.`category_id` = 3 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` = (173) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	127	127	3
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (9715, 9869, 9870, 9871, 9798, 9728, 9847, 9872, 9845, 9755, 9873, 9874, 9853, 9875, 9768, 9843, 9788, 9727, 9876, 9800, 9877, 9862, 9779, 9748, 9878, 9879, 9880, 9881, 9835, 9882, 9654, 9852, 9883, 9884, 9885, 9886, 9709, 9817, 9793, 9887, 9692, 9772, 9888, 9507, 9790, 9825, 9722, 9889, 9744, 9665, 9742, 9661, 9775, 9890, 9891, 9729, 9892, 9893, 9894, 9782, 9855, 9895, 9706, 9861, 9761, 9675, 9773, 9896, 9741, 9821, 9806, 9897, 9797, 9898, 9899, 9900, 9863, 9699, 9646, 9724, 9857, 9901, 9902, 9903, 9781, 9904, 9859, 9613, 9753, 9802, 9693, 9833, 9827, 9830, 9656, 9819, 9677, 9807, 9714, 9905, 9774, 9906, 9786, 9763, 9695, 9867, 9799, 9826, 9907, 9908, 9909, 9795, 9648, 9851, 9828, 9824, 9784, 9829, 9866, 9804, 9848, 9910, 9911, 9513, 9739, 9912, 9582, 11343) 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` = 173	129	129	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 212, 133, 92, 13, 217, 179, 135, 178, 68, 21, 196, 36, 94, 149, 173, 29, 14, 172, 10, 84, 147)	22	22	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 212, 133, 92, 13, 217, 179, 135, 178, 68, 21, 196, 36, 94, 149, 173, 29, 14, 172, 10, 84, 147)	22	22	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9715, 9869, 9870, 9871, 9798, 9728, 9847, 9872, 9845, 9755, 9873, 9874, 9853, 9875, 9768, 9843, 9788, 9727, 9876, 9800, 9877, 9862, 9779, 9748, 9878, 9879, 9880, 9881, 9835, 9882, 9654, 9852, 9883, 9884, 9885, 9886, 9709, 9817, 9793, 9887, 9692, 9772, 9888, 9507, 9790, 9825, 9722, 9889, 9744, 9665, 9742, 9661, 9775, 9890, 9891, 9729, 9892, 9893, 9894, 9782, 9855, 9895, 9706, 9861, 9761, 9675, 9773, 9896, 9741, 9821, 9806, 9897, 9797, 9898, 9899, 9900, 9863, 9699, 9646, 9724, 9857, 9901, 9902, 9903, 9781, 9904, 9859, 9613, 9753, 9802, 9693, 9833, 9827, 9830, 9656, 9819, 9677, 9807, 9714, 9905, 9774, 9906, 9786, 9763, 9695, 9867, 9799, 9826, 9907, 9908, 9909, 9795, 9648, 9851, 9828, 9824, 9784, 9829, 9866, 9804, 9848, 9910, 9911, 9513, 9739, 9912, 9582, 11343)) AND (`Playercontest`.`contest_id` = 173))	128	128	2
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 3 ORDER BY `Contest`.`date_from` ASC	98	98	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 42 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` = 'australian-open' 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` = (1)

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` = (1)

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` = 'australian-open' AND `Category`.`slug` = 'women-singles' LIMIT 1

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` = 1 AND `Contest`.`category_id` = 3 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` = (173) 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, 9869, 9870, 9871, 9798, 9728, 9847, 9872, 9845, 9755, 9873, 9874, 9853, 9875, 9768, 9843, 9788, 9727, 9876, 9800, 9877, 9862, 9779, 9748, 9878, 9879, 9880, 9881, 9835, 9882, 9654, 9852, 9883, 9884, 9885, 9886, 9709, 9817, 9793, 9887, 9692, 9772, 9888, 9507, 9790, 9825, 9722, 9889, 9744, 9665, 9742, 9661, 9775, 9890, 9891, 9729, 9892, 9893, 9894, 9782, 9855, 9895, 9706, 9861, 9761, 9675, 9773, 9896, 9741, 9821, 9806, 9897, 9797, 9898, 9899, 9900, 9863, 9699, 9646, 9724, 9857, 9901, 9902, 9903, 9781, 9904, 9859, 9613, 9753, 9802, 9693, 9833, 9827, 9830, 9656, 9819, 9677, 9807, 9714, 9905, 9774, 9906, 9786, 9763, 9695, 9867, 9799, 9826, 9907, 9908, 9909, 9795, 9648, 9851, 9828, 9824, 9784, 9829, 9866, 9804, 9848, 9910, 9911, 9513, 9739, 9912, 9582, 11343) 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` = 173

129

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9715, 9869, 9870, 9871, 9798, 9728, 9847, 9872, 9845, 9755, 9873, 9874, 9853, 9875, 9768, 9843, 9788, 9727, 9876, 9800, 9877, 9862, 9779, 9748, 9878, 9879, 9880, 9881, 9835, 9882, 9654, 9852, 9883, 9884, 9885, 9886, 9709, 9817, 9793, 9887, 9692, 9772, 9888, 9507, 9790, 9825, 9722, 9889, 9744, 9665, 9742, 9661, 9775, 9890, 9891, 9729, 9892, 9893, 9894, 9782, 9855, 9895, 9706, 9861, 9761, 9675, 9773, 9896, 9741, 9821, 9806, 9897, 9797, 9898, 9899, 9900, 9863, 9699, 9646, 9724, 9857, 9901, 9902, 9903, 9781, 9904, 9859, 9613, 9753, 9802, 9693, 9833, 9827, 9830, 9656, 9819, 9677, 9807, 9714, 9905, 9774, 9906, 9786, 9763, 9695, 9867, 9799, 9826, 9907, 9908, 9909, 9795, 9648, 9851, 9828, 9824, 9784, 9829, 9866, 9804, 9848, 9910, 9911, 9513, 9739, 9912, 9582, 11343)) AND (`Playercontest`.`contest_id` = 173))

128

SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 3 ORDER BY `Contest`.`date_from` ASC

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)