Australian Open 2000 Women's Singles (January 17 - January 30)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Martina Hingis
				Martina Hingis
2.			Mirjana Lucic	6-1 6-2
					Martina Hingis
3.			Justine Henin		6-3 6-3
				Justine Henin
4.		[Q]	Kerry-Anne Guse	6-4 6-2
						Martina Hingis
5.			Karina Habsudova			6-2 6-3
				Karina Habsudova
6.			Jolene Watanabe	6-0 6-1
					Alicia Molik
7.			Alicia Molik		6-2 6-3
				Alicia Molik
8.			Silvija Talaja	6-1 5-7 7-5
							Martina Hingis
9.			Tamarine Tanasugarn				6-1 7-6(3)
				Tamarine Tanasugarn
10.			Rita Grande	6-3 6-4
					Tamarine Tanasugarn
11.			Jana Nejedly		7-5 6-4
				Jana Nejedly
12.			Katarina Srebotnik	6-4 1-6 6-4
						Sandrine Testud
13.			Angelica Gavaldon			4-6 7-5 6-2
				Angelica Gavaldon
14.		[Q]	Tzipora Obziler	6-4 4-6 6-4
					Sandrine Testud
15.		[12]	Sandrine Testud		6-1 6-2
				Sandrine Testud
16.			Petra Mandula	6-3 4-6 6-3
								Martina Hingis
17.		[13]	Arantxa Sanchez-Vicario					6-1 6-1
				Arantxa Sanchez-Vicario
18.			Julia Abe	6-2 6-2
					Arantxa Sanchez-Vicario
19.			Lisa Raymond		6-1 3-6 6-3
				Lisa Raymond
20.		[Q]	Alexandra Fusai	5-7 6-4 6-4
						Arantxa Sanchez-Vicario
21.			Emmanuelle Gagliardi			7-5 6-1
				Emmanuelle Gagliardi
22.			Alexia Dechaume	6-2 6-0
					Bryanne Stewart
23.		[WC]	Bryanne Stewart		2-6 6-4 6-4
				Bryanne Stewart
24.			Maria Vento-Kabchi	7-5 6-3
							Arantxa Sanchez-Vicario
25.			Florencia Labat				1-6 6-0 7-5
				Florencia Labat
26.			Ludmila Cervanova	6-2 6-3
					Florencia Labat
27.			Magui Serna		7-6(3) 7-5
				Magui Serna
28.			Maureen Drake	6-4 6-2
						Barbara Schett
29.			Miroslava Vavrinec			6-1 6-3
				Miroslava Vavrinec
30.		[WC]	Lisa McShea	6-1 6-4
					Barbara Schett
31.		[6]	Barbara Schett		6-4 6-4
				Barbara Schett
32.			Meilen Tu	6-2 6-7(1) 6-4
									Martina Hingis
33.		[3]	Serena Williams						6-3 6-2
				Serena Williams
34.		[WC]	Amanda Grahame	6-4 4-6 6-4
					Serena Williams
35.			Nicole Pratt		7-5 6-1
				Nicole Pratt
36.			Maria Sanchez Lorenzo	6-3 6-0
						Serena Williams
37.			Sabine Appelmans			6-2 7-6(2)
				Sabine Appelmans
38.			Annabel Ellwood	6-2 6-2
					Sabine Appelmans
39.			Chanda Rubin		6-1 3-6 6-3
				Chanda Rubin
40.			Anna Smashnova	6-3 6-4
							Elena Likhovtseva
41.			Els Callens				6-3 6-3
				Els Callens
42.			Amy Frazier	6-1 6-3
					Els Callens
43.			Denisa Chladkova		2-6 7-5 6-4
				Denisa Chladkova
44.		[WC]	Virginie Razzano	7-6(10) 6-2
						Elena Likhovtseva
45.			Meghann Shaughnessy			5-7 7-6(5) 6-3
				Meghann Shaughnessy
46.			Tara Snyder	6-0 1-6 10-8
					Elena Likhovtseva
47.		[16]	Elena Likhovtseva		6-3 7-5
				Elena Likhovtseva
48.			Pavlina Stoyanova	6-2 6-2
								Conchita Martinez
49.		[10]	Conchita Martinez					6-3 4-6 9-7
				Conchita Martinez
50.			Sandra Kleinova	6-1 6-1
					Conchita Martinez
51.			Olga Barabanschikova		6-3 4-6 6-3
				Olga Barabanschikova
52.			Irina Spirlea	6-4 3-6 6-3
						Conchita Martinez
53.			Sylvia Plischke			6-4 6-4
				Sylvia Plischke
54.			Lubomira Bacheva	6-4 6-4
					Jelena Kostanic
55.			Jelena Kostanic		6-3 0-6 6-4
				Jelena Kostanic
56.			Mariana Diaz-Oliva	6-3 6-7(3) 6-4
							Conchita Martinez
57.			Erika De Lone				6-1 6-1
				Erika De Lone
58.			Anna Maria Foldenyi	6-1 6-4
					Ruxandra Dragomir
59.			Ruxandra Dragomir		6-4 5-7 6-0
				Ruxandra Dragomir
60.		[Q]	Tathiana Garbin	7-5 6-4
						Kristina Brandi
61.			Kristina Brandi			6-4 7-6(7)
				Kristina Brandi
62.			Gala Leon Garcia	6-3 6-3
					Kristina Brandi
63.		[8]	Amanda Coetzer		6-1 6-3
				Amanda Coetzer
64.			Tatiana Panova	6-3 6-3
										Lindsay Davenport
65.		[7]	Amelie Mauresmo							6-1 7-5
				Amelie Mauresmo
66.			Cristina Torrens-Valero	6-1 6-2
					Patty Schnyder
67.			Patty Schnyder		6-4 6-4
				Patty Schnyder
68.			Lilia Osterloh	6-3 6-4
						Patty Schnyder
69.			Nadia Petrova			7-6(6) 4-6 6-2
				Nadia Petrova
70.			Anne-Gaelle Sidot	6-4 6-2
					Nadia Petrova
71.			Cara Black		4-6 6-4 6-4
				Cara Black
72.			Lenka Nemeckova	6-4 7-6(4)
							Jennifer Capriati
73.		[Q]	Julie Pullin				6-3 4-6 6-1
				Julie Pullin
74.			Jane Chi	6-1 6-3
					Jing-Qian Yi
75.		[WC]	Jing-Qian Yi		6-3 2-6 9-7
				Jing-Qian Yi
76.			Laurence Courtois	7-6(5) 6-2
						Jennifer Capriati
77.			Jennifer Capriati			6-4 6-4
				Jennifer Capriati
78.			Barbara Schwartz	6-1 7-6(1)
					Jennifer Capriati
79.		[14]	Dominique Monami		6-1 4-6 8-6
				Dominique Monami
80.			Kim Clijsters	3-6 6-1 6-1
								Jennifer Capriati
81.			Kristie Boogert					6-0 6-2
				Kristie Boogert
82.		[15]	Anke Huber	6-4 6-4
					Asa Carlsson
83.			Asa Carlsson		7-5 6-3
				Asa Carlsson
84.			Alexandra Stevenson	7-6(6) 6-3
						Ai Sugiyama
85.			Ai Sugiyama			6-4 4-6 6-3
				Ai Sugiyama
86.			Magdalena Maleeva	7-6(3) 7-6(4)
					Ai Sugiyama
87.			Adriana Gersi		6-1 6-4
				Adriana Gersi
88.			Seda Noorlander	3-6 6-3 6-3
							Ai Sugiyama
89.			Miriam Oremans				7-5 6-4
				Miriam Oremans
90.			Anca Barna	6-2 6-2
					Miriam Oremans
91.			Sandra Nacuk		6-3 7-5
				Sandra Nacuk
92.			Janet Lee	6-4 6-7(6) 7-5
						Mary Pierce
93.			Amelie Cocheteux			6-2 6-4
				Amelie Cocheteux
94.			Barbara Rittner	1-6 7-5 6-4
					Mary Pierce
95.		[4]	Mary Pierce		6-2 6-2
				Mary Pierce
96.		[Q]	Linda Harvey	7-5 6-3
									Lindsay Davenport
97.		[5]	Nathalie Tauziat						6-2 7-6(4)
				Nathalie Tauziat
98.			Henrieta Nagyova	6-1 2-6 6-1
					Sonya Jeyaseelan
99.		[Q]	Sonya Jeyaseelan		7-6(3) 6-4
				Sonya Jeyaseelan
100.			Amanda Hopmans	6-2 3-6 6-1
						Jana Kandarr
101.		[Q]	Jana Kandarr			6-2 0-6 6-3
				Jana Kandarr
102.		[WC]	Melissa Dowse	6-4 6-7(5) 8-6
					Jana Kandarr
103.			Emilie Loit		1-6 7-5 6-3
				Emilie Loit
104.		[WC]	Evie Dominikovic	6-7(3) 6-4 6-2
							Julie Halard
105.			Angeles Montolio				6-1 3-0 rtd.
				Angeles Montolio
106.		[WC]	Rachel McQuillan	6-4 6-3
					Elena Dementieva
107.			Elena Dementieva		6-4 6-3
				Elena Dementieva
108.			Paola Suarez	6-0 3-6 8-6
						Julie Halard
109.			Fabiola Zuluaga			3-6 6-4 6-2
				Fabiola Zuluaga
110.			Nathalie Dechy	6-1 3-6 6-1
					Julie Halard
111.		[9]	Julie Halard		6-3 6-3
				Julie Halard
112.		[Q]	Lina Krasnoroutskaya	6-2 6-4
								Lindsay Davenport
113.		[11]	Anna Kournikova					6-1 6-2
				Anna Kournikova
114.			Patricia Wartusch	6-0 6-0
					Anna Kournikova
115.			Natasha Zvereva		6-1 6-4
				Natasha Zvereva
116.			Brie Rippner	6-7(4) 7-5 6-2
						Anna Kournikova
117.			Kveta Hrdlickova			2-6 6-3 6-4
				Kveta Hrdlickova
118.			Virginia Ruano-Pascual	6-2 6-1
					Kveta Hrdlickova
119.			Rita Kuti-Kis		7-6(2) 6-7(5) 6-3
				Rita Kuti-Kis
120.			Jelena Dokic	6-1 2-6 6-3
							Lindsay Davenport
121.		[Q]	Alina Jidkova				6-4 6-3
				Alina Jidkova
122.			Tina Pisnik	2-6 7-6(5) 6-1
					Alina Jidkova
123.			Marlene Weingartner		7-5 6-3
				Marlene Weingartner
124.			Anne Kremer	6-2 2-6 6-4
						Lindsay Davenport
125.		[Q]	Marissa Irvin			6-0 6-1
				Marissa Irvin
126.			Corina Morariu	2-6 7-5 6-3
					Lindsay Davenport
127.		[2]	Lindsay Davenport		6-4 7-5
				Lindsay Davenport
128.			Sarah Pitkowski	6-3 6-1

(default) 17 queries took 26 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	2
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	2
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` = '2000' 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` = (184) 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 (10078, 10149, 10179, 9869, 9946, 10058, 10172, 10122, 10115, 10098, 10092, 10180, 9941, 10181, 9990, 10182, 9957, 10183, 10039, 10026, 10130, 9873, 10110, 10105, 9994, 10184, 10111, 9934, 10185, 10053, 10077, 10126, 10150, 10186, 9937, 10090, 9936, 10080, 9985, 10062, 10068, 9845, 10133, 10187, 10147, 10135, 10064, 10188, 9885, 10100, 10137, 10050, 10153, 10189, 10190, 10146, 9913, 10004, 10063, 10170, 10124, 10114, 10018, 10145, 10152, 10123, 10356, 10175, 10163, 10131, 10160, 10144, 10191, 10159, 10108, 10037, 9997, 10167, 10012, 10192, 10048, 9915, 10101, 10193, 10070, 9959, 10117, 10162, 9953, 10194, 10195, 10086, 10155, 9967, 10024, 10009, 10017, 10129, 10094, 10196, 10106, 10197, 10165, 10109, 10069, 9819, 10174, 10119, 10198, 10116, 9829, 10199, 10113, 10200, 9945, 10164, 10156, 10055, 10169, 10173, 10201, 10202, 10157, 10128, 10203, 10121, 10025, 10084) 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` = 184	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (72, 21, 31, 20, 207, 133, 151, 197, 178, 168, 53, 68, 172, 154, 10, 13, 153, 36, 84, 179, 92, 173, 121, 50, 111, 181, 219, 135, 91, 169, 14, 196, 94, 184, 201, 42, 43)	37	37	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (72, 21, 31, 20, 207, 133, 151, 197, 178, 168, 53, 68, 172, 154, 10, 13, 153, 36, 84, 179, 92, 173, 121, 50, 111, 181, 219, 135, 91, 169, 14, 196, 94, 184, 201, 42, 43)	37	37	3
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10078, 10149, 10179, 9869, 9946, 10058, 10172, 10122, 10115, 10098, 10092, 10180, 9941, 10181, 9990, 10182, 9957, 10183, 10039, 10026, 10130, 9873, 10110, 10105, 9994, 10184, 10111, 9934, 10185, 10053, 10077, 10126, 10150, 10186, 9937, 10090, 9936, 10080, 9985, 10062, 10068, 9845, 10133, 10187, 10147, 10135, 10064, 10188, 9885, 10100, 10137, 10050, 10153, 10189, 10190, 10146, 9913, 10004, 10063, 10170, 10124, 10114, 10018, 10145, 10152, 10123, 10356, 10175, 10163, 10131, 10160, 10144, 10191, 10159, 10108, 10037, 9997, 10167, 10012, 10192, 10048, 9915, 10101, 10193, 10070, 9959, 10117, 10162, 9953, 10194, 10195, 10086, 10155, 9967, 10024, 10009, 10017, 10129, 10094, 10196, 10106, 10197, 10165, 10109, 10069, 9819, 10174, 10119, 10198, 10116, 9829, 10199, 10113, 10200, 9945, 10164, 10156, 10055, 10169, 10173, 10201, 10202, 10157, 10128, 10203, 10121, 10025, 10084)) AND (`Playercontest`.`contest_id` = 184))	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` = 2000	20	20	2
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	2
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 26 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` = '2000' 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` = (184) 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, 10149, 10179, 9869, 9946, 10058, 10172, 10122, 10115, 10098, 10092, 10180, 9941, 10181, 9990, 10182, 9957, 10183, 10039, 10026, 10130, 9873, 10110, 10105, 9994, 10184, 10111, 9934, 10185, 10053, 10077, 10126, 10150, 10186, 9937, 10090, 9936, 10080, 9985, 10062, 10068, 9845, 10133, 10187, 10147, 10135, 10064, 10188, 9885, 10100, 10137, 10050, 10153, 10189, 10190, 10146, 9913, 10004, 10063, 10170, 10124, 10114, 10018, 10145, 10152, 10123, 10356, 10175, 10163, 10131, 10160, 10144, 10191, 10159, 10108, 10037, 9997, 10167, 10012, 10192, 10048, 9915, 10101, 10193, 10070, 9959, 10117, 10162, 9953, 10194, 10195, 10086, 10155, 9967, 10024, 10009, 10017, 10129, 10094, 10196, 10106, 10197, 10165, 10109, 10069, 9819, 10174, 10119, 10198, 10116, 9829, 10199, 10113, 10200, 9945, 10164, 10156, 10055, 10169, 10173, 10201, 10202, 10157, 10128, 10203, 10121, 10025, 10084) 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` = 184

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10078, 10149, 10179, 9869, 9946, 10058, 10172, 10122, 10115, 10098, 10092, 10180, 9941, 10181, 9990, 10182, 9957, 10183, 10039, 10026, 10130, 9873, 10110, 10105, 9994, 10184, 10111, 9934, 10185, 10053, 10077, 10126, 10150, 10186, 9937, 10090, 9936, 10080, 9985, 10062, 10068, 9845, 10133, 10187, 10147, 10135, 10064, 10188, 9885, 10100, 10137, 10050, 10153, 10189, 10190, 10146, 9913, 10004, 10063, 10170, 10124, 10114, 10018, 10145, 10152, 10123, 10356, 10175, 10163, 10131, 10160, 10144, 10191, 10159, 10108, 10037, 9997, 10167, 10012, 10192, 10048, 9915, 10101, 10193, 10070, 9959, 10117, 10162, 9953, 10194, 10195, 10086, 10155, 9967, 10024, 10009, 10017, 10129, 10094, 10196, 10106, 10197, 10165, 10109, 10069, 9819, 10174, 10119, 10198, 10116, 9829, 10199, 10113, 10200, 9945, 10164, 10156, 10055, 10169, 10173, 10201, 10202, 10157, 10128, 10203, 10121, 10025, 10084)) AND (`Playercontest`.`contest_id` = 184))

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

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)