Australian Open 2006 Women's Singles (January 16 - January 28)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Lindsay Davenport
				Lindsay Davenport
2.		[WC]	Casey Dellacqua	6-2 6-1
					Lindsay Davenport
3.			Karolina Sprem		7-6(4) 6-3
				Karolina Sprem
4.			Alona Bondarenko	6-4 6-2
						Lindsay Davenport
5.			Galina Voskoboeva			6-4 4-6 6-2
				Galina Voskoboeva
6.			Emmanuelle Gagliardi	6-4 6-3
					Maria Kirilenko
7.		[25]	Maria Kirilenko		7-6(1) 6-4
				Maria Kirilenko
8.			Evgenia Linetskaya	6-1 3-1 rtd.
							Lindsay Davenport
9.			Mara Santangelo				6-2 6-4
				Mara Santangelo
10.		[24]	Tatiana Golovin	6-4 4-6 6-4
					Mara Santangelo
11.			Katarina Srebotnik		7-6(5) 5-7 6-3
				Katarina Srebotnik
12.			Stephanie Foretz	6-4 6-3
						Svetlana Kuznetsova
13.			Arantxa Parra-Santonja			6-3 6-1
				Arantxa Parra-Santonja
14.			Tatiana Panova	4-6 7-5 6-1
					Svetlana Kuznetsova
15.		[14]	Svetlana Kuznetsova		6-2 6-7(3) 6-2
				Svetlana Kuznetsova
16.		[WC]	Lauren Breadmore	6-1 6-3
								Justine Henin
17.			Tsvetana Pironkova					2-6 6-2 6-3
				Tsvetana Pironkova
18.		[10]	Venus Williams	2-6 6-0 9-7
					Laura Granville
19.			Laura Granville		7-5 6-2
				Laura Granville
20.		[Q]	Kathrin Woerle	5-7 6-2 6-0
						Virginia Ruano-Pascual
21.			Virginia Ruano-Pascual			6-3 6-3
				Virginia Ruano-Pascual
22.			Lourdes Dominguez-Lino	6-2 7-6(1)
					Virginia Ruano-Pascual
23.		[18]	Elena Likhovtseva		6-4 6-4
				Elena Likhovtseva
24.			Lisa Raymond	7-6(4) 7-6(5)
							Justine Henin
25.			Conchita Martinez-Granados				6-0 6-3
				Conchita Martinez-Granados
26.		[26]	Ai Sugiyama	6-4 6-3
					Virginie Razzano
27.			Virginie Razzano		7-6(3) 6-3
				Virginie Razzano
28.		[WC]	Jelena Dokic	3-6 7-6(6) 6-1
						Justine Henin
29.			Hana Sromova			6-4 6-1
				Hana Sromova
30.			Akiko Morigami	3-0 rtd.
					Justine Henin
31.		[8]	Justine Henin		7-6(2) 6-1
				Justine Henin
32.			Marta Domachowska	6-2 6-1
									Justine Henin
33.		[4]	Maria Sharapova						4-6 6-1 6-4
				Maria Sharapova
34.			Sandra Kloesel	6-2 6-1
					Maria Sharapova
35.		[Q]	Ashley Harkleroad		6-1 7-5
				Ashley Harkleroad
36.			Shuai Peng	6-4 6-1
						Maria Sharapova
37.			Jelena Kostanic			6-0 6-1
				Jelena Kostanic
38.			Mashona Washington	6-1 6-2
					Jelena Kostanic
39.			Zuzana Ondraskova		6-2 6-1
				Zuzana Ondraskova
40.		[28]	Anabel Medina-Garrigues	6-3 6-4
							Maria Sharapova
41.		[17]	Daniela Hantuchova				6-4 6-4
				Daniela Hantuchova
42.			Saori Obata	3-6 6-3 6-0
					Daniela Hantuchova
43.		[WC]	Akgul Amanmuradova		6-4 6-1
				Akgul Amanmuradova
44.			Dally Randriantefy	6-3 2-6 6-1
						Daniela Hantuchova
45.			Camille Pin			6-1 7-6(5)
				Camille Pin
46.			Mariana Diaz-Oliva	2-6 7-5 6-4
					Serena Williams
47.		[13]	Serena Williams		6-3 6-1
				Serena Williams
48.			Na Li	6-3 6-7(1) 6-2
								Maria Sharapova
49.			Julia Schruff					7-6(6) 6-4
				Julia Schruff
50.		[9]	Elena Dementieva	7-5 6-2
					Elena Vesnina
51.			Elena Vesnina		6-0 7-5
				Elena Vesnina
52.		[Q]	Ting Li	6-2 6-3
						Elena Vesnina
53.		[Q]	Olga Savchuk			5-7 6-2 6-4
				Olga Savchuk
54.		[Q]	Tzipora Obziler	6-1 3-6 6-4
					Olga Savchuk
55.		[23]	Jelena Jankovic		6-3 6-4
				Jelena Jankovic
56.			Jill Craybas	6-2 4-6 6-4
							Nadia Petrova
57.			Ekaterina Bychkova				6-3 6-1
				Ekaterina Bychkova
58.		[29]	Klara Koukalova	6-1 5-7 6-2
					Maria Elena Camerin
59.			Maria Elena Camerin		4-6 7-6(7) 6-2
				Maria Elena Camerin
60.		[Q]	Yvonne Meusburger	6-4 6-2
						Nadia Petrova
61.			Martina Muller			6-1 6-2
				Martina Muller
62.		[Q]	Jarmila Gajdosova	1-6 6-2 6-3
					Nadia Petrova
63.		[6]	Nadia Petrova		6-4 6-1
				Nadia Petrova
64.		[WC]	Sophie Ferguson	6-2 6-1
										Amelie Mauresmo
65.		[7]	Patty Schnyder							6-1 2-0 rtd.
				Patty Schnyder
66.			Eleni Daniilidou	6-4 6-3
					Patty Schnyder
67.			Shinobu Asagoe		6-1 7-6(7)
				Shinobu Asagoe
68.			Shahar Peer	3-6 6-1 6-4
						Patty Schnyder
69.			Aiko Nakamura			6-2 6-3
				Aiko Nakamura
70.		[WC]	Alize Cornet	6-2 4-6 6-2
					Aiko Nakamura
71.		[31]	Gisela Dulko		6-1 6-1
				Gisela Dulko
72.			Maret Ani	6-0 7-6(7)
							Patty Schnyder
73.		[19]	Dinara Safina				6-2 6-1
				Dinara Safina
74.			Tathiana Garbin	6-0 6-1
					Sofia Arvidsson
75.			Sofia Arvidsson		6-4 6-0
				Sofia Arvidsson
76.			Maria Vento-Kabchi	6-1 6-2
						Anastasia Myskina
77.			Jamea Jackson			6-3 6-1
				Jamea Jackson
78.		[Q]	Tamarine Tanasugarn	7-6(5) 6-2
					Anastasia Myskina
79.		[12]	Anastasia Myskina		7-6(4) 0-6 6-3
				Anastasia Myskina
80.			Yuliana Fedak	7-6(6) 6-1
								Amelie Mauresmo
81.		[16]	Nicole Vaidisova					6-3 6-0
				Nicole Vaidisova
82.		[Q]	Anastasia Yakimova	6-1 6-3
					Nicole Vaidisova
83.			Anna Chakvetadze		6-2 6-1
				Anna Chakvetadze
84.			Jie Zheng	5-7 6-2 6-4
						Nicole Vaidisova
85.			Martina Sucha			6-4 6-2
				Martina Sucha
86.			Anna Smashnova	3-6 6-3 6-4
					Flavia Pennetta
87.		[20]	Flavia Pennetta		6-3 6-0
				Flavia Pennetta
88.		[Q]	Cara Black	6-2 2-6 6-3
							Amelie Mauresmo
89.		[32]	Sania Mirza				6-1 6-1
				Sania Mirza
90.		[Q]	Victoria Azarenka	7-6(6) 6-2
					Michaella Krajicek
91.			Michaella Krajicek		6-3 7-5
				Michaella Krajicek
92.			Kristina Brandi	6-4 7-6(1)
						Amelie Mauresmo
93.			Emilie Loit			6-2 rtd.
				Emilie Loit
94.			Viktoriya Kutuzova	6-2 6-0
					Amelie Mauresmo
95.		[3]	Amelie Mauresmo		7-6(1) 6-2
				Amelie Mauresmo
96.			Tian-Tian Sun	4-6 6-2 6-2
									Amelie Mauresmo
97.		[5]	Mary Pierce						5-7 6-2 3-2 rtd.
				Mary Pierce
98.		[WC]	Nicole Pratt	6-1 6-1
					Iveta Benesova
99.			Iveta Benesova		6-3 7-5
				Iveta Benesova
100.			Rika Fujiwara	2-6 6-1 7-5
						Martina Hingis
101.			Emma Laine			6-4 6-1
				Emma Laine
102.			Nuria Llagostera-Vives	6-1 6-1
					Martina Hingis
103.		[WC]	Martina Hingis		6-1 6-1
				Martina Hingis
104.		[30]	Vera Zvonareva	6-1 6-2
							Martina Hingis
105.		[21]	Ana Ivanovic				6-1 7-6(8)
				Ana Ivanovic
106.			Shenay Perry	6-4 6-4
					Samantha Stosur
107.			Samantha Stosur		6-3 7-5
				Samantha Stosur
108.			Severine Beltrame	6-3 6-4
						Samantha Stosur
109.			Sybille Bammer			7-5 4-6 6-3
				Sybille Bammer
110.			Eva Birnerova	7-5 6-4
					Sybille Bammer
111.			Yan Zi		6-3 6-4
				Yan Zi
112.		[11]	Nathalie Dechy	6-7(5) 6-2 6-3
								Kim Clijsters
113.		[15]	Francesca Schiavone					6-3 2-6 6-4
				Francesca Schiavone
114.			Antonella Serra-Zanetti	6-2 7-5
					Francesca Schiavone
115.			Catalina Castano		6-1 4-6 6-3
				Catalina Castano
116.			Vera Dushevina	5-7 6-3 6-1
						Francesca Schiavone
117.			Maria Sanchez Lorenzo			6-0 6-0
				Maria Sanchez Lorenzo
118.			Lucie Safarova	6-4 6-3
					Maria Sanchez Lorenzo
119.		[22]	Anna-Lena Groenefeld		4-6 6-4 6-1
				Anna-Lena Groenefeld
120.			Laura Pous-Tio	2-6 6-4 7-5
							Kim Clijsters
121.		[27]	Marion Bartoli				7-6(5) 6-4
				Marion Bartoli
122.			Amy Frazier	6-3 6-2
					Roberta Vinci
123.			Roberta Vinci		6-4 3-6 6-3
				Roberta Vinci
124.			Meghann Shaughnessy	7-5 6-4
						Kim Clijsters
125.		[Q]	Meng Yuan			6-1 6-2
				Meng Yuan
126.			Melinda Czink	6-4 6-2
					Kim Clijsters
127.		[2]	Kim Clijsters		6-4 6-2
				Kim Clijsters
128.			Cho Yoon-Jeong	6-3 6-0

(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` = '2006' 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` = (190) 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 (10025, 10285, 10320, 10343, 10361, 10130, 10360, 10354, 10306, 10317, 10180, 10297, 10319, 10145, 10255, 10362, 10363, 10151, 10278, 10364, 10055, 10365, 10064, 10039, 10359, 10070, 10187, 10173, 10366, 10292, 10179, 10349, 10326, 10142, 10323, 10335, 10190, 10303, 10307, 10208, 10299, 10265, 10367, 10083, 10294, 10146, 10150, 10351, 10348, 10174, 10368, 10350, 10369, 10181, 10284, 10171, 10370, 10282, 10264, 10371, 10266, 10372, 10163, 10325, 10356, 10253, 10222, 10373, 10333, 10374, 10316, 10375, 10290, 10170, 10324, 10105, 10376, 10115, 10262, 10310, 10330, 10336, 10342, 10322, 10223, 10062, 10302, 10160, 10353, 10377, 10339, 10124, 10165, 10378, 10152, 10379, 10024, 9937, 10279, 10380, 10381, 10221, 10078, 10281, 10355, 10305, 10270, 10382, 10383, 10315, 10384, 10116, 10218, 10258, 10337, 10321, 10090, 10385, 10345, 10386, 10261, 9845, 10387, 10147, 10388, 10286, 10192, 10256) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	3
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` = 190	128	128	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (199, 63, 178, 94, 20, 14, 68, 53, 207, 194, 151, 13, 154, 92, 43, 100, 21, 197, 84, 74, 10, 149, 173, 179, 168, 72, 216, 50, 133, 67, 42, 86, 91, 31, 113, 169, 184, 201, 96)	39	39	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (199, 63, 178, 94, 20, 14, 68, 53, 207, 194, 151, 13, 154, 92, 43, 100, 21, 197, 84, 74, 10, 149, 173, 179, 168, 72, 216, 50, 133, 67, 42, 86, 91, 31, 113, 169, 184, 201, 96)	39	39	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10025, 10285, 10320, 10343, 10361, 10130, 10360, 10354, 10306, 10317, 10180, 10297, 10319, 10145, 10255, 10362, 10363, 10151, 10278, 10364, 10055, 10365, 10064, 10039, 10359, 10070, 10187, 10173, 10366, 10292, 10179, 10349, 10326, 10142, 10323, 10335, 10190, 10303, 10307, 10208, 10299, 10265, 10367, 10083, 10294, 10146, 10150, 10351, 10348, 10174, 10368, 10350, 10369, 10181, 10284, 10171, 10370, 10282, 10264, 10371, 10266, 10372, 10163, 10325, 10356, 10253, 10222, 10373, 10333, 10374, 10316, 10375, 10290, 10170, 10324, 10105, 10376, 10115, 10262, 10310, 10330, 10336, 10342, 10322, 10223, 10062, 10302, 10160, 10353, 10377, 10339, 10124, 10165, 10378, 10152, 10379, 10024, 9937, 10279, 10380, 10381, 10221, 10078, 10281, 10355, 10305, 10270, 10382, 10383, 10315, 10384, 10116, 10218, 10258, 10337, 10321, 10090, 10385, 10345, 10386, 10261, 9845, 10387, 10147, 10388, 10286, 10192, 10256)) AND (`Playercontest`.`contest_id` = 190))	128	128	3
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` = 2006	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` = '2006' 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` = (190) 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 (10025, 10285, 10320, 10343, 10361, 10130, 10360, 10354, 10306, 10317, 10180, 10297, 10319, 10145, 10255, 10362, 10363, 10151, 10278, 10364, 10055, 10365, 10064, 10039, 10359, 10070, 10187, 10173, 10366, 10292, 10179, 10349, 10326, 10142, 10323, 10335, 10190, 10303, 10307, 10208, 10299, 10265, 10367, 10083, 10294, 10146, 10150, 10351, 10348, 10174, 10368, 10350, 10369, 10181, 10284, 10171, 10370, 10282, 10264, 10371, 10266, 10372, 10163, 10325, 10356, 10253, 10222, 10373, 10333, 10374, 10316, 10375, 10290, 10170, 10324, 10105, 10376, 10115, 10262, 10310, 10330, 10336, 10342, 10322, 10223, 10062, 10302, 10160, 10353, 10377, 10339, 10124, 10165, 10378, 10152, 10379, 10024, 9937, 10279, 10380, 10381, 10221, 10078, 10281, 10355, 10305, 10270, 10382, 10383, 10315, 10384, 10116, 10218, 10258, 10337, 10321, 10090, 10385, 10345, 10386, 10261, 9845, 10387, 10147, 10388, 10286, 10192, 10256) 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` = 190

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (199, 63, 178, 94, 20, 14, 68, 53, 207, 194, 151, 13, 154, 92, 43, 100, 21, 197, 84, 74, 10, 149, 173, 179, 168, 72, 216, 50, 133, 67, 42, 86, 91, 31, 113, 169, 184, 201, 96)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (199, 63, 178, 94, 20, 14, 68, 53, 207, 194, 151, 13, 154, 92, 43, 100, 21, 197, 84, 74, 10, 149, 173, 179, 168, 72, 216, 50, 133, 67, 42, 86, 91, 31, 113, 169, 184, 201, 96)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10025, 10285, 10320, 10343, 10361, 10130, 10360, 10354, 10306, 10317, 10180, 10297, 10319, 10145, 10255, 10362, 10363, 10151, 10278, 10364, 10055, 10365, 10064, 10039, 10359, 10070, 10187, 10173, 10366, 10292, 10179, 10349, 10326, 10142, 10323, 10335, 10190, 10303, 10307, 10208, 10299, 10265, 10367, 10083, 10294, 10146, 10150, 10351, 10348, 10174, 10368, 10350, 10369, 10181, 10284, 10171, 10370, 10282, 10264, 10371, 10266, 10372, 10163, 10325, 10356, 10253, 10222, 10373, 10333, 10374, 10316, 10375, 10290, 10170, 10324, 10105, 10376, 10115, 10262, 10310, 10330, 10336, 10342, 10322, 10223, 10062, 10302, 10160, 10353, 10377, 10339, 10124, 10165, 10378, 10152, 10379, 10024, 9937, 10279, 10380, 10381, 10221, 10078, 10281, 10355, 10305, 10270, 10382, 10383, 10315, 10384, 10116, 10218, 10258, 10337, 10321, 10090, 10385, 10345, 10386, 10261, 9845, 10387, 10147, 10388, 10286, 10192, 10256)) AND (`Playercontest`.`contest_id` = 190))

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

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)