Australian Open 1997 Women's Singles (January 13 - January 26)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Steffi Graf
				Steffi Graf
2.			Janette Husarova	5-1 rtd.
					Steffi Graf
3.			Larisa Savchenko		7-5 6-2
				Larisa Savchenko
4.		[WC]	Evie Dominikovic	6-2 6-7(2) 6-0
						Steffi Graf
5.			Ines Gorrochategui			7-5 6-3
				Ines Gorrochategui
6.		[WC]	Bryanne Stewart	6-2 6-1
					Ines Gorrochategui
7.			Gigi Fernandez		7-5 7-6(3)
				Gigi Fernandez
8.			Els Callens	6-4 6-3
							Amanda Coetzer
9.			Lindsay Lee				6-2 7-5
				Lindsay Lee
10.			Barbara Mulej	2-6 6-3 6-2
					Magui Serna
11.		[Q]	Magui Serna		7-5 7-6(2)
				Magui Serna
12.		[Q]	Miho Saeki	6-3 6-7(6) 7-5
						Amanda Coetzer
13.			Jana Kandarr			6-3 6-2
				Jana Kandarr
14.			Kyoko Nagatsuka	6-3 3-6 6-3
					Amanda Coetzer
15.		[12]	Amanda Coetzer		6-2 7-6(4)
				Amanda Coetzer
16.			Anna Kournikova	6-2 6-2
								Amanda Coetzer
17.		[10]	Brenda Schultz					6-4 6-1
				Brenda Schultz
18.			Sung-Hee Park	6-2 2-6 6-2
					Rika Hiraki
19.			Rika Hiraki		0-6 6-1 6-4
				Rika Hiraki
20.			Ludmila Richterova	6-4 2-6 6-4
						Kimberly Po
21.			Kimberly Po			6-2 6-2
				Kimberly Po
22.			Gala Leon Garcia	4-6 7-6(4) 6-2
					Kimberly Po
23.			Ai Sugiyama		6-0 4-6 6-3
				Ai Sugiyama
24.			Catalina Cristea	7-6(3) 6-4
							Kimberly Po
25.		[WC]	Jane Taylor				7-6(13) 6-4
				Jane Taylor
26.			Maria Sanchez Lorenzo	7-5 4-6 7-5
					Tamarine Tanasugarn
27.			Tamarine Tanasugarn		6-4 6-3
				Tamarine Tanasugarn
28.			Elena Makarova	6-3 1-6 6-4
						Lindsay Davenport
29.			Flora Perfetti			6-1 6-0
				Flora Perfetti
30.			Katarina Studenikova	6-4 7-6(1)
					Lindsay Davenport
31.		[7]	Lindsay Davenport		6-1 6-0
				Lindsay Davenport
32.			Nathalie Dechy	4-6 6-1 6-1
									Mary Pierce
33.		[3]	Conchita Martinez						7-5 6-1
				Conchita Martinez
34.			Miriam Oremans	6-0 6-2
					Conchita Martinez
35.			Adriana Gersi		6-2 7-6(6)
				Adriana Gersi
36.			Sandra Dopfer	7-6(7) 6-2
						Conchita Martinez
37.			Asa Carlsson			6-0 6-1
				Asa Carlsson
38.			Petra Langrova	6-3 6-2
					Asa Carlsson
39.			Patricia Hy		2-6 6-3 6-0
				Patricia Hy
40.			Alexia Dechaume	6-0 2-6 6-4
							Sabine Appelmans
41.			Kristie Boogert				2-6 7-5 6-1
				Kristie Boogert
42.			Nicole Arendt	3-6 6-3 6-4
					Kristie Boogert
43.			Rita Grande		6-3 7-5
				Rita Grande
44.			Angeles Montolio	6-2 6-4
						Sabine Appelmans
45.			Ann Grossman			6-1 6-3
				Ann Grossman
46.			Anne Miller	7-5 6-2
					Sabine Appelmans
47.		[16]	Sabine Appelmans		6-4 6-1
				Sabine Appelmans
48.			Helena Sukova	6-4 6-1
								Mary Pierce
49.			Mary Pierce					1-6 6-4 6-4
				Mary Pierce
50.		[13]	Elena Likhovtseva	3-6 6-2 6-4
					Mary Pierce
51.			Natalia Medvedeva		6-2 6-2
				Natalia Medvedeva
52.		[WC]	Li-Ling Chen	6-2 3-6 6-3
						Mary Pierce
53.		[Q]	Marketa Kochta			6-0 6-2
				Marketa Kochta
54.			Marianne Werdel	4-6 7-6(4) 6-0
					Marketa Kochta
55.		[WC]	Annabel Ellwood		6-0 4-6 6-1
				Annabel Ellwood
56.			Lori McNeil	6-3 6-2
							Mary Pierce
57.			Natasha Zvereva				6-2 6-3
				Natasha Zvereva
58.			Nancy Feber	7-6(9) 6-1
					Natasha Zvereva
59.			Wiltrud Probst		7-6(5) 6-3
				Wiltrud Probst
60.			Sandra Cacic	6-4 2-6 7-5
						Anke Huber
61.			Francesca Lubiani			7-5 6-0
				Francesca Lubiani
62.		[WC]	Rachel McQuillan	6-2 7-6(4)
					Anke Huber
63.		[5]	Anke Huber		4-6 6-2 6-0
				Anke Huber
64.			Amy Frazier	0-6 6-2 7-5
										Martina Hingis
65.		[8]	Irina Spirlea							6-2 6-2
				Irina Spirlea
66.			Naoko Kijimuta	6-2 6-4
					Irina Spirlea
67.			Joanette Kruger		6-1 6-1
				Joanette Kruger
68.			Dally Randriantefy	6-3 2-6 6-2
						Irina Spirlea
69.			Paola Suarez			6-1 6-3
				Paola Suarez
70.			Karin Kschwendt	7-6(9) 6-3
					Silvia Farina
71.			Silvia Farina		6-4 6-1
				Silvia Farina
72.			Aleksandra Olsza	6-3 6-2
							Irina Spirlea
73.			Jolene Watanabe				6-4 6-4
				Jolene Watanabe
74.			Jennifer Capriati	6-2 3-6 6-4
					Shi-Ting Wang
75.			Shi-Ting Wang		7-5 6-3
				Shi-Ting Wang
76.			Linda Harvey	6-3 6-1
						Karina Habsudova
77.			Nicole Provis			6-3 7-6(5)
				Nicole Provis
78.			Corina Morariu	6-3 6-2
					Karina Habsudova
79.		[9]	Karina Habsudova		6-3 6-3
				Karina Habsudova
80.			Silvija Talaja	6-1 6-2
								Martina Hingis
81.			Ruxandra Dragomir					7-5 6-2
				Ruxandra Dragomir
82.		[11]	Judith Wiesner	4-6 6-3 10-8
					Ruxandra Dragomir
83.			Virginia Ruano-Pascual		7-6(3) 6-1
				Virginia Ruano-Pascual
84.			Cristina Torrens-Valero	6-0 3-6 6-3
						Ruxandra Dragomir
85.		[LL]	Noelle Van Lottum			6-1 6-1
				Noelle Van Lottum
86.			Sabine Hack	4-6 6-3 6-2
					Kristina Brandi
87.		[Q]	Kristina Brandi		6-0 1-6 6-4
				Kristina Brandi
88.			Petra Begerow	6-1 6-1
							Martina Hingis
89.			Alexandra Fusai				7-6(6) 6-1
				Alexandra Fusai
90.			Ginger Helgeson	6-2 6-2
					Barbara Schett
91.			Barbara Schett		2-6 7-5 7-5
				Barbara Schett
92.			Nana Miyagi	7-6(8)7-6(6)
						Martina Hingis
93.			Lisa Raymond			6-2 6-1
				Lisa Raymond
94.		[WC]	Siobhan Drake-Brockman	6-2 6-2
					Martina Hingis
95.		[4]	Martina Hingis		6-4 6-2
				Martina Hingis
96.			Barbara Rittner	6-1 7-5
									Martina Hingis
97.			Patty Schnyder						6-1 6-3
				Patty Schnyder
98.		[6]	Iva Majoli	7-5 6-1
					Patty Schnyder
99.			Mana Endo		6-0 6-4
				Mana Endo
100.		[WC]	Kristine Radford	7-5 6-1
						Patty Schnyder
101.		[Q]	Meilen Tu			7-6(4) 6-1
				Meilen Tu
102.			Lenka Cenkova	3-6 6-2 6-3
					Magdalena Grzybowska
103.		[Q]	Magdalena Grzybowska		6-4 6-7(3) 6-1
				Magdalena Grzybowska
104.			Sarah Pitkowski	4-6 6-3 6-1
							Mary Joe Fernandez
105.			Florencia Labat				4-6 6-4 6-1
				Florencia Labat
106.			Anne Kremer	7-5 4-6 6-2
					Henrieta Nagyova
107.			Henrieta Nagyova		6-3 6-2
				Henrieta Nagyova
108.			Emmanuelle Gagliardi	6-3 7-6(3)
						Mary Joe Fernandez
109.			Yayuk Basuki			6-2 6-1
				Yayuk Basuki
110.			Naoko Sawamatsu	6-3 4-1 rtd.
					Mary Joe Fernandez
111.		[14]	Mary Joe Fernandez		7-5 6-4
				Mary Joe Fernandez
112.		[Q]	Laura Golarsa	6-2 4-6 6-2
								Mary Joe Fernandez
113.		[15]	Chanda Rubin					7-5 4-0 rtd.
				Chanda Rubin
114.			Radomira Zrubakova	7-6(2) 6-3
					Chanda Rubin
115.			Sandrine Testud		6-2 6-1
				Sandrine Testud
116.			Elena Pampoulova	6-3 6-1
						Chanda Rubin
117.		[LL]	Sandra Kleinova			6-1 6-4
				Sandra Kleinova
118.			Tami Whitlinger	7-6(12) 6-1
					Sandra Kleinova
119.			Anne-Gaelle Sidot		6-4 4-6 8-6
				Anne-Gaelle Sidot
120.			Tatjana Jecmenica	5-7 7-5 6-4
							Dominique Monami
121.		[Q]	Yuka Yoshida				7-5 6-4
				Yuka Yoshida
122.			Katrina Adams	7-5 6-3
					Dominique Monami
123.			Dominique Monami		4-6 7-5 6-3
				Dominique Monami
124.			Bettina Fulco	6-0 6-3
						Dominique Monami
125.			Stephanie De Ville			1-6 6-4 8-6
				Stephanie De Ville
126.			Denisa Chladkova	6-3 6-7(2) 8-6
					Arantxa Sanchez-Vicario
127.		[2]	Arantxa Sanchez-Vicario		1-0 rtd.
				Arantxa Sanchez-Vicario
128.			Gloria Pizzichini	6-4 6-4

(default) 17 queries took 18 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	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` = (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	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` = 1 AND `Contest`.`category_id` = 3 AND `Contest`.`slug` = '1997' 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` = (181) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	127	127	1
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (9715, 10045, 9750, 10109, 9999, 10110, 9719, 10068, 10097, 10006, 10111, 10112, 10106, 10035, 10018, 10113, 9863, 10075, 9988, 10081, 9991, 10114, 10070, 10059, 9874, 10090, 10115, 10040, 10036, 10054, 10025, 10116, 9885, 9953, 10117, 10030, 10101, 9880, 9796, 9873, 10048, 9983, 10098, 10069, 9907, 10076, 9936, 9677, 10024, 10064, 9926, 10118, 9971, 9798, 10080, 9727, 9945, 10093, 9804, 10061, 10087, 9819, 9915, 9845, 10050, 10052, 10023, 10083, 10119, 9890, 10049, 10120, 10058, 9997, 10028, 10009, 9768, 10121, 9946, 10122, 10063, 9781, 10055, 10123, 9970, 9975, 10124, 10046, 10026, 9972, 10077, 9920, 10039, 10082, 10078, 9967, 10356, 10088, 10014, 9868, 10126, 10127, 10103, 10084, 9994, 10128, 10129, 10130, 10032, 9966, 9909, 9896, 9985, 9837, 9990, 9928, 10100, 9942, 10131, 10107, 10072, 9866, 10012, 10010, 10132, 10133, 9957, 10016) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	1
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` = 181	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 21, 87, 72, 133, 151, 178, 53, 42, 172, 153, 68, 13, 14, 94, 92, 179, 173, 10, 149, 168, 36, 219, 154, 111, 50, 194, 169, 100, 113, 104, 184, 181, 20)	34	34	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 21, 87, 72, 133, 151, 178, 53, 42, 172, 153, 68, 13, 14, 94, 92, 179, 173, 10, 149, 168, 36, 219, 154, 111, 50, 194, 169, 100, 113, 104, 184, 181, 20)	34	34	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9715, 10045, 9750, 10109, 9999, 10110, 9719, 10068, 10097, 10006, 10111, 10112, 10106, 10035, 10018, 10113, 9863, 10075, 9988, 10081, 9991, 10114, 10070, 10059, 9874, 10090, 10115, 10040, 10036, 10054, 10025, 10116, 9885, 9953, 10117, 10030, 10101, 9880, 9796, 9873, 10048, 9983, 10098, 10069, 9907, 10076, 9936, 9677, 10024, 10064, 9926, 10118, 9971, 9798, 10080, 9727, 9945, 10093, 9804, 10061, 10087, 9819, 9915, 9845, 10050, 10052, 10023, 10083, 10119, 9890, 10049, 10120, 10058, 9997, 10028, 10009, 9768, 10121, 9946, 10122, 10063, 9781, 10055, 10123, 9970, 9975, 10124, 10046, 10026, 9972, 10077, 9920, 10039, 10082, 10078, 9967, 10356, 10088, 10014, 9868, 10126, 10127, 10103, 10084, 9994, 10128, 10129, 10130, 10032, 9966, 9909, 9896, 9985, 9837, 9990, 9928, 10100, 9942, 10131, 10107, 10072, 9866, 10012, 10010, 10132, 10133, 9957, 10016)) AND (`Playercontest`.`contest_id` = 181))	128	128	1
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` = 1997	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 18 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` = '1997' 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` = (181) 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, 10045, 9750, 10109, 9999, 10110, 9719, 10068, 10097, 10006, 10111, 10112, 10106, 10035, 10018, 10113, 9863, 10075, 9988, 10081, 9991, 10114, 10070, 10059, 9874, 10090, 10115, 10040, 10036, 10054, 10025, 10116, 9885, 9953, 10117, 10030, 10101, 9880, 9796, 9873, 10048, 9983, 10098, 10069, 9907, 10076, 9936, 9677, 10024, 10064, 9926, 10118, 9971, 9798, 10080, 9727, 9945, 10093, 9804, 10061, 10087, 9819, 9915, 9845, 10050, 10052, 10023, 10083, 10119, 9890, 10049, 10120, 10058, 9997, 10028, 10009, 9768, 10121, 9946, 10122, 10063, 9781, 10055, 10123, 9970, 9975, 10124, 10046, 10026, 9972, 10077, 9920, 10039, 10082, 10078, 9967, 10356, 10088, 10014, 9868, 10126, 10127, 10103, 10084, 9994, 10128, 10129, 10130, 10032, 9966, 9909, 9896, 9985, 9837, 9990, 9928, 10100, 9942, 10131, 10107, 10072, 9866, 10012, 10010, 10132, 10133, 9957, 10016) 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` = 181

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9715, 10045, 9750, 10109, 9999, 10110, 9719, 10068, 10097, 10006, 10111, 10112, 10106, 10035, 10018, 10113, 9863, 10075, 9988, 10081, 9991, 10114, 10070, 10059, 9874, 10090, 10115, 10040, 10036, 10054, 10025, 10116, 9885, 9953, 10117, 10030, 10101, 9880, 9796, 9873, 10048, 9983, 10098, 10069, 9907, 10076, 9936, 9677, 10024, 10064, 9926, 10118, 9971, 9798, 10080, 9727, 9945, 10093, 9804, 10061, 10087, 9819, 9915, 9845, 10050, 10052, 10023, 10083, 10119, 9890, 10049, 10120, 10058, 9997, 10028, 10009, 9768, 10121, 9946, 10122, 10063, 9781, 10055, 10123, 9970, 9975, 10124, 10046, 10026, 9972, 10077, 9920, 10039, 10082, 10078, 9967, 10356, 10088, 10014, 9868, 10126, 10127, 10103, 10084, 9994, 10128, 10129, 10130, 10032, 9966, 9909, 9896, 9985, 9837, 9990, 9928, 10100, 9942, 10131, 10107, 10072, 9866, 10012, 10010, 10132, 10133, 9957, 10016)) AND (`Playercontest`.`contest_id` = 181))

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

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)