Wimbledon 1991 Ladies' Singles (June 24 - July 6)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Steffi Graf
				Steffi Graf
2.			Sabine Appelmans	6-2 6-2
					Steffi Graf
3.			Mareen Louie		6-0 6-1
				Mareen Louie
4.			Claudia Porwik	6-4 6-1
						Steffi Graf
5.			Nathalie Herreman			6-2 6-3
				Nathalie Herreman
6.			Kathy Rinaldi	7-5 6-2
					Yayuk Basuki
7.			Yayuk Basuki		6-4 6-4
				Yayuk Basuki
8.			Ann Henricksson	6-4 7-6(4)
							Steffi Graf
9.			Julie Halard				6-2 6-1
				Julie Halard
10.		[LL]	Claudine Toleafoa	6-1 2-6 6-3
					Marianne Werdel
11.			Marianne Werdel		6-2 6-4
				Marianne Werdel
12.			Debbie Graham	6-3 6-2
						Amy Frazier
13.			Robin White			6-2 6-1
				Robin White
14.			Federica Bonsignori	6-1 6-1
					Amy Frazier
15.		[14]	Amy Frazier		7-5 6-4
				Amy Frazier
16.			Karin Kschwendt	7-6(3) 6-4
								Steffi Graf
17.		[13]	Anke Huber					6-1 6-3
				Anke Huber
18.			Veronika Martinek	6-1 6-2
					Anke Huber
19.			Tami Whitlinger		6-2 6-1
				Tami Whitlinger
20.			Magdalena Maleeva	6-1 6-3
						Anke Huber
21.			Manon Bollegraf			6-3 6-7(5) 6-0
				Manon Bollegraf
22.		[WC]	Virginia Humphreys-Davies	6-4 6-4
					Manon Bollegraf
23.			Jo Durie		6-3 5-7 6-3
				Jo Durie
24.			Helen Kelesi	6-3 6-2
							Zina Garrison
25.			Emanuela Zardo				4-6 6-3 6-0
				Emanuela Zardo
26.			Nana Miyagi	6-0 6-3
					Maria Strandlund
27.			Maria Strandlund		6-4 6-4
				Maria Strandlund
28.			Rika Hiraki	6-2 7-6(5)
						Zina Garrison
29.			Elena Pampoulova			6-3 6-3
				Elena Pampoulova
30.		[WC]	Belinda Borneo	2-6 6-3 6-4
					Zina Garrison
31.		[7]	Zina Garrison		6-3 6-1
				Zina Garrison
32.			Sara Gomer	6-3 6-3
									Steffi Graf
33.		[4]	Arantxa Sanchez-Vicario						6-2 6-4
				Arantxa Sanchez-Vicario
34.			Barbara Rittner	6-1 6-2
					Arantxa Sanchez-Vicario
35.			Amanda Coetzer		6-4 6-1
				Amanda Coetzer
36.			Francesca Romano	7-6(5) 6-2
						Arantxa Sanchez-Vicario
37.			Lori McNeil			6-2 6-4
				Lori McNeil
38.			Petra Langrova	6-4 7-5
					Lori McNeil
39.			Naoko Sawamatsu		3-6 6-2 6-2
				Naoko Sawamatsu
40.			Csilla Bartos	6-2 6-2
							Arantxa Sanchez-Vicario
41.		[LL]	Jo-Anne Faull				7-5 3-6 6-1
				Jo-Anne Faull
42.			Kristin Godridge	6-0 6-2
					Anne Minter
43.			Anne Minter		6-3 6-2
				Anne Minter
44.			Shawna Martin	6-4 6-0
						Anne Minter
45.			Donna Faber			6-3 6-3
				Donna Faber
46.			Cathy Caverzasio	6-3 6-7(4) 6-2
					Gigi Fernandez
47.			Gigi Fernandez		7-5 7-5
				Gigi Fernandez
48.		[10]	Helena Sukova	4-6 6-1 6-4
								Mary Joe Fernandez
49.		[16]	Judith Wiesner					6-2 7-5
				Judith Wiesner
50.			Halle Cioffi	6-1 6-2
					Judith Wiesner
51.			Larisa Savchenko		6-3 6-0
				Larisa Savchenko
52.			Andrea Temesvari	6-2 6-7(5) 8-6
						Judith Wiesner
53.			Claudia Kohde-Kilsch			3-6 7-5 6-1
				Claudia Kohde-Kilsch
54.		[WC]	Barbara Griffiths	6-1 6-3
					Claudia Kohde-Kilsch
55.		[Q]	Nicole Jagerman		7-6(2) 6-2
				Nicole Jagerman
56.		[Q]	Miriam Oremans	7-5 6-4
							Mary Joe Fernandez
57.			Pam Shriver				6-0 7-5
				Pam Shriver
58.			Andrea Leand	6-0 7-5
					Pam Shriver
59.			Bettina Fulco		6-0 6-3
				Bettina Fulco
60.			Erika De Lone	3-6 6-2 6-4
						Mary Joe Fernandez
61.			Audra Keller			6-3 7-5
				Audra Keller
62.			Laura Golarsa	7-5 6-3
					Mary Joe Fernandez
63.		[5]	Mary Joe Fernandez		7-6(5) 6-1
				Mary Joe Fernandez
64.		[Q]	Petra Kamstra	6-2 6-4
										Steffi Graf
65.		[6]	Jana Novotna							6-4 3-6 8-6
				Jana Novotna
66.		[LL]	Nicole Pratt	6-3 6-0
					Brenda Schultz
67.			Brenda Schultz		4-6 7-6(5) 6-4
				Brenda Schultz
68.			Beate Reinstadler	6-3 6-0
						Brenda Schultz
69.			Elena Brioukhovets			5-7 6-4 7-5
				Elena Brioukhovets
70.			Betsy Nagelsen	6-2 6-1
					Elena Brioukhovets
71.			Nicole Provis		7-6(3) 6-4
				Nicole Provis
72.			Samantha Smith	3-6 6-4 6-2
							Jennifer Capriati
73.			Wiltrud Probst				3-6 6-1 6-1
				Wiltrud Probst
74.			Eva Sviglerova	7-6(6) 7-5
					Wiltrud Probst
75.		[Q]	Els Callens		7-6(5) 6-3
				Els Callens
76.			Noelle Van Lottum	7-6(1) 2-6 7-5
						Jennifer Capriati
77.			Radomira Zrubakova			6-3 1-6 6-3
				Radomira Zrubakova
78.			Rachel McQuillan	7-6(4) 6-2
					Jennifer Capriati
79.		[9]	Jennifer Capriati		6-2 6-3
				Jennifer Capriati
80.			Shaun Stafford	6-0 7-5
								Jennifer Capriati
81.			Liz Sayers					6-4 7-5
				Liz Sayers
82.		[15]	Sandra Cecchini	6-3 3-6 6-1
					Liz Sayers
83.		[Q]	Catherine Suire		6-3 6-4
				Catherine Suire
84.			Susan Sloane Lundy	6-2 6-2
						Catarina Lindqvist
85.			Catarina Lindqvist			6-1 7-6(5)
				Catarina Lindqvist
86.		[Q]	Isabelle Demongeot	6-1 6-0
					Catarina Lindqvist
87.			Karina Habsudova		6-3 6-2
				Karina Habsudova
88.			Cecilia Dahlman	6-3 6-2
							Martina Navratilova
89.			Maya Kidowaki				6-1 6-3
				Maya Kidowaki
90.		[WC]	Sarah Bentley	1-6 7-5 6-1
					Laura Garrone
91.			Laura Garrone		6-4 6-3
				Laura Garrone
92.			Gretchen Anne Rush	6-4 7-6(5)
						Martina Navratilova
93.			Amanda Grunfeld			6-2 6-2
				Amanda Grunfeld
94.			Alexia Dechaume	6-4 6-4
					Martina Navratilova
95.		[3]	Martina Navratilova		6-3 6-1
				Martina Navratilova
96.			Elna Reinach	4-6 6-2 6-4
									Gabriela Sabatini
97.		[8]	Katerina Maleeva						6-4 6-4
				Katerina Maleeva
98.		[WC]	Julie Salmon	7-5 6-3
					Katerina Maleeva
99.			Ann Grossman		6-4 6-4
				Ann Grossman
100.		[WC]	Kaye Hand	6-0 6-4
						Katerina Maleeva
101.			Patricia Hy			6-3 6-4
				Patricia Hy
102.			Rosalyn Fairbank	6-2 3-6 6-0
					Patricia Hy
103.			Pascale Paradis		4-6 6-4 6-2
				Pascale Paradis
104.		[Q]	Kristine Radford	6-3 6-2
							Laura Arraya
105.			Mariaan De Swardt				3-6 6-2 6-3
				Mariaan De Swardt
106.			Stephanie Rehe	6-3 3-6 6-4
					Laura Arraya
107.			Laura Arraya		6-4 6-1
				Laura Arraya
108.			Clare Wood	6-4 6-4
						Laura Arraya
109.			Linda Harvey			2-2 rtd.
				Linda Harvey
110.			Lisa Bonder	6-4 6-2
					Linda Harvey
111.		[12]	Natasha Zvereva		6-4 6-1
				Natasha Zvereva
112.			Cristina Tessi	7-6(3) 6-4
								Gabriela Sabatini
113.		[11]	Nathalie Tauziat					6-2 6-1
				Nathalie Tauziat
114.			Regina Rajchrtova	6-4 7-5
					Nathalie Tauziat
115.			Akiko Kijimuta		3-6 6-2 6-2
				Akiko Kijimuta
116.			Mercedes Paz	6-1 6-3
						Nathalie Tauziat
117.			Patty Fendick			6-1 6-1
				Patty Fendick
118.		[LL]	Jill Hetherington	7-6(5) 4-6 6-1
					Linda Ferrando
119.			Linda Ferrando		4-6 6-1 7-5
				Linda Ferrando
120.		[LL]	Kimiko Date	6-4 3-6 6-2
							Gabriela Sabatini
121.			Carrie Cunningham				7-6(3) 6-3
				Carrie Cunningham
122.			Ginger Helgeson	7-6(12) 6-4
					Andrea Strnadova
123.			Andrea Strnadova		6-1 6-3
				Andrea Strnadova
124.		[WC]	Sarah Loosemore	6-4 7-5
						Gabriela Sabatini
125.			Karine Quentrec			6-1 6-3
				Karine Quentrec
126.		[Q]	Rennae Stubbs	6-2 6-2
					Gabriela Sabatini
127.		[2]	Gabriela Sabatini		6-4 6-2
				Gabriela Sabatini
128.			Monique Javer	6-4 6-0

(default) 17 queries took 25 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` = 'wimbledon' 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` = (3)	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` = (3)	4	4	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` = (3)	57	57	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` = 'wimbledon' 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` = (19) ORDER BY `Contest`.`year` ASC	130	130	3
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` = 3 AND `Contest`.`category_id` = 19 AND `Contest`.`slug` = '1991' 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` = (1802) 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, 9936, 11270, 9779, 9888, 9717, 10032, 9763, 9829, 9960, 9798, 10002, 13428, 9899, 9845, 9890, 9915, 9881, 9942, 9959, 9784, 12486, 9692, 9771, 9944, 9920, 9894, 9988, 9928, 12476, 9706, 9743, 9957, 9967, 10018, 9968, 9727, 9880, 9966, 9785, 9843, 9929, 9646, 14119, 9877, 9871, 9719, 9677, 9781, 9901, 9750, 9741, 9654, 12487, 9830, 9953, 9656, 9704, 10010, 9913, 9922, 9896, 9909, 9964, 9848, 9937, 9863, 9921, 12484, 9636, 9768, 9992, 9804, 9886, 10068, 9970, 9837, 9819, 9997, 9916, 9661, 10091, 9716, 10008, 9753, 9938, 9946, 9884, 9939, 12488, 11337, 9802, 12473, 9873, 9582, 9780, 9756, 9803, 9907, 12489, 9796, 9658, 9721, 9868, 10074, 9996, 9948, 9851, 10009, 9764, 9945, 9947, 10017, 9919, 9794, 9962, 9857, 9853, 10057, 9930, 9911, 9972, 9951, 9827, 9905, 9891, 9883, 9817) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	3
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` = 1802	133	133	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (21, 87, 196, 133, 197, 92, 218, 179, 172, 178, 94, 68, 13, 147, 72, 217, 36, 31, 10, 14, 173, 84, 135, NULL)	23	23	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (21, 87, 196, 133, 197, 92, 218, 179, 172, 178, 94, 68, 13, 147, 72, 217, 36, 31, 10, 14, 173, 84, 135, NULL)	23	23	2
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9715, 9936, 11270, 9779, 9888, 9717, 10032, 9763, 9829, 9960, 9798, 10002, 13428, 9899, 9845, 9890, 9915, 9881, 9942, 9959, 9784, 12486, 9692, 9771, 9944, 9920, 9894, 9988, 9928, 12476, 9706, 9743, 9957, 9967, 10018, 9968, 9727, 9880, 9966, 9785, 9843, 9929, 9646, 14119, 9877, 9871, 9719, 9677, 9781, 9901, 9750, 9741, 9654, 12487, 9830, 9953, 9656, 9704, 10010, 9913, 9922, 9896, 9909, 9964, 9848, 9937, 9863, 9921, 12484, 9636, 9768, 9992, 9804, 9886, 10068, 9970, 9837, 9819, 9997, 9916, 9661, 10091, 9716, 10008, 9753, 9938, 9946, 9884, 9939, 12488, 11337, 9802, 12473, 9873, 9582, 9780, 9756, 9803, 9907, 12489, 9796, 9658, 9721, 9868, 10074, 9996, 9948, 9851, 10009, 9764, 9945, 9947, 10017, 9919, 9794, 9962, 9857, 9853, 10057, 9930, 9911, 9972, 9951, 9827, 9905, 9891, 9883, 9817)) AND (`Playercontest`.`contest_id` = 1802))	128	128	2
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 19 ORDER BY `Contest`.`date_from` ASC	130	130	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1991	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 25 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` = 'wimbledon' 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` = (3)

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

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

130

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` = 3 AND `Contest`.`category_id` = 19 AND `Contest`.`slug` = '1991' 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` = (1802) 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, 9936, 11270, 9779, 9888, 9717, 10032, 9763, 9829, 9960, 9798, 10002, 13428, 9899, 9845, 9890, 9915, 9881, 9942, 9959, 9784, 12486, 9692, 9771, 9944, 9920, 9894, 9988, 9928, 12476, 9706, 9743, 9957, 9967, 10018, 9968, 9727, 9880, 9966, 9785, 9843, 9929, 9646, 14119, 9877, 9871, 9719, 9677, 9781, 9901, 9750, 9741, 9654, 12487, 9830, 9953, 9656, 9704, 10010, 9913, 9922, 9896, 9909, 9964, 9848, 9937, 9863, 9921, 12484, 9636, 9768, 9992, 9804, 9886, 10068, 9970, 9837, 9819, 9997, 9916, 9661, 10091, 9716, 10008, 9753, 9938, 9946, 9884, 9939, 12488, 11337, 9802, 12473, 9873, 9582, 9780, 9756, 9803, 9907, 12489, 9796, 9658, 9721, 9868, 10074, 9996, 9948, 9851, 10009, 9764, 9945, 9947, 10017, 9919, 9794, 9962, 9857, 9853, 10057, 9930, 9911, 9972, 9951, 9827, 9905, 9891, 9883, 9817) 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` = 1802

133

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9715, 9936, 11270, 9779, 9888, 9717, 10032, 9763, 9829, 9960, 9798, 10002, 13428, 9899, 9845, 9890, 9915, 9881, 9942, 9959, 9784, 12486, 9692, 9771, 9944, 9920, 9894, 9988, 9928, 12476, 9706, 9743, 9957, 9967, 10018, 9968, 9727, 9880, 9966, 9785, 9843, 9929, 9646, 14119, 9877, 9871, 9719, 9677, 9781, 9901, 9750, 9741, 9654, 12487, 9830, 9953, 9656, 9704, 10010, 9913, 9922, 9896, 9909, 9964, 9848, 9937, 9863, 9921, 12484, 9636, 9768, 9992, 9804, 9886, 10068, 9970, 9837, 9819, 9997, 9916, 9661, 10091, 9716, 10008, 9753, 9938, 9946, 9884, 9939, 12488, 11337, 9802, 12473, 9873, 9582, 9780, 9756, 9803, 9907, 12489, 9796, 9658, 9721, 9868, 10074, 9996, 9948, 9851, 10009, 9764, 9945, 9947, 10017, 9919, 9794, 9962, 9857, 9853, 10057, 9930, 9911, 9972, 9951, 9827, 9905, 9891, 9883, 9817)) AND (`Playercontest`.`contest_id` = 1802))

128

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

130

SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1991

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)