Wimbledon 1995 Ladies' Singles (June 26 - July 8)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Steffi Graf
				Steffi Graf
2.			Martina Hingis	6-3 6-1
					Steffi Graf
3.			Amanda Coetzer		6-3 7-5
				Amanda Coetzer
4.			Petra Ritter	4-6 6-2 6-3
						Steffi Graf
5.			Kristie Boogert			6-1 6-0
				Kristie Boogert
6.			Virginia Ruano-Pascual	6-4 6-3
					Kristie Boogert
7.			Elena Makarova		6-0 6-2
				Elena Makarova
8.			Marianne Werdel	6-3 1-6 8-6
							Steffi Graf
9.		[Q]	Rennae Stubbs				6-0 6-1
				Rennae Stubbs
10.			Tatiana Ignatieva	5-7 6-1 6-1
					Ines Gorrochategui
11.			Ines Gorrochategui		6-3 6-2
				Ines Gorrochategui
12.			Wiltrud Probst	6-1 6-3
						Ines Gorrochategui
13.		[Q]	Lindsay Lee			2-6 6-4 6-4
				Lindsay Lee
14.			Pam Shriver	3-6 6-1 6-4
					Natasha Zvereva
15.		[10]	Natasha Zvereva		6-7(5) 6-1 6-4
				Natasha Zvereva
16.		[WC]	Megan Miller	6-2 6-3
								Steffi Graf
17.		[13]	Mary Joe Fernandez					6-3 6-0
				Mary Joe Fernandez
18.			Karina Habsudova	5-7 6-3 6-3
					Mary Joe Fernandez
19.			Sung-Hee Park		6-4 6-0
				Sung-Hee Park
20.			Alexandra Fusai	6-1 6-4
						Mary Joe Fernandez
21.		[Q]	Melanie Schnell			6-1 6-2
				Melanie Schnell
22.			Katerina Maleeva	6-0 7-5
					Miriam Oremans
23.			Miriam Oremans		6-3 6-4
				Miriam Oremans
24.			Ruxandra Dragomir	4-6 6-4 6-4
							Mary Joe Fernandez
25.			Barbara Paulus				7-6(6) 6-1
				Barbara Paulus
26.			Kristine Radford	6-4 4-6 7-5
					Christina Singer
27.			Christina Singer		6-2 6-4
				Christina Singer
28.		[WC]	Elizabeth Jelfs	6-4 6-3
						Lindsay Davenport
29.			Florencia Labat			6-7(8) 6-3 6-2
				Florencia Labat
30.		[WC]	Shirli-Ann Siddall	6-2 6-3
					Lindsay Davenport
31.		[7]	Lindsay Davenport		6-1 6-1
				Lindsay Davenport
32.			Gigi Fernandez	6-2 4-6 7-5
									Steffi Graf
33.		[4]	Jana Novotna						5-7 6-4 6-2
				Jana Novotna
34.			Karin Kschwendt	6-4 6-4
					Jana Novotna
35.		[WC]	Jo Durie		6-2 6-2
				Jo Durie
36.			Alexia Dechaume	6-2 7-6(2)
						Jana Novotna
37.			Judith Wiesner			7-5 6-4
				Judith Wiesner
38.		[Q]	Claudia Porwik	6-4 6-3
					Judith Wiesner
39.			Sandrine Testud		6-4 3-6 6-0
				Sandrine Testud
40.			Nana Miyagi	7-5 6-3
							Jana Novotna
41.			Nicole Provis				6-0 5-7 6-4
				Nicole Provis
42.			Elena Pampoulova	6-2 6-4
					Nicole Provis
43.			Jana Nejedly		6-3 6-3
				Jana Nejedly
44.			Julie Halard	7-5 4-6 6-4
						Nicole Provis
45.		[WC]	Rosalyn Fairbank			6-2 6-1
				Rosalyn Fairbank
46.			Petra Begerow	7-6(5) 1-0 rtd.
					Angelica Gavaldon
47.			Angelica Gavaldon		6-1 6-2
				Angelica Gavaldon
48.		[11]	Iva Majoli	1-6 6-3 6-1
								Jana Novotna
49.		[16]	Helena Sukova					6-2 6-3
				Helena Sukova
50.			Sandra Cecchini	6-3 7-6(5)
					Yone Kamio
51.			Yone Kamio		4-6 6-4 6-4
				Yone Kamio
52.			Jolene Watanabe	6-4 6-2
						Mariaan De Swardt
53.			Mariaan De Swardt			6-4 6-4
				Mariaan De Swardt
54.			Laura Golarsa	6-3 6-3
					Mariaan De Swardt
55.			Isabelle Demongeot		6-4 6-3
				Isabelle Demongeot
56.		[WC]	Clare Wood	6-2 6-3
							Kimiko Date
57.			Ann Grossman				6-1 2-6 6-2
				Ann Grossman
58.			Audra Keller	3-6 6-2 6-4
					Tami Whitlinger
59.			Tami Whitlinger		6-1 6-4
				Tami Whitlinger
60.			Kimberly Po	7-6(5) 6-0
						Kimiko Date
61.			Meike Babel			1-6 6-3 6-3
				Meike Babel
62.			Flora Perfetti	2-6 6-2 6-4
					Kimiko Date
63.		[6]	Kimiko Date		7-5 7-6(4)
				Kimiko Date
64.			Sabine Appelmans	6-4 6-2
										Steffi Graf
65.		[8]	Gabriela Sabatini							4-6 6-1 7-5
				Gabriela Sabatini
66.			Lea Ghirardi	6-3 6-4
					Gabriela Sabatini
67.			Silvia Farina		6-2 6-2
				Silvia Farina
68.			Elena Likhovtseva	6-3 6-1
						Gabriela Sabatini
69.			Dominique Monami			7-5 6-1
				Dominique Monami
70.			Patty Fendick	6-2 6-3
					Nancy Feber
71.			Nancy Feber		7-5 6-0
				Nancy Feber
72.			Nicole Arendt	6-3 6-1
							Gabriela Sabatini
73.			Lisa Raymond				6-0 3-6 7-5
				Lisa Raymond
74.		[WC]	Julie Pullin	6-0 7-6(5)
					Lisa Raymond
75.			Rachel McQuillan		6-4 6-2
				Rachel McQuillan
76.			Linda Harvey	6-1 6-2
						Lisa Raymond
77.			Irina Spirlea			6-4 2-6 6-4
				Irina Spirlea
78.			Joanette Kruger	6-2 3-6 6-4
					Irina Spirlea
79.		[12]	Amy Frazier		6-1 6-3
				Amy Frazier
80.			Stephanie Rottier	6-4 7-5
								Conchita Martinez
81.		[14]	Naoko Sawamatsu					7-5 7-6(5)
				Naoko Sawamatsu
82.			Lori McNeil	4-6 6-0 6-3
					Naoko Sawamatsu
83.			Maria Strandlund		3-6 6-4 6-0
				Maria Strandlund
84.			Silke Meier	7-5 6-0
						Petra Kamstra
85.			Sandra Cacic			6-1 7-6(5)
				Sandra Cacic
86.		[Q]	Katrina Adams	6-4 6-2
					Petra Kamstra
87.		[Q]	Petra Kamstra		7-5 7-6(7)
				Petra Kamstra
88.			Sarah Pitkowski	6-1 6-2
							Conchita Martinez
89.			Andrea Temesvari				6-2 6-3
				Andrea Temesvari
90.		[Q]	Gloria Pizzichini	7-6(5) 6-4
					Shaun Stafford
91.			Shaun Stafford		7-5 6-2
				Shaun Stafford
92.			Veronika Martinek	6-4 6-1
						Conchita Martinez
93.			Jana Kandarr			6-1 6-1
				Jana Kandarr
94.		[WC]	Karen Cross	6-3 6-1
					Conchita Martinez
95.		[3]	Conchita Martinez		6-4 6-3
				Conchita Martinez
96.			Asa Carlsson	6-1 6-1
									Arantxa Sanchez-Vicario
97.		[5]	Mary Pierce						6-3 6-7 6-1
				Mary Pierce
98.			Sandra Dopfer	6-1 6-2
					Nathalie Tauziat
99.			Nathalie Tauziat		6-4 3-6 6-1
				Nathalie Tauziat
100.		[LL]	Maria Vento-Kabchi	6-1 4-6 7-5
						Yayuk Basuki
101.			Yayuk Basuki			6-7(4) 6-3 6-4
				Yayuk Basuki
102.			Natalia Medvedeva	6-2 6-7(4) 6-2
					Yayuk Basuki
103.			Kyoko Nagatsuka		7-5 6-0
				Kyoko Nagatsuka
104.			Debbie Graham	6-3 4-6 6-1
							Brenda Schultz
105.			Radomira Zrubakova				6-3 6-1
				Radomira Zrubakova
106.			Anna Smashnova	6-3 7-6(4)
					Radomira Zrubakova
107.			Laurence Courtois		6-3 6-2
				Laurence Courtois
108.			Meredith McGrath	4-6 6-0 6-2
						Brenda Schultz
109.			Larisa Savchenko			6-4 7-5
				Larisa Savchenko
110.			Neus Avila	6-0 6-1
					Brenda Schultz
111.		[15]	Brenda Schultz		6-2 6-4
				Brenda Schultz
112.			Radka Bobkova	6-7(4) 7-6(3) 6-1
								Arantxa Sanchez-Vicario
113.		[9]	Anke Huber					6-4 7-6(4)
				Anke Huber
114.			Tina Krizan	6-7(5) 6-1 6-1
					Anke Huber
115.			Beate Reinstadler		6-2 7-6(5)
				Beate Reinstadler
116.			Ai Sugiyama	3-6 6-4 6-3
						Anke Huber
117.			Patricia Hy			6-2 6-4
				Patricia Hy
118.			Silke Frankl	6-3 6-0
					Chanda Rubin
119.			Chanda Rubin		7-6(4) 6-7(5) 17-15
				Chanda Rubin
120.			Ludmila Richterova	6-1 6-3
							Arantxa Sanchez-Vicario
121.			Zina Garrison				7-5 6-4
				Zina Garrison
122.		[Q]	Amanda Wainwright	6-3 6-3
					Zina Garrison
123.			Elna Reinach		6-4 6-2
				Elna Reinach
124.			Marketa Kochta	6-1 3-6 6-0
						Arantxa Sanchez-Vicario
125.			Mana Endo			6-1 6-2
				Mana Endo
126.			Nathalie Baudone	6-3 7-6(5)
					Arantxa Sanchez-Vicario
127.		[2]	Arantxa Sanchez-Vicario		7-5 6-2
				Arantxa Sanchez-Vicario
128.			Katarina Studenikova	6-2 6-1

(default) 17 queries took 25 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	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` = (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` = '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` = (1806) 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, 10078, 10018, 10007, 10048, 10055, 10040, 9798, 9891, 10066, 9999, 9804, 10097, 9656, 9945, 12536, 9909, 9946, 10075, 10026, 10096, 9756, 9953, 10063, 9918, 9868, 9790, 12537, 9994, 12490, 10025, 9719, 9848, 9890, 9692, 9873, 9781, 9779, 9990, 9920, 9768, 9928, 10092, 9829, 9658, 10046, 9941, 10088, 9677, 10091, 9998, 10058, 10074, 9896, 9938, 9851, 9907, 9922, 9942, 9991, 10005, 10036, 9930, 9936, 9883, 10089, 10049, 10064, 10012, 9857, 10093, 9983, 10039, 10191, 9819, 10009, 10050, 10023, 9845, 9961, 9966, 9727, 9894, 9900, 10061, 9866, 9964, 10084, 9741, 10016, 9916, 9881, 10106, 12496, 9885, 10101, 10024, 10030, 10017, 10105, 10032, 9926, 10035, 10002, 9837, 10062, 10037, 10047, 9750, 11385, 9863, 9989, 9915, 10043, 9921, 10070, 9796, 10001, 9985, 10081, 9706, 12495, 9780, 9971, 10014, 10021, 9957, 10054) 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` = 1806	129	129	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 21, 173, 72, 87, 92, 53, 133, 178, 172, 196, 94, 68, 14, 153, 121, 10, 168, 179, 36, 20, 169, 154, 50, 31, 13, 194, 100, 104, 91, 84, 201)	32	32	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 21, 173, 72, 87, 92, 53, 133, 178, 172, 196, 94, 68, 14, 153, 121, 10, 168, 179, 36, 20, 169, 154, 50, 31, 13, 194, 100, 104, 91, 84, 201)	32	32	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9715, 10078, 10018, 10007, 10048, 10055, 10040, 9798, 9891, 10066, 9999, 9804, 10097, 9656, 9945, 12536, 9909, 9946, 10075, 10026, 10096, 9756, 9953, 10063, 9918, 9868, 9790, 12537, 9994, 12490, 10025, 9719, 9848, 9890, 9692, 9873, 9781, 9779, 9990, 9920, 9768, 9928, 10092, 9829, 9658, 10046, 9941, 10088, 9677, 10091, 9998, 10058, 10074, 9896, 9938, 9851, 9907, 9922, 9942, 9991, 10005, 10036, 9930, 9936, 9883, 10089, 10049, 10064, 10012, 9857, 10093, 9983, 10039, 10191, 9819, 10009, 10050, 10023, 9845, 9961, 9966, 9727, 9894, 9900, 10061, 9866, 9964, 10084, 9741, 10016, 9916, 9881, 10106, 12496, 9885, 10101, 10024, 10030, 10017, 10105, 10032, 9926, 10035, 10002, 9837, 10062, 10037, 10047, 9750, 11385, 9863, 9989, 9915, 10043, 9921, 10070, 9796, 10001, 9985, 10081, 9706, 12495, 9780, 9971, 10014, 10021, 9957, 10054)) AND (`Playercontest`.`contest_id` = 1806))	128	128	2
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` = 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 25 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` = '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` = (1806) 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, 10078, 10018, 10007, 10048, 10055, 10040, 9798, 9891, 10066, 9999, 9804, 10097, 9656, 9945, 12536, 9909, 9946, 10075, 10026, 10096, 9756, 9953, 10063, 9918, 9868, 9790, 12537, 9994, 12490, 10025, 9719, 9848, 9890, 9692, 9873, 9781, 9779, 9990, 9920, 9768, 9928, 10092, 9829, 9658, 10046, 9941, 10088, 9677, 10091, 9998, 10058, 10074, 9896, 9938, 9851, 9907, 9922, 9942, 9991, 10005, 10036, 9930, 9936, 9883, 10089, 10049, 10064, 10012, 9857, 10093, 9983, 10039, 10191, 9819, 10009, 10050, 10023, 9845, 9961, 9966, 9727, 9894, 9900, 10061, 9866, 9964, 10084, 9741, 10016, 9916, 9881, 10106, 12496, 9885, 10101, 10024, 10030, 10017, 10105, 10032, 9926, 10035, 10002, 9837, 10062, 10037, 10047, 9750, 11385, 9863, 9989, 9915, 10043, 9921, 10070, 9796, 10001, 9985, 10081, 9706, 12495, 9780, 9971, 10014, 10021, 9957, 10054) 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` = 1806

129

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9715, 10078, 10018, 10007, 10048, 10055, 10040, 9798, 9891, 10066, 9999, 9804, 10097, 9656, 9945, 12536, 9909, 9946, 10075, 10026, 10096, 9756, 9953, 10063, 9918, 9868, 9790, 12537, 9994, 12490, 10025, 9719, 9848, 9890, 9692, 9873, 9781, 9779, 9990, 9920, 9768, 9928, 10092, 9829, 9658, 10046, 9941, 10088, 9677, 10091, 9998, 10058, 10074, 9896, 9938, 9851, 9907, 9922, 9942, 9991, 10005, 10036, 9930, 9936, 9883, 10089, 10049, 10064, 10012, 9857, 10093, 9983, 10039, 10191, 9819, 10009, 10050, 10023, 9845, 9961, 9966, 9727, 9894, 9900, 10061, 9866, 9964, 10084, 9741, 10016, 9916, 9881, 10106, 12496, 9885, 10101, 10024, 10030, 10017, 10105, 10032, 9926, 10035, 10002, 9837, 10062, 10037, 10047, 9750, 11385, 9863, 9989, 9915, 10043, 9921, 10070, 9796, 10001, 9985, 10081, 9706, 12495, 9780, 9971, 10014, 10021, 9957, 10054)) AND (`Playercontest`.`contest_id` = 1806))

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