Australian Open 2008 Women's Singles (January 14 - January 26)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Justine Henin
				Justine Henin
2.			Aiko Nakamura	6-2 6-2
					Justine Henin
3.			Olga Poutchkova		6-1 7-5
				Olga Poutchkova
4.		[WC]	Monique Adamczak	6-4 6-0
						Justine Henin
5.			Angelique Kerber			7-5 6-4
				Angelique Kerber
6.			Maret Ani	0-6 6-3 6-2
					Francesca Schiavone
7.		[25]	Francesca Schiavone		6-2 6-3
				Francesca Schiavone
8.			Emilie Loit	6-3 7-6(5)
							Justine Henin
9.		[19]	Sybille Bammer				6-2 6-2
				Sybille Bammer
10.		[Q]	Tamarine Tanasugarn	6-7(6) 6-4 6-2
					Su-Wei Hsieh
11.		[Q]	Su-Wei Hsieh		6-2 6-0
				Su-Wei Hsieh
12.			Klara Koukalova	2-6 6-4 8-6
						Su-Wei Hsieh
13.			Aravane Rezai			6-2 6-7(3) 6-4
				Aravane Rezai
14.			Kateryna Bondarenko	7-6(4) 6-2
					Aravane Rezai
15.		[13]	Tatiana Golovin		6-3 3-6 6-3
				Tatiana Golovin
16.			Stephanie Cohen-Aloro	6-1 4-6 6-3
								Maria Sharapova
17.		[11]	Elena Dementieva					6-4 6-0
				Elena Dementieva
18.			Tzipora Obziler	6-2 6-2
					Elena Dementieva
19.			Anabel Medina-Garrigues		5-7 6-2 6-3
				Anabel Medina-Garrigues
20.			Petra Cetkovska	7-6(1) 6-0
						Elena Dementieva
21.		[WC]	Jessica Moore			6-2 6-0
				Jessica Moore
22.			Julie Ditty	6-3 6-2
					Shahar Peer
23.		[17]	Shahar Peer		6-0 7-5
				Shahar Peer
24.			Renata Voracova	6-2 2-6 6-0
							Maria Sharapova
25.			Elena Vesnina				6-2 6-0
				Elena Vesnina
26.		[32]	Julia Vakulenko	6-4 1-6 6-4
					Elena Vesnina
27.			Jill Craybas		6-2 6-4
				Jill Craybas
28.			Yung-Jan Chan	6-4 6-2
						Maria Sharapova
29.			Lindsay Davenport			6-3 6-0
				Lindsay Davenport
30.			Sara Errani	6-2 3-6 7-5
					Maria Sharapova
31.		[5]	Maria Sharapova		6-1 6-3
				Maria Sharapova
32.			Jelena Kostanic	6-4 6-3
									Maria Sharapova
33.		[3]	Jelena Jankovic						6-3 6-1
				Jelena Jankovic
34.			Tamira Paszek	2-6 6-2 12-10
					Jelena Jankovic
35.			Edina Gallovits		6-2 7-5
				Edina Gallovits
36.			Stephanie Dubois	7-6(7) 6-3
						Jelena Jankovic
37.			Flavia Pennetta			6-2 4-6 6-1
				Flavia Pennetta
38.			Dominika Cibulkova	6-4 5-7 6-4
					Virginie Razzano
39.		[30]	Virginie Razzano		6-2 5-7 6-3
				Virginie Razzano
40.			Ashley Harkleroad	6-3 7-5
							Jelena Jankovic
41.		[18]	Amelie Mauresmo				7-6(3) 6-1
				Amelie Mauresmo
42.			Tatiana Poutchek	6-7(6) 6-0 6-0
					Amelie Mauresmo
43.			Yaroslava Shvedova		6-4 7-6(5)
				Yaroslava Shvedova
44.			Tatjana Malek	6-2 6-2
						Casey Dellacqua
45.			Casey Dellacqua			3-6 6-4 6-4
				Casey Dellacqua
46.			Karin Knapp	4-6 6-3 8-6
					Casey Dellacqua
47.		[15]	Patty Schnyder		4-6 7-5 8-6
				Patty Schnyder
48.			Lilia Osterloh	6-3 6-3
								Jelena Jankovic
49.		[12]	Nicole Vaidisova					6-3 6-4
				Nicole Vaidisova
50.			Ioana Raluca Olaru	6-3 6-0
					Nicole Vaidisova
51.			Alicia Molik		6-2 6-3
				Alicia Molik
52.			Kaia Kanepi	7-6(4) 7-5
						Nicole Vaidisova
53.			Tatiana Perebiynis			6-3 6-4
				Tatiana Perebiynis
54.		[WC]	Madison Brengle	7-5 6-2
					Ai Sugiyama
55.			Ai Sugiyama		6-4 6-4
				Ai Sugiyama
56.		[23]	Vera Zvonareva	6-3 1-1 rtd.
							Serena Williams
57.		[26]	Victoria Azarenka				6-3 6-4
				Victoria Azarenka
58.			Akgul Amanmuradova	6-2 7-5
					Victoria Azarenka
59.		[Q]	Sandra Kloesel		6-1 6-1
				Sandra Kloesel
60.		[Q]	Julia Schruff	6-1 6-7(1) 6-4
						Serena Williams
61.		[Q]	Meng Yuan			6-3 6-4
				Meng Yuan
62.		[Q]	Ekaterina Ivanova	4-6 6-4 6-2
					Serena Williams
63.		[7]	Serena Williams		6-3 6-1
				Serena Williams
64.		[WC]	Jarmila Gajdosova	6-3 6-3
										Maria Sharapova
65.		[8]	Venus Williams							7-5 6-3
				Venus Williams
66.			Yan Zi	6-2 7-5
					Venus Williams
67.			Camille Pin		7-5 6-4
				Camille Pin
68.		[Q]	Monica Niculescu	5-7 6-1 6-1
						Venus Williams
69.		[Q]	Timea Bacsinszky			7-6(0) 6-4
				Timea Bacsinszky
70.		[WC]	Sophie Ferguson	6-4 6-3
					Sania Mirza
71.		[31]	Sania Mirza		6-1 4-6 7-5
				Sania Mirza
72.		[WC]	Iroda Tulyaganova	6-4 6-2
							Venus Williams
73.		[24]	Na Li				6-4 6-4
				Na Li
74.			Severine Beltrame	6-2 4-6 6-4
					Na Li
75.			Maria Elena Camerin		6-4 6-3
				Maria Elena Camerin
76.		[WC]	Christina Wheeler	6-1 6-2
						Marta Domachowska
77.		[Q]	Marta Domachowska			2-6 6-2 6-4
				Marta Domachowska
78.		[WC]	Mathilde Johansson	6-1 6-1
					Marta Domachowska
79.			Sofia Arvidsson		7-5 1-6 6-1
				Sofia Arvidsson
80.		[10]	Marion Bartoli	6-7(3) 6-4 6-3
								Ana Ivanovic
81.		[Q]	Sabine Lisicki					7-6(3) 6-4
				Sabine Lisicki
82.		[16]	Dinara Safina	7-6(4) 4-6 6-2
					Sabine Lisicki
83.			Mariya Koryttseva		6-1 7-5
				Mariya Koryttseva
84.			Maria-Emilia Salerni	6-2 6-3
						Caroline Wozniacki
85.			Caroline Wozniacki			4-6 6-4 6-3
				Caroline Wozniacki
86.			Gisela Dulko	6-1 6-1
					Caroline Wozniacki
87.		[21]	Alona Bondarenko		7-6(4) 6-1
				Alona Bondarenko
88.			Alla Kudryavtseva	6-4 7-6(4)
							Ana Ivanovic
89.		[28]	Katarina Srebotnik				6-1 7-6(2)
				Katarina Srebotnik
90.			Lourdes Dominguez-Lino	4-6 6-0 9-7
					Katarina Srebotnik
91.			Anastasia Rodionova		6-4 6-1
				Anastasia Rodionova
92.		[Q]	Angelika Bachmann	7-6(3) 6-4
						Ana Ivanovic
93.			Tathiana Garbin			6-3 6-4
				Tathiana Garbin
94.			Eleni Daniilidou	6-2 6-2
					Ana Ivanovic
95.		[4]	Ana Ivanovic		6-0 6-3
				Ana Ivanovic
96.			Sorana Cirstea	7-5 6-3
									Ana Ivanovic
97.		[6]	Anna Chakvetadze						0-6 6-3 6-4
				Anna Chakvetadze
98.			Andrea Petkovic	0-0 rtd.
					Anna Chakvetadze
99.		[Q]	Alisa Kleybanova		6-3 6-4
				Alisa Kleybanova
100.			Shuai Peng	7-5 4-6 9-7
						Maria Kirilenko
101.			Akiko Morigami			6-7(6) 6-1 6-2
				Akiko Morigami
102.			Michaella Krajicek	6-2 6-2
					Maria Kirilenko
103.		[27]	Maria Kirilenko		6-1 6-1
				Maria Kirilenko
104.			Meilen Tu	6-4 4-6 6-3
							Daniela Hantuchova
105.			Catalina Castano				1-6 6-4 6-4
				Catalina Castano
106.		[22]	Lucie Safarova	6-1 6-4
					Virginia Ruano-Pascual
107.			Virginia Ruano-Pascual		6-2 6-4
				Virginia Ruano-Pascual
108.			Roberta Vinci	6-4 6-4
						Daniela Hantuchova
109.			Alize Cornet			6-2 6-3
				Alize Cornet
110.			Clarisa Fernandez	6-3 6-3
					Daniela Hantuchova
111.		[9]	Daniela Hantuchova		6-2 7-5
				Daniela Hantuchova
112.			Vania King	6-3 7-5
								Daniela Hantuchova
113.		[14]	Nadia Petrova					6-2 6-2
				Nadia Petrova
114.			Nicole Pratt	6-1 6-3
					Nadia Petrova
115.			Anne Kremer		7-5 7-5
				Anne Kremer
116.			Evgenia Linetskaya	7-6(8) 6-0
						Nadia Petrova
117.			Yvonne Meusburger			6-1 7-6(8)
				Yvonne Meusburger
118.			Laura Granville	6-1 6-4
					Ekaterina Makarova
119.			Ekaterina Makarova		6-3 6-1
				Ekaterina Makarova
120.		[20]	Agnes Szavay	3-6 6-4 7-5
							Agnieszka Radwanska
121.		[29]	Agnieszka Radwanska				1-6 7-5 6-0
				Agnieszka Radwanska
122.			Olga Savchuk	6-0 6-1
					Agnieszka Radwanska
123.			Pauline Parmentier		7-5 6-4
				Pauline Parmentier
124.			Martina Muller	7-5 6-3
						Agnieszka Radwanska
125.			Tsvetana Pironkova			6-3 6-4
				Tsvetana Pironkova
126.			Olga Govortsova	6-1 6-1
					Svetlana Kuznetsova
127.		[2]	Svetlana Kuznetsova		7-6(0) 6-2
				Svetlana Kuznetsova
128.			Nathalie Dechy	6-3 6-1

(default) 17 queries took 24 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	4
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` = '2008' LIMIT 1	1	1	1
8	SELECT `Match`.`id`, `Match`.`contest_id`, `Match`.`player_a_id`, `Match`.`player_aa_id`, `Match`.`player_b_id`, `Match`.`player_bb_id`, `Match`.`results`, `Match`.`long`, `Match`.`attendance`, `Match`.`no`, `Match`.`round`, `Match`.`round_id`, `Match`.`note`, `Match`.`created`, `Match`.`created_by`, `Match`.`modified`, `Match`.`modified_by` FROM `zavoihu1_db4tennis`.`matches` AS `Match` WHERE `Match`.`contest_id` = (192) 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, 10333, 10412, 10332, 10413, 10375, 10218, 10165, 10383, 10115, 10414, 10282, 10403, 10462, 10317, 10327, 10174, 10181, 10208, 10415, 10408, 10416, 10373, 10392, 10368, 10314, 10171, 10451, 10025, 10417, 10326, 10190, 10284, 10393, 10407, 10418, 10302, 10419, 10187, 10323, 10152, 10216, 10420, 10449, 10285, 10421, 10356, 10175, 10330, 10422, 10172, 10398, 10312, 10400, 10070, 10281, 10377, 10367, 10142, 10348, 10388, 10423, 10150, 10372, 10151, 10384, 10294, 10434, 10433, 10325, 10353, 10205, 10351, 10382, 10264, 10214, 10349, 10432, 10324, 10261, 10430, 10290, 10431, 10257, 10440, 10316, 10343, 10390, 10180, 10365, 10391, 10313, 10170, 10253, 10355, 10429, 10342, 10428, 10427, 10335, 10292, 10339, 10360, 10126, 10337, 10385, 10055, 10387, 10374, 10254, 10299, 10396, 10163, 9937, 10128, 10354, 10371, 10278, 10458, 10426, 10394, 10369, 10425, 10266, 10363, 10424, 10255, 10116) 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` = 192	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (42, 54, 197, 13, 53, 92, 154, 194, 199, 184, 84, 94, 169, 96, 72, 179, 10, 173, 68, 149, 20, 31, 91, 14, 153, 86, 111, 133, 50, 63, 164, 181, 21, 168, 36, 74, 43, 178)	38	38	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (42, 54, 197, 13, 53, 92, 154, 194, 199, 184, 84, 94, 169, 96, 72, 179, 10, 173, 68, 149, 20, 31, 91, 14, 153, 86, 111, 133, 50, 63, 164, 181, 21, 168, 36, 74, 43, 178)	38	38	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10179, 10333, 10412, 10332, 10413, 10375, 10218, 10165, 10383, 10115, 10414, 10282, 10403, 10462, 10317, 10327, 10174, 10181, 10208, 10415, 10408, 10416, 10373, 10392, 10368, 10314, 10171, 10451, 10025, 10417, 10326, 10190, 10284, 10393, 10407, 10418, 10302, 10419, 10187, 10323, 10152, 10216, 10420, 10449, 10285, 10421, 10356, 10175, 10330, 10422, 10172, 10398, 10312, 10400, 10070, 10281, 10377, 10367, 10142, 10348, 10388, 10423, 10150, 10372, 10151, 10384, 10294, 10434, 10433, 10325, 10353, 10205, 10351, 10382, 10264, 10214, 10349, 10432, 10324, 10261, 10430, 10290, 10431, 10257, 10440, 10316, 10343, 10390, 10180, 10365, 10391, 10313, 10170, 10253, 10355, 10429, 10342, 10428, 10427, 10335, 10292, 10339, 10360, 10126, 10337, 10385, 10055, 10387, 10374, 10254, 10299, 10396, 10163, 9937, 10128, 10354, 10371, 10278, 10458, 10426, 10394, 10369, 10425, 10266, 10363, 10424, 10255, 10116)) AND (`Playercontest`.`contest_id` = 192))	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` = 2008	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 24 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` = '2008' 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` = (192) 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, 10333, 10412, 10332, 10413, 10375, 10218, 10165, 10383, 10115, 10414, 10282, 10403, 10462, 10317, 10327, 10174, 10181, 10208, 10415, 10408, 10416, 10373, 10392, 10368, 10314, 10171, 10451, 10025, 10417, 10326, 10190, 10284, 10393, 10407, 10418, 10302, 10419, 10187, 10323, 10152, 10216, 10420, 10449, 10285, 10421, 10356, 10175, 10330, 10422, 10172, 10398, 10312, 10400, 10070, 10281, 10377, 10367, 10142, 10348, 10388, 10423, 10150, 10372, 10151, 10384, 10294, 10434, 10433, 10325, 10353, 10205, 10351, 10382, 10264, 10214, 10349, 10432, 10324, 10261, 10430, 10290, 10431, 10257, 10440, 10316, 10343, 10390, 10180, 10365, 10391, 10313, 10170, 10253, 10355, 10429, 10342, 10428, 10427, 10335, 10292, 10339, 10360, 10126, 10337, 10385, 10055, 10387, 10374, 10254, 10299, 10396, 10163, 9937, 10128, 10354, 10371, 10278, 10458, 10426, 10394, 10369, 10425, 10266, 10363, 10424, 10255, 10116) 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` = 192

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (42, 54, 197, 13, 53, 92, 154, 194, 199, 184, 84, 94, 169, 96, 72, 179, 10, 173, 68, 149, 20, 31, 91, 14, 153, 86, 111, 133, 50, 63, 164, 181, 21, 168, 36, 74, 43, 178)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (42, 54, 197, 13, 53, 92, 154, 194, 199, 184, 84, 94, 169, 96, 72, 179, 10, 173, 68, 149, 20, 31, 91, 14, 153, 86, 111, 133, 50, 63, 164, 181, 21, 168, 36, 74, 43, 178)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10179, 10333, 10412, 10332, 10413, 10375, 10218, 10165, 10383, 10115, 10414, 10282, 10403, 10462, 10317, 10327, 10174, 10181, 10208, 10415, 10408, 10416, 10373, 10392, 10368, 10314, 10171, 10451, 10025, 10417, 10326, 10190, 10284, 10393, 10407, 10418, 10302, 10419, 10187, 10323, 10152, 10216, 10420, 10449, 10285, 10421, 10356, 10175, 10330, 10422, 10172, 10398, 10312, 10400, 10070, 10281, 10377, 10367, 10142, 10348, 10388, 10423, 10150, 10372, 10151, 10384, 10294, 10434, 10433, 10325, 10353, 10205, 10351, 10382, 10264, 10214, 10349, 10432, 10324, 10261, 10430, 10290, 10431, 10257, 10440, 10316, 10343, 10390, 10180, 10365, 10391, 10313, 10170, 10253, 10355, 10429, 10342, 10428, 10427, 10335, 10292, 10339, 10360, 10126, 10337, 10385, 10055, 10387, 10374, 10254, 10299, 10396, 10163, 9937, 10128, 10354, 10371, 10278, 10458, 10426, 10394, 10369, 10425, 10266, 10363, 10424, 10255, 10116)) AND (`Playercontest`.`contest_id` = 192))

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

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)