US Open 2006 Women's Singles (August 28 - September 10)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Amelie Mauresmo
				Amelie Mauresmo
2.		[Q]	Kristina Barrois	6-1 7-5
					Amelie Mauresmo
3.			Meghann Shaughnessy		6-4 6-3
				Meghann Shaughnessy
4.			Roberta Vinci	6-3 6-4
						Amelie Mauresmo
5.			Mara Santangelo			6-3 3-6 6-2
				Mara Santangelo
6.			Lisa Raymond	7-6(4) 6-2
					Mara Santangelo
7.			Sybille Bammer		6-3 6-1
				Sybille Bammer
8.		[31]	Nathalie Dechy	5-7 6-3 6-1
							Amelie Mauresmo
9.		[17]	Daniela Hantuchova				6-4 0-6 6-2
				Daniela Hantuchova
10.		[WC]	Bethanie Mattek-Sands	7-5 6-3
					Serena Williams
11.		[WC]	Serena Williams		7-5 6-3
				Serena Williams
12.			Lourdes Dominguez-Lino	6-1 6-2
						Serena Williams
13.			Aiko Nakamura			6-2 6-4
				Aiko Nakamura
14.			Melinda Czink	6-1 6-2
					Ana Ivanovic
15.		[16]	Ana Ivanovic		7-5 6-3
				Ana Ivanovic
16.			Vera Dushevina	6-3 5-7 6-4
								Amelie Mauresmo
17.		[12]	Dinara Safina					6-2 6-3
				Dinara Safina
18.		[Q]	Yuliya Beygelzimer	6-1 6-3
					Dinara Safina
19.			Yuliana Fedak		6-3 6-4
				Yuliana Fedak
20.		[Q]	Tatiana Poutchek	7-5 6-3
						Dinara Safina
21.			Jarmila Gajdosova			6-3 6-0
				Jarmila Gajdosova
22.		[WC]	Alexa Glatch	6-2 6-1
					Jarmila Gajdosova
23.			Viktoriya Kutuzova		6-3 7-6(5)
				Viktoriya Kutuzova
24.		[LL]	Maria Jose Martinez-Sanchez	6-3 6-3
							Dinara Safina
25.		[Q]	Youlia Fedossova				6-0 7-5
				Youlia Fedossova
26.		[25]	Anabel Medina-Garrigues	7-5 6-1
					Kaia Kanepi
27.			Kaia Kanepi		6-4 4-6 7-5
				Kaia Kanepi
28.			Stephanie Foretz	3-6 7-5 6-1
						Virginie Razzano
29.			Virginie Razzano			7-5 6-2
				Virginie Razzano
30.			Maret Ani	7-5 6-4
					Virginie Razzano
31.		[8]	Martina Hingis		6-2 6-4
				Martina Hingis
32.			Shuai Peng	4-6 6-1 6-3
									Maria Sharapova
33.		[3]	Maria Sharapova						6-0 4-6 6-0
				Maria Sharapova
34.			Michaella Krajicek	6-3 6-0
					Maria Sharapova
35.			Emilie Loit		6-0 6-1
				Emilie Loit
36.			Camille Pin	5-7 6-4 7-6(4)
						Maria Sharapova
37.		[LL]	Nicole Pratt			6-3 6-2
				Nicole Pratt
38.		[Q]	Milagros Sequera	1-6 7-5 6-2
					Elena Likhovtseva
39.		[32]	Elena Likhovtseva		6-3 6-2
				Elena Likhovtseva
40.			Tian-Tian Sun	4-6 6-0 6-4
							Maria Sharapova
41.		[24]	Na Li				6-4 6-2
				Na Li
42.			Maria Sanchez Lorenzo	4-6 6-3 6-0
					Na Li
43.			Eleni Daniilidou		6-0 1-6 6-4
				Eleni Daniilidou
44.			Shenay Perry	6-0 6-2
						Na Li
45.		[Q]	Eva Birnerova			4-6 6-0 6-0
				Eva Birnerova
46.			Galina Voskoboeva	7-6(4) 5-7 6-3
					Mary Pierce
47.		[13]	Mary Pierce		6-3 6-4
				Mary Pierce
48.			Elena Vesnina	7-5 6-1
								Maria Sharapova
49.			Victoria Azarenka					7-6(4) 7-6(0)
				Victoria Azarenka
50.		[11]	Anastasia Myskina	6-4 6-2
					Victoria Azarenka
51.			Jamea Jackson		6-3 6-2
				Jamea Jackson
52.			Tsvetana Pironkova	6-2 6-2
						Anna Chakvetadze
53.			Alona Bondarenko			6-4 6-3
				Alona Bondarenko
54.		[WC]	Ahsha Rolle	6-4 6-4
					Anna Chakvetadze
55.		[23]	Anna Chakvetadze		7-6(6) 6-0
				Anna Chakvetadze
56.			Martina Sucha	6-4 6-1
							Tatiana Golovin
57.		[27]	Tatiana Golovin				6-3 6-2
				Tatiana Golovin
58.			Ashley Harkleroad	6-3 7-5
					Tatiana Golovin
59.		[Q]	Agnieszka Radwanska		6-4 6-3
				Agnieszka Radwanska
60.			Yan Zi	6-0 7-5
						Tatiana Golovin
61.			Virginia Ruano-Pascual			7-5 6-7(4) 6-3
				Virginia Ruano-Pascual
62.			Amy Frazier	6-2 6-1
					Nadia Petrova
63.		[5]	Nadia Petrova		6-1 6-1
				Nadia Petrova
64.		[Q]	Clarisa Fernandez	6-2 6-1
										Maria Sharapova
65.		[6]	Svetlana Kuznetsova							6-4 6-4
				Svetlana Kuznetsova
66.		[Q]	Sandra Kloesel	6-2 2-6 6-3
					Svetlana Kuznetsova
67.		[WC]	Lauren Albanese		6-1 6-1
				Lauren Albanese
68.			Olga Savchuk	6-7(5) 6-4 6-2
						Svetlana Kuznetsova
69.			Anastasia Rodionova			6-3 6-0
				Anastasia Rodionova
70.			Hana Sromova	7-5 7-5
					Anastasia Rodionova
71.		[29]	Jie Zheng		7-5 6-3
				Jie Zheng
72.			Kveta Hrdlickova	6-4 5-7 7-5
							Jelena Jankovic
73.		[19]	Jelena Jankovic				6-7(5) 6-3 6-2
				Jelena Jankovic
74.			Gisela Dulko	6-7(2) 6-1 6-4
					Jelena Jankovic
75.		[Q]	Kirsten Flipkens		6-2 6-3
				Kirsten Flipkens
76.		[Q]	Yung-Jan Chan	6-4 6-2
						Jelena Jankovic
77.			Alina Jidkova			5-7 6-3 6-2
				Alina Jidkova
78.		[WC]	Jessica Kirkland	3-6 6-2 6-4
					Nicole Vaidisova
79.		[9]	Nicole Vaidisova		6-2 3-6 6-3
				Nicole Vaidisova
80.		[WC]	Chanda Rubin	6-4 6-3
								Jelena Jankovic
81.			Aravane Rezai					6-2 6-1
				Aravane Rezai
82.		[15]	Anna-Lena Groenefeld	2-6 6-0 6-4
					Aravane Rezai
83.			Lucie Safarova		7-6(3) 2-6 6-4
				Lucie Safarova
84.			Samantha Stosur	6-2 7-6(5)
						Aravane Rezai
85.			Severine Beltrame			6-3 6-1
				Severine Beltrame
86.		[Q]	Stephanie Dubois	6-1 6-3
					Maria Kirilenko
87.		[20]	Maria Kirilenko		6-2 6-3
				Maria Kirilenko
88.			Julia Schruff	6-3 6-4
							Elena Dementieva
89.		[33]	Vera Zvonareva				7-5 6-4
				Vera Zvonareva
90.			Marta Domachowska	7-6(4) 6-3
					Vera Zvonareva
91.			Jill Craybas		6-3 7-5
				Jill Craybas
92.			Iveta Benesova	6-2 6-0
						Elena Dementieva
93.			Emma Laine			7-5 6-3
				Emma Laine
94.			Meilen Tu	6-1 6-1
					Elena Dementieva
95.		[4]	Elena Dementieva		6-4 6-0
				Elena Dementieva
96.			Laura Granville	6-1 6-4
									Justine Henin
97.		[7]	Patty Schnyder						4-6 6-4 6-0
				Patty Schnyder
98.			Anna Smashnova	6-1 6-2
					Patty Schnyder
99.			Sofia Arvidsson		6-3 7-5
				Sofia Arvidsson
100.			Conchita Martinez-Granados	6-2 6-4
						Patty Schnyder
101.		[Q]	Varvara Lepchenko			0-6 6-3 6-3
				Varvara Lepchenko
102.			Catalina Castano	6-7(9) 6-1 6-1
					Marion Bartoli
103.		[26]	Marion Bartoli		6-1 6-2
				Marion Bartoli
104.		[Q]	Olga Poutchkova	6-4 6-0
							Lindsay Davenport
105.		[22]	Katarina Srebotnik				6-4 6-4
				Katarina Srebotnik
106.			Akiko Morigami	6-2 6-3
					Katarina Srebotnik
107.			Ekaterina Bychkova		6-2 4-6 6-2
				Ekaterina Bychkova
108.		[Q]	Lioudmila Skavronskaia	7-6(1) 7-6(3)
						Lindsay Davenport
109.			Jelena Kostanic			3-6 6-3 7-6(5)
				Jelena Kostanic
110.			Shinobu Asagoe	6-4 7-6(4)
					Lindsay Davenport
111.		[10]	Lindsay Davenport		6-0 6-0
				Lindsay Davenport
112.			Klara Koukalova	6-1 6-4
								Justine Henin
113.		[14]	Francesca Schiavone					6-4 6-4
				Francesca Schiavone
114.			Romina Oprandi	6-1 6-2
					Francesca Schiavone
115.			Sania Mirza		5-7 6-1 6-2
				Sania Mirza
116.			Karolina Sprem	6-4 6-2
						Shahar Peer
117.			Martina Muller			6-3 6-7(3) 7-6(3)
				Martina Muller
118.			Anastasia Yakimova	7-6(2) 6-3
					Shahar Peer
119.		[21]	Shahar Peer		6-1 5-7 6-2
				Shahar Peer
120.		[Q]	Vasilisa Bardina	6-2 6-2
							Justine Henin
121.		[28]	Ai Sugiyama				6-1 6-0
				Ai Sugiyama
122.			Zuzana Ondraskova	6-1 6-0
					Ai Sugiyama
123.			Tathiana Garbin		6-7(2) 6-4 6-2
				Tathiana Garbin
124.			Meng Yuan	6-3 6-1
						Justine Henin
125.			Vania King			4-6 6-1 6-0
				Vania King
126.		[WC]	Alicia Molik	6-3 6-2
					Justine Henin
127.		[2]	Justine Henin		6-1 6-2
				Justine Henin
128.			Maria Elena Camerin	6-2 6-1

(default) 17 queries took 26 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` = 'us-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` = (4)	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` = (4)	3	3	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` = (4)	2	2	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` = 'us-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` = (24) ORDER BY `Contest`.`year` ASC	138	138	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` = 4 AND `Contest`.`category_id` = 24 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` = (1425) 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 (10152, 10450, 10147, 10387, 10306, 10039, 10383, 10116, 10299, 10487, 10150, 10365, 10333, 10286, 10355, 10321, 10290, 10397, 10310, 10216, 10372, 11422, 10378, 10212, 10404, 10208, 10398, 10297, 10187, 10375, 10078, 10335, 10326, 10339, 10165, 10294, 9937, 10328, 10064, 10379, 10351, 10090, 10253, 10305, 10315, 10361, 10024, 10368, 10377, 10262, 10376, 10363, 10343, 10405, 10342, 10223, 10317, 10323, 10394, 10384, 10055, 9845, 10163, 10254, 10255, 10142, 13387, 10369, 10391, 10366, 10322, 10156, 10284, 10316, 10410, 10451, 10201, 10344, 10330, 9985, 10403, 10345, 10385, 10270, 10382, 10418, 10360, 10348, 10281, 10349, 10171, 10279, 10381, 10126, 10174, 10278, 10356, 10062, 10324, 10359, 10395, 10337, 10261, 10412, 10180, 10292, 10370, 13390, 10190, 10222, 10025, 10282, 10218, 10406, 10353, 10320, 10266, 10336, 10373, 10401, 10070, 10307, 10170, 10388, 10396, 10172, 10179, 10264) 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` = 1425	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 63, 178, 94, 20, 14, 154, 72, 68, 53, 194, 92, 43, 181, 84, 74, 149, 173, 36, 10, 21, 168, 179, 164, 50, 133, 67, 199, 42, 86, 13, 91, 31, 201, 169, 96)	36	36	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 63, 178, 94, 20, 14, 154, 72, 68, 53, 194, 92, 43, 181, 84, 74, 149, 173, 36, 10, 21, 168, 179, 164, 50, 133, 67, 199, 42, 86, 13, 91, 31, 201, 169, 96)	36	36	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10152, 10450, 10147, 10387, 10306, 10039, 10383, 10116, 10299, 10487, 10150, 10365, 10333, 10286, 10355, 10321, 10290, 10397, 10310, 10216, 10372, 11422, 10378, 10212, 10404, 10208, 10398, 10297, 10187, 10375, 10078, 10335, 10326, 10339, 10165, 10294, 9937, 10328, 10064, 10379, 10351, 10090, 10253, 10305, 10315, 10361, 10024, 10368, 10377, 10262, 10376, 10363, 10343, 10405, 10342, 10223, 10317, 10323, 10394, 10384, 10055, 9845, 10163, 10254, 10255, 10142, 13387, 10369, 10391, 10366, 10322, 10156, 10284, 10316, 10410, 10451, 10201, 10344, 10330, 9985, 10403, 10345, 10385, 10270, 10382, 10418, 10360, 10348, 10281, 10349, 10171, 10279, 10381, 10126, 10174, 10278, 10356, 10062, 10324, 10359, 10395, 10337, 10261, 10412, 10180, 10292, 10370, 13390, 10190, 10222, 10025, 10282, 10218, 10406, 10353, 10320, 10266, 10336, 10373, 10401, 10070, 10307, 10170, 10388, 10396, 10172, 10179, 10264)) AND (`Playercontest`.`contest_id` = 1425))	128	128	5
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 24 ORDER BY `Contest`.`date_from` ASC	138	138	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 26 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` = 'us-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` = (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` = (4)

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` = 'us-open' AND `Category`.`slug` = 'women-singles' LIMIT 1

138

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` = 4 AND `Contest`.`category_id` = 24 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` = (1425) 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 (10152, 10450, 10147, 10387, 10306, 10039, 10383, 10116, 10299, 10487, 10150, 10365, 10333, 10286, 10355, 10321, 10290, 10397, 10310, 10216, 10372, 11422, 10378, 10212, 10404, 10208, 10398, 10297, 10187, 10375, 10078, 10335, 10326, 10339, 10165, 10294, 9937, 10328, 10064, 10379, 10351, 10090, 10253, 10305, 10315, 10361, 10024, 10368, 10377, 10262, 10376, 10363, 10343, 10405, 10342, 10223, 10317, 10323, 10394, 10384, 10055, 9845, 10163, 10254, 10255, 10142, 13387, 10369, 10391, 10366, 10322, 10156, 10284, 10316, 10410, 10451, 10201, 10344, 10330, 9985, 10403, 10345, 10385, 10270, 10382, 10418, 10360, 10348, 10281, 10349, 10171, 10279, 10381, 10126, 10174, 10278, 10356, 10062, 10324, 10359, 10395, 10337, 10261, 10412, 10180, 10292, 10370, 13390, 10190, 10222, 10025, 10282, 10218, 10406, 10353, 10320, 10266, 10336, 10373, 10401, 10070, 10307, 10170, 10388, 10396, 10172, 10179, 10264) 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` = 1425

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10152, 10450, 10147, 10387, 10306, 10039, 10383, 10116, 10299, 10487, 10150, 10365, 10333, 10286, 10355, 10321, 10290, 10397, 10310, 10216, 10372, 11422, 10378, 10212, 10404, 10208, 10398, 10297, 10187, 10375, 10078, 10335, 10326, 10339, 10165, 10294, 9937, 10328, 10064, 10379, 10351, 10090, 10253, 10305, 10315, 10361, 10024, 10368, 10377, 10262, 10376, 10363, 10343, 10405, 10342, 10223, 10317, 10323, 10394, 10384, 10055, 9845, 10163, 10254, 10255, 10142, 13387, 10369, 10391, 10366, 10322, 10156, 10284, 10316, 10410, 10451, 10201, 10344, 10330, 9985, 10403, 10345, 10385, 10270, 10382, 10418, 10360, 10348, 10281, 10349, 10171, 10279, 10381, 10126, 10174, 10278, 10356, 10062, 10324, 10359, 10395, 10337, 10261, 10412, 10180, 10292, 10370, 13390, 10190, 10222, 10025, 10282, 10218, 10406, 10353, 10320, 10266, 10336, 10373, 10401, 10070, 10307, 10170, 10388, 10396, 10172, 10179, 10264)) AND (`Playercontest`.`contest_id` = 1425))

128

SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 24 ORDER BY `Contest`.`date_from` ASC

138

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)