Wimbledon 1983 Ladies' Singles (June 20 - July 2)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Martina Navratilova
				Martina Navratilova
2.			Beverly Mould	6-1 6-0
					Martina Navratilova
3.			Sherry Acker		7-6 6-3
				Sherry Acker
4.			Catherine Tanvier	6-4 6-2
						Martina Navratilova
5.			Mima Jausovec			6-2 6-1
				Mima Jausovec
6.			Annabel Croft	6-1 6-2
					Mima Jausovec
7.			Elise Burgin		6-1 6-3
				Elise Burgin
8.			Claudia Monteiro	6-2 6-4
							Martina Navratilova
9.			Barbara Jordan				6-1 6-2
				Barbara Jordan
10.			Chris O'Neil	6-3 6-3
					Barbara Jordan
11.			Corinne Vanier		6-3 6-2
				Corinne Vanier
12.			Trey Lewis	6-1 1-6 8-6
						Claudia Kohde-Kilsch
13.			Patricia Hy			6-2 6-3
				Patricia Hy
14.			Ann Kiyomura	6-1 7-6
					Claudia Kohde-Kilsch
15.		[16]	Claudia Kohde-Kilsch		6-3 6-3
				Claudia Kohde-Kilsch
16.			Helena Sukova	6-3 7-6
								Martina Navratilova
17.		[9]	Sylvia Hanika					6-3 6-1
				Sylvia Hanika
18.			Beverly Bowes	6-3 6-2
					Sylvia Hanika
19.			Rosalyn Fairbank		3-6 6-2 6-3
				Rosalyn Fairbank
20.			Kim Jones	6-7 6-2 6-0
						Jennifer Mundel
21.		[Q]	Bernadette Randall			2-6 6-4 6-3
				Bernadette Randall
22.		[LL]	Laura Bernstein	6-4 6-0
					Jennifer Mundel
23.			Jennifer Mundel		6-1 6-1
				Jennifer Mundel
24.		[Q]	Nerida Gregory	6-1 6-4
							Jennifer Mundel
25.			Catherine Suire				5-7 6-4 6-4
				Catherine Suire
26.			Anna-Maria Fernandez	6-7 6-3 6-0
					Louise Allen
27.			Louise Allen		6-2 6-4
				Louise Allen
28.			Kate Brasher	6-2 6-1
						Hana Mandlikova
29.			Rene Mentz			6-1 6-3
				Rene Mentz
30.			Heather Ludloff	7-6 6-7 6-4
					Hana Mandlikova
31.		[8]	Hana Mandlikova		6-2 6-3
				Hana Mandlikova
32.			Rina Einy	7-5 6-3
									Martina Navratilova
33.			Barbara Hallquist						6-1 6-1
				Barbara Hallquist
34.		[LL]	Myriam Schropp	6-3 6-3
					Andrea Leand
35.			Andrea Leand		7-6 4-6 6-4
				Andrea Leand
36.			Paula Smith	6-1 6-3
						Virginia Wade
37.			Raffaella Reggi			3-6 7-6 6-2
				Raffaella Reggi
38.		[LL]	Micki Schillig	3-6 6-3 7-5
					Virginia Wade
39.			Virginia Wade		6-1 6-2
				Virginia Wade
40.			Amanda Tobin	1-6 7-5 6-4
							Virginia Wade
41.			Eva Pfaff				3-6 7-6 7-5
				Eva Pfaff
42.		[LL]	Brenda Remilton	7-5 6-2
					Eva Pfaff
43.			Zina Garrison		3-6 7-6 6-4
				Zina Garrison
44.			Amy Holton	7-6 7-5
						Eva Pfaff
45.			Tina Mochizuki			7-6 7-5
				Tina Mochizuki
46.			Cathy Drury	7-6 4-6 6-1
					Jo Durie
47.		[13]	Jo Durie		6-4 6-0
				Jo Durie
48.			Yvona Brzakova	6-4 6-2
								Yvonne Vermaak
49.		[12]	Virginia Ruzici					6-3 2-6 6-2
				Virginia Ruzici
50.			Catarina Lindqvist	6-0 6-2
					Virginia Ruzici
51.			Nancy Yeargin		6-1 6-4
				Nancy Yeargin
52.			Deborah Jevans	6-1 6-1
						Virginia Ruzici
53.			Sabina Simmonds			6-1 3-6 6-2
				Sabina Simmonds
54.			Jean Hepner	6-0 6-1
					Sabina Simmonds
55.			Amanda Brown		6-3 6-4
				Amanda Brown
56.		[Q]	Lisa Spain	6-4 6-2
							Yvonne Vermaak
57.			Yvonne Vermaak				6-3 6-2
				Yvonne Vermaak
58.			Sara Gomer	4-6 6-2 6-2
					Yvonne Vermaak
59.			Kim Sands		7-6 1-6 6-3
				Kim Sands
60.			Lele Forood	7-6 6-4
						Yvonne Vermaak
61.			Iva Budarova			5-7 6-4 6-2
				Iva Budarova
62.			Renata Tomanova	6-1 6-3
					Iva Budarova
63.		[5]	Pam Shriver		2-6 7-6 6-4
				Pam Shriver
64.			Patty Fendick	6-2 6-2
										Martina Navratilova
65.			Christiane Jolissaint							6-0 6-3
				Christiane Jolissaint
66.		[6]	Bettina Bunge	3-6 7-6 11-9
					Anne Minter
67.			Anne Minter		6-3 6-3
				Anne Minter
68.			Barbi Bramblett	7-5 6-2
						Lisa Bonder
69.			Ann Henricksson			6-1 6-3
				Ann Henricksson
70.		[Q]	Elizabeth Ekblom	6-4 5-7 6-3
					Lisa Bonder
71.			Lisa Bonder		6-3 7-6
				Lisa Bonder
72.			Cornelia Dries	6-3 7-5
							Barbara Potter
73.			Camille Benjamin				7-5 6-4
				Camille Benjamin
74.			Lucia Romanov	6-3 7-6
					Camille Benjamin
75.			Jill Davis		6-2 6-7 11-9
				Jill Davis
76.			Heather Crowe	7-5 6-4
						Barbara Potter
77.			Michelle Torres			6-7 6-2 6-1
				Michelle Torres
78.			Jane Preyer	6-4 6-2
					Barbara Potter
79.		[11]	Barbara Potter		6-1 6-4
				Barbara Potter
80.			Patricia Medrado	7-5 6-1
								Andrea Jaeger
81.		[14]	Andrea Temesvari					6-1 6-1
				Andrea Temesvari
82.			Vicki Nelson	6-0 6-1
					Manuela Maleeva
83.			Manuela Maleeva		6-2 6-3
				Manuela Maleeva
84.			Sue Barker	6-3 6-2
						Sharon Walsh
85.			Sharon Walsh			6-3 7-6
				Sharon Walsh
86.			Candy Reynolds	6-4 6-4
					Sharon Walsh
87.			Carling Bassett		7-5 6-4
				Carling Bassett
88.			JoAnne Russell	6-3 7-5
							Andrea Jaeger
89.			Sandra Collins				6-4 6-3
				Sandra Collins
90.			Kim Steinmetz	6-3 6-0
					Susan Leo
91.			Susan Leo		6-2 6-4
				Susan Leo
92.			Rene Blount	7-6 6-2
						Andrea Jaeger
93.			Pam Casale			6-3 6-2
				Pam Casale
94.		[Q]	Elizabeth Minter	5-7 7-5 6-3
					Andrea Jaeger
95.		[3]	Andrea Jaeger		6-3 6-2
				Andrea Jaeger
96.		[Q]	Susan Rimes	6-1 7-6
									Andrea Jaeger
97.		[7]	Wendy Turnbull						6-1 6-1
				Wendy Turnbull
98.			Dianne Fromholtz	6-1 6-1
					Wendy Turnbull
99.			Anne White		6-3 6-3
				Anne White
100.			Etsuko Inoue	6-1 6-3
						Wendy Turnbull
101.			Kate Latham			6-3 6-4
				Kate Latham
102.			Pam Teeguarden	6-7 7-6 7-5
					Wendy White
103.			Wendy White		7-6 6-1
				Wendy White
104.		[WC]	Julie Salmon	7-6 6-4
							Billie Jean King
105.			Rosie Casals				7-5 6-3
				Rosie Casals
106.			Mary Lou Piatek	3-6 7-6 6-3
					Rosie Casals
107.			Petra Delhees		6-3 3-6 6-2
				Petra Delhees
108.			Lea Antonoplis	6-4 6-2
						Billie Jean King
109.			Beth Herr			6-3 6-4
				Beth Herr
110.			Terry Phelps	4-6 6-2 6-1
					Billie Jean King
111.		[10]	Billie Jean King		6-7 6-2 8-6
				Billie Jean King
112.			Liz Sayers	7-5 6-3
								Billie Jean King
113.		[15]	Kathy Rinaldi					7-5 6-4
				Kathy Rinaldi
114.			Katerina Bohmova	4-6 6-4 6-1
					Kathy Rinaldi
115.			Lena Sandin		6-4 6-3
				Lena Sandin
116.			Catrin Jexell	6-1 6-4
						Kathy Rinaldi
117.			Claudia Pasquale			6-0 6-7 6-4
				Claudia Pasquale
118.		[Q]	Debbie Freeman	6-2 6-3
					Betsy Nagelsen
119.			Betsy Nagelsen		6-3 7-5
				Betsy Nagelsen
120.			Jenny Klitch	6-4 6-7 6-3
							Kathy Jordan
121.			Kathy Jordan				6-2 6-4
				Kathy Jordan
122.		[Q]	Jamie Golder	6-0 6-0
					Kathy Jordan
123.			Duk-Hee Lee		6-1 6-1
				Duk-Hee Lee
124.			Marcelis Skuherska	6-1 4-6 6-4
						Kathy Jordan
125.			Marcella Mesker			6-1 7-6
				Marcella Mesker
126.			Anne Hobbs	6-3 7-5
					Chris Evert
127.		[2]	Chris Evert		6-4 6-2
				Chris Evert
128.			Alycia Moulton	6-2 6-1

(default) 17 queries took 19 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	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` = 3 AND `Contest`.`category_id` = 19 AND `Contest`.`slug` = '1983' 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` = (1794) 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 (9582, 9751, 9691, 9695, 9670, 9737, 9744, 9707, 9644, 9571, 9687, 11298, 9796, 9564, 9654, 9677, 9665, 9773, 9658, 9733, 9645, 9731, 9700, 9562, 9716, 9720, 9772, 11310, 11326, 9714, 9648, 11329, 9663, 9754, 9704, 9680, 9722, 12464, 9528, 9617, 9828, 9685, 9706, 11319, 9789, 9630, 9692, 11300, 9638, 9753, 9679, 11296, 9637, 11315, 9718, 9760, 9711, 9743, 9635, 9653, 9699, 9606, 9656, 9857, 9657, 9671, 9646, 11316, 9763, 9608, 9764, 11306, 9709, 11282, 11321, 12465, 11307, 9712, 9675, 11268, 9741, 9713, 9702, 9554, 9515, 9668, 9723, 11303, 9748, 9696, 9628, 9631, 9842, 9729, 9681, 9776, 9507, 9513, 9686, 9724, 9701, 9573, 9703, 9803, 9449, 9690, 9710, 9693, 9728, 9795, 9406, 9661, 9717, 9676, 11286, 11318, 11304, 11291, 9636, 11301, 9689, 9770, 9532, 9730, 9640, 9682, 9672, 9708) 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` = 1794	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 196, 36, 217, 212, 179, 178, 172, 13, 83, 94, 219, 100, 31, 29, 133, 92, 153, 68, 84)	20	20	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 196, 36, 217, 212, 179, 178, 172, 13, 83, 94, 219, 100, 31, 29, 133, 92, 153, 68, 84)	20	20	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9582, 9751, 9691, 9695, 9670, 9737, 9744, 9707, 9644, 9571, 9687, 11298, 9796, 9564, 9654, 9677, 9665, 9773, 9658, 9733, 9645, 9731, 9700, 9562, 9716, 9720, 9772, 11310, 11326, 9714, 9648, 11329, 9663, 9754, 9704, 9680, 9722, 12464, 9528, 9617, 9828, 9685, 9706, 11319, 9789, 9630, 9692, 11300, 9638, 9753, 9679, 11296, 9637, 11315, 9718, 9760, 9711, 9743, 9635, 9653, 9699, 9606, 9656, 9857, 9657, 9671, 9646, 11316, 9763, 9608, 9764, 11306, 9709, 11282, 11321, 12465, 11307, 9712, 9675, 11268, 9741, 9713, 9702, 9554, 9515, 9668, 9723, 11303, 9748, 9696, 9628, 9631, 9842, 9729, 9681, 9776, 9507, 9513, 9686, 9724, 9701, 9573, 9703, 9803, 9449, 9690, 9710, 9693, 9728, 9795, 9406, 9661, 9717, 9676, 11286, 11318, 11304, 11291, 9636, 11301, 9689, 9770, 9532, 9730, 9640, 9682, 9672, 9708)) AND (`Playercontest`.`contest_id` = 1794))	128	128	1
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` = 1983	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	0
17	SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 3, 4)	4	4	0

(default) 17 queries took 19 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` = '1983' 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` = (1794) 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 (9582, 9751, 9691, 9695, 9670, 9737, 9744, 9707, 9644, 9571, 9687, 11298, 9796, 9564, 9654, 9677, 9665, 9773, 9658, 9733, 9645, 9731, 9700, 9562, 9716, 9720, 9772, 11310, 11326, 9714, 9648, 11329, 9663, 9754, 9704, 9680, 9722, 12464, 9528, 9617, 9828, 9685, 9706, 11319, 9789, 9630, 9692, 11300, 9638, 9753, 9679, 11296, 9637, 11315, 9718, 9760, 9711, 9743, 9635, 9653, 9699, 9606, 9656, 9857, 9657, 9671, 9646, 11316, 9763, 9608, 9764, 11306, 9709, 11282, 11321, 12465, 11307, 9712, 9675, 11268, 9741, 9713, 9702, 9554, 9515, 9668, 9723, 11303, 9748, 9696, 9628, 9631, 9842, 9729, 9681, 9776, 9507, 9513, 9686, 9724, 9701, 9573, 9703, 9803, 9449, 9690, 9710, 9693, 9728, 9795, 9406, 9661, 9717, 9676, 11286, 11318, 11304, 11291, 9636, 11301, 9689, 9770, 9532, 9730, 9640, 9682, 9672, 9708) 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` = 1794

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9582, 9751, 9691, 9695, 9670, 9737, 9744, 9707, 9644, 9571, 9687, 11298, 9796, 9564, 9654, 9677, 9665, 9773, 9658, 9733, 9645, 9731, 9700, 9562, 9716, 9720, 9772, 11310, 11326, 9714, 9648, 11329, 9663, 9754, 9704, 9680, 9722, 12464, 9528, 9617, 9828, 9685, 9706, 11319, 9789, 9630, 9692, 11300, 9638, 9753, 9679, 11296, 9637, 11315, 9718, 9760, 9711, 9743, 9635, 9653, 9699, 9606, 9656, 9857, 9657, 9671, 9646, 11316, 9763, 9608, 9764, 11306, 9709, 11282, 11321, 12465, 11307, 9712, 9675, 11268, 9741, 9713, 9702, 9554, 9515, 9668, 9723, 11303, 9748, 9696, 9628, 9631, 9842, 9729, 9681, 9776, 9507, 9513, 9686, 9724, 9701, 9573, 9703, 9803, 9449, 9690, 9710, 9693, 9728, 9795, 9406, 9661, 9717, 9676, 11286, 11318, 11304, 11291, 9636, 11301, 9689, 9770, 9532, 9730, 9640, 9682, 9672, 9708)) AND (`Playercontest`.`contest_id` = 1794))

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

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)