US Open 1996 Women's Singles (August 26 - September 8)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Steffi Graf
				Steffi Graf
2.			Yayuk Basuki	6-3 7-6
					Steffi Graf
3.			Karin Kschwendt		6-2 6-1
				Karin Kschwendt
4.			Sandra Kleinova	6-3 6-4
						Steffi Graf
5.			Ai Sugiyama			6-4 6-2
				Ai Sugiyama
6.			Jana Kandarr	6-2 6-1
					Natasha Zvereva
7.			Natasha Zvereva		4-6 6-4 6-3
				Natasha Zvereva
8.			Virginia Ruano-Pascual	6-2 6-7 6-2
							Steffi Graf
9.		[Q]	Anna Kournikova				6-2 6-1
				Anna Kournikova
10.			Ludmila Richterova	7-6 6-3
					Anna Kournikova
11.			Nathalie Baudone		6-3 6-3
				Nathalie Baudone
12.			Jolene Watanabe	6-4 3-6 7-6
						Anna Kournikova
13.			Elena Pampoulova			3-6 6-2 6-4
				Elena Pampoulova
14.			Gigi Fernandez	6-1 6-4
					Barbara Paulus
15.		[14]	Barbara Paulus		7-5 7-6
				Barbara Paulus
16.			Jing-Qian Yi	6-2 6-1
								Steffi Graf
17.		[LL]	Tina Krizan					7-5 6-3
				Tina Krizan
18.			Rika Hiraki	7-6 7-5
					Rita Grande
19.			Rita Grande		6-2 6-0
				Rita Grande
20.			Alexia Dechaume	6-3 6-0
						Rita Grande
21.		[LL]	Annabel Ellwood			7-5 6-1
				Annabel Ellwood
22.			Jennifer Capriati	6-4 6-4
					Els Callens
23.			Els Callens		6-4 1-6 6-1
				Els Callens
24.			Nicole Provis	7-6 7-6
							Judith Wiesner
25.			Petra Langrova				6-0 6-3
				Petra Langrova
26.			Katrina Adams	6-4 6-2
					Petra Langrova
27.			Naoko Sawamatsu		6-4 3-6 7-5
				Naoko Sawamatsu
28.			Rennae Stubbs	6-4 6-3
						Judith Wiesner
29.		[WC]	Debbie Graham			6-2 6-0
				Debbie Graham
30.		[Q]	Stephanie De Ville	6-4 6-2
					Judith Wiesner
31.			Judith Wiesner		6-2 7-5
				Judith Wiesner
32.		[5]	Iva Majoli	2-6 6-3 6-1
									Steffi Graf
33.		[3]	Arantxa Sanchez-Vicario						7-5 6-3
				Arantxa Sanchez-Vicario
34.		[Q]	Laxmi Poruri	6-2 6-1
					Arantxa Sanchez-Vicario
35.			Nicole Arendt		6-2 6-2
				Nicole Arendt
36.			Sandra Cacic	6-2 7-6
						Arantxa Sanchez-Vicario
37.			Elena Likhovtseva			6-1 6-0
				Elena Likhovtseva
38.			Kyoko Nagatsuka	7-6 6-1
					Elena Likhovtseva
39.		[WC]	Lilia Osterloh		6-4 6-2
				Lilia Osterloh
40.			Mana Endo	6-2 6-2
							Martina Hingis
41.			Naoko Kijimuta				6-1 3-6 6-4
				Naoko Kijimuta
42.			Tatjana Jecmenica	6-3 6-2
					Naoko Kijimuta
43.			Alexandra Fusai		6-4 7-5
				Alexandra Fusai
44.		[WC]	Jill Craybas	6-1 2-6 7-5
						Martina Hingis
45.			Miriam Oremans			6-2 6-2
				Miriam Oremans
46.		[Q]	Radomira Zrubakova	6-2 4-6 6-1
					Martina Hingis
47.		[16]	Martina Hingis		6-4 6-4
				Martina Hingis
48.			Angeles Montolio	6-1 6-0
								Martina Hingis
49.		[17]	Karina Habsudova					7-6 6-4
				Karina Habsudova
50.			Radka Bobkova	6-4 6-1
					Karina Habsudova
51.			Nathalie Dechy		6-4 6-2
				Nathalie Dechy
52.			Christina Singer	6-4 6-0
						Karina Habsudova
53.			Nanne Dahlman			6-2 6-3
				Nanne Dahlman
54.			Lindsay Lee	6-3 6-4
					Sandra Dopfer
55.			Sandra Dopfer		2-6 6-2 6-3
				Sandra Dopfer
56.			Zina Garrison	2-6 6-3 7-5
							Jana Novotna
57.			Tami Whitlinger				6-2 6-0
				Tami Whitlinger
58.			Sandra Cecchini	6-2 6-0
					Tami Whitlinger
59.			Amy Frazier		7-6 6-2
				Amy Frazier
60.			Larisa Savchenko	6-1 6-3
						Jana Novotna
61.			Florencia Labat			6-2 6-3
				Florencia Labat
62.		[WC]	Kathy Rinaldi	6-2 6-2
					Jana Novotna
63.		[7]	Jana Novotna		6-2 4-6 6-2
				Jana Novotna
64.			Francesca Lubiani	6-1 7-5
										Steffi Graf
65.		[8]	Lindsay Davenport							7-5 6-4
				Lindsay Davenport
66.		[Q]	Adriana Serra-Zanetti	6-2 6-1
					Lindsay Davenport
67.			Henrieta Nagyova		6-0 6-4
				Henrieta Nagyova
68.			Gala Leon Garcia	6-1 4-6 6-3
						Lindsay Davenport
69.			Anne-Gaelle Sidot			6-0 6-3
				Anne-Gaelle Sidot
70.			Janette Husarova	6-4 6-4
					Anne-Gaelle Sidot
71.			Shi-Ting Wang		6-4 3-6 6-3
				Shi-Ting Wang
72.			Corina Morariu	6-4 6-7 6-2
							Linda Harvey
73.			Linda Harvey				6-2 3-6 6-0
				Linda Harvey
74.			Sung-Hee Park	6-2 6-3
					Linda Harvey
75.			Kristie Boogert		5-7 6-3 6-3
				Kristie Boogert
76.			Joanette Kruger	6-1 6-0
						Linda Harvey
77.			Barbara Rittner			6-4 4-6 7-5
				Barbara Rittner
78.			Katarina Studenikova	7-5 7-5
					Barbara Rittner
79.		[13]	Brenda Schultz		6-2 6-1
				Brenda Schultz
80.			Nana Miyagi	6-1 6-4
								Conchita Martinez
81.		[15]	Gabriela Sabatini					7-6 6-0
				Gabriela Sabatini
82.			Patricia Hy	6-1 6-1
					Gabriela Sabatini
83.			Ann Grossman		6-2 6-3
				Ann Grossman
84.			Silvia Farina	6-4 6-3
						Asa Carlsson
85.			Asa Carlsson			7-5 3-6 6-2
				Asa Carlsson
86.			Gloria Pizzichini	3-6 6-1 7-5
					Asa Carlsson
87.			Barbara Schett		6-2 3-1 rtd.
				Barbara Schett
88.			Sabine Appelmans	1-6 6-4 6-4
							Conchita Martinez
89.			Paola Suarez				6-2 6-1
				Paola Suarez
90.			Marianne Werdel	6-4 6-3
					Helena Sukova
91.			Helena Sukova		6-4 7-6
				Helena Sukova
92.			Yone Kamio	6-2 6-3
						Conchita Martinez
93.			Nathalie Tauziat			6-4 6-3
				Nathalie Tauziat
94.		[Q]	Angelica Gavaldon	7-6 6-2
					Conchita Martinez
95.		[4]	Conchita Martinez		6-1 6-3
				Conchita Martinez
96.			Ruxandra Dragomir	6-2 6-0
									Monica Seles
97.			Amanda Coetzer						6-4 6-3
				Amanda Coetzer
98.		[6]	Anke Huber	6-1 2-6 6-2
					Amanda Coetzer
99.			Mariaan De Swardt		6-2 7-5
				Mariaan De Swardt
100.			Dominique Monami	1-6 6-2 7-6
						Amanda Coetzer
101.			Irina Spirlea			7-6 7-5
				Irina Spirlea
102.			Petra Begerow	6-3 6-2
					Irina Spirlea
103.		[Q]	Maria Jose Gaidano		6-1 6-2
				Maria Jose Gaidano
104.			Melanie Schnell	6-4 6-0
							Amanda Coetzer
105.			Lisa Raymond				6-4 6-1
				Lisa Raymond
106.			Lori McNeil	7-6 6-3
					Lisa Raymond
107.			Sarah Pitkowski		6-2 6-0
				Sarah Pitkowski
108.			Meghann Shaughnessy	6-3 6-3
						Lisa Raymond
109.		[WC]	Kristina Brandi			6-3 6-2
				Kristina Brandi
110.			Andrea Glass	6-2 6-3
					Kimberly Po
111.			Kimberly Po		6-1 6-4
				Kimberly Po
112.		[10]	Kimiko Date	6-2 7-5
								Monica Seles
113.		[Q]	Aleksandra Olsza					6-0 6-3
				Aleksandra Olsza
114.		[12]	Magdalena Maleeva	6-4 6-2
					Ines Gorrochategui
115.			Ines Gorrochategui		6-1 6-1
				Ines Gorrochategui
116.			Magdalena Grzybowska	4-6 6-4 6-1
						Sandrine Testud
117.			Cristina Torrens-Valero			4-6 6-2 6-1
				Cristina Torrens-Valero
118.			Sabine Hack	2-6 6-4 6-2
					Sandrine Testud
119.			Sandrine Testud		6-2 6-1
				Sandrine Testud
120.		[WC]	Pam Shriver	7-5 6-2
							Monica Seles
121.		[WC]	Jane Chi				7-5 6-0
				Jane Chi
122.			Maria Sanchez Lorenzo	6-4 1-6 6-3
					Dally Randriantefy
123.			Dally Randriantefy		6-3 6-1
				Dally Randriantefy
124.			Elena Makarova	6-3 1-6 7-5
						Monica Seles
125.			Laurence Courtois			6-0 6-2
				Laurence Courtois
126.			Flora Perfetti	6-4 3-6 6-2
					Monica Seles
127.		[2]	Monica Seles		w/o
				Monica Seles
128.			Anne Miller	6-0 6-1

(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	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` = (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	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` = (24) ORDER BY `Contest`.`year` ASC	138	138	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` = 4 AND `Contest`.`category_id` = 24 AND `Contest`.`slug` = '1996' 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` = (1415) 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, 10032, 9890, 10100, 10070, 10106, 9945, 10055, 10113, 10081, 10021, 10058, 9928, 9719, 9918, 10108, 10043, 9988, 10098, 9873, 10080, 9997, 10068, 9768, 9880, 9866, 9966, 9891, 10002, 10132, 9781, 10088, 9957, 9895, 9983, 10061, 10064, 10035, 10175, 10014, 10052, 10107, 10026, 10171, 9953, 9837, 10078, 10069, 9946, 9989, 10116, 9790, 9995, 10097, 10030, 9706, 9942, 10091, 9845, 9750, 9994, 9717, 9848, 10087, 10025, 10095, 10129, 10114, 10131, 10045, 10028, 10121, 10009, 10075, 10048, 10023, 9967, 10054, 9863, 9920, 9883, 9796, 9907, 10049, 10101, 10016, 10077, 9936, 10119, 9798, 9677, 9998, 10017, 9941, 9885, 10063, 10018, 9915, 10074, 10012, 10050, 10046, 10056, 10096, 10039, 9727, 10084, 10147, 10124, 10141, 9991, 9930, 10120, 9959, 9999, 10103, 10123, 9975, 9990, 9656, 10159, 10090, 10083, 10040, 10037, 10036, 9974, 10076) 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` = 1415	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 21, 87, 92, 72, 53, 133, 151, 178, 172, 67, 94, 68, 14, 153, 13, 10, 173, 121, 149, 168, 179, 36, 219, 154, 169, 50, 31, 100, 113, 104, 181, 42, 20)	34	34	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 21, 87, 92, 72, 53, 133, 151, 178, 172, 67, 94, 68, 14, 153, 13, 10, 173, 121, 149, 168, 179, 36, 219, 154, 169, 50, 31, 100, 113, 104, 181, 42, 20)	34	34	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9715, 10032, 9890, 10100, 10070, 10106, 9945, 10055, 10113, 10081, 10021, 10058, 9928, 9719, 9918, 10108, 10043, 9988, 10098, 9873, 10080, 9997, 10068, 9768, 9880, 9866, 9966, 9891, 10002, 10132, 9781, 10088, 9957, 9895, 9983, 10061, 10064, 10035, 10175, 10014, 10052, 10107, 10026, 10171, 9953, 9837, 10078, 10069, 9946, 9989, 10116, 9790, 9995, 10097, 10030, 9706, 9942, 10091, 9845, 9750, 9994, 9717, 9848, 10087, 10025, 10095, 10129, 10114, 10131, 10045, 10028, 10121, 10009, 10075, 10048, 10023, 9967, 10054, 9863, 9920, 9883, 9796, 9907, 10049, 10101, 10016, 10077, 9936, 10119, 9798, 9677, 9998, 10017, 9941, 9885, 10063, 10018, 9915, 10074, 10012, 10050, 10046, 10056, 10096, 10039, 9727, 10084, 10147, 10124, 10141, 9991, 9930, 10120, 9959, 9999, 10103, 10123, 9975, 9990, 9656, 10159, 10090, 10083, 10040, 10037, 10036, 9974, 10076)) AND (`Playercontest`.`contest_id` = 1415))	128	128	9
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` = 1996	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` = '1996' 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` = (1415) 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, 10032, 9890, 10100, 10070, 10106, 9945, 10055, 10113, 10081, 10021, 10058, 9928, 9719, 9918, 10108, 10043, 9988, 10098, 9873, 10080, 9997, 10068, 9768, 9880, 9866, 9966, 9891, 10002, 10132, 9781, 10088, 9957, 9895, 9983, 10061, 10064, 10035, 10175, 10014, 10052, 10107, 10026, 10171, 9953, 9837, 10078, 10069, 9946, 9989, 10116, 9790, 9995, 10097, 10030, 9706, 9942, 10091, 9845, 9750, 9994, 9717, 9848, 10087, 10025, 10095, 10129, 10114, 10131, 10045, 10028, 10121, 10009, 10075, 10048, 10023, 9967, 10054, 9863, 9920, 9883, 9796, 9907, 10049, 10101, 10016, 10077, 9936, 10119, 9798, 9677, 9998, 10017, 9941, 9885, 10063, 10018, 9915, 10074, 10012, 10050, 10046, 10056, 10096, 10039, 9727, 10084, 10147, 10124, 10141, 9991, 9930, 10120, 9959, 9999, 10103, 10123, 9975, 9990, 9656, 10159, 10090, 10083, 10040, 10037, 10036, 9974, 10076) 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` = 1415

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 21, 87, 92, 72, 53, 133, 151, 178, 172, 67, 94, 68, 14, 153, 13, 10, 173, 121, 149, 168, 179, 36, 219, 154, 169, 50, 31, 100, 113, 104, 181, 42, 20)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 21, 87, 92, 72, 53, 133, 151, 178, 172, 67, 94, 68, 14, 153, 13, 10, 173, 121, 149, 168, 179, 36, 219, 154, 169, 50, 31, 100, 113, 104, 181, 42, 20)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9715, 10032, 9890, 10100, 10070, 10106, 9945, 10055, 10113, 10081, 10021, 10058, 9928, 9719, 9918, 10108, 10043, 9988, 10098, 9873, 10080, 9997, 10068, 9768, 9880, 9866, 9966, 9891, 10002, 10132, 9781, 10088, 9957, 9895, 9983, 10061, 10064, 10035, 10175, 10014, 10052, 10107, 10026, 10171, 9953, 9837, 10078, 10069, 9946, 9989, 10116, 9790, 9995, 10097, 10030, 9706, 9942, 10091, 9845, 9750, 9994, 9717, 9848, 10087, 10025, 10095, 10129, 10114, 10131, 10045, 10028, 10121, 10009, 10075, 10048, 10023, 9967, 10054, 9863, 9920, 9883, 9796, 9907, 10049, 10101, 10016, 10077, 9936, 10119, 9798, 9677, 9998, 10017, 9941, 9885, 10063, 10018, 9915, 10074, 10012, 10050, 10046, 10056, 10096, 10039, 9727, 10084, 10147, 10124, 10141, 9991, 9930, 10120, 9959, 9999, 10103, 10123, 9975, 9990, 9656, 10159, 10090, 10083, 10040, 10037, 10036, 9974, 10076)) AND (`Playercontest`.`contest_id` = 1415))

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

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)