US Open 1999 Women's Singles (August 30 - September 11)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Martina Hingis
				Martina Hingis
2.			Kveta Hrdlickova	6-1 7-5
					Martina Hingis
3.			Sarah Pitkowski		6-1 6-1
				Sarah Pitkowski
4.		[WC]	Jennifer Hopkins	6-4 6-2
						Martina Hingis
5.		[Q]	Sandra Kloesel			6-3 6-1
				Sandra Kloesel
6.		[WC]	Zuzana Lesenarova	6-4 6-3
					Sandra Kloesel
7.			Jane Chi		6-4 7-6(4)
				Jane Chi
8.			Sandra Kleinova	6-7(5) 6-3 7-5
							Martina Hingis
9.			Patty Schnyder				6-4 7-5
				Patty Schnyder
10.			Cristina Torrens-Valero	6-3 7-5
					Patty Schnyder
11.			Lisa Raymond		6-3 3-6 6-3
				Lisa Raymond
12.			Emilie Loit	6-0 6-4
						Arantxa Sanchez-Vicario
13.			Nicole Pratt			6-2 6-2
				Nicole Pratt
14.			Meilen Tu	6-4 6-2
					Arantxa Sanchez-Vicario
15.		[10]	Arantxa Sanchez-Vicario		6-2 6-2
				Arantxa Sanchez-Vicario
16.			Jelena Dokic	7-5 6-1
								Martina Hingis
17.		[15]	Amelie Mauresmo					6-2 6-0
				Amelie Mauresmo
18.			Justine Henin	6-1 6-4
					Amelie Mauresmo
19.			Mariaan De Swardt		4-6 6-1 6-3
				Mariaan De Swardt
20.			Kristina Brandi	6-3 7-6(5)
						Amelie Mauresmo
21.			Mirjana Lucic			6-4 6-3
				Mirjana Lucic
22.		[WC]	Erika De Lone	6-3 6-3
					Tara Snyder
23.			Tara Snyder		7-5 6-3
				Tara Snyder
24.			Ludmila Cervanova	6-1 7-5
							Anke Huber
25.			Anke Huber				6-4 6-4
				Anke Huber
26.			Silvija Talaja	2-6 6-2 6-0
					Anke Huber
27.			Anne Kremer		6-1 7-6(5)
				Anne Kremer
28.		[WC]	Jill Craybas	6-2 6-2
						Anke Huber
29.		[Q]	Tina Krizan			6-3 6-2
				Tina Krizan
30.			Meghann Shaughnessy	6-3 6-3
					Jana Novotna
31.		[8]	Jana Novotna		6-0 6-3
				Jana Novotna
32.			Shi-Ting Wang	6-2 6-2
									Martina Hingis
33.		[3]	Venus Williams						6-1 4-6 6-3
				Venus Williams
34.		[Q]	Tatiana Poutchek	6-1 6-2
					Venus Williams
35.			Anne-Gaelle Sidot		6-4 6-3
				Anne-Gaelle Sidot
36.			Laurence Courtois	4-6 6-4 6-2
						Venus Williams
37.			Henrieta Nagyova			w/o
				Henrieta Nagyova
38.			Lubomira Bacheva	6-1 6-4
					Henrieta Nagyova
39.		[Q]	Magdalena Grzybowska		6-4 6-3
				Magdalena Grzybowska
40.			Jana Nejedly	6-1 6-4
							Venus Williams
41.		[Q]	Anastasia Myskina				2-6 6-1 6-0
				Anastasia Myskina
42.		[Q]	Lisa McShea	6-3 6-2
					Mary Joe Fernandez
43.			Mary Joe Fernandez		7-5 7-5
				Mary Joe Fernandez
44.			Miriam Oremans	3-6 6-4 6-2
						Mary Joe Fernandez
45.			Rita Grande			7-5 6-0
				Rita Grande
46.			Barbara Schwartz	7-6(7) 4-6 6-4
					Dominique Monami
47.		[13]	Dominique Monami		6-3 6-3
				Dominique Monami
48.			Maureen Drake	6-1 6-0
								Venus Williams
49.		[12]	Barbara Schett					6-4 6-3
				Barbara Schett
50.		[Q]	Tracy Almeda	6-0 6-1
					Barbara Schett
51.		[Q]	Asa Carlsson		6-4 6-2
				Asa Carlsson
52.			Andrea Glass	6-0 6-2
						Barbara Schett
53.			Amanda Hopmans			6-1 6-0
				Amanda Hopmans
54.			Elena Pampoulova	7-6(1) 6-3
					Virginia Ruano-Pascual
55.			Virginia Ruano-Pascual		6-4 6-1
				Virginia Ruano-Pascual
56.			Emmanuelle Gagliardi	6-2 6-4
							Barbara Schett
57.			Elena Likhovtseva				6-0 6-1
				Elena Likhovtseva
58.		[Q]	Catalina Cristea	6-7(5) 6-4 6-1
					Elena Likhovtseva
59.		[Q]	Tina Pisnik		6-2 6-3
				Tina Pisnik
60.			Denisa Chladkova	6-3 6-4
						Elena Likhovtseva
61.			Tamarine Tanasugarn			6-1 6-3
				Tamarine Tanasugarn
62.			Tatiana Panova	7-6(4) 6-1
					Irina Spirlea
63.			Irina Spirlea		4-6 7-5 6-3
				Irina Spirlea
64.		[6]	Amanda Coetzer	6-1 7-5
										Serena Williams
65.		[7]	Serena Williams							6-3 7-6(4)
				Serena Williams
66.			Kimberly Po	6-1 6-0
					Serena Williams
67.		[Q]	Jelena Kostanic		6-4 6-2
				Jelena Kostanic
68.		[WC]	Mashona Washington	2-6 6-4 6-1
						Serena Williams
69.		[Q]	Adriana Gersi			4-6 6-2 7-5
				Adriana Gersi
70.			Nathalie Dechy	4-6 6-0 6-2
					Kim Clijsters
71.			Kim Clijsters		6-3 6-2
				Kim Clijsters
72.		[Q]	Anca Barna	7-5 6-1
							Serena Williams
73.			Fabiola Zuluaga				4-6 6-2 6-2
				Fabiola Zuluaga
74.		[WC]	Laura Granville	6-1 6-2
					Elena Dementieva
75.			Elena Dementieva		4-6 6-3 6-1
				Elena Dementieva
76.			Christina Papadaki	6-2 6-2
						Conchita Martinez
77.			Alexia Dechaume			6-2 2-6 6-4
				Alexia Dechaume
78.			Katarina Srebotnik	6-1 6-4
					Conchita Martinez
79.		[16]	Conchita Martinez		6-0 6-0
				Conchita Martinez
80.			Chanda Rubin	6-2 6-3
								Serena Williams
81.		[11]	Nathalie Tauziat					4-6 6-3 6-2
				Nathalie Tauziat
82.			Alexandra Stevenson	6-2 6-2
					Nathalie Tauziat
83.			Maria Sanchez Lorenzo		7-5 4-6 6-1
				Maria Sanchez Lorenzo
84.		[Q]	Janet Lee	5-7 6-3 6-4
						Jennifer Capriati
85.			Jennifer Capriati			6-3 1-6 6-1
				Jennifer Capriati
86.			Iva Majoli	6-1 7-5
					Jennifer Capriati
87.			Seda Noorlander		5-7 6-1 6-4
				Seda Noorlander
88.			Laura Golarsa	6-2 6-1
							Monica Seles
89.			Karina Habsudova				6-4 6-3
				Karina Habsudova
90.			Lenka Nemeckova	6-3 6-1
					Ai Sugiyama
91.			Ai Sugiyama		6-2 4-6 7-5
				Ai Sugiyama
92.			Anna Smashnova	7-6(5) 6-4
						Monica Seles
93.			Silvia Farina			6-2 6-3
				Silvia Farina
94.		[Q]	Maria Vento-Kabchi	6-4 6-0
					Monica Seles
95.		[4]	Monica Seles		6-2 6-3
				Monica Seles
96.			Barbara Rittner	6-1 6-1
									Serena Williams
97.		[5]	Mary Pierce						6-4 1-6 6-4
				Mary Pierce
98.			Sandra Nacuk	6-3 7-5
					Mary Pierce
99.			Gala Leon Garcia		6-2 6-3
				Gala Leon Garcia
100.			Brie Rippner	6-4 7-6(4)
						Mary Pierce
101.			Angeles Montolio			6-1 7-6(4)
				Angeles Montolio
102.			Olga Barabanschikova	6-4 6-4
					Angeles Montolio
103.			Paola Suarez		7-6(5) 6-2
				Paola Suarez
104.		[WC]	Melissa Middleton	6-4 6-1
							Mary Pierce
105.		[WC]	Samantha Reeves				6-3 7-6(6)
				Samantha Reeves
106.			Lilia Osterloh	7-5 6-3
					Sabine Appelmans
107.			Sabine Appelmans		6-4 6-7(5) 6-3
				Sabine Appelmans
108.		[Q]	Jana Kandarr	6-2 7-6(3)
						Sabine Appelmans
109.			Magui Serna			0-6 6-1 6-3
				Magui Serna
110.			Els Callens	6-3 1-6 7-6(6)
					Magui Serna
111.		[14]	Sandrine Testud		6-3 6-3
				Sandrine Testud
112.			Marlene Weingartner	7-6(4) 6-4
								Lindsay Davenport
113.		[9]	Julie Halard					6-2 3-6 7-5
				Julie Halard
114.			Cara Black	6-3 5-7 6-3
					Julie Halard
115.			Fang Li		6-2 6-4
				Fang Li
116.			Pavlina Stoyanova	6-1 6-3
						Julie Halard
117.			Sylvia Plischke			5-2 rtd.
				Sylvia Plischke
118.			Alicia Molik	6-3 6-2
					Amelie Cocheteux
119.			Amelie Cocheteux		6-3 4-6 6-3
				Amelie Cocheteux
120.			Elena Tatarkova	6-3 6-3
							Lindsay Davenport
121.			Natasha Zvereva				6-1 6-2
				Natasha Zvereva
122.			Ines Gorrochategui	6-2 6-2
					Amy Frazier
123.			Amy Frazier		6-2 6-4
				Amy Frazier
124.			Anne Miller	6-2 3-6 6-3
						Lindsay Davenport
125.			Ruxandra Dragomir			6-1 6-1
				Ruxandra Dragomir
126.			Rita Kuti-Kis	6-1 5-7 6-4
					Lindsay Davenport
127.		[2]	Lindsay Davenport		6-0 6-2
				Lindsay Davenport
128.			Corina Morariu	6-0 6-3

(default) 17 queries took 29 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` = 'us-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` = (4)	5	5	2
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` = (4)	3	3	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` = (4)	2	2	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` = 'us-open' AND `Category`.`slug` = 'women-singles' LIMIT 1	1	1	2
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` = (24) ORDER BY `Contest`.`year` ASC	138	138	6
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` = 4 AND `Contest`.`category_id` = 24 AND `Contest`.`slug` = '1999' 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` = (1418) 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 (10078, 10156, 10084, 10209, 10142, 13419, 10159, 10100, 10356, 10123, 10039, 10165, 9937, 10126, 9957, 10173, 10152, 10179, 10074, 10124, 10149, 9913, 10135, 10184, 9915, 10122, 10128, 10171, 10043, 10147, 9848, 10028, 10151, 10216, 10131, 10037, 10129, 10189, 10103, 10092, 10262, 10053, 9909, 9953, 10098, 10167, 10012, 9934, 10077, 13420, 10101, 10141, 10196, 9928, 10055, 10130, 10064, 10059, 10202, 10133, 10115, 10145, 10050, 10018, 10150, 9991, 10190, 10303, 10117, 10116, 10192, 10194, 10198, 10278, 10174, 10044, 9873, 10180, 9885, 9985, 10017, 10193, 10090, 10086, 9997, 10088, 10162, 9896, 9946, 10144, 10070, 10062, 10049, 10105, 9974, 9967, 10024, 10195, 10114, 10164, 10069, 10137, 10119, 13421, 10154, 10175, 9936, 10106, 10111, 10068, 9990, 10157, 9829, 10160, 9987, 10188, 10153, 10172, 10155, 10134, 9945, 9999, 9845, 10076, 10063, 10169, 10025, 10121) 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` = 1418	128	128	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (21, 31, 20, 72, 207, 151, 197, 178, 168, 53, 68, 172, 153, 154, 13, 36, 92, 179, 173, 10, 149, 133, 84, 50, 111, 169, 181, 42, 219, 74, 14, 91, 94, 184, 194, 201, 43)	37	37	2
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (21, 31, 20, 72, 207, 151, 197, 178, 168, 53, 68, 172, 153, 154, 13, 36, 92, 179, 173, 10, 149, 133, 84, 50, 111, 169, 181, 42, 219, 74, 14, 91, 94, 184, 194, 201, 43)	37	37	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10078, 10156, 10084, 10209, 10142, 13419, 10159, 10100, 10356, 10123, 10039, 10165, 9937, 10126, 9957, 10173, 10152, 10179, 10074, 10124, 10149, 9913, 10135, 10184, 9915, 10122, 10128, 10171, 10043, 10147, 9848, 10028, 10151, 10216, 10131, 10037, 10129, 10189, 10103, 10092, 10262, 10053, 9909, 9953, 10098, 10167, 10012, 9934, 10077, 13420, 10101, 10141, 10196, 9928, 10055, 10130, 10064, 10059, 10202, 10133, 10115, 10145, 10050, 10018, 10150, 9991, 10190, 10303, 10117, 10116, 10192, 10194, 10198, 10278, 10174, 10044, 9873, 10180, 9885, 9985, 10017, 10193, 10090, 10086, 9997, 10088, 10162, 9896, 9946, 10144, 10070, 10062, 10049, 10105, 9974, 9967, 10024, 10195, 10114, 10164, 10069, 10137, 10119, 13421, 10154, 10175, 9936, 10106, 10111, 10068, 9990, 10157, 9829, 10160, 9987, 10188, 10153, 10172, 10155, 10134, 9945, 9999, 9845, 10076, 10063, 10169, 10025, 10121)) AND (`Playercontest`.`contest_id` = 1418))	128	128	1
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 24 ORDER BY `Contest`.`date_from` ASC	138	138	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1999	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 29 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` = 'us-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` = (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` = (4)

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

138

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` = 4 AND `Contest`.`category_id` = 24 AND `Contest`.`slug` = '1999' 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` = (1418) 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 (10078, 10156, 10084, 10209, 10142, 13419, 10159, 10100, 10356, 10123, 10039, 10165, 9937, 10126, 9957, 10173, 10152, 10179, 10074, 10124, 10149, 9913, 10135, 10184, 9915, 10122, 10128, 10171, 10043, 10147, 9848, 10028, 10151, 10216, 10131, 10037, 10129, 10189, 10103, 10092, 10262, 10053, 9909, 9953, 10098, 10167, 10012, 9934, 10077, 13420, 10101, 10141, 10196, 9928, 10055, 10130, 10064, 10059, 10202, 10133, 10115, 10145, 10050, 10018, 10150, 9991, 10190, 10303, 10117, 10116, 10192, 10194, 10198, 10278, 10174, 10044, 9873, 10180, 9885, 9985, 10017, 10193, 10090, 10086, 9997, 10088, 10162, 9896, 9946, 10144, 10070, 10062, 10049, 10105, 9974, 9967, 10024, 10195, 10114, 10164, 10069, 10137, 10119, 13421, 10154, 10175, 9936, 10106, 10111, 10068, 9990, 10157, 9829, 10160, 9987, 10188, 10153, 10172, 10155, 10134, 9945, 9999, 9845, 10076, 10063, 10169, 10025, 10121) 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` = 1418

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (21, 31, 20, 72, 207, 151, 197, 178, 168, 53, 68, 172, 153, 154, 13, 36, 92, 179, 173, 10, 149, 133, 84, 50, 111, 169, 181, 42, 219, 74, 14, 91, 94, 184, 194, 201, 43)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (21, 31, 20, 72, 207, 151, 197, 178, 168, 53, 68, 172, 153, 154, 13, 36, 92, 179, 173, 10, 149, 133, 84, 50, 111, 169, 181, 42, 219, 74, 14, 91, 94, 184, 194, 201, 43)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10078, 10156, 10084, 10209, 10142, 13419, 10159, 10100, 10356, 10123, 10039, 10165, 9937, 10126, 9957, 10173, 10152, 10179, 10074, 10124, 10149, 9913, 10135, 10184, 9915, 10122, 10128, 10171, 10043, 10147, 9848, 10028, 10151, 10216, 10131, 10037, 10129, 10189, 10103, 10092, 10262, 10053, 9909, 9953, 10098, 10167, 10012, 9934, 10077, 13420, 10101, 10141, 10196, 9928, 10055, 10130, 10064, 10059, 10202, 10133, 10115, 10145, 10050, 10018, 10150, 9991, 10190, 10303, 10117, 10116, 10192, 10194, 10198, 10278, 10174, 10044, 9873, 10180, 9885, 9985, 10017, 10193, 10090, 10086, 9997, 10088, 10162, 9896, 9946, 10144, 10070, 10062, 10049, 10105, 9974, 9967, 10024, 10195, 10114, 10164, 10069, 10137, 10119, 13421, 10154, 10175, 9936, 10106, 10111, 10068, 9990, 10157, 9829, 10160, 9987, 10188, 10153, 10172, 10155, 10134, 9945, 9999, 9845, 10076, 10063, 10169, 10025, 10121)) AND (`Playercontest`.`contest_id` = 1418))

128

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

138

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

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)