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

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Serena Williams
				Serena Williams
2.			Emilie Loit	3-6 7-6(5) 7-5
					Serena Williams
3.			Els Callens		6-4 6-0
				Els Callens
4.			Martina Sucha	6-0 6-2
						Serena Williams
5.			Alina Jidkova			6-1 6-1
				Alina Jidkova
6.			Laura Granville	2-6 6-4 6-0
					Tamarine Tanasugarn
7.		[26]	Tamarine Tanasugarn		6-2 3-6 6-3
				Tamarine Tanasugarn
8.			Maureen Drake	6-0 6-2
							Serena Williams
9.		[18]	Eleni Daniilidou				6-4 6-1
				Eleni Daniilidou
10.			Marissa Irvin	7-6(6) 6-3
					Eleni Daniilidou
11.			Amy Frazier		6-1 6-2
				Amy Frazier
12.			Conchita Martinez-Granados	6-0 6-1
						Eleni Daniilidou
13.			Daja Bedanova			6-4 6-3
				Daja Bedanova
14.			Iveta Benesova	6-3 5-7 6-4
					Nathalie Dechy
15.		[16]	Nathalie Dechy		6-3 6-3
				Nathalie Dechy
16.			Sarah Taylor	6-2 6-3
								Serena Williams
17.		[11]	Magdalena Maleeva					6-2 6-2
				Magdalena Maleeva
18.			Marion Bartoli	6-4 6-1
					Magdalena Maleeva
19.			Cho Yoon-Jeong		2-6 6-4 6-1
				Cho Yoon-Jeong
20.			Eva Dyrberg	6-3 6-3
						Elena Bovina
21.			Rita Grande			7-5 4-6 7-5
				Rita Grande
22.			Aniko Kapros	6-0 6-1
					Elena Bovina
23.		[20]	Elena Bovina		6-1 6-2
				Elena Bovina
24.			Vera Zvonareva	6-2 6-1
							Meghann Shaughnessy
25.		[25]	Meghann Shaughnessy				5-7 6-2 6-4
				Meghann Shaughnessy
26.		[Q]	Nuria Llagostera-Vives	4-6 6-3 6-3
					Meghann Shaughnessy
27.			Ludmila Cervanova		6-1 6-1
				Ludmila Cervanova
28.			Mariana Diaz-Oliva	7-6(2) 6-2
						Meghann Shaughnessy
29.		[Q]	Klara Koukalova			6-1 6-3
				Klara Koukalova
30.		[Q]	Maria Sharapova	6-4 7-6(6)
					Klara Koukalova
31.		[6]	Monica Seles		6-7(6) 7-5 6-3
				Monica Seles
32.			Lubomira Kurhajcova	6-0 6-1
									Serena Williams
33.		[4]	Kim Clijsters						4-6 6-3 7-5
				Kim Clijsters
34.			Samantha Reeves	6-2 6-1
					Kim Clijsters
35.			Petra Mandula		6-0 6-0
				Petra Mandula
36.			Silvija Talaja	7-5 6-1
						Kim Clijsters
37.			Tatiana Poutchek			6-2 6-1
				Tatiana Poutchek
38.			Tina Pisnik	6-3 6-0
					Tatiana Poutchek
39.			Cristina Torrens-Valero		2-6 6-4 6-4
				Cristina Torrens-Valero
40.		[29]	Iva Majoli	6-3 4-6 6-4
							Kim Clijsters
41.		[19]	Amanda Coetzer				6-3 6-1
				Amanda Coetzer
42.			Barbara Schett	6-4 6-3
					Amanda Coetzer
43.		[Q]	Jelena Jankovic		6-2 4-6 6-4
				Jelena Jankovic
44.			Rossana De Los Rios	6-3 6-3
						Amanda Coetzer
45.			Maja Matevzic			6-0 6-2
				Maja Matevzic
46.		[WC]	Casey Dellacqua	6-7(6) 6-2 6-2
					Anna Smashnova
47.		[14]	Anna Smashnova		5-1 rtd.
				Anna Smashnova
48.			Meilen Tu	6-4 4-6 6-2
								Kim Clijsters
49.		[10]	Chanda Rubin					6-2 6-4
				Chanda Rubin
50.		[Q]	Melinda Czink	6-4 7-5
					Chanda Rubin
51.			Mary Pierce		0-6 6-4 6-2
				Mary Pierce
52.			Patricia Wartusch	6-1 6-4
						Chanda Rubin
53.			Antonella Serra-Zanetti			6-3 6-2
				Antonella Serra-Zanetti
54.			Martina Muller	7-6(5) 6-0
					Barbara Schwartz
55.		[Q]	Barbara Schwartz		6-1 6-2
				Barbara Schwartz
56.		[17]	Elena Dementieva	5-7 6-4 6-2
							Anastasia Myskina
57.		[28]	Clarisa Fernandez				4-6 6-4 6-1
				Clarisa Fernandez
58.		[WC]	Adriana Szili	6-1 7-5
					Clarisa Fernandez
59.			Magui Serna		6-3 6-4
				Magui Serna
60.			Asa Carlsson	6-4 3-6 7-5
						Anastasia Myskina
61.			Emmanuelle Gagliardi			6-3 6-4
				Emmanuelle Gagliardi
62.			Marie-Gaiane Mikaelian	6-1 3-0 rtd.
					Anastasia Myskina
63.		[8]	Anastasia Myskina		5-7 6-2 6-0
				Anastasia Myskina
64.		[Q]	Eva Fislova	7-5 6-3
										Serena Williams
65.		[5]	Justine Henin							7-6(4) 3-6 6-4
				Justine Henin
66.			Myriam Casanova	6-3 6-4
					Justine Henin
67.			Anna Kournikova		6-0 6-1
				Anna Kournikova
68.			Henrieta Nagyova	6-1 6-2
						Justine Henin
69.			Virginie Razzano			6-2 6-0
				Virginie Razzano
70.			Jill Craybas	7-6(7) 4-6 6-1
					Katarina Srebotnik
71.		[32]	Katarina Srebotnik		6-1 6-7(4) 6-3
				Katarina Srebotnik
72.			Dinara Safina	3-6 6-3 6-3
							Justine Henin
73.		[24]	Tatiana Panova				7-5 5-7 9-7
				Tatiana Panova
74.			Angelika Roesch	7-6(2) 3-6 6-2
					Tatiana Panova
75.		[WC]	Akiko Morigami		3-6 7-5 6-4
				Akiko Morigami
76.		[Q]	Stanislava Hrozenska	6-2 6-1
						Lindsay Davenport
77.			Iroda Tulyaganova			6-2 6-1
				Iroda Tulyaganova
78.			Alicia Molik	3-6 6-4 rtd.
					Lindsay Davenport
79.		[9]	Lindsay Davenport		6-7(7) 6-4 7-5
				Lindsay Davenport
80.		[WC]	Camille Pin	6-2 6-1
								Justine Henin
81.		[15]	Alexandra Stevenson					6-2 6-2
				Alexandra Stevenson
82.		[WC]	Elena Baltacha	6-1 6-4
					Denisa Chladkova
83.			Denisa Chladkova		6-2 6-2
				Denisa Chladkova
84.			Cara Black	6-3 6-0
						Denisa Chladkova
85.		[WC]	Evie Dominikovic			6-3 6-2
				Evie Dominikovic
86.			Barbara Rittner	7-5 4-6 6-4
					Evie Dominikovic
87.		[22]	Anne Kremer		6-1 6-4
				Anne Kremer
88.			Libuse Prusova	6-2 6-2
							Virginia Ruano-Pascual
89.		[30]	Janette Husarova				6-3 6-3
				Janette Husarova
90.		[Q]	Maria-Emilia Salerni	6-3 6-0
					Virginia Ruano-Pascual
91.			Virginia Ruano-Pascual		5-7 7-5 6-0
				Virginia Ruano-Pascual
92.			Shinobu Asagoe	6-2 6-1
						Virginia Ruano-Pascual
93.			Stephanie Foretz			6-1 4-6 6-4
				Stephanie Foretz
94.			Evgenia Koulikovskaya	4-6 6-1 6-0
					Marlene Weingartner
95.			Marlene Weingartner		3-6 6-1 6-2
				Marlene Weingartner
96.		[3]	Jennifer Capriati	2-6 7-6(6) 6-4
									Venus Williams
97.		[7]	Daniela Hantuchova						6-3 6-3
				Daniela Hantuchova
98.			Fabiola Zuluaga	7-5 6-7(3) 6-4
					Daniela Hantuchova
99.			Adriana Serra-Zanetti		7-6(6) 7-6(3)
				Adriana Serra-Zanetti
100.			Elena Likhovtseva	7-6(6) 6-4
						Daniela Hantuchova
101.		[Q]	Vanessa Webb			6-4 6-2
				Vanessa Webb
102.			Maria Sanchez Lorenzo	2-6 7-5 6-3
					Samantha Stosur
103.		[WC]	Samantha Stosur		6-4 6-1
				Samantha Stosur
104.		[31]	Conchita Martinez	6-7(3) 6-3 6-4
							Daniela Hantuchova
105.		[21]	Ai Sugiyama				7-5 6-3
				Ai Sugiyama
106.			Angelique Widjaja	6-3 4-6 6-2
					Nadia Petrova
107.			Nadia Petrova		6-4 6-4
				Nadia Petrova
108.			Greta Arn	6-2 6-1
						Patty Schnyder
109.			Marta Marrero			6-2 4-6 6-3
				Marta Marrero
110.			Jelena Kostanic	7-6(7) 6-1
					Patty Schnyder
111.		[12]	Patty Schnyder		6-3 6-1
				Patty Schnyder
112.			Wynne Prakusya	6-3 6-1
								Venus Williams
113.		[13]	Silvia Farina					6-4 6-3
				Silvia Farina
114.			Flavia Pennetta	6-4 6-2
					Nicole Pratt
115.			Nicole Pratt		6-3 6-2
				Nicole Pratt
116.			Mashona Washington	6-1 7-6(5)
						Nicole Pratt
117.			Tathiana Garbin			7-5 6-4
				Tathiana Garbin
118.		[WC]	Rachel McQuillan	6-4 7-6(3)
					Paola Suarez
119.		[23]	Paola Suarez		6-0 3-0 rtd.
				Paola Suarez
120.			Dally Randriantefy	6-4 6-3
							Venus Williams
121.		[27]	Lisa Raymond				6-3 6-2
				Lisa Raymond
122.		[Q]	Lindsay Lee	7-6(3) 6-3
					Anca Barna
123.			Anca Barna		6-3 6-1
				Anca Barna
124.			Francesca Schiavone	5-7 6-1 6-3
						Venus Williams
125.		[Q]	Ansley Cargill			6-1 6-4
				Ansley Cargill
126.			Anabel Medina-Garrigues	6-1 6-2
					Venus Williams
127.		[2]	Venus Williams		6-3 6-0
				Venus Williams
128.			Svetlana Kuznetsova	6-4 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	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	2
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	2
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` = '2003' LIMIT 1	1	1	3
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` = (187) 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 (10150, 10165, 10068, 10223, 10201, 10278, 10115, 9934, 10253, 10203, 9845, 10359, 10210, 10279, 10116, 10280, 9959, 10261, 10256, 10260, 10098, 10271, 10211, 10281, 10147, 10221, 10184, 10146, 10282, 10326, 9974, 10283, 10192, 10154, 10182, 10122, 10216, 10202, 10123, 10088, 10018, 10077, 10284, 10065, 10276, 10285, 10062, 10126, 9985, 10286, 10024, 10200, 10258, 10266, 10167, 10174, 10254, 10287, 10111, 10101, 10130, 10275, 10262, 10288, 10179, 10289, 10113, 10129, 10187, 10171, 10180, 10290, 10145, 10291, 10292, 10293, 10205, 10172, 10025, 10294, 10193, 10295, 10133, 10160, 10109, 9967, 10128, 10296, 10045, 10257, 10055, 10222, 10297, 10298, 10157, 9997, 10299, 10198, 10095, 10064, 10300, 10090, 10270, 9885, 10070, 10301, 10163, 10224, 10215, 10190, 10356, 10263, 10049, 10302, 9937, 10303, 10170, 9819, 10119, 10083, 10039, 10097, 10194, 10218, 10277, 10208, 10151, 10255) 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` = 187	129	129	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (84, 94, 196, 72, 68, 53, 207, 154, 21, 197, 179, 168, 100, 172, 74, 13, 10, 36, 54, 92, 219, 50, 111, 173, 31, 169, 20, 87, 113, 146, 14, 91, 178, 184, 199, 43)	36	36	2
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (84, 94, 196, 72, 68, 53, 207, 154, 21, 197, 179, 168, 100, 172, 74, 13, 10, 36, 54, 92, 219, 50, 111, 173, 31, 169, 20, 87, 113, 146, 14, 91, 178, 184, 199, 43)	36	36	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10150, 10165, 10068, 10223, 10201, 10278, 10115, 9934, 10253, 10203, 9845, 10359, 10210, 10279, 10116, 10280, 9959, 10261, 10256, 10260, 10098, 10271, 10211, 10281, 10147, 10221, 10184, 10146, 10282, 10326, 9974, 10283, 10192, 10154, 10182, 10122, 10216, 10202, 10123, 10088, 10018, 10077, 10284, 10065, 10276, 10285, 10062, 10126, 9985, 10286, 10024, 10200, 10258, 10266, 10167, 10174, 10254, 10287, 10111, 10101, 10130, 10275, 10262, 10288, 10179, 10289, 10113, 10129, 10187, 10171, 10180, 10290, 10145, 10291, 10292, 10293, 10205, 10172, 10025, 10294, 10193, 10295, 10133, 10160, 10109, 9967, 10128, 10296, 10045, 10257, 10055, 10222, 10297, 10298, 10157, 9997, 10299, 10198, 10095, 10064, 10300, 10090, 10270, 9885, 10070, 10301, 10163, 10224, 10215, 10190, 10356, 10263, 10049, 10302, 9937, 10303, 10170, 9819, 10119, 10083, 10039, 10097, 10194, 10218, 10277, 10208, 10151, 10255)) AND (`Playercontest`.`contest_id` = 187))	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` = 2003	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` = '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` = '2003' 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` = (187) 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 (10150, 10165, 10068, 10223, 10201, 10278, 10115, 9934, 10253, 10203, 9845, 10359, 10210, 10279, 10116, 10280, 9959, 10261, 10256, 10260, 10098, 10271, 10211, 10281, 10147, 10221, 10184, 10146, 10282, 10326, 9974, 10283, 10192, 10154, 10182, 10122, 10216, 10202, 10123, 10088, 10018, 10077, 10284, 10065, 10276, 10285, 10062, 10126, 9985, 10286, 10024, 10200, 10258, 10266, 10167, 10174, 10254, 10287, 10111, 10101, 10130, 10275, 10262, 10288, 10179, 10289, 10113, 10129, 10187, 10171, 10180, 10290, 10145, 10291, 10292, 10293, 10205, 10172, 10025, 10294, 10193, 10295, 10133, 10160, 10109, 9967, 10128, 10296, 10045, 10257, 10055, 10222, 10297, 10298, 10157, 9997, 10299, 10198, 10095, 10064, 10300, 10090, 10270, 9885, 10070, 10301, 10163, 10224, 10215, 10190, 10356, 10263, 10049, 10302, 9937, 10303, 10170, 9819, 10119, 10083, 10039, 10097, 10194, 10218, 10277, 10208, 10151, 10255) 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` = 187

129

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (84, 94, 196, 72, 68, 53, 207, 154, 21, 197, 179, 168, 100, 172, 74, 13, 10, 36, 54, 92, 219, 50, 111, 173, 31, 169, 20, 87, 113, 146, 14, 91, 178, 184, 199, 43)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (84, 94, 196, 72, 68, 53, 207, 154, 21, 197, 179, 168, 100, 172, 74, 13, 10, 36, 54, 92, 219, 50, 111, 173, 31, 169, 20, 87, 113, 146, 14, 91, 178, 184, 199, 43)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10150, 10165, 10068, 10223, 10201, 10278, 10115, 9934, 10253, 10203, 9845, 10359, 10210, 10279, 10116, 10280, 9959, 10261, 10256, 10260, 10098, 10271, 10211, 10281, 10147, 10221, 10184, 10146, 10282, 10326, 9974, 10283, 10192, 10154, 10182, 10122, 10216, 10202, 10123, 10088, 10018, 10077, 10284, 10065, 10276, 10285, 10062, 10126, 9985, 10286, 10024, 10200, 10258, 10266, 10167, 10174, 10254, 10287, 10111, 10101, 10130, 10275, 10262, 10288, 10179, 10289, 10113, 10129, 10187, 10171, 10180, 10290, 10145, 10291, 10292, 10293, 10205, 10172, 10025, 10294, 10193, 10295, 10133, 10160, 10109, 9967, 10128, 10296, 10045, 10257, 10055, 10222, 10297, 10298, 10157, 9997, 10299, 10198, 10095, 10064, 10300, 10090, 10270, 9885, 10070, 10301, 10163, 10224, 10215, 10190, 10356, 10263, 10049, 10302, 9937, 10303, 10170, 9819, 10119, 10083, 10039, 10097, 10194, 10218, 10277, 10208, 10151, 10255)) AND (`Playercontest`.`contest_id` = 187))

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

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)