Wimbledon 1997 Ladies' Singles (June 23 - July 5)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Martina Hingis
				Martina Hingis
2.		[Q]	Anne Kremer	6-4 6-4
					Martina Hingis
3.			Olga Barabanschikova		6-2 6-2
				Olga Barabanschikova
4.			Petra Begerow	6-3 6-3
						Martina Hingis
5.			Lisa Raymond			6-1 6-3
				Lisa Raymond
6.			Eva Martincova	6-4 6-2
					Nicole Arendt
7.			Nicole Arendt		1-6 6-4 6-3
				Nicole Arendt
8.			Petra Langrova	6-2 6-0
							Martina Hingis
9.		[Q]	Laura Golarsa				6-1 6-3
				Laura Golarsa
10.			Alexia Dechaume	6-1 4-6 6-3
					Sabine Appelmans
11.			Sabine Appelmans		6-2 6-0
				Sabine Appelmans
12.			Rene Simpson	6-2 3-6 6-0
						Sabine Appelmans
13.			Amy Frazier			6-2 6-3
				Amy Frazier
14.			Sandra Cacic	7-5 6-4
					Brenda Schultz
15.		[14]	Brenda Schultz		7-6(3) 6-3
				Brenda Schultz
16.			Silvia Farina	4-6 6-3 6-2
								Martina Hingis
17.			Andrea Glass					6-3 6-2
				Andrea Glass
18.		[15]	Ruxandra Dragomir	5-7 6-2 10-8
					Maria Vento-Kabchi
19.		[Q]	Maria Vento-Kabchi		2-1 rtd.
				Maria Vento-Kabchi
20.			Annabel Ellwood	7-5 6-1
						Maria Vento-Kabchi
21.			Ginger Helgeson			6-2 7-5
				Ginger Helgeson
22.		[WC]	Lucie Ahl	6-2 6-4
					Magdalena Maleeva
23.			Magdalena Maleeva		7-5 7-5
				Magdalena Maleeva
24.		[WC]	Julie Pullin	6-1 6-3
							Denisa Chladkova
25.		[Q]	Nicole Pratt				6-1 6-3
				Nicole Pratt
26.			Katarina Studenikova	6-3 4-6 6-3
					Radomira Zrubakova
27.			Radomira Zrubakova		6-4 7-5
				Radomira Zrubakova
28.		[Q]	Nancy Feber	6-1 7-5
						Denisa Chladkova
29.			Denisa Chladkova			6-7(3) 6-3 8-6
				Denisa Chladkova
30.			Sandra Kleinova	7-6(5) 6-4
					Denisa Chladkova
31.		[5]	Lindsay Davenport		7-5 6-2
				Lindsay Davenport
32.			Tami Whitlinger	5-7 6-2 6-2
									Martina Hingis
33.		[4]	Iva Majoli						6-3 6-2
				Iva Majoli
34.			Mariana Diaz-Oliva	2-6 6-0 6-3
					Iva Majoli
35.			Marion Maruska		6-3 6-3
				Marion Maruska
36.			Adriana Gersi	7-6(4) 6-2
						Iva Majoli
37.		[Q]	Karen Cross			4-6 7-6(2) 6-4
				Karen Cross
38.			Linda Harvey	6-4 6-2
					Karen Cross
39.			Maria Sanchez Lorenzo		6-4 6-0
				Maria Sanchez Lorenzo
40.			Flora Perfetti	6-4 6-4
							Iva Majoli
41.		[WC]	Gigi Fernandez				6-7 (8) 6-1 9-7
				Gigi Fernandez
42.			Miriam Oremans	7-6(5) 6-3
					Gigi Fernandez
43.			Nathalie Dechy		6-3 4-6 6-3
				Nathalie Dechy
44.			Laurence Courtois	6-7(6) 6-1 6-2
						Irina Spirlea
45.			Elena Makarova			6-3 6-1
				Elena Makarova
46.			Tatiana Panova	6-4 4-6 6-3
					Irina Spirlea
47.		[12]	Irina Spirlea		4-6 6-1 10-8
				Irina Spirlea
48.			Henrieta Nagyova	6-1 6-0
								Anna Kournikova
49.		[10]	Conchita Martinez					7-6(1) 6-4
				Conchita Martinez
50.			Karina Habsudova	6-1 6-2
					Conchita Martinez
51.			Yuka Yoshida		6-0 6-0
				Yuka Yoshida
52.			Rika Hiraki	6-2 6-3
						Helena Sukova
53.			Helena Sukova			6-4 6-2
				Helena Sukova
54.		[WC]	Shirli-Ann Siddall	7-6(4) 6-1
					Helena Sukova
55.			Shi-Ting Wang		6-0 6-3
				Shi-Ting Wang
56.			Lori McNeil	6-1 2-6 7-5
							Anna Kournikova
57.			Anna Kournikova				2-6 6-2 6-3
				Anna Kournikova
58.			Chanda Rubin	6-1 6-1
					Anna Kournikova
59.			Barbara Rittner		4-6 7-6(7) 6-3
				Barbara Rittner
60.			Anne-Gaelle Sidot	7-6(6) 6-4
						Anna Kournikova
61.			Joanette Kruger			3-6 6-4 6-4
				Joanette Kruger
62.			Stephanie De Ville	7-6(3) 6-3
					Anke Huber
63.		[7]	Anke Huber		6-2 6-0
				Anke Huber
64.		[Q]	Haruka Inoue	6-3 6-3
										Martina Hingis
65.		[6]	Amanda Coetzer							2-6 6-3 6-3
				Amanda Coetzer
66.			Alexandra Fusai	7-6(10) 6-1
					Patricia Hy
67.			Patricia Hy		6-2 6-1
				Patricia Hy
68.			Miho Saeki	6-2 1-6 6-2
						Patricia Hy
69.			Magdalena Grzybowska			6-4 6-1
				Magdalena Grzybowska
70.			Venus Williams	4-6 6-2 6-4
					Magdalena Grzybowska
71.			Barbara Schett		4-6 6-3 6-2
				Barbara Schett
72.			Asa Carlsson	2-6 6-3 6-0
							Yayuk Basuki
73.			Yayuk Basuki				6-0 7-6(2)
				Yayuk Basuki
74.			Ai Sugiyama	6-3 6-0
					Yayuk Basuki
75.			Ines Gorrochategui		6-2 6-0
				Ines Gorrochategui
76.			Meilen Tu	6-0 6-3
						Yayuk Basuki
77.			Naoko Kijimuta			6-3 6-2
				Naoko Kijimuta
78.			Larisa Savchenko	7-5 6-2
					Naoko Kijimuta
79.		[16]	Barbara Paulus		5-7 6-3 6-3
				Barbara Paulus
80.			Kristie Boogert	6-3 1-6 6-3
								Jana Novotna
81.		[11]	Mary Joe Fernandez					6-3 6-3
				Mary Joe Fernandez
82.			Noelle Van Lottum	6-2 6-2
					Mary Joe Fernandez
83.			Aleksandra Olsza		6-4 6-0
				Aleksandra Olsza
84.			Lenka Nemeckova	3-6 6-1 6-2
						Mary Joe Fernandez
85.			Naoko Sawamatsu			6-2 6-4
				Naoko Sawamatsu
86.		[WC]	Samantha Smith	6-1 6-3
					Tamarine Tanasugarn
87.			Tamarine Tanasugarn		6-2 6-2
				Tamarine Tanasugarn
88.			Ludmila Richterova	6-3 6-1
							Jana Novotna
89.			Gala Leon Garcia				5-7 6-4 7-5
				Gala Leon Garcia
90.			Mana Endo	6-3 6-3
					Gala Leon Garcia
91.			Cristina Torrens-Valero		3-6 6-2 6-3
				Cristina Torrens-Valero
92.			Gloria Pizzichini	1-6 6-3 6-4
						Jana Novotna
93.			Elena Likhovtseva			6-4 6-2
				Elena Likhovtseva
94.			Natasha Zvereva	6-2 6-2
					Jana Novotna
95.		[3]	Jana Novotna		6-1 4-6 6-4
				Jana Novotna
96.			Wiltrud Probst	6-4 4-6 6-0
									Jana Novotna
97.		[8]	Arantxa Sanchez-Vicario						6-4 6-2
				Arantxa Sanchez-Vicario
98.		[WC]	Clare Wood	6-0 6-0
					Arantxa Sanchez-Vicario
99.			Emmanuelle Gagliardi		6-4 6-2
				Emmanuelle Gagliardi
100.			Catalina Cristea	3-6 7-5 6-1
						Arantxa Sanchez-Vicario
101.			Florencia Labat			6-1 6-2
				Florencia Labat
102.			Rita Grande	6-4 6-4
					Florencia Labat
103.			Els Callens		6-2 6-3
				Els Callens
104.			Paola Suarez	6-4 6-2
							Arantxa Sanchez-Vicario
105.			Sarah Pitkowski				6-1 6-3
				Sarah Pitkowski
106.			Francesca Lubiani	6-3 4-6 6-1
					Magui Serna
107.			Magui Serna		6-2 6-0
				Magui Serna
108.			Jolene Watanabe	6-3 6-1
						Mary Pierce
109.			Virginia Ruano-Pascual			6-4 6-3
				Virginia Ruano-Pascual
110.			Sandra Dopfer	6-2 6-2
					Mary Pierce
111.		[9]	Mary Pierce		6-0 2-6 6-3
				Mary Pierce
112.			Dominique Monami	6-3 6-4
								Arantxa Sanchez-Vicario
113.			Kerry-Anne Guse					6-2 7-5
				Kerry-Anne Guse
114.		[13]	Kimberly Po	3-6 7-5 6-2
					Nathalie Tauziat
115.			Nathalie Tauziat		6-0 6-3
				Nathalie Tauziat
116.		[LL]	Nana Miyagi	6-3 6-4
						Nathalie Tauziat
117.		[WC]	Lorna Woodroffe			3-6 6-3 6-2
				Lorna Woodroffe
118.			Patty Schnyder	6-4 6-4
					Judith Wiesner
119.			Judith Wiesner		6-2 6-3
				Judith Wiesner
120.			Jana Kandarr	7-5 6-2
							Nathalie Tauziat
121.			Corina Morariu				4-6 7-5 12-10
				Corina Morariu
122.		[WC]	Claire Taylor	6-2 6-1
					Sandrine Testud
123.			Sandrine Testud		6-7(5) 6-3 6-1
				Sandrine Testud
124.		[Q]	Miriam Schnitzer	6-3 6-0
						Sandrine Testud
125.			Kristina Brandi			0-6 6-4 8-6
				Kristina Brandi
126.			Ann Grossman	6-2 7-6(5)
					Monica Seles
127.		[2]	Monica Seles		5-7 6-3 6-3
				Monica Seles
128.			Rachel McQuillan	6-0 6-2

(default) 17 queries took 20 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` = '1997' 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` = (1808) 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 (10078, 10128, 10137, 10046, 10039, 11380, 9983, 9880, 9896, 9873, 9936, 9870, 9845, 10061, 9863, 10049, 10141, 10063, 10105, 10080, 9972, 12539, 9959, 10191, 9937, 10054, 9837, 10093, 10133, 10100, 10025, 9942, 10088, 10146, 10000, 10117, 12496, 10009, 10090, 10036, 9719, 9953, 10116, 10037, 10040, 10145, 10050, 10129, 9885, 9946, 10072, 9988, 9677, 12490, 10028, 9727, 10113, 9985, 9967, 10131, 10023, 10132, 9915, 10148, 10018, 10026, 9796, 10112, 10103, 10151, 10077, 10101, 10032, 10070, 9999, 10126, 10052, 9750, 9918, 10048, 9909, 9970, 10120, 10144, 9966, 9992, 10115, 10081, 10114, 10014, 10123, 10016, 10064, 9945, 9848, 9804, 9957, 9851, 10130, 10059, 9994, 10098, 10068, 10119, 10084, 10087, 10111, 10058, 10055, 10030, 10024, 10012, 9869, 9991, 10017, 9920, 12494, 10356, 9781, 10106, 10121, 12498, 9990, 12540, 10124, 9907, 9974, 9819) 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` = 1808	129	129	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (196, 21, 197, 20, 87, 72, 133, NULL, 151, 178, 53, 172, 153, 68, 10, 14, 13, 94, 92, 179, 173, 149, 168, 36, 154, 111, 50, 31, 104, 184, 201, 181)	31	31	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (196, 21, 197, 20, 87, 72, 133, NULL, 151, 178, 53, 172, 153, 68, 10, 14, 13, 94, 92, 179, 173, 149, 168, 36, 154, 111, 50, 31, 104, 184, 201, 181)	31	31	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10078, 10128, 10137, 10046, 10039, 11380, 9983, 9880, 9896, 9873, 9936, 9870, 9845, 10061, 9863, 10049, 10141, 10063, 10105, 10080, 9972, 12539, 9959, 10191, 9937, 10054, 9837, 10093, 10133, 10100, 10025, 9942, 10088, 10146, 10000, 10117, 12496, 10009, 10090, 10036, 9719, 9953, 10116, 10037, 10040, 10145, 10050, 10129, 9885, 9946, 10072, 9988, 9677, 12490, 10028, 9727, 10113, 9985, 9967, 10131, 10023, 10132, 9915, 10148, 10018, 10026, 9796, 10112, 10103, 10151, 10077, 10101, 10032, 10070, 9999, 10126, 10052, 9750, 9918, 10048, 9909, 9970, 10120, 10144, 9966, 9992, 10115, 10081, 10114, 10014, 10123, 10016, 10064, 9945, 9848, 9804, 9957, 9851, 10130, 10059, 9994, 10098, 10068, 10119, 10084, 10087, 10111, 10058, 10055, 10030, 10024, 10012, 9869, 9991, 10017, 9920, 12494, 10356, 9781, 10106, 10121, 12498, 9990, 12540, 10124, 9907, 9974, 9819)) AND (`Playercontest`.`contest_id` = 1808))	128	128	1
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` = 1997	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	0
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 20 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` = '1997' 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` = (1808) 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 (10078, 10128, 10137, 10046, 10039, 11380, 9983, 9880, 9896, 9873, 9936, 9870, 9845, 10061, 9863, 10049, 10141, 10063, 10105, 10080, 9972, 12539, 9959, 10191, 9937, 10054, 9837, 10093, 10133, 10100, 10025, 9942, 10088, 10146, 10000, 10117, 12496, 10009, 10090, 10036, 9719, 9953, 10116, 10037, 10040, 10145, 10050, 10129, 9885, 9946, 10072, 9988, 9677, 12490, 10028, 9727, 10113, 9985, 9967, 10131, 10023, 10132, 9915, 10148, 10018, 10026, 9796, 10112, 10103, 10151, 10077, 10101, 10032, 10070, 9999, 10126, 10052, 9750, 9918, 10048, 9909, 9970, 10120, 10144, 9966, 9992, 10115, 10081, 10114, 10014, 10123, 10016, 10064, 9945, 9848, 9804, 9957, 9851, 10130, 10059, 9994, 10098, 10068, 10119, 10084, 10087, 10111, 10058, 10055, 10030, 10024, 10012, 9869, 9991, 10017, 9920, 12494, 10356, 9781, 10106, 10121, 12498, 9990, 12540, 10124, 9907, 9974, 9819) 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` = 1808

129

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (196, 21, 197, 20, 87, 72, 133, NULL, 151, 178, 53, 172, 153, 68, 10, 14, 13, 94, 92, 179, 173, 149, 168, 36, 154, 111, 50, 31, 104, 184, 201, 181)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (196, 21, 197, 20, 87, 72, 133, NULL, 151, 178, 53, 172, 153, 68, 10, 14, 13, 94, 92, 179, 173, 149, 168, 36, 154, 111, 50, 31, 104, 184, 201, 181)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (10078, 10128, 10137, 10046, 10039, 11380, 9983, 9880, 9896, 9873, 9936, 9870, 9845, 10061, 9863, 10049, 10141, 10063, 10105, 10080, 9972, 12539, 9959, 10191, 9937, 10054, 9837, 10093, 10133, 10100, 10025, 9942, 10088, 10146, 10000, 10117, 12496, 10009, 10090, 10036, 9719, 9953, 10116, 10037, 10040, 10145, 10050, 10129, 9885, 9946, 10072, 9988, 9677, 12490, 10028, 9727, 10113, 9985, 9967, 10131, 10023, 10132, 9915, 10148, 10018, 10026, 9796, 10112, 10103, 10151, 10077, 10101, 10032, 10070, 9999, 10126, 10052, 9750, 9918, 10048, 9909, 9970, 10120, 10144, 9966, 9992, 10115, 10081, 10114, 10014, 10123, 10016, 10064, 9945, 9848, 9804, 9957, 9851, 10130, 10059, 9994, 10098, 10068, 10119, 10084, 10087, 10111, 10058, 10055, 10030, 10024, 10012, 9869, 9991, 10017, 9920, 12494, 10356, 9781, 10106, 10121, 12498, 9990, 12540, 10124, 9907, 9974, 9819)) AND (`Playercontest`.`contest_id` = 1808))

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

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)