Wimbledon 2006 Ladies' Singles (June 26 - July 8)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Amelie Mauresmo
				Amelie Mauresmo
2.		[Q]	Ivana Abramovic	6-0 6-0
					Amelie Mauresmo
3.			Samantha Stosur		6-4 6-2
				Samantha Stosur
4.			Michaella Krajicek	7-5 6-3
						Amelie Mauresmo
5.		[Q]	Nicole Pratt			6-1 6-2
				Nicole Pratt
6.			Jarmila Gajdosova	6-2 6-3
					Nicole Pratt
7.		[29]	Tatiana Golovin		2-6 6-4 6-4
				Tatiana Golovin
8.			Mariana Diaz-Oliva	3-6 6-2 9-7
							Amelie Mauresmo
9.		[19]	Ana Ivanovic				6-3 6-4
				Ana Ivanovic
10.			Emmanuelle Gagliardi	7-5 7-6(4)
					Ana Ivanovic
11.		[WC]	Sarah Borwell		6-1 6-2
				Sarah Borwell
12.			Marta Domachowska	6-3 6-7(3) 6-4
						Ana Ivanovic
13.			Mashona Washington			3-6 7-6(3) 6-1
				Mashona Washington
14.			Julia Schruff	6-3 6-4
					Dinara Safina
15.		[14]	Dinara Safina		4-6 6-4 6-1
				Dinara Safina
16.			Jill Craybas	3-6 7-5 7-5
								Amelie Mauresmo
17.		[9]	Anastasia Myskina					6-1 3-6 6-3
				Anastasia Myskina
18.		[WC]	Cara Black	6-0 6-4
					Anastasia Myskina
19.			Martina Muller		6-2 6-1
				Martina Muller
20.			Kaia Kanepi	6-4 6-4
						Anastasia Myskina
21.		[Q]	Clarisa Fernandez			6-3 6-4
				Clarisa Fernandez
22.			Conchita Martinez-Granados	6-2 4-6 4-3 rtd.
					Anabel Medina-Garrigues
23.		[23]	Anabel Medina-Garrigues		6-7(7) 7-5 11-9
				Anabel Medina-Garrigues
24.			Su-Wei Hsieh	6-3 6-2
							Anastasia Myskina
25.		[26]	Jelena Jankovic				6-4 7-6(5)
				Jelena Jankovic
26.			Lourdes Dominguez-Lino	6-3 6-4
					Jelena Jankovic
27.			Vania King		6-2 4-6 6-4
				Vania King
28.		[LL]	Julia Vakulenko	5-4 rtd.
						Jelena Jankovic
29.			Lisa Raymond			7-6(8) 4-6 6-4
				Lisa Raymond
30.		[Q]	Yaroslava Shvedova	3-5 rtd.
					Venus Williams
31.		[6]	Venus Williams		6-7(4) 7-5 6-2
				Venus Williams
32.			Bethanie Mattek-Sands	6-1 6-0
									Amelie Mauresmo
33.		[4]	Maria Sharapova						6-3 3-6 6-2
				Maria Sharapova
34.			Anna Smashnova	6-2 6-0
					Maria Sharapova
35.			Ashley Harkleroad		6-2 6-2
				Ashley Harkleroad
36.			Jelena Kostanic	6-3 6-2
						Maria Sharapova
37.			Melinda Czink			6-3 6-2
				Melinda Czink
38.			Laura Pous-Tio	6-3 6-1
					Amy Frazier
39.			Amy Frazier		6-2 6-3
				Amy Frazier
40.		[32]	Mara Santangelo	3-6 6-3 6-4
							Maria Sharapova
41.		[20]	Shahar Peer				7-6(5) 3-6 6-3
				Shahar Peer
42.			Yuliana Fedak	6-2 6-1
					Shuai Peng
43.			Shuai Peng		6-4 7-6(5)
				Shuai Peng
44.			Eleni Daniilidou	6-4 6-4
						Flavia Pennetta
45.			Laura Granville			6-2 6-3
				Laura Granville
46.			Maret Ani	6-1 7-6(3)
					Flavia Pennetta
47.		[16]	Flavia Pennetta		6-2 6-1
				Flavia Pennetta
48.			Sandra Kloesel	5-7 6-4 6-2
								Maria Sharapova
49.		[WC]	Melanie South					6-1 6-4
				Melanie South
50.		[11]	Francesca Schiavone	3-6 6-3 6-4
					Shenay Perry
51.			Shenay Perry		7-6(5) 6-2
				Shenay Perry
52.		[Q]	Kristina Barrois	7-5 5-7 8-6
						Shenay Perry
53.			Anastasia Rodionova			7-5 6-3
				Anastasia Rodionova
54.			Emilie Loit	1-6 7-6(5) 6-4
					Sybille Bammer
55.			Sybille Bammer		6-4 6-4
				Sybille Bammer
56.		[22]	Nathalie Dechy	7-5 7-5
							Elena Dementieva
57.		[25]	Elena Likhovtseva				6-2 6-0
				Elena Likhovtseva
58.			Stephanie Foretz	6-0 6-2
					Elena Likhovtseva
59.			Tian-Tian Sun		6-3 6-3
				Tian-Tian Sun
60.			Nathalie Vierin	6-3 6-4
						Elena Dementieva
61.			Meghann Shaughnessy			7-5 6-3
				Meghann Shaughnessy
62.			Alona Bondarenko	4-6 6-2 6-3
					Elena Dementieva
63.		[7]	Elena Dementieva		5-7 6-3 7-5
				Elena Dementieva
64.			Sania Mirza	7-6(5) 7-5
										Amelie Mauresmo
65.		[8]	Patty Schnyder							2-6 6-3 6-4
				Patty Schnyder
66.			Antonella Serra-Zanetti	2-6 7-6(4) 6-2
					Severine Beltrame
67.		[Q]	Severine Beltrame		4-6 6-1 6-4
				Severine Beltrame
68.			Anastasia Yakimova	7-5 6-3
						Severine Beltrame
69.			Virginia Ruano-Pascual			7-6(6) 5-7 7-5
				Virginia Ruano-Pascual
70.			Hana Sromova	6-4 6-3
					Gisela Dulko
71.		[31]	Gisela Dulko		7-5 6-4
				Gisela Dulko
72.			Emma Laine	7-6(11) 6-1
							Severine Beltrame
73.		[18]	Ai Sugiyama				7-6(11) 6-3
				Ai Sugiyama
74.		[WC]	Naomi Cavaday	6-4 7-5
					Ai Sugiyama
75.			Akiko Morigami		6-2 7-5
				Akiko Morigami
76.			Vera Dushevina	1-6 6-4 6-2
						Ai Sugiyama
77.			Tathiana Garbin			7-5 3-6 6-4
				Tathiana Garbin
78.		[WC]	Katie O'Brien	2-6 7-6(2) 6-2
					Martina Hingis
79.		[12]	Martina Hingis		6-1 6-2
				Martina Hingis
80.			Olga Savchuk	6-2 6-2
								Justine Henin
81.		[15]	Daniela Hantuchova					6-4 6-4
				Daniela Hantuchova
82.			Maria Elena Camerin	6-4 4-6 6-1
					Daniela Hantuchova
83.			Jamea Jackson		6-3 4-6 7-5
				Jamea Jackson
84.		[Q]	Kirsten Flipkens	4-6 6-4 6-1
						Daniela Hantuchova
85.		[WC]	Alicia Molik			6-4 7-6(2)
				Alicia Molik
86.		[Q]	Yung-Jan Chan	7-5 6-1
					Katarina Srebotnik
87.		[21]	Katarina Srebotnik		6-2 6-1
				Katarina Srebotnik
88.			Martina Sucha	6-4 6-1
							Justine Henin
89.		[30]	Anna Chakvetadze				6-3 6-1
				Anna Chakvetadze
90.			Yan Zi	6-3 6-2
					Anna Chakvetadze
91.			Elena Vesnina		6-4 3-6 6-3
				Elena Vesnina
92.			Maria Sanchez Lorenzo	2-6 6-4 6-3
						Justine Henin
93.			Ekaterina Bychkova			6-2 6-3
				Ekaterina Bychkova
94.			Aiko Nakamura	6-3 1-6 6-3
					Justine Henin
95.		[3]	Justine Henin		6-1 6-2
				Justine Henin
96.			Meng Yuan	6-0 6-1
									Justine Henin
97.		[5]	Svetlana Kuznetsova						6-4 7-6(4)
				Svetlana Kuznetsova
98.		[Q]	Romina Oprandi	6-3 6-2
					Svetlana Kuznetsova
99.			Kveta Hrdlickova		4-6 6-1 6-4
				Kveta Hrdlickova
100.			Kristina Brandi	6-3 6-0
						Na Li
101.		[Q]	Meilen Tu			3-6 6-2 6-3
				Meilen Tu
102.		[Q]	Vasilisa Bardina	6-3 6-0
					Na Li
103.		[27]	Na Li		6-2 6-4
				Na Li
104.			Virginie Razzano	6-2 6-0
							Na Li
105.		[24]	Marion Bartoli				4-6 6-1 6-3
				Marion Bartoli
106.			Camille Pin	6-0 6-2
					Karolina Sprem
107.			Karolina Sprem		3-6 6-2 6-3
				Karolina Sprem
108.		[WC]	Anne Keothavong	6-0 6-2
						Nicole Vaidisova
109.			Kateryna Bondarenko			7-5 7-5
				Kateryna Bondarenko
110.			Ivana Lisjak	6-4 7-5
					Nicole Vaidisova
111.		[10]	Nicole Vaidisova		6-1 6-1
				Nicole Vaidisova
112.			Klara Koukalova	7-5 7-5
								Kim Clijsters
113.			Tsvetana Pironkova					6-4 7-5
				Tsvetana Pironkova
114.		[13]	Anna-Lena Groenefeld	3-6 6-3 6-1
					Agnieszka Radwanska
115.		[WC]	Agnieszka Radwanska		7-5 7-6(5)
				Agnieszka Radwanska
116.			Victoria Azarenka	7-5 6-4
						Agnieszka Radwanska
117.		[Q]	Tamarine Tanasugarn			6-3 6-2
				Tamarine Tanasugarn
118.			Catalina Castano	6-7(2) 6-1 6-2
					Tamarine Tanasugarn
119.			Shinobu Asagoe		6-3 7-5
				Shinobu Asagoe
120.		[17]	Maria Kirilenko	6-2 7-6(1)
							Kim Clijsters
121.			Eva Birnerova				6-2 6-2
				Eva Birnerova
122.		[28]	Sofia Arvidsson	6-2 6-4
					Jie Zheng
123.			Jie Zheng		7-6(6) 5-7 6-3
				Jie Zheng
124.			Iveta Benesova	7-5 6-2
						Kim Clijsters
125.			Viktoriya Kutuzova			6-3 6-2
				Viktoriya Kutuzova
126.			Lilia Osterloh	6-4 3-3 rtd.
					Kim Clijsters
127.		[2]	Kim Clijsters		w/o
				Kim Clijsters
128.			Vera Zvonareva	7-5 6-3

(default) 17 queries took 33 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` = 'wimbledon' 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` = (3)	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` = (3)	4	4	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` = (3)	57	57	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` = 'wimbledon' 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` = (19) ORDER BY `Contest`.`year` ASC	130	130	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` = 3 AND `Contest`.`category_id` = 19 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` = (1817) 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, 12560, 10270, 10339, 9937, 10372, 10317, 10146, 10355, 10130, 12558, 10349, 10303, 10348, 10290, 10171, 10262, 10160, 10266, 10398, 10254, 10359, 10208, 10414, 10284, 10365, 10396, 10314, 10039, 10420, 10151, 10487, 10326, 10062, 10323, 10190, 10286, 10386, 9845, 10306, 10373, 10310, 10335, 10253, 10278, 10375, 10302, 10142, 10459, 10218, 10305, 10450, 10391, 10165, 10383, 10116, 10064, 10297, 10379, 11411, 10147, 10343, 10174, 10353, 10356, 10258, 10382, 10336, 10055, 10366, 10316, 10381, 10070, 12561, 10292, 10321, 10170, 10437, 10078, 10369, 10299, 10264, 10376, 10410, 10172, 10451, 10180, 10223, 10342, 10384, 10368, 10090, 10370, 10333, 10179, 10388, 10255, 10406, 10156, 10124, 10126, 10401, 10351, 10187, 10261, 10294, 10320, 10442, 10462, 11412, 10330, 10282, 10363, 10345, 10394, 10377, 10115, 10337, 10222, 10360, 10315, 10324, 10322, 10279, 10378, 10175, 10192, 10281) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	10
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` = 1817	128	128	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (50, 63, 178, 94, 20, 14, 154, 72, 68, 53, 207, 194, 196, 151, 92, 43, 181, 21, 197, 84, 74, 10, 149, 173, 179, 168, 164, 133, 67, 42, 86, 13, 91, 31, 169, 184)	36	36	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (50, 63, 178, 94, 20, 14, 154, 72, 68, 53, 207, 194, 196, 151, 92, 43, 181, 21, 197, 84, 74, 10, 149, 173, 179, 168, 164, 133, 67, 42, 86, 13, 91, 31, 169, 184)	36	36	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10152, 12560, 10270, 10339, 9937, 10372, 10317, 10146, 10355, 10130, 12558, 10349, 10303, 10348, 10290, 10171, 10262, 10160, 10266, 10398, 10254, 10359, 10208, 10414, 10284, 10365, 10396, 10314, 10039, 10420, 10151, 10487, 10326, 10062, 10323, 10190, 10286, 10386, 9845, 10306, 10373, 10310, 10335, 10253, 10278, 10375, 10302, 10142, 10459, 10218, 10305, 10450, 10391, 10165, 10383, 10116, 10064, 10297, 10379, 11411, 10147, 10343, 10174, 10353, 10356, 10258, 10382, 10336, 10055, 10366, 10316, 10381, 10070, 12561, 10292, 10321, 10170, 10437, 10078, 10369, 10299, 10264, 10376, 10410, 10172, 10451, 10180, 10223, 10342, 10384, 10368, 10090, 10370, 10333, 10179, 10388, 10255, 10406, 10156, 10124, 10126, 10401, 10351, 10187, 10261, 10294, 10320, 10442, 10462, 11412, 10330, 10282, 10363, 10345, 10394, 10377, 10115, 10337, 10222, 10360, 10315, 10324, 10322, 10279, 10378, 10175, 10192, 10281)) AND (`Playercontest`.`contest_id` = 1817))	128	128	2
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 19 ORDER BY `Contest`.`date_from` ASC	130	130	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	2

(default) 17 queries took 33 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` = 'wimbledon' 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` = (3)

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` = (3)

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

130

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` = 3 AND `Contest`.`category_id` = 19 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` = (1817) 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, 12560, 10270, 10339, 9937, 10372, 10317, 10146, 10355, 10130, 12558, 10349, 10303, 10348, 10290, 10171, 10262, 10160, 10266, 10398, 10254, 10359, 10208, 10414, 10284, 10365, 10396, 10314, 10039, 10420, 10151, 10487, 10326, 10062, 10323, 10190, 10286, 10386, 9845, 10306, 10373, 10310, 10335, 10253, 10278, 10375, 10302, 10142, 10459, 10218, 10305, 10450, 10391, 10165, 10383, 10116, 10064, 10297, 10379, 11411, 10147, 10343, 10174, 10353, 10356, 10258, 10382, 10336, 10055, 10366, 10316, 10381, 10070, 12561, 10292, 10321, 10170, 10437, 10078, 10369, 10299, 10264, 10376, 10410, 10172, 10451, 10180, 10223, 10342, 10384, 10368, 10090, 10370, 10333, 10179, 10388, 10255, 10406, 10156, 10124, 10126, 10401, 10351, 10187, 10261, 10294, 10320, 10442, 10462, 11412, 10330, 10282, 10363, 10345, 10394, 10377, 10115, 10337, 10222, 10360, 10315, 10324, 10322, 10279, 10378, 10175, 10192, 10281) 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` = 1817

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10152, 12560, 10270, 10339, 9937, 10372, 10317, 10146, 10355, 10130, 12558, 10349, 10303, 10348, 10290, 10171, 10262, 10160, 10266, 10398, 10254, 10359, 10208, 10414, 10284, 10365, 10396, 10314, 10039, 10420, 10151, 10487, 10326, 10062, 10323, 10190, 10286, 10386, 9845, 10306, 10373, 10310, 10335, 10253, 10278, 10375, 10302, 10142, 10459, 10218, 10305, 10450, 10391, 10165, 10383, 10116, 10064, 10297, 10379, 11411, 10147, 10343, 10174, 10353, 10356, 10258, 10382, 10336, 10055, 10366, 10316, 10381, 10070, 12561, 10292, 10321, 10170, 10437, 10078, 10369, 10299, 10264, 10376, 10410, 10172, 10451, 10180, 10223, 10342, 10384, 10368, 10090, 10370, 10333, 10179, 10388, 10255, 10406, 10156, 10124, 10126, 10401, 10351, 10187, 10261, 10294, 10320, 10442, 10462, 11412, 10330, 10282, 10363, 10345, 10394, 10377, 10115, 10337, 10222, 10360, 10315, 10324, 10322, 10279, 10378, 10175, 10192, 10281)) AND (`Playercontest`.`contest_id` = 1817))

128

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

130

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)