Roland Garros 1988 Women's Singles (May 23 - June 5)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Steffi Graf
				Steffi Graf
2.		[WC]	Nathalie Guerree	6-0 6-4
					Steffi Graf
3.			Ronnie Reis		6-1 6-0
				Ronnie Reis
4.			Niurka Sodupe	6-3 6-3
						Steffi Graf
5.			Susan Sloane Lundy			6-0 6-1
				Susan Sloane Lundy
6.			Camille Benjamin	6-2 0-6 6-1
					Susan Sloane Lundy
7.			Eva Pfaff		6-3 3-6 6-3
				Eva Pfaff
8.			Amy Frazier	6-3 6-2
							Steffi Graf
9.			Jenny Byrne				6-1 6-3
				Jenny Byrne
10.			Pascale Paradis	6-1 1-6 6-4
					Jenny Byrne
11.			Dianne Van Rensburg		7-5 7-6(3)
				Dianne Van Rensburg
12.			Kathy Rinaldi	4-6 7-5 7-5
						Nathalie Tauziat
13.			Nathalie Tauziat			7-5 6-2
				Nathalie Tauziat
14.			Manon Bollegraf	6-3 6-2
					Nathalie Tauziat
15.		[LL]	Luciana Corsato		6-3 6-0
				Luciana Corsato
16.			Halle Cioffi	6-0 6-4
								Steffi Graf
17.		[9]	Lori McNeil					6-0 6-1
				Lori McNeil
18.			Elly Hakami	6-3 6-2
					Lori McNeil
19.			Christiane Jolissaint		6-1 4-6 6-2
				Christiane Jolissaint
20.			Cristina Casale	6-7(5) 6-1 6-1
						Conchita Martinez
21.		[Q]	Conchita Martinez			1-6 6-3 6-1
				Conchita Martinez
22.			Alexia Dechaume	6-0 6-2
					Conchita Martinez
23.			Tine Scheuer-Larsen		6-2 6-0
				Tine Scheuer-Larsen
24.			Catherine Suire	6-3 6-2
							Bettina Fulco
25.			Radomira Zrubakova				6-2 6-4
				Radomira Zrubakova
26.			Monique Javer	6-0 6-0
					Radomira Zrubakova
27.			Patricia Tarabini		6-4 6-4
				Patricia Tarabini
28.			Jana Novotna	1-6 6-3 6-2
						Bettina Fulco
29.			Bettina Fulco			6-2 6-1
				Bettina Fulco
30.		[Q]	Maria-Christine Damas	6-0 6-2
					Bettina Fulco
31.		[8]	Hana Mandlikova		6-4 6-3
				Hana Mandlikova
32.			Elizabeth Minter	6-2 6-1
									Steffi Graf
33.		[4]	Gabriela Sabatini						6-3 7-6(3)
				Gabriela Sabatini
34.		[WC]	Maider Laval	6-1 7-5
					Gabriela Sabatini
35.			Karen Schimper		6-3 6-0
				Karen Schimper
36.			Maria Lindstrom	6-7(4) 6-3 6-1
						Gabriela Sabatini
37.			Masako Yanagi			6-3 6-0
				Masako Yanagi
38.			Michelle Jaggard	6-3 6-3
					Masako Yanagi
39.			Mareen Louie		4-6 6-1 6-2
				Mareen Louie
40.			Lisa Bonder	1-6 6-3 6-4
							Gabriela Sabatini
41.			Brenda Schultz				6-4 6-1
				Brenda Schultz
42.			Sandra Wasserman	7-5 6-0
					Brenda Schultz
43.			Mariana Perez Roldan		w/o
				Mariana Perez Roldan
44.			Susan Mascarin	7-6(2) 4-6 6-4
						Brenda Schultz
45.		[Q]	Jana Pospisilova			6-4 7-5
				Jana Pospisilova
46.			Rosalyn Fairbank	7-6(3) 7-6(3)
					Sandra Cecchini
47.		[14]	Sandra Cecchini		6-1 6-0
				Sandra Cecchini
48.			Kumiko Okamoto	6-1 6-3
								Gabriela Sabatini
49.		[12]	Raffaella Reggi					4-6 6-1 6-3
				Raffaella Reggi
50.			Sabrina Goles	6-4 6-2
					Maria Strandlund
51.		[Q]	Maria Strandlund		3-6 6-1 6-3
				Maria Strandlund
52.			Christina Singer	1-6 6-2 6-2
						Nicole Jagerman
53.		[LL]	Nicole Jagerman			4-6 6-0 6-3
				Nicole Jagerman
54.			Marcella Mesker	6-3 6-1
					Nicole Jagerman
55.			Julie Halard		7-6(5) 7-6(2)
				Julie Halard
56.			Gisele Miro	6-3 6-2
							Helen Kelesi
57.			Helen Kelesi				6-2 6-1
				Helen Kelesi
58.		[WC]	Maria-Christine Calleja	4-6 6-2 6-4
					Helen Kelesi
59.			Andrea Holikova		6-2 6-2
				Andrea Holikova
60.			Nathalie Herreman	6-2 6-2
						Helen Kelesi
61.			Linda Ferrando			6-4 6-2
				Linda Ferrando
62.			Kathy Horvath	6-2 2-6 6-3
					Manuela Maleeva
63.		[5]	Manuela Maleeva		6-0 6-2
				Manuela Maleeva
64.			Petra Huber	6-3 6-1
										Steffi Graf
65.		[7]	Claudia Kohde-Kilsch							6-0 6-0
				Claudia Kohde-Kilsch
66.			Angeliki Kanellopoulous	6-2 6-2
					Claudia Kohde-Kilsch
67.			Federica Bonsignori		6-4 6-0
				Federica Bonsignori
68.			Hu Na	5-7 6-4 6-3
						Nicole Provis
69.			Nicole Provis			1-6 6-4 7-5
				Nicole Provis
70.		[WC]	Sybille Niox-Chateau	6-0 6-3
					Nicole Provis
71.		[WC]	Emmanuelle Derly		5-7 6-3 6-1
				Emmanuelle Derly
72.			Regina Marsikova	6-2 6-2
							Nicole Provis
73.			Isabelle Demongeot				7-6(1) 7-6(4)
				Isabelle Demongeot
74.			Akiko Kijimuta	4-6 6-3 6-2
					Isabelle Demongeot
75.			Wiltrud Probst		6-4 6-1
				Wiltrud Probst
76.		[Q]	Sabine Hack	6-4 6-1
						Sylvia Hanika
77.		[WC]	Karine Quentrec			3-6 7-5 6-4
				Karine Quentrec
78.			Adriana Villagran	2-6 6-3 6-3
					Sylvia Hanika
79.		[15]	Sylvia Hanika		5-7 6-2 6-2
				Sylvia Hanika
80.			Claudia Porwik	6-1 6-3
								Nicole Provis
81.			Catherine Tanvier					7-5 3-6 6-4
				Catherine Tanvier
82.		[11]	Katerina Maleeva	6-4 7-5
					Catherine Tanvier
83.			Hester Witvoet		6-1 6-1
				Hester Witvoet
84.		[Q]	Andrea Tiezzi	7-6(6) 6-3
						Catherine Tanvier
85.			Jo Durie			3-6 6-4 6-3
				Jo Durie
86.			Terry Phelps	7-6(3) 6-2
					Elna Reinach
87.			Elna Reinach		6-1 6-4
				Elna Reinach
88.			Carling Bassett	6-3 6-0
							Arantxa Sanchez-Vicario
89.			Arantxa Sanchez-Vicario				6-2 6-0
				Arantxa Sanchez-Vicario
90.			Iwona Kuczynska	6-2 6-0
					Arantxa Sanchez-Vicario
91.			Silke Meier		7-5 6-0
				Silke Meier
92.			Anne Minter	6-1 6-3
						Arantxa Sanchez-Vicario
93.		[Q]	Barbara Romano			6-1 7-6(4)
				Barbara Romano
94.		[Q]	Jonna Jonerup	6-2 6-0
					Chris Evert
95.		[3]	Chris Evert		7-5 6-2
				Chris Evert
96.			Judith Wiesner	6-1 6-4
									Natasha Zvereva
97.		[6]	Helena Sukova						6-3 6-7(3) 7-5
				Helena Sukova
98.			Isabel Cueto	6-2 6-0
					Helena Sukova
99.		[LL]	Sabine Appelmans		6-1 6-4
				Sabine Appelmans
100.			Elise Burgin	6-4 6-7(4) 6-0
						Helena Sukova
101.			Mercedes Paz			6-4 6-4
				Mercedes Paz
102.			Catarina Lindqvist	5-7 6-4 6-3
					Mercedes Paz
103.			Donna Faber		7-6(4) 6-4
				Donna Faber
104.		[WC]	Catherine Mothes	6-0 6-4
							Helena Sukova
105.			Michelle Torres				6-1 6-2
				Michelle Torres
106.			Natalia Bykova	6-1 6-2
					Michelle Torres
107.			Laura Garrone		6-1 2-6 6-4
				Laura Garrone
108.			Katrina Adams	7-5 1-6 6-3
						Zina Garrison
109.			Iva Budarova			6-1 6-1
				Iva Budarova
110.			Neige Dias	6-7(6) 6-3 7-5
					Zina Garrison
111.		[10]	Zina Garrison		6-0 6-7(4) 6-2
				Zina Garrison
112.			Stephanie Rehe	6-2 4-6 6-1
								Natasha Zvereva
113.		[13]	Natasha Zvereva					6-2 6-3
				Natasha Zvereva
114.			Laura Golarsa	7-6(5) 6-0
					Natasha Zvereva
115.			Louise Field		6-2 6-0
				Louise Field
116.			Carol Christian	6-1 4-6 6-1
						Natasha Zvereva
117.			Melissa Gurney			6-0 6-4
				Melissa Gurney
118.			Sabine Auer	7-5 7-5
					Melissa Gurney
119.		[WC]	Noelle Van Lottum		2-6 6-2 7-5
				Noelle Van Lottum
120.			Celine Cohen	7-5 6-3
							Natasha Zvereva
121.			Barbara Paulus				6-3 7-6(5)
				Barbara Paulus
122.		[LL]	Clare Wood	6-1 7-6(3)
					Barbara Paulus
123.			Ann Devries		6-3 6-2
				Ann Devries
124.			Eva Stutzki	6-3 4-6 7-5
						Martina Navratilova
125.			Hellas Ter Riet			6-2 6-2
				Hellas Ter Riet
126.			Beth Herr	6-0 7-5
					Martina Navratilova
127.		[2]	Martina Navratilova		6-1 2-0 rtd.
				Martina Navratilova
128.			Patricia Medrado	6-0 6-3

(default) 17 queries took 22 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	2
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` = '1988' 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` = (1278) 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, 9876, 9902, 11349, 10008, 9709, 9828, 9845, 9739, 9721, 9793, 9717, 10017, 9784, 11358, 9901, 9727, 10042, 9657, 11359, 9885, 9873, 9752, 9716, 9837, 9817, 9963, 9848, 10010, 9835, 9648, 9729, 9883, 9840, 11356, 9861, 9755, 9797, 11270, 9764, 9863, 9855, 11348, 9705, 9943, 9658, 10091, 9783, 9722, 11313, 9894, 9790, 9830, 9640, 9829, 9903, 9771, 9669, 9757, 9888, 10057, 9897, 9702, 11336, 9654, 11334, 9899, 9767, 9768, 9824, 9859, 9613, 9938, 9794, 9804, 9975, 9905, 9747, 9665, 9779, 9695, 9756, 9875, 11360, 9692, 9795, 9780, 9723, 9957, 9906, 9900, 9646, 11361, 9882, 9672, 9781, 9677, 9973, 9936, 9744, 9962, 9753, 9877, 11362, 11307, 11363, 11337, 9866, 9699, 11341, 9706, 9996, 9945, 9896, 9742, 9833, 11335, 9908, 9970, 9852, 9918, 9851, 9782, 9786, 9826, 9728, 9582, 11268) 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` = 1278	130	130	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 21, 212, 36, 133, 92, 217, 218, 13, 68, 179, 29, 196, 172, 219, 14, 178, 74, 94, 149, 31, 173, 10, 54)	24	24	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 21, 212, 36, 133, 92, 217, 218, 13, 68, 179, 29, 196, 172, 219, 14, 178, 74, 94, 149, 31, 173, 10, 54)	24	24	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9715, 9876, 9902, 11349, 10008, 9709, 9828, 9845, 9739, 9721, 9793, 9717, 10017, 9784, 11358, 9901, 9727, 10042, 9657, 11359, 9885, 9873, 9752, 9716, 9837, 9817, 9963, 9848, 10010, 9835, 9648, 9729, 9883, 9840, 11356, 9861, 9755, 9797, 11270, 9764, 9863, 9855, 11348, 9705, 9943, 9658, 10091, 9783, 9722, 11313, 9894, 9790, 9830, 9640, 9829, 9903, 9771, 9669, 9757, 9888, 10057, 9897, 9702, 11336, 9654, 11334, 9899, 9767, 9768, 9824, 9859, 9613, 9938, 9794, 9804, 9975, 9905, 9747, 9665, 9779, 9695, 9756, 9875, 11360, 9692, 9795, 9780, 9723, 9957, 9906, 9900, 9646, 11361, 9882, 9672, 9781, 9677, 9973, 9936, 9744, 9962, 9753, 9877, 11362, 11307, 11363, 11337, 9866, 9699, 11341, 9706, 9996, 9945, 9896, 9742, 9833, 11335, 9908, 9970, 9852, 9918, 9851, 9782, 9786, 9826, 9728, 9582, 11268)) AND (`Playercontest`.`contest_id` = 1278))	128	128	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` = 1988	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 22 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` = '1988' 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` = (1278) 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, 9876, 9902, 11349, 10008, 9709, 9828, 9845, 9739, 9721, 9793, 9717, 10017, 9784, 11358, 9901, 9727, 10042, 9657, 11359, 9885, 9873, 9752, 9716, 9837, 9817, 9963, 9848, 10010, 9835, 9648, 9729, 9883, 9840, 11356, 9861, 9755, 9797, 11270, 9764, 9863, 9855, 11348, 9705, 9943, 9658, 10091, 9783, 9722, 11313, 9894, 9790, 9830, 9640, 9829, 9903, 9771, 9669, 9757, 9888, 10057, 9897, 9702, 11336, 9654, 11334, 9899, 9767, 9768, 9824, 9859, 9613, 9938, 9794, 9804, 9975, 9905, 9747, 9665, 9779, 9695, 9756, 9875, 11360, 9692, 9795, 9780, 9723, 9957, 9906, 9900, 9646, 11361, 9882, 9672, 9781, 9677, 9973, 9936, 9744, 9962, 9753, 9877, 11362, 11307, 11363, 11337, 9866, 9699, 11341, 9706, 9996, 9945, 9896, 9742, 9833, 11335, 9908, 9970, 9852, 9918, 9851, 9782, 9786, 9826, 9728, 9582, 11268) 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` = 1278

130

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9715, 9876, 9902, 11349, 10008, 9709, 9828, 9845, 9739, 9721, 9793, 9717, 10017, 9784, 11358, 9901, 9727, 10042, 9657, 11359, 9885, 9873, 9752, 9716, 9837, 9817, 9963, 9848, 10010, 9835, 9648, 9729, 9883, 9840, 11356, 9861, 9755, 9797, 11270, 9764, 9863, 9855, 11348, 9705, 9943, 9658, 10091, 9783, 9722, 11313, 9894, 9790, 9830, 9640, 9829, 9903, 9771, 9669, 9757, 9888, 10057, 9897, 9702, 11336, 9654, 11334, 9899, 9767, 9768, 9824, 9859, 9613, 9938, 9794, 9804, 9975, 9905, 9747, 9665, 9779, 9695, 9756, 9875, 11360, 9692, 9795, 9780, 9723, 9957, 9906, 9900, 9646, 11361, 9882, 9672, 9781, 9677, 9973, 9936, 9744, 9962, 9753, 9877, 11362, 11307, 11363, 11337, 9866, 9699, 11341, 9706, 9996, 9945, 9896, 9742, 9833, 11335, 9908, 9970, 9852, 9918, 9851, 9782, 9786, 9826, 9728, 9582, 11268)) AND (`Playercontest`.`contest_id` = 1278))

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

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)