Wimbledon 2004 Ladies' Singles (June 21 - July 3)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Serena Williams
				Serena Williams
2.			Jie Zheng	6-3 6-1
					Serena Williams
3.		[Q]	Stephanie Foretz		6-0 6-4
				Stephanie Foretz
4.			Stephanie Cohen-Aloro	6-1 6-3
						Serena Williams
5.		[WC]	Jane O'Donoghue			6-4 6-0
				Jane O'Donoghue
6.			Lindsay Lee	2-6 6-3 6-3
					Magui Serna
7.			Magui Serna		6-3 6-3
				Magui Serna
8.		[30]	Eleni Daniilidou	6-4 6-2
							Serena Williams
9.		[18]	Francesca Schiavone				6-2 6-1
				Francesca Schiavone
10.			Myriam Casanova	3-6 7-6(4) 6-3
					Tatiana Golovin
11.			Tatiana Golovin		6-1 6-0
				Tatiana Golovin
12.			Alina Jidkova	6-4 7-6(4)
						Tatiana Golovin
13.			Emmanuelle Gagliardi			6-3 2-6 6-3
				Emmanuelle Gagliardi
14.			Tara Snyder	3-3 rtd.
					Emmanuelle Gagliardi
15.		[15]	Patty Schnyder		2-6 7-6(4) 6-2
				Patty Schnyder
16.			Akiko Morigami	6-4 6-1
								Serena Williams
17.		[10]	Nadia Petrova					6-1 6-1
				Nadia Petrova
18.			Flavia Pennetta	6-3 2-6 6-4
					Nadia Petrova
19.			Maria Vento-Kabchi		6-3 3-6 6-2
				Maria Vento-Kabchi
20.			Martina Sucha	6-1 6-0
						Nadia Petrova
21.			Tatiana Perebiynis			7-6(5) 6-2
				Tatiana Perebiynis
22.		[Q]	Christina Wheeler	6-3 6-2
					Tatiana Perebiynis
23.			Milagros Sequera		6-2 7-5
				Milagros Sequera
24.		[22]	Conchita Martinez	6-4 7-6(6)
							Jennifer Capriati
25.		[25]	Nathalie Dechy				6-4 6-4
				Nathalie Dechy
26.			Anabel Medina-Garrigues	6-3 6-4
					Nathalie Dechy
27.			Maria Sanchez Lorenzo		6-1 6-1
				Maria Sanchez Lorenzo
28.		[WC]	Katie O'Brien	6-4 6-4
						Jennifer Capriati
29.		[WC]	Elena Baltacha			7-5 6-1
				Elena Baltacha
30.			Marta Marrero	6-1 6-3
					Jennifer Capriati
31.		[7]	Jennifer Capriati		6-4 6-4
				Jennifer Capriati
32.			Claudine Schaul	6-2 6-2
									Serena Williams
33.		[4]	Amelie Mauresmo						6-7(4) 7-5 6-4
				Amelie Mauresmo
34.			Jelena Kostanic	6-2 6-3
					Amelie Mauresmo
35.		[Q]	Jennifer Hopkins		6-3 6-3
				Jennifer Hopkins
36.			Julia Vakulenko	7-6(5) 6-2
						Amelie Mauresmo
37.			Ludmila Cervanova			6-1 6-4
				Ludmila Cervanova
38.			Barbara Schett	3-6 6-4 6-4
					Ludmila Cervanova
39.		[26]	Lisa Raymond		6-4 6-3
				Lisa Raymond
40.			Shinobu Asagoe	6-3 7-6(4)
							Amelie Mauresmo
41.			Virginia Ruano-Pascual				7-5 6-3
				Virginia Ruano-Pascual
42.		[24]	Mary Pierce	6-2 7-5
					Virginia Ruano-Pascual
43.			Henrieta Nagyova		6-4 6-4
				Henrieta Nagyova
44.			Lina Krasnoroutskaya	3-6 6-4 6-3
						Silvia Farina
45.			Silvija Talaja			2-6 6-4 7-5
				Silvija Talaja
46.			Barbora Strycova	6-3 6-4
					Silvia Farina
47.		[14]	Silvia Farina		6-3 6-3
				Silvia Farina
48.			Shuai Peng	6-0 6-4
								Amelie Mauresmo
49.		[9]	Paola Suarez					6-0 5-7 6-1
				Paola Suarez
50.			Shenay Perry	6-2 6-4
					Paola Suarez
51.			Els Callens		6-2 6-2
				Els Callens
52.			Ashley Harkleroad	6-3 5-7 6-4
						Paola Suarez
53.		[Q]	Tian-Tian Sun			6-1 4-6 6-0
				Tian-Tian Sun
54.			Tathiana Garbin	2-6 6-0 6-2
					Anne Kremer
55.			Anne Kremer		6-3 7-5
				Anne Kremer
56.		[19]	Fabiola Zuluaga	6-4 6-3
							Paola Suarez
57.			Arantxa Parra-Santonja				4-6 6-0 6-2
				Arantxa Parra-Santonja
58.		[29]	Dinara Safina	6-0 2-0 rtd.
					Rita Grande
59.			Rita Grande		5-7 6-2 6-3
				Rita Grande
60.			Mara Santangelo	7-5 7-5
						Rita Grande
61.			Elena Likhovtseva			6-4 4-6 6-3
				Elena Likhovtseva
62.			Gala Leon Garcia	6-2 6-2
					Virginie Razzano
63.		[Q]	Virginie Razzano		6-1 6-2
				Virginie Razzano
64.		[8]	Svetlana Kuznetsova	7-6(4) 3-6 6-4
										Maria Sharapova
65.		[5]	Lindsay Davenport							6-1 6-4
				Lindsay Davenport
66.			Dally Randriantefy	6-2 6-1
					Lindsay Davenport
67.			Kristina Brandi		6-0 1-0 rtd.
				Kristina Brandi
68.			Iveta Benesova	6-2 6-0
						Lindsay Davenport
69.		[Q]	Mashona Washington			6-2 6-1
				Mashona Washington
70.		[Q]	Angelique Widjaja	6-2 6-1
					Tatiana Panova
71.		[Q]	Tatiana Panova		6-3 6-4
				Tatiana Panova
72.		[28]	Emilie Loit	6-1 6-2
							Lindsay Davenport
73.			Gisela Dulko				6-4 6-4
				Gisela Dulko
74.		[23]	Jelena Dokic	6-3 6-3
					Gisela Dulko
75.		[WC]	Martina Navratilova		3-6 6-3 6-3
				Martina Navratilova
76.			Catalina Castano	6-0 6-1
						Vera Zvonareva
77.			Saori Obata			6-4 6-2
				Saori Obata
78.		[Q]	Eva Birnerova	4-6 6-4 7-5
					Vera Zvonareva
79.		[12]	Vera Zvonareva		6-1 6-4
				Vera Zvonareva
80.			Samantha Stosur	6-4 6-4
								Lindsay Davenport
81.			Katarina Srebotnik					6-2 6-2
				Katarina Srebotnik
82.		[16]	Anna Smashnova	6-4 6-3
					Denisa Chladkova
83.			Denisa Chladkova		7-6(6) 6-0
				Denisa Chladkova
84.			Marlene Weingartner	6-3 6-1
						Magdalena Maleeva
85.			Jill Craybas			7-5 6-3
				Jill Craybas
86.			Cara Black	6-4 6-3
					Magdalena Maleeva
87.		[21]	Magdalena Maleeva		6-2 6-3
				Magdalena Maleeva
88.			Vera Dushevina	6-1 7-5
							Karolina Sprem
89.		[32]	Meghann Shaughnessy				6-4 6-4
				Meghann Shaughnessy
90.			Marissa Irvin	7-6(3) 7-6(0)
					Meghann Shaughnessy
91.		[Q]	Nuria Llagostera-Vives		6-4 4-6 10-8
				Nuria Llagostera-Vives
92.			Petra Mandula	6-3 6-3
						Karolina Sprem
93.			Karolina Sprem			7-6(5) 7-6(2)
				Karolina Sprem
94.			Laura Granville	2-6 6-1 6-4
					Karolina Sprem
95.		[3]	Venus Williams		7-6(5) 7-6(6)
				Venus Williams
96.			Marie-Gaiane Mikaelian	6-3 6-0
									Maria Sharapova
97.			Sandra Kleinova						2-6 7-6(5) 6-1
				Sandra Kleinova
98.		[6]	Elena Dementieva	6-4 1-6 6-4
					Tamarine Tanasugarn
99.			Tamarine Tanasugarn		6-3 6-3
				Tamarine Tanasugarn
100.			Anna-Lena Groenefeld	6-2 6-0
						Tamarine Tanasugarn
101.			Teryn Ashley			6-2 6-4
				Teryn Ashley
102.			Tina Pisnik	2-6 6-1 7-5
					Alicia Molik
103.		[27]	Alicia Molik		7-5 6-4
				Alicia Molik
104.			Melinda Czink	6-1 6-4
							Ai Sugiyama
105.			Marion Bartoli				6-3 7-5
				Marion Bartoli
106.		[17]	Chanda Rubin	7-6(5) 6-3
					Marion Bartoli
107.			Maria Elena Camerin		6-3 6-3
				Maria Elena Camerin
108.			Anca Barna	7-5 6-2
						Ai Sugiyama
109.			Klara Koukalova			6-1 6-2
				Klara Koukalova
110.			Jelena Jankovic	3-6 6-1 6-4
					Ai Sugiyama
111.		[11]	Ai Sugiyama		6-4 6-4
				Ai Sugiyama
112.		[WC]	Amanda Janes	3-6 6-2 6-3
								Maria Sharapova
113.		[13]	Maria Sharapova					5-7 7-5 6-1
				Maria Sharapova
114.		[Q]	Yuliya Beygelzimer	6-2 6-1
					Maria Sharapova
115.		[WC]	Anne Keothavong		6-4 6-0
				Anne Keothavong
116.			Nicole Pratt	6-3 6-1
						Maria Sharapova
117.			Daniela Hantuchova			6-3 6-1
				Daniela Hantuchova
118.			Samantha Reeves	6-1 6-4
					Daniela Hantuchova
119.		[20]	Elena Bovina		w/o
				Elena Bovina
120.		[Q]	Edina Gallovits	6-1 6-2
							Maria Sharapova
121.		[31]	Amy Frazier				6-4 7-5
				Amy Frazier
122.			Maria Kirilenko	6-1 6-4
					Amy Frazier
123.		[WC]	Emily Webley-Smith		6-2 3-6 8-6
				Emily Webley-Smith
124.			Severine Beltrame	7-6(2) 6-4
						Amy Frazier
125.			Aniko Kapros			4-6 6-4 6-4
				Aniko Kapros
126.			Mervana Jugic-Salkic	6-4 2-6 6-3
					Anastasia Myskina
127.		[2]	Anastasia Myskina		5-7 6-2 6-4
				Anastasia Myskina
128.			Lubomira Kurhajcova	7-5 6-1

(default) 17 queries took 23 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	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` = 3 AND `Contest`.`category_id` = 19 AND `Contest`.`slug` = '2004' 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` = (1815) 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 (10150, 10322, 10297, 10327, 12553, 10097, 10111, 10253, 10218, 10289, 10317, 10201, 10130, 10135, 10356, 10292, 10163, 10302, 10105, 10223, 10312, 10214, 10328, 9885, 10116, 10208, 10090, 10437, 10295, 10215, 9997, 10311, 10152, 10190, 10209, 10314, 10184, 10077, 10039, 10222, 10055, 10024, 10129, 10199, 10122, 10318, 10049, 10335, 10119, 10305, 10068, 10323, 10379, 10170, 10128, 10198, 10319, 10290, 10098, 10306, 10064, 10114, 10187, 10255, 10025, 10083, 10124, 10279, 10303, 10301, 10145, 10165, 10316, 10173, 9582, 10337, 10265, 10315, 10281, 10270, 10180, 10062, 10133, 10157, 10171, 10160, 9959, 10321, 10147, 10203, 10221, 10182, 10320, 10278, 10151, 10275, 10100, 10174, 10115, 10345, 11407, 10202, 10172, 10286, 10261, 9985, 10264, 10194, 10282, 10284, 10070, 12555, 10326, 10397, 10442, 9937, 10299, 10154, 10211, 10407, 9845, 10360, 12556, 10382, 10271, 11405, 10262, 10283) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	2
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` = 1815	129	129	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (94, 197, 196, 72, 68, NULL, 53, 194, 207, 154, 151, 21, 92, 179, 43, 168, 84, 74, 216, 10, 153, 173, 27, 50, 111, 31, 13, 42, 169, 113, 14, 201, 91, 184, 87)	34	34	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (94, 197, 196, 72, 68, NULL, 53, 194, 207, 154, 151, 21, 92, 179, 43, 168, 84, 74, 216, 10, 153, 173, 27, 50, 111, 31, 13, 42, 169, 113, 14, 201, 91, 184, 87)	34	34	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10150, 10322, 10297, 10327, 12553, 10097, 10111, 10253, 10218, 10289, 10317, 10201, 10130, 10135, 10356, 10292, 10163, 10302, 10105, 10223, 10312, 10214, 10328, 9885, 10116, 10208, 10090, 10437, 10295, 10215, 9997, 10311, 10152, 10190, 10209, 10314, 10184, 10077, 10039, 10222, 10055, 10024, 10129, 10199, 10122, 10318, 10049, 10335, 10119, 10305, 10068, 10323, 10379, 10170, 10128, 10198, 10319, 10290, 10098, 10306, 10064, 10114, 10187, 10255, 10025, 10083, 10124, 10279, 10303, 10301, 10145, 10165, 10316, 10173, 9582, 10337, 10265, 10315, 10281, 10270, 10180, 10062, 10133, 10157, 10171, 10160, 9959, 10321, 10147, 10203, 10221, 10182, 10320, 10278, 10151, 10275, 10100, 10174, 10115, 10345, 11407, 10202, 10172, 10286, 10261, 9985, 10264, 10194, 10282, 10284, 10070, 12555, 10326, 10397, 10442, 9937, 10299, 10154, 10211, 10407, 9845, 10360, 12556, 10382, 10271, 11405, 10262, 10283)) AND (`Playercontest`.`contest_id` = 1815))	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` = 2004	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 23 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` = '2004' 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` = (1815) 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 (10150, 10322, 10297, 10327, 12553, 10097, 10111, 10253, 10218, 10289, 10317, 10201, 10130, 10135, 10356, 10292, 10163, 10302, 10105, 10223, 10312, 10214, 10328, 9885, 10116, 10208, 10090, 10437, 10295, 10215, 9997, 10311, 10152, 10190, 10209, 10314, 10184, 10077, 10039, 10222, 10055, 10024, 10129, 10199, 10122, 10318, 10049, 10335, 10119, 10305, 10068, 10323, 10379, 10170, 10128, 10198, 10319, 10290, 10098, 10306, 10064, 10114, 10187, 10255, 10025, 10083, 10124, 10279, 10303, 10301, 10145, 10165, 10316, 10173, 9582, 10337, 10265, 10315, 10281, 10270, 10180, 10062, 10133, 10157, 10171, 10160, 9959, 10321, 10147, 10203, 10221, 10182, 10320, 10278, 10151, 10275, 10100, 10174, 10115, 10345, 11407, 10202, 10172, 10286, 10261, 9985, 10264, 10194, 10282, 10284, 10070, 12555, 10326, 10397, 10442, 9937, 10299, 10154, 10211, 10407, 9845, 10360, 12556, 10382, 10271, 11405, 10262, 10283) 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` = 1815

129

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (94, 197, 196, 72, 68, NULL, 53, 194, 207, 154, 151, 21, 92, 179, 43, 168, 84, 74, 216, 10, 153, 173, 27, 50, 111, 31, 13, 42, 169, 113, 14, 201, 91, 184, 87)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (94, 197, 196, 72, 68, NULL, 53, 194, 207, 154, 151, 21, 92, 179, 43, 168, 84, 74, 216, 10, 153, 173, 27, 50, 111, 31, 13, 42, 169, 113, 14, 201, 91, 184, 87)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10150, 10322, 10297, 10327, 12553, 10097, 10111, 10253, 10218, 10289, 10317, 10201, 10130, 10135, 10356, 10292, 10163, 10302, 10105, 10223, 10312, 10214, 10328, 9885, 10116, 10208, 10090, 10437, 10295, 10215, 9997, 10311, 10152, 10190, 10209, 10314, 10184, 10077, 10039, 10222, 10055, 10024, 10129, 10199, 10122, 10318, 10049, 10335, 10119, 10305, 10068, 10323, 10379, 10170, 10128, 10198, 10319, 10290, 10098, 10306, 10064, 10114, 10187, 10255, 10025, 10083, 10124, 10279, 10303, 10301, 10145, 10165, 10316, 10173, 9582, 10337, 10265, 10315, 10281, 10270, 10180, 10062, 10133, 10157, 10171, 10160, 9959, 10321, 10147, 10203, 10221, 10182, 10320, 10278, 10151, 10275, 10100, 10174, 10115, 10345, 11407, 10202, 10172, 10286, 10261, 9985, 10264, 10194, 10282, 10284, 10070, 12555, 10326, 10397, 10442, 9937, 10299, 10154, 10211, 10407, 9845, 10360, 12556, 10382, 10271, 11405, 10262, 10283)) AND (`Playercontest`.`contest_id` = 1815))

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

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)