Australian Open 2004 Women's Singles (January 19 - February 1)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Justine Henin
				Justine Henin
2.		[WC]	Olivia Lukaszewicz	6-0 6-0
					Justine Henin
3.		[Q]	Camille Pin		6-1 6-4
				Camille Pin
4.			Tathiana Garbin	6-4 6-7(3) 6-4
						Justine Henin
5.			Antonella Serra-Zanetti			6-2 7-5
				Antonella Serra-Zanetti
6.			Flavia Pennetta	7-5 6-4
					Svetlana Kuznetsova
7.		[30]	Svetlana Kuznetsova		7-6(0) 6-4
				Svetlana Kuznetsova
8.		[Q]	Shenay Perry	6-3 6-3
							Justine Henin
9.		[19]	Eleni Daniilidou				6-1 7-6(5)
				Eleni Daniilidou
10.		[Q]	Jennifer Hopkins	6-1 6-3
					Eleni Daniilidou
11.			Cara Black		3-6 6-0 6-1
				Cara Black
12.			Els Callens	2-6 6-3 6-3
						Mara Santangelo
13.			Barbara Schett			6-4 5-7 6-3
				Barbara Schett
14.			Clarisa Fernandez	4-6 6-3 6-4
					Mara Santangelo
15.		[Q]	Mara Santangelo		7-6(3) 0-6 6-3
				Mara Santangelo
16.		[16]	Magui Serna	6-7(3) 7-5 6-4
								Justine Henin
17.		[11]	Vera Zvonareva					7-5 6-3
				Vera Zvonareva
18.			Zuzana Ondraskova	6-3 6-1
					Vera Zvonareva
19.			Melinda Czink		7-5 6-4
				Melinda Czink
20.			Maria Vento-Kabchi	6-4 6-3
						Vera Zvonareva
21.			Akiko Morigami			7-5 2-6 6-1
				Akiko Morigami
22.		[Q]	Marie-Eve Pelletier	7-6(2) 4-6 6-4
					Nicole Pratt
23.			Nicole Pratt		1-6 6-3 6-3
				Nicole Pratt
24.		[17]	Meghann Shaughnessy	6-4 5-7 6-4
							Lindsay Davenport
25.			Laura Granville				6-1 6-3
				Laura Granville
26.		[31]	Tamarine Tanasugarn	6-1 6-3
					Laura Granville
27.		[WC]	Evie Dominikovic		6-2 2-6 6-1
				Evie Dominikovic
28.		[WC]	Trudi Musgrave	4-6 7-5 6-3
						Lindsay Davenport
29.			Emilie Loit			6-4 6-0
				Emilie Loit
30.			Marta Marrero	7-5 6-4
					Lindsay Davenport
31.		[5]	Lindsay Davenport		6-3 3-6 6-0
				Lindsay Davenport
32.			Ruxandra Dragomir	6-2 6-3
									Justine Henin
33.		[4]	Amelie Mauresmo						6-2 6-2
				Amelie Mauresmo
34.		[WC]	Chia-Jung Chuang	6-1 6-0
					Amelie Mauresmo
35.			Ludmila Cervanova		6-0 6-2
				Ludmila Cervanova
36.		[WC]	Casey Dellacqua	6-4 6-4
						Amelie Mauresmo
37.			Anabel Medina-Garrigues			6-1 6-2
				Anabel Medina-Garrigues
38.			Ansley Cargill	6-3 6-4
					Anabel Medina-Garrigues
39.		[Q]	Yuliana Fedak		6-2 2-6 6-3
				Yuliana Fedak
40.		[26]	Tina Pisnik	7-5 6-0
							Amelie Mauresmo
41.		[21]	Elena Bovina				7-5 7-5
				Elena Bovina
42.			Sandra Kleinova	4-6 6-1 7-5
					Claudine Schaul
43.			Claudine Schaul		6-4 6-3
				Claudine Schaul
44.			Tatiana Perebiynis	6-0 6-0
						Alicia Molik
45.			Alicia Molik			6-7(4) 6-1 6-2
				Alicia Molik
46.		[Q]	Angelika Bachmann	6-1 6-4
					Alicia Molik
47.		[15]	Daniela Hantuchova		6-4 6-3
				Daniela Hantuchova
48.			Adriana Serra-Zanetti	7-6(5) 6-4
								Fabiola Zuluaga
49.			Aniko Kapros					w/o
				Aniko Kapros
50.		[10]	Nadia Petrova	6-3 6-3
					Aniko Kapros
51.		[WC]	Samantha Stosur		6-3 6-1
				Samantha Stosur
52.			Silvija Talaja	6-3 6-2
						Aniko Kapros
53.			Petra Mandula			3-6 6-3 12-10
				Petra Mandula
54.			Gala Leon Garcia	6-4 4-6 6-4
					Petra Mandula
55.		[24]	Magdalena Maleeva		6-7(6) 6-2 6-3
				Magdalena Maleeva
56.			Samantha Reeves	6-1 6-0
							Fabiola Zuluaga
57.		[32]	Fabiola Zuluaga				6-4 6-2
				Fabiola Zuluaga
58.			Shinobu Asagoe	6-3 6-2
					Fabiola Zuluaga
59.		[Q]	Mariana Diaz-Oliva		6-3 6-4
				Mariana Diaz-Oliva
60.			Alina Jidkova	6-2 7-6(5)
						Fabiola Zuluaga
61.			Jill Craybas			7-6(6) 4-6 6-2
				Jill Craybas
62.			Rita Grande	6-2 6-1
					Jill Craybas
63.			Jelena Jankovic		6-4 2-6 8-6
				Jelena Jankovic
64.		[7]	Elena Dementieva	6-1 6-4
										Justine Henin
65.		[8]	Ai Sugiyama							6-3 4-6 6-3
				Ai Sugiyama
66.			Tatiana Panova	6-4 6-2
					Saori Obata
67.			Saori Obata		6-4 6-4
				Saori Obata
68.			Myriam Casanova	6-3 4-6 6-4
						Nathalie Dechy
69.		[Q]	Tzipora Obziler			7-5 6-1
				Tzipora Obziler
70.			Martina Sucha	6-3 6-2
					Nathalie Dechy
71.		[29]	Nathalie Dechy		6-3 6-0
				Nathalie Dechy
72.			Jelena Kostanic	7-5 6-4
							Patty Schnyder
73.		[22]	Patty Schnyder				6-2 6-4
				Patty Schnyder
74.			Angelique Widjaja	6-3 5-7 6-3
					Patty Schnyder
75.			Marion Bartoli		6-4 2-6 6-3
				Marion Bartoli
76.			Alexandra Stevenson	6-3 6-1
						Patty Schnyder
77.			Julia Vakulenko			7-5 6-3
				Julia Vakulenko
78.			Eva Birnerova	6-4 6-3
					Paola Suarez
79.		[12]	Paola Suarez		6-3 6-4
				Paola Suarez
80.		[Q]	Gisela Dulko	6-2 6-2
								Patty Schnyder
81.		[14]	Anna Smashnova					7-6(2) 6-3
				Anna Smashnova
82.			Klara Koukalova	6-3 6-3
					Tatiana Golovin
83.		[WC]	Tatiana Golovin		6-2 6-3
				Tatiana Golovin
84.			Marie-Gaiane Mikaelian	6-0 4-1 rtd.
						Tatiana Golovin
85.		[Q]	Barbora Strycova			6-2 7-6(4)
				Barbora Strycova
86.			Arantxa Parra-Santonja	7-5 6-1
					Lina Krasnoroutskaya
87.		[23]	Lina Krasnoroutskaya		6-3 4-6 6-3
				Lina Krasnoroutskaya
88.			Karolina Sprem	6-3 6-4
							Lisa Raymond
89.		[25]	Lisa Raymond				6-2 6-0
				Lisa Raymond
90.			Maria Sanchez Lorenzo	5-7 6-3 6-4
					Lisa Raymond
91.			Anca Barna		6-3 6-4
				Anca Barna
92.			Maureen Drake	2-6 6-0 7-5
						Lisa Raymond
93.			Vera Dushevina			6-4 7-6(5)
				Vera Dushevina
94.			Jie Zheng	6-2 4-6 6-0
					Venus Williams
95.		[3]	Venus Williams		6-4 6-2
				Venus Williams
96.			Ashley Harkleroad	6-2 6-1
									Kim Clijsters
97.		[6]	Anastasia Myskina						6-2 7-6(2)
				Anastasia Myskina
98.			Sofia Arvidsson	6-2 7-5
					Anastasia Myskina
99.			Emmanuelle Gagliardi		6-2 6-4
				Emmanuelle Gagliardi
100.		[Q]	Libuse Prusova	7-6(5) 7-5
						Anastasia Myskina
101.		[LL]	Lindsay Lee			6-4 1-6 6-2
				Lindsay Lee
102.		[WC]	Sophie Ferguson	6-3 6-1
					Maria Sharapova
103.		[28]	Maria Sharapova		6-1 6-3
				Maria Sharapova
104.			Conchita Martinez-Granados	6-4 6-3
							Anastasia Myskina
105.		[18]	Francesca Schiavone				6-7(3) 6-2 6-2
				Francesca Schiavone
106.			Cristina Torrens-Valero	7-5 6-1
					Elena Likhovtseva
107.			Elena Likhovtseva		6-2 6-2
				Elena Likhovtseva
108.			Dally Randriantefy	3-6 6-1 6-1
						Chanda Rubin
109.			Denisa Chladkova			6-3 6-2
				Denisa Chladkova
110.			Stephanie Foretz	6-4 6-2
					Chanda Rubin
111.		[9]	Chanda Rubin		6-2 6-4
				Chanda Rubin
112.			Asa Carlsson	6-3 4-6 6-3
								Kim Clijsters
113.			Kristina Brandi					6-2 7-6(9)
				Kristina Brandi
114.		[13]	Conchita Martinez	7-6(7) 6-1
					Amy Frazier
115.			Amy Frazier		2-6 6-0 7-5
				Amy Frazier
116.			Stephanie Cohen-Aloro	4-6 7-5 6-3
						Silvia Farina
117.			Virginia Ruano-Pascual			4-6 6-1 7-5
				Virginia Ruano-Pascual
118.			Katarina Srebotnik	6-4 6-3
					Silvia Farina
119.		[20]	Silvia Farina		5-7 6-4 6-4
				Silvia Farina
120.			Henrieta Nagyova	6-3 6-3
							Kim Clijsters
121.		[27]	Amanda Coetzer				6-3 6-3
				Amanda Coetzer
122.			Tara Snyder	6-3 6-1
					Dinara Safina
123.			Dinara Safina		7-5 6-3
				Dinara Safina
124.			Lubomira Kurhajcova	6-3 7-6(1)
						Kim Clijsters
125.			Maria Elena Camerin			6-2 6-1
				Maria Elena Camerin
126.			Milagros Sequera	6-2 6-2
					Kim Clijsters
127.		[2]	Kim Clijsters		6-0 6-0
				Kim Clijsters
128.			Marlene Weingartner	6-3 6-2

(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` = '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` = '2004' 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` = (188) 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 (10179, 10304, 10294, 10170, 10258, 10302, 10255, 10305, 10253, 10209, 10160, 10068, 10077, 10254, 10306, 10111, 10281, 10307, 10286, 10105, 10292, 10308, 9937, 10147, 10278, 10115, 10109, 10104, 10165, 10215, 10025, 10063, 10152, 10309, 10184, 10285, 10208, 10277, 10310, 10202, 10211, 10100, 10311, 10312, 10172, 10313, 10299, 10095, 10271, 10163, 10270, 10122, 10182, 10114, 9959, 10154, 10198, 10222, 10146, 10201, 10171, 10098, 10284, 10174, 10070, 10145, 10265, 10289, 10181, 10223, 10116, 10190, 10356, 10301, 10261, 10193, 10314, 10315, 10119, 10316, 10062, 10282, 10317, 10275, 10318, 10319, 10199, 10320, 10039, 10090, 10194, 9934, 10321, 10322, 10151, 10323, 10262, 10324, 10130, 10296, 10097, 10325, 10326, 10359, 10218, 10123, 10064, 10083, 10133, 10297, 9985, 10101, 10124, 9885, 9845, 10327, 10055, 10180, 10049, 10129, 10018, 10135, 10290, 10283, 10264, 10328, 10192, 10157) 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` = 188	129	129	5
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (178, 94, 72, 68, 53, 207, 154, 151, 21, 92, 197, 179, 168, 181, 172, 84, 74, 13, 10, 153, 36, 194, 173, 216, 50, 31, 91, 169, 113, 111, 14, 201, 184, 87, 42, 43)	36	36	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (178, 94, 72, 68, 53, 207, 154, 151, 21, 92, 197, 179, 168, 181, 172, 84, 74, 13, 10, 153, 36, 194, 173, 216, 50, 31, 91, 169, 113, 111, 14, 201, 184, 87, 42, 43)	36	36	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10179, 10304, 10294, 10170, 10258, 10302, 10255, 10305, 10253, 10209, 10160, 10068, 10077, 10254, 10306, 10111, 10281, 10307, 10286, 10105, 10292, 10308, 9937, 10147, 10278, 10115, 10109, 10104, 10165, 10215, 10025, 10063, 10152, 10309, 10184, 10285, 10208, 10277, 10310, 10202, 10211, 10100, 10311, 10312, 10172, 10313, 10299, 10095, 10271, 10163, 10270, 10122, 10182, 10114, 9959, 10154, 10198, 10222, 10146, 10201, 10171, 10098, 10284, 10174, 10070, 10145, 10265, 10289, 10181, 10223, 10116, 10190, 10356, 10301, 10261, 10193, 10314, 10315, 10119, 10316, 10062, 10282, 10317, 10275, 10318, 10319, 10199, 10320, 10039, 10090, 10194, 9934, 10321, 10322, 10151, 10323, 10262, 10324, 10130, 10296, 10097, 10325, 10326, 10359, 10218, 10123, 10064, 10083, 10133, 10297, 9985, 10101, 10124, 9885, 9845, 10327, 10055, 10180, 10049, 10129, 10018, 10135, 10290, 10283, 10264, 10328, 10192, 10157)) AND (`Playercontest`.`contest_id` = 188))	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` = 2004	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	0

(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` = '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` = '2004' 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` = (188) 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 (10179, 10304, 10294, 10170, 10258, 10302, 10255, 10305, 10253, 10209, 10160, 10068, 10077, 10254, 10306, 10111, 10281, 10307, 10286, 10105, 10292, 10308, 9937, 10147, 10278, 10115, 10109, 10104, 10165, 10215, 10025, 10063, 10152, 10309, 10184, 10285, 10208, 10277, 10310, 10202, 10211, 10100, 10311, 10312, 10172, 10313, 10299, 10095, 10271, 10163, 10270, 10122, 10182, 10114, 9959, 10154, 10198, 10222, 10146, 10201, 10171, 10098, 10284, 10174, 10070, 10145, 10265, 10289, 10181, 10223, 10116, 10190, 10356, 10301, 10261, 10193, 10314, 10315, 10119, 10316, 10062, 10282, 10317, 10275, 10318, 10319, 10199, 10320, 10039, 10090, 10194, 9934, 10321, 10322, 10151, 10323, 10262, 10324, 10130, 10296, 10097, 10325, 10326, 10359, 10218, 10123, 10064, 10083, 10133, 10297, 9985, 10101, 10124, 9885, 9845, 10327, 10055, 10180, 10049, 10129, 10018, 10135, 10290, 10283, 10264, 10328, 10192, 10157) 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` = 188

129

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10179, 10304, 10294, 10170, 10258, 10302, 10255, 10305, 10253, 10209, 10160, 10068, 10077, 10254, 10306, 10111, 10281, 10307, 10286, 10105, 10292, 10308, 9937, 10147, 10278, 10115, 10109, 10104, 10165, 10215, 10025, 10063, 10152, 10309, 10184, 10285, 10208, 10277, 10310, 10202, 10211, 10100, 10311, 10312, 10172, 10313, 10299, 10095, 10271, 10163, 10270, 10122, 10182, 10114, 9959, 10154, 10198, 10222, 10146, 10201, 10171, 10098, 10284, 10174, 10070, 10145, 10265, 10289, 10181, 10223, 10116, 10190, 10356, 10301, 10261, 10193, 10314, 10315, 10119, 10316, 10062, 10282, 10317, 10275, 10318, 10319, 10199, 10320, 10039, 10090, 10194, 9934, 10321, 10322, 10151, 10323, 10262, 10324, 10130, 10296, 10097, 10325, 10326, 10359, 10218, 10123, 10064, 10083, 10133, 10297, 9985, 10101, 10124, 9885, 9845, 10327, 10055, 10180, 10049, 10129, 10018, 10135, 10290, 10283, 10264, 10328, 10192, 10157)) AND (`Playercontest`.`contest_id` = 188))

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

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)