Australian Open 2002 Women's Singles (January 14 - January 27)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Jennifer Capriati
				Jennifer Capriati
2.			Silvija Talaja	6-4 6-1
					Jennifer Capriati
3.			Meilen Tu		6-1 6-3
				Meilen Tu
4.			Joanette Kruger	7-6(2) 6-0
						Jennifer Capriati
5.			Eleni Daniilidou			6-2 3-6 6-1
				Eleni Daniilidou
6.			Rita Kuti-Kis	4-6 7-6(2) 6-4
					Eleni Daniilidou
7.		[29]	Tatiana Panova		6-2 4-6 6-0
				Tatiana Panova
8.			Alicia Molik	1-6 6-3 10-8
							Jennifer Capriati
9.		[20]	Rita Grande				6-3 7-6(9)
				Rita Grande
10.		[Q]	Clarisa Fernandez	7-6(4) 6-4
					Rita Grande
11.		[Q]	Kristie Boogert		7-6(4) 7-5
				Kristie Boogert
12.		[Q]	Gloria Pizzichini	6-3 6-3
						Rita Grande
13.		[Q]	Svetlana Kuznetsova			6-3 5-7 6-4
				Svetlana Kuznetsova
14.		[WC]	Cho Yoon-Jeong	6-3 2-6 6-4
					Iroda Tulyaganova
15.		[16]	Iroda Tulyaganova		6-4 6-1
				Iroda Tulyaganova
16.		[Q]	Maria-Emilia Salerni	6-3 6-4
								Jennifer Capriati
17.		[10]	Meghann Shaughnessy					6-2 6-2
				Meghann Shaughnessy
18.			Alexandra Stevenson	6-7(5) 6-2 7-5
					Meghann Shaughnessy
19.		[WC]	Bryanne Stewart		6-2 6-0
				Bryanne Stewart
20.			Jana Nejedly	6-4 6-4
						Marlene Weingartner
21.		[Q]	Antonella Serra-Zanetti			6-2 3-6 6-3
				Antonella Serra-Zanetti
22.			Elena Bovina	6-2 2-6 7-5
					Marlene Weingartner
23.			Marlene Weingartner		6-4 6-2
				Marlene Weingartner
24.		[19]	Angeles Montolio	6-3 6-3
							Amelie Mauresmo
25.		[25]	Tamarine Tanasugarn				6-0 4-6 7-5
				Tamarine Tanasugarn
26.			Selima Sfar	6-4 6-3
					Tamarine Tanasugarn
27.			Petra Mandula		2-6 6-2 6-2
				Petra Mandula
28.			Anca Barna	6-4 6-4
						Amelie Mauresmo
29.			Katarina Srebotnik			7-6(3) 6-1
				Katarina Srebotnik
30.			Anna Smashnova	6-2 6-2
					Amelie Mauresmo
31.		[7]	Amelie Mauresmo		7-5 6-3
				Amelie Mauresmo
32.			Janet Lee	6-1 6-0
									Jennifer Capriati
33.		[4]	Kim Clijsters						7-5 3-6 6-1
				Kim Clijsters
34.		[WC]	Christina Wheeler	6-2 6-1
					Kim Clijsters
35.			Barbara Schwartz		6-1 6-1
				Barbara Schwartz
36.		[Q]	Eva Dyrberg	6-1 6-4
						Janette Husarova
37.		[WC]	Cindy Watson			6-2 6-3
				Cindy Watson
38.			Maria Jose Martinez-Sanchez	6-3 6-3
					Cindy Watson
39.			Emmanuelle Gagliardi		3-6 7-5 6-2
				Emmanuelle Gagliardi
40.		[30]	Elena Likhovtseva	6-1 6-7(7) 8-6
							Kim Clijsters
41.		[24]	Ai Sugiyama				6-0 6-2
				Ai Sugiyama
42.			Rachel McQuillan	6-7(7) 6-3 6-3
					Ai Sugiyama
43.			Tina Pisnik		7-6(2) 6-0
				Tina Pisnik
44.		[WC]	Marion Bartoli	6-3 4-6 9-7
						Elena Dementieva
45.			Janette Husarova			6-1 6-2
				Janette Husarova
46.		[LL]	Pavlina Stoyanova	6-1 6-0
					Janette Husarova
47.			Iva Majoli		6-4 6-3
				Iva Majoli
48.		[14]	Arantxa Sanchez-Vicario	6-4 7-5
								Kim Clijsters
49.		[12]	Elena Dementieva					6-2 6-3
				Elena Dementieva
50.			Alina Jidkova	6-3 6-2
					Elena Dementieva
51.			Anastasia Myskina		6-4 6-2
				Anastasia Myskina
52.			Wynne Prakusya	6-7(3) 6-2 6-2
						Justine Henin
53.			Maria Elena Camerin			6-4 6-0
				Maria Elena Camerin
54.			Saori Obata	7-5 6-4
					Magui Serna
55.		[23]	Magui Serna		6-3 6-3
				Magui Serna
56.		[WC]	Amanda Grahame	6-3 6-3
							Justine Henin
57.			Martina Muller				6-0 6-3
				Martina Muller
58.		[27]	Paola Suarez	6-3 6-4
					Nicole Pratt
59.			Nicole Pratt		6-1 6-2
				Nicole Pratt
60.			Zsofia Gubacsi	6-7(6) 6-2 6-3
						Martina Sucha
61.			Marta Marrero			6-0 6-4
				Marta Marrero
62.			Adriana Gersi	6-4 6-2
					Justine Henin
63.		[6]	Justine Henin		6-3 3-6 6-1
				Justine Henin
64.			Anna Kournikova	6-2 7-5
										Jennifer Capriati
65.			Conchita Martinez							4-6 7-6(7) 6-2
				Conchita Martinez
66.		[33]	Lina Krasnoroutskaya	3-6 6-3 2-0 rtd.
					Asa Carlsson
67.			Asa Carlsson		6-4 6-1
				Asa Carlsson
68.			Evie Dominikovic	6-3 6-2
						Adriana Serra-Zanetti
69.			Martina Sucha			6-2 4-6 6-4
				Martina Sucha
70.			Gala Leon Garcia	1-6 6-2 6-4
					Martina Sucha
71.			Mariana Diaz-Oliva		6-1 7-5
				Mariana Diaz-Oliva
72.		[26]	Cristina Torrens-Valero	7-5 6-4
							Adriana Serra-Zanetti
73.			Amy Frazier				6-1 7-5
				Amy Frazier
74.		[22]	Henrieta Nagyova	7-5 6-4
					Adriana Serra-Zanetti
75.			Adriana Serra-Zanetti		6-3 7-6(5)
				Adriana Serra-Zanetti
76.			Virginia Ruano-Pascual	6-2 2-6 7-5
						Amanda Coetzer
77.			Jennifer Hopkins			6-3 6-3
				Jennifer Hopkins
78.			Irina Selyutina	6-2 0-6 6-2
					Silvia Farina
79.		[11]	Silvia Farina		6-2 6-0
				Silvia Farina
80.			Lilia Osterloh	6-4 3-6 6-4
								Martina Hingis
81.		[15]	Amanda Coetzer					6-2 6-3
				Amanda Coetzer
82.			Miriam Oremans	6-1 6-1
					Amanda Coetzer
83.			Rossana De Los Rios		6-3 6-1
				Rossana De Los Rios
84.		[Q]	Elena Tatarkova	6-3 6-2
						Martina Hingis
85.			Nuria Llagostera-Vives			6-1 6-0
				Nuria Llagostera-Vives
86.			Jana Kandarr	6-0 6-1
					Barbara Schett
87.		[17]	Barbara Schett		6-2 1-6 6-2
				Barbara Schett
88.			Andrea Glass	6-2 6-4
							Martina Hingis
89.		[28]	Anne Kremer				6-1 6-0
				Anne Kremer
90.			Denisa Chladkova	6-3 6-4
					Barbara Rittner
91.			Barbara Rittner		6-1 6-4
				Barbara Rittner
92.			Eva Bes	6-3 6-4
						Monica Seles
93.		[Q]	Greta Arn			6-4 6-4
				Greta Arn
94.		[WC]	Samantha Stosur	6-2 4-6 6-2
					Martina Hingis
95.		[3]	Martina Hingis		6-1 6-2
				Martina Hingis
96.			Virginie Razzano	6-2 6-2
									Martina Hingis
97.		[8]	Monica Seles						4-6 6-1 6-4
				Monica Seles
98.			Patty Schnyder	6-1 6-2
					Monica Seles
99.			Cara Black		6-1 6-1
				Cara Black
100.			Emilie Loit	7-5 6-3
						Anabel Medina-Garrigues
101.		[Q]	Jelena Kostanic			6-3 6-2
				Jelena Kostanic
102.			Samantha Reeves	6-0 6-7(6) 6-3
					Francesca Schiavone
103.		[31]	Francesca Schiavone		6-1 6-2
				Francesca Schiavone
104.			Aniko Kapros	4-6 6-3 8-6
							Monica Seles
105.		[21]	Daja Bedanova				4-2 rtd.
				Daja Bedanova
106.			Tatiana Poutchek	6-1 6-2
					Anabel Medina-Garrigues
107.			Anabel Medina-Garrigues		6-4 6-2
				Anabel Medina-Garrigues
108.		[Q]	Bahia Mouhtassine	6-2 4-6 6-1
						Magdalena Maleeva
109.			Bianka Lamade			7-5 6-1
				Bianka Lamade
110.			Celine Beigbeder	5-7 7-5 6-2
					Nathalie Dechy
111.			Nathalie Dechy		6-3 6-7(4) 6-1
				Nathalie Dechy
112.		[9]	Sandrine Testud	7-5 4-6 6-3
								Monica Seles
113.		[13]	Magdalena Maleeva					6-7(4) 6-2 6-3
				Magdalena Maleeva
114.			Marie-Gaiane Mikaelian	6-3 6-4
					Magdalena Maleeva
115.			Kveta Hrdlickova		6-4 7-5
				Kveta Hrdlickova
116.			Shinobu Asagoe	4-6 6-3 6-2
						Venus Williams
117.			Jill Craybas			3-6 6-0 6-4
				Jill Craybas
118.		[WC]	Mary Pierce	4-0 rtd.
					Lisa Raymond
119.		[18]	Lisa Raymond		6-3 6-3
				Lisa Raymond
120.			Seda Noorlander	6-0 6-1
							Venus Williams
121.		[32]	Daniela Hantuchova				6-0 6-3
				Daniela Hantuchova
122.			Maja Matevzic	6-3 6-1
					Daniela Hantuchova
123.			Tathiana Garbin		6-0 6-2
				Tathiana Garbin
124.			Marissa Irvin	6-0 6-3
						Kim Clijsters
125.			Kristina Brandi			6-1 6-2
				Kristina Brandi
126.			Ludmila Cervanova	6-3 4-6 6-0
					Venus Williams
127.		[2]	Venus Williams		6-3 6-4
				Venus Williams
128.		[Q]	Ansley Cargill	6-2 6-2

(default) 17 queries took 35 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	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	3
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` = '2002' 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` = (186) 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 (9997, 10122, 10126, 10023, 10253, 10169, 10145, 10172, 10098, 10254, 10048, 10016, 10255, 10256, 10205, 10257, 10147, 10193, 10110, 10092, 10258, 10211, 10157, 10069, 10115, 10259, 10182, 10194, 10180, 10062, 10152, 10086, 10192, 10214, 10167, 10260, 10168, 10212, 10130, 10064, 10070, 9819, 10202, 10261, 10045, 10188, 10088, 9957, 10174, 10201, 10262, 10263, 10264, 10265, 10111, 10186, 10266, 10119, 9937, 10267, 10215, 10117, 10179, 10113, 9885, 10199, 10101, 10109, 10223, 10114, 10146, 10123, 9845, 10129, 10095, 10055, 10209, 10268, 10049, 10175, 10018, 9953, 10065, 10134, 10221, 10106, 10077, 10141, 10128, 10133, 9967, 10269, 10224, 10270, 10078, 10187, 9974, 10356, 10160, 10165, 10190, 10154, 10218, 10271, 10210, 10216, 10208, 10272, 10273, 10274, 10116, 9990, 9959, 10275, 10156, 10222, 10171, 10024, 10039, 10162, 10299, 10276, 10170, 10203, 10124, 10184, 10151, 10277) 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` = 186	129	129	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (84, 94, 72, 68, 53, 173, 207, 133, 154, 151, 92, 197, 168, 100, 21, 172, 74, 10, 13, 54, 179, 50, 111, 181, 31, 169, 127, 36, 135, 20, 87, 146, 14, 96, 189, 91, 178, 184, 194, 199)	40	40	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (84, 94, 72, 68, 53, 173, 207, 133, 154, 151, 92, 197, 168, 100, 21, 172, 74, 10, 13, 54, 179, 50, 111, 181, 31, 169, 127, 36, 135, 20, 87, 146, 14, 96, 189, 91, 178, 184, 194, 199)	40	40	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9997, 10122, 10126, 10023, 10253, 10169, 10145, 10172, 10098, 10254, 10048, 10016, 10255, 10256, 10205, 10257, 10147, 10193, 10110, 10092, 10258, 10211, 10157, 10069, 10115, 10259, 10182, 10194, 10180, 10062, 10152, 10086, 10192, 10214, 10167, 10260, 10168, 10212, 10130, 10064, 10070, 9819, 10202, 10261, 10045, 10188, 10088, 9957, 10174, 10201, 10262, 10263, 10264, 10265, 10111, 10186, 10266, 10119, 9937, 10267, 10215, 10117, 10179, 10113, 9885, 10199, 10101, 10109, 10223, 10114, 10146, 10123, 9845, 10129, 10095, 10055, 10209, 10268, 10049, 10175, 10018, 9953, 10065, 10134, 10221, 10106, 10077, 10141, 10128, 10133, 9967, 10269, 10224, 10270, 10078, 10187, 9974, 10356, 10160, 10165, 10190, 10154, 10218, 10271, 10210, 10216, 10208, 10272, 10273, 10274, 10116, 9990, 9959, 10275, 10156, 10222, 10171, 10024, 10039, 10162, 10299, 10276, 10170, 10203, 10124, 10184, 10151, 10277)) AND (`Playercontest`.`contest_id` = 186))	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	3
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 2002	20	20	5
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	4
17	SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 3, 4)	4	4	2

(default) 17 queries took 35 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` = '2002' 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` = (186) 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 (9997, 10122, 10126, 10023, 10253, 10169, 10145, 10172, 10098, 10254, 10048, 10016, 10255, 10256, 10205, 10257, 10147, 10193, 10110, 10092, 10258, 10211, 10157, 10069, 10115, 10259, 10182, 10194, 10180, 10062, 10152, 10086, 10192, 10214, 10167, 10260, 10168, 10212, 10130, 10064, 10070, 9819, 10202, 10261, 10045, 10188, 10088, 9957, 10174, 10201, 10262, 10263, 10264, 10265, 10111, 10186, 10266, 10119, 9937, 10267, 10215, 10117, 10179, 10113, 9885, 10199, 10101, 10109, 10223, 10114, 10146, 10123, 9845, 10129, 10095, 10055, 10209, 10268, 10049, 10175, 10018, 9953, 10065, 10134, 10221, 10106, 10077, 10141, 10128, 10133, 9967, 10269, 10224, 10270, 10078, 10187, 9974, 10356, 10160, 10165, 10190, 10154, 10218, 10271, 10210, 10216, 10208, 10272, 10273, 10274, 10116, 9990, 9959, 10275, 10156, 10222, 10171, 10024, 10039, 10162, 10299, 10276, 10170, 10203, 10124, 10184, 10151, 10277) 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` = 186

129

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (84, 94, 72, 68, 53, 173, 207, 133, 154, 151, 92, 197, 168, 100, 21, 172, 74, 10, 13, 54, 179, 50, 111, 181, 31, 169, 127, 36, 135, 20, 87, 146, 14, 96, 189, 91, 178, 184, 194, 199)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (84, 94, 72, 68, 53, 173, 207, 133, 154, 151, 92, 197, 168, 100, 21, 172, 74, 10, 13, 54, 179, 50, 111, 181, 31, 169, 127, 36, 135, 20, 87, 146, 14, 96, 189, 91, 178, 184, 194, 199)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9997, 10122, 10126, 10023, 10253, 10169, 10145, 10172, 10098, 10254, 10048, 10016, 10255, 10256, 10205, 10257, 10147, 10193, 10110, 10092, 10258, 10211, 10157, 10069, 10115, 10259, 10182, 10194, 10180, 10062, 10152, 10086, 10192, 10214, 10167, 10260, 10168, 10212, 10130, 10064, 10070, 9819, 10202, 10261, 10045, 10188, 10088, 9957, 10174, 10201, 10262, 10263, 10264, 10265, 10111, 10186, 10266, 10119, 9937, 10267, 10215, 10117, 10179, 10113, 9885, 10199, 10101, 10109, 10223, 10114, 10146, 10123, 9845, 10129, 10095, 10055, 10209, 10268, 10049, 10175, 10018, 9953, 10065, 10134, 10221, 10106, 10077, 10141, 10128, 10133, 9967, 10269, 10224, 10270, 10078, 10187, 9974, 10356, 10160, 10165, 10190, 10154, 10218, 10271, 10210, 10216, 10208, 10272, 10273, 10274, 10116, 9990, 9959, 10275, 10156, 10222, 10171, 10024, 10039, 10162, 10299, 10276, 10170, 10203, 10124, 10184, 10151, 10277)) AND (`Playercontest`.`contest_id` = 186))

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

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)