Australian Open 1995 Women's Singles (January 16 - January 29)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Arantxa Sanchez-Vicario
				Arantxa Sanchez-Vicario
2.			Fang Li	6-2 6-0
					Arantxa Sanchez-Vicario
3.			Tami Whitlinger		6-1 6-2
				Tami Whitlinger
4.			Petra Begerow	6-2 6-4
						Arantxa Sanchez-Vicario
5.			Zina Garrison			6-1 6-3
				Zina Garrison
6.			Kerry-Anne Guse	3-6 6-2 6-3
					Zina Garrison
7.			Christina Singer		6-2 6-1
				Christina Singer
8.			Marketa Kochta	6-1 6-3
							Arantxa Sanchez-Vicario
9.			Meike Babel				7-5 6-0
				Meike Babel
10.			Mana Endo	6-4 6-2
					Meike Babel
11.			Chanda Rubin		6-4 4-6 9-7
				Chanda Rubin
12.			Kristine Radford	6-1 6-2
						Karina Habsudova
13.			Karina Habsudova			2-6 6-1 6-3
				Karina Habsudova
14.			Nathalie Baudone	6-4 6-2
					Karina Habsudova
15.			Natalia Medvedeva		6-3 6-1
				Natalia Medvedeva
16.		[9]	Magdalena Maleeva	4-6 7-5 6-3
								Arantxa Sanchez-Vicario
17.		[11]	Mary Joe Fernandez					6-1 6-3
				Mary Joe Fernandez
18.			Els Callens	7-5 6-4
					Mary Joe Fernandez
19.			Linda Harvey		7-6(5) 7-5
				Linda Harvey
20.			Pam Shriver	6-3 6-0
						Mary Joe Fernandez
21.			Amanda Coetzer			6-3 5-7 6-2
				Amanda Coetzer
22.			Angeles Montolio	6-2 6-2
					Amanda Coetzer
23.			Ruxandra Dragomir		6-4 4-6 6-3
				Ruxandra Dragomir
24.			Sandra Dopfer	7-5 4-6 6-4
							Naoko Sawamatsu
25.			Naoko Sawamatsu				6-4 7-6(5)
				Naoko Sawamatsu
26.			Ai Sugiyama	6-3 6-3
					Naoko Sawamatsu
27.			Laurence Courtois		6-0 6-4
				Laurence Courtois
28.		[Q]	Katerina Kroupova	7-6(2) 6-2
						Naoko Sawamatsu
29.			Patty Fendick			3-6 6-3 6-3
				Patty Fendick
30.			Ann Grossman	6-1 6-2
					Kimiko Date
31.		[7]	Kimiko Date		6-4 6-3
				Kimiko Date
32.			Elena Likhovtseva	6-2 6-2
									Arantxa Sanchez-Vicario
33.		[3]	Jana Novotna						6-4 6-1
				Jana Novotna
34.			Patricia Hy	6-2 3-6 6-0
					Jana Novotna
35.			Helena Sukova		3-6 6-3 6-2
				Helena Sukova
36.			Meredith McGrath	6-3 6-1
						Jana Novotna
37.			Lisa Raymond			6-1 3-6 9-7
				Lisa Raymond
38.		[Q]	Yuka Yoshida	6-4 6-2
					Lisa Raymond
39.		[WC]	Kristin Godridge		6-3 4-6 6-4
				Kristin Godridge
40.			Nana Miyagi	6-7(4) 6-2 6-1
							Angelica Gavaldon
41.			Angelica Gavaldon				7-5 6-0
				Angelica Gavaldon
42.		[LL]	Yvette Basting	6-2 6-0
					Angelica Gavaldon
43.			Joanette Kruger		6-3 6-1
				Joanette Kruger
44.			Mariaan De Swardt	4-6 6-3 6-4
						Angelica Gavaldon
45.			Silke Meier			2-6 6-3 8-6
				Silke Meier
46.		[WC]	Jane Taylor	7-6(13) 2-6 6-2
					Lori McNeil
47.		[15]	Lori McNeil		7-6(4) 6-1
				Lori McNeil
48.			Alexia Dechaume	6-3 6-3
								Marianne Werdel
49.		[Q]	Audra Keller					6-1 6-2
				Audra Keller
50.		[13]	Sabine Hack	7-5 1-6 6-0
					Barbara Paulus
51.			Barbara Paulus		6-3 6-3
				Barbara Paulus
52.			Emanuela Zardo	7-6(3) 6-0
						Barbara Paulus
53.			Sabine Appelmans			6-1 6-3
				Sabine Appelmans
54.			Laura Golarsa	6-2 6-4
					Sabine Appelmans
55.			Radka Bobkova		6-2 6-0
				Radka Bobkova
56.			Petra Ritter	7-5 6-3
							Marianne Werdel
57.			Elena Makarova				6-2 6-3
				Elena Makarova
58.			Tatiana Ignatieva	6-0 6-1
					Elena Makarova
59.			Radomira Zrubakova		6-0 6-2
				Radomira Zrubakova
60.			Nicole Arendt	6-4 6-1
						Marianne Werdel
61.			Sung-Hee Park			6-0 6-2
				Sung-Hee Park
62.			Leila Meskhi	0-6 7-6(4) 6-2
					Marianne Werdel
63.			Marianne Werdel		7-5 6-3
				Marianne Werdel
64.		[5]	Gabriela Sabatini	6-4 6-4
										Mary Pierce
65.		[8]	Natasha Zvereva							6-3 6-2
				Natasha Zvereva
66.			Alexandra Fusai	6-4 6-0
					Natasha Zvereva
67.			Silvia Farina		6-4 6-2
				Silvia Farina
68.			Gigi Fernandez	7-5 6-2
						Natasha Zvereva
69.			Judith Wiesner			4-6 7-6(3) 6-2
				Judith Wiesner
70.		[Q]	Rika Hiraki	6-1 6-7(6) 6-0
					Judith Wiesner
71.			Shaun Stafford		6-4 6-0
				Shaun Stafford
72.		[WC]	Anne Miller	6-3 6-4
							Natasha Zvereva
73.			Kyoko Nagatsuka				3-6 6-3 6-1
				Kyoko Nagatsuka
74.			Barbara Schett	6-0 6-4
					Kyoko Nagatsuka
75.			Martina Hingis		6-3 6-4
				Martina Hingis
76.			Jolene Watanabe	6-0 7-6(2)
						Kyoko Nagatsuka
77.			Sandra Cacic			6-3 6-3
				Sandra Cacic
78.			Asa Carlsson	6-2 6-2
					Amy Frazier
79.		[14]	Amy Frazier		6-3 5-7 6-4
				Amy Frazier
80.		[WC]	Annabel Ellwood	6-0 6-2
								Mary Pierce
81.		[10]	Anke Huber					6-1 6-4
				Anke Huber
82.			Ludmila Richterova	6-2 6-4
					Anke Huber
83.		[WC]	Siobhan Drake-Brockman		6-1 6-0
				Siobhan Drake-Brockman
84.		[Q]	Naoko Kijimuta	2-6 6-4 6-3
						Anke Huber
85.			Yayuk Basuki			6-0 6-1
				Yayuk Basuki
86.			Ginger Helgeson	3-6 6-1 6-4
					Yayuk Basuki
87.		[WC]	Nicole Provis		7-5 6-4
				Nicole Provis
88.			Katarina Studenikova	6-0 6-1
							Mary Pierce
89.		[Q]	Dally Randriantefy				6-2 6-4
				Dally Randriantefy
90.			Florencia Labat	6-3 7-6(5)
					Dally Randriantefy
91.			Patricia Tarabini		6-2 6-0
				Patricia Tarabini
92.		[WC]	Nicole Pratt	6-0 6-1
						Mary Pierce
93.			Elna Reinach			6-3 6-3
				Elna Reinach
94.			Rachel McQuillan	3-6 6-0 6-4
					Mary Pierce
95.		[4]	Mary Pierce		6-1 6-2
				Mary Pierce
96.			Tina Krizan	6-1 6-0
									Mary Pierce
97.		[6]	Lindsay Davenport						6-3 6-1
				Lindsay Davenport
98.			Debbie Graham	4-6 6-3 6-2
					Lindsay Davenport
99.			Wiltrud Probst		6-2 6-2
				Wiltrud Probst
100.		[Q]	Elly Hakami	6-3 6-2
						Lindsay Davenport
101.			Sandrine Testud			6-3 6-4
				Sandrine Testud
102.			Caroline Vis	6-4 6-0
					Sandrine Testud
103.			Miriam Oremans		6-4 7-6(3)
				Miriam Oremans
104.			Shi-Ting Wang	3-6 6-3 6-3
							Lindsay Davenport
105.			Anna Smashnova				6-2 3-6 6-2
				Anna Smashnova
106.			Elena Pampoulova	6-7(5) 6-3 6-3
					Anna Smashnova
107.			Sarah Pitkowski		7-5 7-5
				Sarah Pitkowski
108.		[Q]	Hiromi Nagano	6-3 6-3
						Brenda Schultz
109.			Bettina Fulco			6-2 6-2
				Bettina Fulco
110.			Noelle Van Lottum	6-1 6-3
					Brenda Schultz
111.		[12]	Brenda Schultz		6-1 6-4
				Brenda Schultz
112.			Karin Kschwendt	6-3 6-2
								Conchita Martinez
113.			Irina Spirlea					6-3 4-6 6-3
				Irina Spirlea
114.		[16]	Julie Halard	6-0 7-5
					Irina Spirlea
115.			Eugenia Maniokova		6-0 6-2
				Eugenia Maniokova
116.		[LL]	Mercedes Paz	7-5 2-6 6-4
						Irina Spirlea
117.			Yone Kamio			2-6 6-3 6-3
				Yone Kamio
118.			Katerina Maleeva	7-6(4) 6-1
					Yone Kamio
119.			Beate Reinstadler		4-6 6-4 6-3
				Beate Reinstadler
120.			Petra Langrova	6-1 7-6(3)
							Conchita Martinez
121.			Kristie Boogert				6-2 6-7(3) 6-2
				Kristie Boogert
122.			Linda Ferrando	6-0 4-6 6-0
					Kristie Boogert
123.			Manon Bollegraf		6-3 6-0
				Manon Bollegraf
124.			Stephanie Rottier	7-6(2) 7-5
						Conchita Martinez
125.			Veronika Martinek			6-3 2-6 6-3
				Veronika Martinek
126.			Larisa Savchenko	7-5 6-3
					Conchita Martinez
127.		[2]	Conchita Martinez		6-1 6-3
				Conchita Martinez
128.			Barbara Rittner	6-3 6-2

(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` = 'australian-open' LIMIT 1	1	1	4
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` = (1)	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` = (1)	1	1	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` = (1)	1	1	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` = 'australian-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` = (3) ORDER BY `Contest`.`year` ASC	98	98	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` = 1 AND `Contest`.`category_id` = 3 AND `Contest`.`slug` = '1995' 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` = (179) 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 (9957, 9987, 9942, 10046, 9706, 9869, 9790, 9971, 10005, 10014, 9985, 9868, 9946, 10021, 9926, 9959, 9909, 10068, 10009, 9656, 10018, 10069, 10063, 10030, 9966, 10070, 10037, 10071, 9857, 9907, 9930, 10064, 9848, 9796, 9677, 10047, 10039, 10072, 9929, 9920, 9941, 10073, 10023, 10074, 9900, 9874, 9727, 9873, 9922, 9975, 9918, 9944, 9936, 9896, 9989, 10007, 10040, 10066, 9837, 9983, 10075, 9914, 9798, 9883, 9945, 10026, 10049, 9719, 9781, 9988, 9916, 10076, 10035, 10077, 10078, 10058, 10061, 10101, 9845, 10080, 9915, 10081, 10082, 10052, 10032, 9972, 9768, 10054, 10083, 9994, 9963, 9937, 9780, 9819, 10024, 10043, 10025, 10002, 9804, 10042, 9990, 10051, 9953, 10028, 10062, 9928, 10084, 10085, 10010, 9970, 9863, 9890, 10050, 9829, 10013, 9962, 9998, 9756, 9921, 9880, 10048, 10057, 9784, 9961, 9881, 9750, 9885, 9967) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	4
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` = 179	129	129	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (21, 197, 72, 133, 87, 92, 53, 172, 94, 68, 14, 153, 13, 121, 168, 179, 36, 20, 169, 10, 42, 154, 31, 173, 194, 71, 100, 113, 104, 91, 178, 181)	32	32	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (21, 197, 72, 133, 87, 92, 53, 172, 94, 68, 14, 153, 13, 121, 168, 179, 36, 20, 169, 10, 42, 154, 31, 173, 194, 71, 100, 113, 104, 91, 178, 181)	32	32	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9957, 9987, 9942, 10046, 9706, 9869, 9790, 9971, 10005, 10014, 9985, 9868, 9946, 10021, 9926, 9959, 9909, 10068, 10009, 9656, 10018, 10069, 10063, 10030, 9966, 10070, 10037, 10071, 9857, 9907, 9930, 10064, 9848, 9796, 9677, 10047, 10039, 10072, 9929, 9920, 9941, 10073, 10023, 10074, 9900, 9874, 9727, 9873, 9922, 9975, 9918, 9944, 9936, 9896, 9989, 10007, 10040, 10066, 9837, 9983, 10075, 9914, 9798, 9883, 9945, 10026, 10049, 9719, 9781, 9988, 9916, 10076, 10035, 10077, 10078, 10058, 10061, 10101, 9845, 10080, 9915, 10081, 10082, 10052, 10032, 9972, 9768, 10054, 10083, 9994, 9963, 9937, 9780, 9819, 10024, 10043, 10025, 10002, 9804, 10042, 9990, 10051, 9953, 10028, 10062, 9928, 10084, 10085, 10010, 9970, 9863, 9890, 10050, 9829, 10013, 9962, 9998, 9756, 9921, 9880, 10048, 10057, 9784, 9961, 9881, 9750, 9885, 9967)) AND (`Playercontest`.`contest_id` = 179))	128	128	2
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 3 ORDER BY `Contest`.`date_from` ASC	98	98	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1995	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` = 'australian-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` = (1)

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

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

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` = 1 AND `Contest`.`category_id` = 3 AND `Contest`.`slug` = '1995' 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` = (179) 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 (9957, 9987, 9942, 10046, 9706, 9869, 9790, 9971, 10005, 10014, 9985, 9868, 9946, 10021, 9926, 9959, 9909, 10068, 10009, 9656, 10018, 10069, 10063, 10030, 9966, 10070, 10037, 10071, 9857, 9907, 9930, 10064, 9848, 9796, 9677, 10047, 10039, 10072, 9929, 9920, 9941, 10073, 10023, 10074, 9900, 9874, 9727, 9873, 9922, 9975, 9918, 9944, 9936, 9896, 9989, 10007, 10040, 10066, 9837, 9983, 10075, 9914, 9798, 9883, 9945, 10026, 10049, 9719, 9781, 9988, 9916, 10076, 10035, 10077, 10078, 10058, 10061, 10101, 9845, 10080, 9915, 10081, 10082, 10052, 10032, 9972, 9768, 10054, 10083, 9994, 9963, 9937, 9780, 9819, 10024, 10043, 10025, 10002, 9804, 10042, 9990, 10051, 9953, 10028, 10062, 9928, 10084, 10085, 10010, 9970, 9863, 9890, 10050, 9829, 10013, 9962, 9998, 9756, 9921, 9880, 10048, 10057, 9784, 9961, 9881, 9750, 9885, 9967) 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` = 179

129

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9957, 9987, 9942, 10046, 9706, 9869, 9790, 9971, 10005, 10014, 9985, 9868, 9946, 10021, 9926, 9959, 9909, 10068, 10009, 9656, 10018, 10069, 10063, 10030, 9966, 10070, 10037, 10071, 9857, 9907, 9930, 10064, 9848, 9796, 9677, 10047, 10039, 10072, 9929, 9920, 9941, 10073, 10023, 10074, 9900, 9874, 9727, 9873, 9922, 9975, 9918, 9944, 9936, 9896, 9989, 10007, 10040, 10066, 9837, 9983, 10075, 9914, 9798, 9883, 9945, 10026, 10049, 9719, 9781, 9988, 9916, 10076, 10035, 10077, 10078, 10058, 10061, 10101, 9845, 10080, 9915, 10081, 10082, 10052, 10032, 9972, 9768, 10054, 10083, 9994, 9963, 9937, 9780, 9819, 10024, 10043, 10025, 10002, 9804, 10042, 9990, 10051, 9953, 10028, 10062, 9928, 10084, 10085, 10010, 9970, 9863, 9890, 10050, 9829, 10013, 9962, 9998, 9756, 9921, 9880, 10048, 10057, 9784, 9961, 9881, 9750, 9885, 9967)) AND (`Playercontest`.`contest_id` = 179))

128

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

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

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)